If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
odbc connection
Hey all,
Is there a way thru code to auto create an odbc entry on a client's pc? thanks in advance, rodney |
#2
|
|||
|
|||
odbc connection
If you mean creating a connection to another database without a DSN being
installed on the local computer, you might want to take a look at: http://www.able-consulting.com/MDAC/...BC_DSNLess.htm hth, -- Cheryl Fischer, MVP Microsoft Access "rodney" wrote in message ... Hey all, Is there a way thru code to auto create an odbc entry on a client's pc? thanks in advance, rodney |
#3
|
|||
|
|||
odbc connection
Copied shamelessly from:
http://groups.google.com/groups?hl=en&lr=&ie=UTF- 8&selm=774sdc%24rse%241%40nnrp1.dejanews.com Two ways to create your dsns yourself: - using the ODBC installer API (documentation comes with the ODBC SDK downloadable from www.microsoft.com\data\odbc) - using the windows registry functions.. more complex and also requires knowledge on how the data in stored (documentation can also be found in the odbc sdk) a third solution for your problem would be the use of dsn- less connections. This allows you to make connections in a dynamical way without having to write code to create your dsns first. Basically you will replace the dsn keyword in your connectionstring with the driver keyword and add all the keywords as they can be found in a normal dsn in the registry. For more info try the odbc sdk or do a powersearch in dejanews using 'toffie' and 'dsn-less' or 'dsn less'. Toffie. Chris Nebinger -----Original Message----- Hey all, Is there a way thru code to auto create an odbc entry on a client's pc? thanks in advance, rodney . |
Thread Tools | |
Display Modes | |
|
|