DSN-less SQL connection.

[travisbrown]

Is it pssible to make a DSN-less linked table connection to a SQL Server in Access?

I have to connect to a SQL table, but this is a web app, so I'd have to create a dsn on the server. Rather than get the host to set up a dsn, I thought I'd ask...

 

[stix4t2]

Try doing a google search, at top of form, for "connection string" DSN's are nothing more than connection strings saved on the computer.

Also, I have seen these strings saved in the Application variable so they are available to the app when needed.

 

[PHV]

Have a look here:

http://www.connectionstrings.com/

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[travisbrown]

Thanks. I know how to write all sorts of connection strings. I never use DSNs for web scripts. But, I also never use Access.

I guess what I should have asked is, where do you put a custom connection string in Access? I've only right-clicked and followed the linked table wizard before.

thanks