next »

[Rina Grom]

Hi guys,
I'm using user with sysdba privilege in order to connect to Oracle. The connection string is:
Driver={Microsoft ODBC for Oracle};Server=xxxxxxxx;Uid="xxxx";Pwd="xxx"
What should be added to the connection string in order to connect with the sys/sys user? "conn sys/sys as sysdba" is command in SQL*PLUS. I tried to add "DBA Privilege=sysdba" and I got error message: "Driver's SQLSetConnectAttr".
Please advise.
Rina

[Dani Vainstein]

Data Source=myOracleDB;User Id=SYS;Password=SYS;DBA Privilege=SYSOPER;
Data Source=myOracleDB;User Id=SYS;Password=SYS;DBA Privilege=SYSDBA;

[Rina Grom]

As you can see your version is a little bit differnt "User Id" instead of "Uid" and "Password" instead of "Pwd". Please correct my if I'm wrong but your version is .Net and I need VBS connection string.

[Dani Vainstein]

you right! sorry, is oracle .net
pls. follow this link
http://www.connectionstrings.com/
you may find the connection string u need.

a second suggestion is :
try to connect to your oracle using ODBC
Control Panel -> Administrative Tools -> Data Sources
after you seceed go to registry
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC
try to locate your odbc one of the sub-keys contains the connection string.
what you've left is to copy the connection string to:
connection.ConnectionString ( ADODB.Connection )

[Rina Grom]

Please see the attached snapshot where you can see that you can't create Database Source Names with sys\sys. Please advise.

[Dani Vainstein]

ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
Cause: connect SYS/<password> is no longer a valid syntax
Action: Try connect SYS/<password> as SYSDBA or connect SYS/<password> as SYSOPER

When you want to connect to the SYS or INTERNAL account, you'll have to connect using SYSDBA or SYSOPER.

[Rina Grom]

DSN Configuration failed with user ID:sys as sysdba \ password: sys or sys \ sys as sysdba.
Error message is:
[Oracle][ODBC][Ora]ORA-01017: invalid username/password; logon denied
Unable to connect
SQLState=28000
[Oracle][ODBC][Ora]ORA-01017: invalid username/password; logon denied

Same message is received by ADODB.Connection object in QTP.

Please correct if I'm wrong but ADODB.Connection object can't connect as sysdba in QTP.

[Dani Vainstein]

Hi

your problem seems for DBA. please contact the DBA in the company you work for
and ask him, how to connect.

about your question i think you're wrong, u can use ADODB.
ADODB depends on the ConnectionString property.

all the driver and database information should be suplyed via ConnectionString
ADODB.Connection only "manages" the connection.