Link to home
Start Free TrialLog in
Avatar of ST3VO
ST3VOFlag for United Kingdom of Great Britain and Northern Ireland

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
ASKER CERTIFIED SOLUTION
Avatar of Ivanov_G
Ivanov_G
Flag of Bulgaria image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ST3VO

ASKER

That code if for a Microsoft Access Driver, I need to connect to the CSV Driver
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...
Avatar of ST3VO

ASKER

Ok, I'll check it out and get back to you...thanks"!!
Avatar of ST3VO

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
Avatar of ST3VO

ASKER

Never mind. I figured it out!

Thanks!

ST3VO