Solved

Access Data to Oracle, ODBC problem

Posted on 2001-09-10
5
846 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
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 how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to recover a database from a user managed backup
Suggested Courses

623 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