Using MDE file to connect to SQLServer via ODBC

[David C. Holley]

Anyone have experience connecting an MDE file to an instance of SQLServer
via ODBC? (Which should be yes). The scenario that I'm in is that I was
going to use a ADP file, but then got word that MS has officially
backpeddled indicating that ODBC is the best means of connecting to
SQLServer. If the server was going to be in the same city, I wouldn't sweat
it, however we're looking at having the server housed in Atlanta in support
of several other offices that will be using the app.

What issues should I be aware of? What about general performance?

 

[Banana]

Anyone have experience connecting an MDE file to an instance of SQLServer
via ODBC? (Which should be yes). The scenario that I'm in is that I was
going to use a ADP file, but then got word that MS has officially
backpeddled indicating that ODBC is the best means of connecting to
SQLServer. If the server was going to be in the same city, I wouldn't sweat
it, however we're looking at having the server housed in Atlanta in support
of several other offices that will be using the app.

What issues should I be aware of? What about general performance?

This is pretty a broad question. I'd refer you to those two links, which
in turn has links to several great articles discussing optimization and
performances and general considerations.

Beginning SQL Development:
http://www.utteraccess.com/forum/index.php?showforum=39

Beginner's Guide to ODBC:
http://www.utteraccess.com/forum/index.php?showtopic=1843709

Do feel free to post back with specific questions.

Best of luck!