Connecting from VB6 to a remote Oracle Database

5 pts.
Tags:
Oracle
SQL Server
SQL Server 2000
SQL Server 2005
VB
Visual Basic 6
We are a SQL 2000 Database shop using Visual Basic 6.0 & Windows 2003. I need to develop an application that can access an Orcale database on a remote system (sight to sight VPN in place) using SQL. I retreived some information yesterday that enabled me to construct the connect statement in our application. However when the code was tested it generate the message. The oracle(tm)Client and networking component were not found. The components are supplied by Oracle Corp and are part of the oracle version 7.3 (or greater) client installation I used the connect statement: "Provider=MSDASQL;Driver={Microsoft ODBC for Oracle};Server=" & sIVCMachine & ";UID=" & sIVCUser & ";PWD=" & sIVCPass & ";" Since we are not an Orcale shop, but need to connect to an Oracle database, Is there a method or another driver that will let us do this with out installing the components. If not, what are risks involved installing the requested components if we are a Microsoft SQL shop.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Nope, you have to install the Oracle drivers to connect to an Oracle database. The Microsoft drivers use the Oracle drivers to make the connection.

There isn’t really any risk to installing the Oracle drivers.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Did this fix the problem for you?
    66,010 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following