morinia
asked on
Login in VB to oracle server through Excel
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;U id=myname; Pwd=mypass word;"
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?
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;U
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?
ASKER
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.
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.
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.
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.
ASKER
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.
I need vb code for ADODB connection.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks,
I was able to connect using just the name of my ODBC Driver.
I was able to connect using just the name of my ODBC Driver.
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.