Connecting to Northwind

On the 3rd page of the Tutorial 1, there is a section Connecting to the Database in a Microsoft SQL Server 2000 or 2005 Database Server. It instructs you to connect to the Northwind database in the C:\DataTutorial\App_Data directory. I have Northwind.mdf showing up in my Server Explorer and it is 3.7 mb in size in the directory, but the Server Explorer shows it with a - sign beside it and I cannot figure any way to get access to the tables, views, etc. I have read and re-read everything I can find on this and I know I am missing something simple, but I am stumped. Can anyone offer some help? Thanks, Ron

Do you have the Northwind database server-attached to your running srver, or did you setup the database as a user instance in your server explorer ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Jens,

It appears that Visual Studio solved the problem. When I opened my project today, the Northwnd.mdf database showed up fully populated in the Server Explorer window.

If you have any clue as to what I could have done yesterday to not properly permit the database to show, I would love to know so I don't do it again. I don't know if I had my "database server-attached to your running srver, or did you setup the database as a user instance in your server explorer ?" All I did was put the file in northwnd.mdf file into the c:\DataTutorial\App_Data\ directory. When it didn't show up, I also executed the instwnd.sql file with debug turned off, but, at least yesterday, that didn't seem to help.

Thanks again,

Ron Hall

sqlsql

CONNECTING TO ACCESS DATA via SQL Server Managemnt Studio

HI All, forgive me but I am new to SQL Server.

My question is in 2 parts. THe first - Could anyone point me to a tutorial or give me a quick pointer? I want to View my Access 2003 datatables through Server MAngement Studio. I cannot however work this out or find articles on it. Is it possible? Are there any wlakthroughs?

The second Part - Eventually I want to create an SQL database, which is comprised of tables which use (point to) MS ACCESS as there datasource. An unchangeable existing piece of software uses Access as the UI, so I want to leave my data in access, and just set up some pointers from the SQL database tables to read in data from these access tables as when required.

Is that a clear question? Am I making any sense? PLease let me know as I am scratching my head a lot at the moment!!

Cheers guys,

Anthony

You can;t access "Access Database" Tables from SQL Management Studio. but SQL Tables can be from "Access DB"

I can suggest you import data from Access into SQL Server then create link tables in your Access DB.

Access Forms will run with Link Tables which will fetch data from SQL Server.

- Jignesh

|||

you can configure a link server from sql server

to view data from access

http://msdn2.microsoft.com/en-us/library/ms175866.aspx

|||

HI Jignesh,

You can by configuring it as a link server. I did this about an hour after posting my query! Lots of people ahve said you cant but you can, it should be made a bit more obvious I think.

CHeers anywya,

Anthony

|||

Hi Joey,

yes I did this shortly after posting the question.

Thanks anywya, loads of people dont know about this, strangely.

Cheers for your help.

Anthoyn

Connecting sql db to an html website

Does anyone know a good site that has a tutorial? I want to be able to input data from the website straight to the db i.e. place orders, check status of order.There are hundreds of web sites like this, each catering to a specific web site configuration. The methods for accessing the datsbase are different for ASP, COLDFUSION, PHP, etc.

-PatP|||I was looking through the forum posts and the closest thing I could find was a link between asp and sql. I do not know asp, but was wondering if there was one for just a regular html website.|||straight from the html to the database? not possible

has to be done using some type of server side program, generally called "cgi" (common gateway interface or something like that)

asp is a type of cgi program, so is perl, coldfusion, jsp, php, et cetera|||Do you know of a beginners guide to using this? Php I'm a little familiar with and thought of a solution to take a mssql db and importing it into a mysql sb; only problem with that is having a php script that will run it