Solved

Access Data to Oracle, ODBC problem

Posted on 2001-09-10
5
840 Views
Last Modified: 2012-05-04
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.
0
Comment
Question by:gizman2
  • 2
  • 2
5 Comments
 

Accepted Solution

by:
atuln earned 60 total points
Comment Utility
Hi,

To save the passwword in DSN file. U have to manually open the open the file and add following data in the file and save it. To open the DSN file U can use the notepad.

Note that Name of the Server is the host string U entered to connect to the oracle. UseID and Password U enter as it is without any quotes.

[ODBC]
DRIVER=ORACLE ODBC DRIVER
UID=userIDForOracle
PWD=PasswordToconnectToOracle
SERVER=NameOfServer

E.g.

DRIVER=ORACLE ODBC DRIVER
UID=SCOTT
PWD=TIGER
SERVER=MYORACLE
0
 
LVL 2

Expert Comment

by:RMZ
Comment Utility
hi
open your odbc
and chane user to youruser/password
---rmz---
0
 

Author Comment

by:gizman2
Comment Utility
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?
0
 

Author Comment

by:gizman2
Comment Utility
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.

0
 

Expert Comment

by:atuln
Comment Utility
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
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to take different types of Oracle backups using RMAN.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now