Home > IT Answers > Oracle > Connecting from VB6 to a remote Oracle Database
Gcasner
5 pts.
 Connecting from VB6 to a remote Oracle Database
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.

Software/Hardware used:
ASKED: February 19, 2008  3:41 PM
UPDATED: March 6, 2008  6:58 AM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  February 19, 2008  4:21 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Did this fix the problem for you?

Denny Cherry
 64,520 pts.