We help IT Professionals succeed at work.

VB Accessing Oracle using SQL NET8

vinaikk
vinaikk asked
on
I have a software created in VB6.  i have used ADO to connect to a oracle DB.  Where ever i install this software i have to install Oracle client.  is there anyway by which i can install 0nly SQL NET8 or some thing which can be used to connect to Oracle DB
Comment
Watch Question

Yes you only need the driver. Below is my answer to a previous questioner:

If you use ADO all you need is the oracle driver.
Here is the syntax for using an ADO DSNless connection
with Oracle

For the current Oracle ODBC Driver from Microsoft:

oConn.Open "Driver={Microsoft ODBC for Oracle};" & _
                  "Server=OracleServer.world;" & _
                  "Uid=myUsername;" & _
                  "Pwd=myPassword;"

For the older Oracle ODBC Driver from Microsoft:

oConn.Open "Driver={Microsoft ODBC Driver for Oracle};" & _
                  "ConnectString=OracleServer.world;" & _
                  "Uid=myUsername;" & _
                  "Pwd=myPassword;"


or using OLDB
OLE DB Provider for Oracle (from Microsoft)

oConn.Open "Provider=msdaora;" & _
                  "Data Source=MyOracleDB;" & _
                  "User Id=myUsername;" & _
                  "Password=myPassword;"

For more information, see: Microsoft OLE DB Provider for Oracle



OLE DB Provider for Oracle (from Oracle)

For Standard Security:

oConn.Open "Provider=OraOLEDB.Oracle;" & _
                  "Data Source=MyOracleDB;" & _
                  "User Id=myUsername;" & _
                  "Password=myPassword;"

For a Trusted Connection:

oConn.Open "Provider=OraOLEDB.Oracle;" & _
                  "Data Source=MyOracleDB;" & _
                  "User Id=/;" & _
                  "Password=;"
' Or

oConn.Open "Provider=OraOLEDB.Oracle;" & _
                  "Data Source=MyOracleDB;" & _
                  "OSAuthent=1;"
 

Note: "Data Source=" must be set to the appropriate Net8 name which is known to the naming method in
use. For example, for Local Naming, it is the alias in the tnsnames.ora file; for Oracle Names, it is
the Net8 Service Name

More information available from
http://technet.oracle.com/docs/tech/nt/ole_db/doc/html/using.htm

Hope this helps
Andrew
Commented:
this from microsoft's paper:

How to Connect to Oracle from  ADO

http://support.microsoft.com/support/kb/articles/Q193/2/25.ASP?LN=EN-US&SD=gn&FR=0&qry=oracle&rnk=11&src=DHCS_MSPSS_gn_SRCH&SPR=ADO

To connect to an Oracle database using ODBC, you must supply a valid SQL*Net connect string. SQL Net Easy Configuration allows you to create an alias that you can reference in an ODBC Data Source Name (DSN) to connect to your Oracle Server.

-------------
Installing the Oracle required support files and SQL*Net
Active Server Pages uses ActiveX Data Objects (ADO) to communicate to Oracle through Open Database Connectivity (ODBC). To enable this connectivity, install Oracle's client software on the Web server.

From your Oracle software compact disc, run Setup from the root directory.

NOTE: If you are installing Oracle software from a network drive, you must map a network drive to install the Oracle software.


Select Language.


Select Installation Directory.


You will be prompted that the install directory path information needs to be added to the registry. The Oracle installer will automatically do this for you. At this point, Setup will exit and you will have to restart again. Repeat the above steps.

Select Oracle7 Client Products.


Select Application User.


When you are prompted to install the Oracle documentation either on your hard disk drive or to read it from the compact disc, choose the appropriate location.


The Oracle client Setup will now copy the files and configure the client software.
To connect to an Oracle database using ODBC, you must supply a valid SQL*Net connect string. SQL Net Easy Configuration allows you to create an alias that you can reference in an ODBC Data Source Name (DSN) to connect to your Oracle Server.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.