odbc connection

[Guest]

Hey all

Is there a way thru code to auto create an odbc entry on a client's pc

thanks in advance
rodney

 

[Cheryl Fischer]

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/ADO/Connection/ODBC_DSNLess.htm


hth,

 

[Chris Nebinger]

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