AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Tuesday, February 08, 2005

DSN-less connection in Access

Once again use it recently, easy, you don't need to create DSN in order to link to MS SQL Server. Nice article from Doug Steele. Basic idea that you construct connection string as:

ODBC;DRIVER={sql server};DATABASE=Northwind;SERVER=MyServer;Trusted_Connection=Yes;

0 Comments:

Post a Comment

Links to this post:

Create a Link

<< Home