connect using ODBC?

[qwertyjjj]

We have an app that connects to a SQL back end using ODBC.
Is there a way to do this in code or should we be using DSN-less connection?

All the tables are linked in the Access front end currently.

 

[mhartman]

Hello:

May be this link can be of assistance:
http://support.microsoft.com/kb/208295/en-us
Regards
Mark

 

[qwertyjjj]

But should we be using ODBC at all?

 

[mhartman]

Hello:
Please see this link:

http://www.powerasp.net/content/database/dsn_vs_dnsless.asp

My opinion is that it is best to connect directly than indirectly, but each camp has cheering section

Regards
Mark

 

[qwertyjjj]

If I use the linked table manager and save the password with the connection, what type of connection is that?

This seems to be different from using a system DSN and separate fro DSN-less string connection?

 

[mhartman]

Hello:

I do not know the answer to that, but here is another link on DSN vrs. DSN-less

http://www.stardeveloper.com/articles/display.html?article=2000120101&page=1

Regards
Mark

 

[qwertyjjj]

nope, the first link requires you to set up a table in the access db with the dsn strings and table names.
I need to do it programatically and relink tables each time the application is started.

If I have linked tables, does it matter whether it's DSN or DSN-less connection?