Create User DSN with code

Question

Hi all,

Can one create an ODBC driver on the "User DSN" on the fly?

I am aiming to create the driver when the user log into the application, and then remove it again when the user closes the application.Thanks

Deon

Answer 1

The below link should help. I generally use the SQLConfigDataSource API function call:

http://www.techrepublic.com/article/creating-a-dsn-using-visual-basic/#

---

Paul ~~~~ Microsoft MVP (Visual Basic)

Answer 2

Just out of curiosity: why do you consider this better than a DSN-less connection?

---

-Tom. Microsoft Access MVP

Answer 3

Hi Tom,

I just read a forum (Stack Overflow) about this and found the solution. Like you are saying, the DSN-less is doing the job.

Thanks for your assistance.

Deon