Printable View
Hi Friends,
from some hours i have tried to test the connection string for oracle10g client .but when i compiler reads the
following line
constr = " Provider = OraOLEDB.Oracle;Data Source=mydatabase/myservicename;User Id=myusername;Password=mypassword"
it says provider cannot be found and Provider cannot be found. It may not be properly installed.
let me know please .any help would be highly appreciated .
1) http://www.connectionstrings.com/oracle
2) you should be using the oracle data connector
3) the link in #1 above even has a link itself to the appropriate download locations
4) none of the examples on that page look like what you have.
-tg
Yes,i tried the attached way .but it stil say
Provider cannot be found. It may not be properly installed.Attachment 99637
DO you HAVE the proper driver installed? And if you're using VB6, that would have been good to know....
-tg
No it does not seems to be installed .i tried the following way .but it is also not working .i have been using 64 bit Microprocessor+64 bit windows 7.
let me know please .any help would be highly appreciatedCode:constr = "Provider=MSDASQL;" & _
"Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=TCP)(HOST=10.64.5.101)(PORT=1521))" & _
"(CONNECT_DATA=(SERVICE_NAME=rms))); uid=MDMFIROZ;pwd=MDMFIROZ_142;"
' constr = "Provider=MSDAORA.1;Password=MDMFIROZ_142;User ID=MDMFIROZ;Data Source=infinity-db:1521;Persist Security Info=True"
con.Open constr
If I am not mistaken the oracle driver cannot be installed on a 64bit machine, I also tried a few months ago but gave up after trying all recommendations on the net, it works on a 32bit machine though.
so is their any solution for 64 Bit machine to connect oracle .Quote:
If I am not mistaken the oracle driver cannot be installed on a 64bit machine, I also tried a few months ago but gave up after trying all recommendations on the net, it works on a 32bit machine though.
As I've said I gave up on trying to make it work in a 64bit machine. =)Quote:
Originally Posted by firoz.raj