?
Solved

Login in VB to oracle server through Excel

Posted on 2015-02-04
7
Medium Priority
?
213 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
[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
  • 3
  • 3
7 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40590977
>>={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
ID: 40591034
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 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40591072
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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 

Author Comment

by:morinia
ID: 40591114
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 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 40591129
>>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
ID: 40597306
Thanks,

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

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Suggested Courses

770 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