gizman2
asked on
Access Data to Oracle, ODBC problem
I built a VB script that will load data from Access to Oracle on a daily basis. I am trying to automate this but the problem I have is that the ODBC driver version 8.01.06.00 does not provide a password field to be saved in the DSN file. Everytime the program runs, it asked for a password. How can I fix this problem? I tried to update the ODBC.INI registry to include the password but this didn't work.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I take it that the DSN file that you are talking about is not the same file in the ODBC.INI registry? If you are talking about a different file, where can I find it?
ASKER
This answer is good for the older version of DSN. The newer version, which use Microsoft Jet Engine, can be opened at the registry. I found out that we cannot add PWD to this registry to be valid. The rest of it gets complicated but the workaround is to modify the query on the Access side to include the PWD. This method works. Thanks for the help.
Hi,
The example I gave in my first solution relates with the FileDSN. The FileDSN U can carry with U at Installation time very easily or add in Installation kit. That makes it simple to use and easy to handle. Infact I should have mentioned this in my first mail. One more thing rather than using normal DSN keyword for connection U have to use
FILEDSN="PHYSICAL PATH OF DSN FILE"
I hope this is clear and this will solve your problem. Don't go into complexity of changing registry entry.
Regards,
Atul
The example I gave in my first solution relates with the FileDSN. The FileDSN U can carry with U at Installation time very easily or add in Installation kit. That makes it simple to use and easy to handle. Infact I should have mentioned this in my first mail. One more thing rather than using normal DSN keyword for connection U have to use
FILEDSN="PHYSICAL PATH OF DSN FILE"
I hope this is clear and this will solve your problem. Don't go into complexity of changing registry entry.
Regards,
Atul
open your odbc
and chane user to youruser/password
---rmz---