Solved

Login in VB to oracle server through Excel

Posted on 2015-02-04
7
205 Views
Last Modified: 2015-02-08
Experts,

I have a module in VB in Excel which logs me into an Oracle server using an ODBC driver

When we used a separate userid and password, this worked for me


cn.Open "Driver={Microsoft ODBC for Oracle};Server=myServer1;Uid=myname;Pwd=mypassword;"

We now use our network ID and password to get into the tables
When i put my network  IS and password into the the statement above, I get invalid id and password

Does anyone know what the issue is?
0
Comment
Question by:morinia
  • 3
  • 3
7 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
>>={Microsoft ODBC for Oracle};

First you should not use the Microsoft drivers.  They have been deprecated and only sit on top of the Oracle drivers anyway.

I'm afraid I don't understand what a network ID versus a network IS is.
0
 

Author Comment

by:morinia
Comment Utility
In the past we were given user IDs s and passwords to  access the Data Warehouse.

Now as an added security to access the Data Warehouse you must use your network ID and password. This is what you use to sign into to system through windows. Prior to this one user could sign in to the company network using their network ID  and login using someone else's Data warehouse credentials.

One anomaly is that our network passwords must have a special character.  Mine has an asterisk in the password.  This may be causing a problem.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
Do you have any other tools installed to attempt a database connection?  Sqlplus preferred since this is the simplest tool to try but SQL Developer will also work.

Before debugging the ODBC drivers, make sure the userid and password is correct and can connect you to the database.  Then we'll figure out how to get the ODBC drivers working.

I strongly suggest you use the Oracle drivers.  The Microsoft ones might have 'issues' with the new complex passwords.
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 

Author Comment

by:morinia
Comment Utility
I am actually using oracle drivers in my odbc connection. It is in the VB code where I have tne problem.

I need vb code for ADODB connection.
0
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
Comment Utility
>>I am actually using oracle drivers in my odbc connection

Then what you posted isn't what you are using?

You posted:  Driver={Microsoft ODBC for Oracle};

That is the Microsoft driver.

>>I need vb code for ADODB connection.

There are many sites out there that have connection strings for the various drivers.  Anything I post here wouldn't be any different.

I always seem to end up on:
http://www.connectionstrings.com/oracle/
0
 

Author Closing Comment

by:morinia
Comment Utility
Thanks,

I was able to connect using just the name of my ODBC Driver.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

762 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

10 Experts available now in Live!

Get 1:1 Help Now