VB Client - Oracle on Unix Communication 
Author Message
 VB Client - Oracle on Unix Communication
I am trying to connect to Oracle Db on a Unix Server with
ADO.
My Connecting string works fine from the Windows NT4SP6
Server when I placed the VB application on the Windows
server with the Oracle on Unix.
I am having problems connecting from the VB App when it is
is on my workstation running  NT4SP5 Workstation  (to the
Oracle DB which is on Unix).
Am I suppossed to install different network protocol apart
from TCP/IP for my VB app on Workstation to connect to the
a DB on a Unix Box?


Sun, 18 Apr 2004 03:08:15 GMT
 VB Client - Oracle on Unix Communication

No.  You do need the Oracle client on the workstation and the Oracle Net8
configuration to be created.  Test the connection from Net8 Easy Config or
Net8 Assistant.  Next, if you are using an ODBC connection (ADO
Provider=MSDASQL or default/not specified), you also need to define the DSN
(or use a DSN-less ODBC connection).  Or you can use the native Oracle OLE
DB provider=MSDAORA.  The server OS does not affect the client connection to
the database.

HTH,
Tore.


Quote:
> I am trying to connect to Oracle Db on a Unix Server with
> ADO.
> My Connecting string works fine from the Windows NT4SP6
> Server when I placed the VB application on the Windows
> server with the Oracle on Unix.
> I am having problems connecting from the VB App when it is
> is on my workstation running  NT4SP5 Workstation  (to the
> Oracle DB which is on Unix).
> Am I suppossed to install different network protocol apart
> from TCP/IP for my VB app on Workstation to connect to the
> a DB on a Unix Box?



Tue, 04 May 2004 14:42:45 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. 11886-WA-Seattle-Communication Skills-Project Management-UNIX-ORACLE-Client/Serv

2. 11886-WA-Seattle-Communication Skills-Project Management-UNIX-ORACLE-Client/Serv

3. 11886-WA-Seattle-Communication Skills-Project Management-UNIX-ORACLE-Client/Serv

4. 11886-WA-Seattle-Communication Skills-Project Management-UNIX-ORACLE-Client/Serv

5. 11886-WA-Seattle-Communication Skills-Project Management-UNIX-ORACLE-Client/Serv

6. 36260-WI-WAUSAU-Communication Skills-ORACLE-PL/SQL-SQL*Plus-UNIX-Intranet-Client

7. 11886-WA-Seattle-Communication Skills-Project Management-UNIX-ORACLE-Client/Serv

8. 29202-WI-Wausau-Communication Skills-Analysis Skills-Client/Server-UNIX-ORACLE-L


 
Powered by phpBB® Forum Software