Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Configuring ODBC With An SQL Server Database.

Status
Not open for further replies.

Elliott3

Programmer
Sep 5, 2002
347
CA
Can someone tell me how to set up a dsn for an sql server database(.mdf)... I have done it for .mdb before but cannot seem to figure out how to do it for .mdf...

CES
 

Is almost the same as for an access database.

Go to your Datasources[ODBC] in Admin Tools in Control Panel. Select Add to add a dsn, then Where it asks you for a driver, go to the very bottom of the list and select SQL SERVER.

The rest is easy, just follow the Wizard, giving a name for your DSN, e.t.c

I would add it as a system DSN aswell, as some application don't seem to pick up User DSN's

-Richard
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top