[UFT] Connection String for Oracle

[robertosalemi]

Hi,
i'm using SQL Developer for to connect to the database.
I have this parameters:
- username
- password
- hostname
- port
- SID

In VBScript, which is the connection string correct?

I tried more different connection strings, but nothing works.

Thanks.

[vinod123]

Code:

"Driver={Microsoft ODBC for Oracle};Server=QTPWorld; Uid=your_username;Pwd=your_password;"

[robertosalemi]

Hi,
not works:
"Microsoft OLE DB Provider: for ODBC Drivers: [Microsoft Driver Manager] Data source name not found and no default driver specified".

Why?

[vinod123]

Code:

con.ConnectionString =
     "User Id=scott;Password=tiger;Data Source=oracle;" +
     "Min Pool Size=10;Connection Lifetime=120;Connection Timeout=60;" +
     "Incr Pool Size=5; Decr Pool Size=2";

[robertosalemi]

Without ServiName or Host?

I try it, but I have the same problem.

[vinod123]

Code:

Set con=createobject("oledb.connection") con.open "Driver={Microsoft ODBC for Oracle};Server=; Uid=your_username;Pwd=your_password;"

OR
Check ODBC driver is available.
If not able to do DSN then Go to environmental variable and then set path

Code:

ConnectionString = "Provider=OraOLEDB.Oracle;Data Source="&mysource&";User Id="&user&";Password="&password&";"

[robertosalemi]

Hi,
I have resolved.

I have modified my ConnectionString as:

Code:

DB_CONNECT_STRING = "Provider=OraOLEDB.Oracle; Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=" & myHostName & ")(PORT=" & myPort & "))(CONNECT_DATA=(SERVER=dedicated)(" & serviceNameString & "))); User ID=" & myUsername & ";Password=" & myPassword & ";"

where I have added
SERVER=dedicated

If i launch my script through MS DOS it works, but If I use it in UFT I have this error:
"Provider cannot be found, it may not be properly installed"

Why?

I have added the plugin ORACLE in my project into UFT, maybe it is necessary another plugin?

Thanks.