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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.