Creating a dsn for access using vb6.0

[caveatashish]

i have written a vb6.0 application and ms access as a backend which i
conncted to the frontend using a dsn, now i wanna to create dsn to th
access database using vb6.0 code.

thanks in advance

 

[Douglas J. Steele]

i have written a vb6.0 application and ms access as a backend which is
conncted to the frontend using a dsn, now i wanna to create dsn to the
access database using vb6.0 code.

Why? It's far better simply to use DAO.

You can also use ADO with a DSN-less connection string. Carl Prothman shows
various possible connection strings to use at
http://www.carlprothman.net/Default.aspx?tabid=81

DSNs are simply entries in the registry. You can stuff the necessary keys
into the registry to replicate the DSN, or you can use the
SQLConfigDataSource ODBC API call. http://support.microsoft.com/?id=184608
and http://support.microsoft.com/?id=171146 provide examples (although
they're aimed at SQL Server)