Can someone help me?  I am new to asp-ado and I am currently reading 
Beginning ASP Databases by Kaufmann.  I am in chapter 2 and i am trying to 
establish a sql server dsn.  I'm following the instructions and it says 
that if the database is stored on a local machine, I should choose "local" 
fromt he drop-down menu.  Well there is no local in the drop-down menu.  
In fact, there is nothing in the drop down menu.  Can someone tell me how 
to establish this connection?

I have sql server in the Create New Data Source box, so I assume it is in 
there correctly.

I'm not trying to do anything fancy here, just trying to connect to a 
database on my machine - I am running Windows 2000.

Any help would be appreciated.

Gary

Gary,

I don't have the book nearby, so I'm assuming we're talking about the 
same things....

Here's the steps I take:

*	Bring up the ODBC Data Source Administrator
*	Select the "System DSN" tab
*	Click the "Add..." button
*	Drag to the bottom of the listbox and select "SQL Server"
*	Click Finish
In the newly-displayed dialog box:
*	Type a DSN name
*	Give a description if you like
*	click the Server dropdown -- at that point the
	word "(local)" usually displays.
*	If not, you can always just type "localhost" into the
	server dialog and it'll work just fine.
*	Click Next
*	Complete the rest of the dialog box parameters as
	appropriate for your installation
*	etc....

Hope this helps,

Beth



-----Original Message-----
From: Gary Cappelletti [mailto:gcapp@m...]
Sent: Tuesday, June 04, 2002 10:43 AM
To: ASP Database Setup
Subject: [asp_database_setup] set up sql server


Can someone help me?  I am new to asp-ado and I am currently reading
Beginning ASP Databases by Kaufmann.  I am in chapter 2 and i am trying 
to
establish a sql server dsn.  I'm following the instructions and it says
that if the database is stored on a local machine, I should choose 
"local"
fromt he drop-down menu.  Well there is no local in the drop-down menu.  

In fact, there is nothing in the drop down menu.  Can someone tell me 
how
to establish this connection?

I have sql server in the Create New Data Source box, so I assume it is 
in
there correctly.

I'm not trying to do anything fancy here, just trying to connect to a
database on my machine - I am running Windows 2000.

Any help would be appreciated.

Gary
beth.breidenbach@g...
%%email.unsub%%