Connection string for oracle 10g Database Issue

[firoz.raj]

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 .

[techgnome]

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

[firoz.raj]

Yes,i tried the attached way .but it stil say
Provider cannot be found. It may not be properly installed.Attachment 99637

[techgnome]

DO you HAVE the proper driver installed? And if you're using VB6, that would have been good to know....

-tg

[firoz.raj]

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 appreciated

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

[dee-u]

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.

[firoz.raj]

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 .

[dee-u]

so is their any solution for 64 Bit machine to connect oracle .

As I've said I gave up on trying to make it work in a 64bit machine. =)