ST3VO
asked on
Create System DSN Connection at Runtime
Hi all,
I need to create a System DSN connection at runtime.
It needs to use the CSV driver as I am going to connection to a CSV file.
Can someone help please?
Thanks
ST3VO
I need to create a System DSN connection at runtime.
It needs to use the CSV driver as I am going to connection to a CSV file.
Can someone help please?
Thanks
ST3VO
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open regedit.exe and go to the following registry key
HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC \ ODBCINST.INI
There you see all available drivers. Then choose the one you need and change the strDriver in the code...
HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC \ ODBCINST.INI
There you see all available drivers. Then choose the one you need and change the strDriver in the code...
ASKER
Ok, I'll check it out and get back to you...thanks"!!
ASKER
Right...I found the driver and used the code which created the DSN BUT how do I specify the Location?
I need to specify a location and not the current...Could you please help?
Thanks
ST3VO
I need to specify a location and not the current...Could you please help?
Thanks
ST3VO
ASKER
Never mind. I figured it out!
Thanks!
ST3VO
Thanks!
ST3VO
ASKER