I wish to know how and where to use File DSN. I believe it is a text file which can be placed on any system to access the database through ODBC. I tried but couldn't succeed. Can anybody help me in this regard ?
Printable View
I wish to know how and where to use File DSN. I believe it is a text file which can be placed on any system to access the database through ODBC. I tried but couldn't succeed. Can anybody help me in this regard ?
Actually the ODBC DSN's are in the system registry under "HKEY_LOCAL_MACHINE\Software\ODBC". Just run regedit from the StartMenu\Run and take a look at it.
I am able to find the DSN name when i create a system dsn or a user dsn but when i create a file dsn i am not able to see that name in HKEY_LOCAL_MACHINE\Software\ODBC. I have checked this even earlier and that is precisely my problem. Though the file dsn is created and seen in c:\programfiles\common\odbc, i can't see this in registry. i hope you can understand my problem better.
krish.....