split databases and connection settings..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm looking to deploy an MDB which contains queries and reports to my clients
users. The queries are setup to use linked tables on an SQL 2005 Server
database and I also use passthrough queries to execute stored procedures.
Since I can't be sure they all have the same DSN setup I'm using can anyone
clue me in as to how this should be done?

Any suggestions would be appreciated.
 
Dabbler said:
I'm looking to deploy an MDB which contains queries and reports to my clients
users. The queries are setup to use linked tables on an SQL 2005 Server
database and I also use passthrough queries to execute stored procedures.
Since I can't be sure they all have the same DSN setup I'm using can anyone
clue me in as to how this should be done?

Any suggestions would be appreciated.
Click to expand...

You can either have your app create its own DSN or go DSNless.

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