oracle connection Provider cannot be found. It may not be properly installed.

[baran121]

Hi,
i am new about Oracle, on my computer i can connect ORACLE database. But in another computer i have a problem following
"oracle connection Provider cannot be found. It may not be properly installed."

if you can help me i ll be apprsuade.

i use visual basic 6.
connection string:

With cnnt
.CursorLocation = adUseClient
.ConnectionString = "Provider=OraOLEDB.Oracle;Data Source=" & server_adi & "/" & db_adi & ";User ID=" & user & ";Password=" & pass
.Open
End With

my computer is windows 7 ultimate.

other computer which i cannot connect to oracle database is windows server 2008 R2 standart service pack1.

tkank you.

 

[baran121]

i found solution.

str = "Driver={Microsoft ODBC for Oracle};"
str = str & "Server=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=" & hostname & ")(PORT=" & portname & "))(CONNECT_DATA=(SID=LIVE)));Uid=" & user & ";Pwd=" & pass & ";"

With cnnt
.CursorLocation = adUseClient
.ConnectionString = str
.Open
End With