Solved

Access Data to Oracle, ODBC problem

Posted on 2001-09-10
5
844 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
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.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

733 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