Solved

Access Data to Oracle, ODBC problem

Posted on 2001-09-10
5
841 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
ID: 6470510
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
ID: 6470879
hi
open your odbc
and chane user to youruser/password
---rmz---
0
 

Author Comment

by:gizman2
ID: 6472850
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
ID: 6473545
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
ID: 6482570
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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many‚Ķ
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

911 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

17 Experts available now in Live!

Get 1:1 Help Now