CODEWITHSUNDEEP
sqloracle-databasevba64-bitconnection-string
matyyyy
matyyyy

Reputation: 387

Provider cannot be found on Windows 7 64 bit

I am trying to run our very old application on Windows 7 64 bit. In this application we use our do template in which there are a Visual Basic scripts. I have a problem with database provider. This is my string connection:

  buildConnectString = _
    "Provider=MSADORA.1" + _
    ";Password=""" + pPassword + _
    """;User ID=" + pUser + _
    ";Data Source=" + pDB + ";"

I receive this error:

Run-time error 3706. Provider cannot be found. It may not be properly installed.

Is there any possibility to run it on 64-bit operating system?

Upvotes: 2

Views: 12504

Answers (2)

Mitch Wheat
Mitch Wheat

Reputation: 300759

Install the Oracle provider (there are 32bit and 64bit versions), then use Provider=OraOLEDB.Oracle

[BTW, its MSDAORA.1. MSDAORA is only available for x86/32bit, there is no 64 bit driver]

Microsoft are no longer supporting MSDAORA, and instead recommended you use the Oracle drivers.

Download page: http://www.oracle.com/technetwork/developer-tools/visual-studio/downloads/index.html

Upvotes: 5

Oldskool
Oldskool

Reputation: 34877

As far as I know the provider name for the MS provider is MSD*A*ORA. So it seems you are missing the A in your connect string.

Upvotes: 1

Related Questions