Re: C++ & ODBC & SQLnet, anybody expe..
Date: 3 Feb 1995 15:59:59 GMT
Message-ID: <3gtjtv$4f5_at_dcsun4.us.oracle.com>
Ralph Button <72667.1131_at_CompuServe.COM> wrote:
>
> For your connect string you should have something like this;
> T:ORASRV:(Schema name)
>
> The T is for TCP/IP
> The ORASRV is the default Listener name unless you have
> select another listener name
> The Schema Name is the optional schema if you have more than one
> schema loaded on the Oracle Server.
>
> The VC++ program comes with a ODBC test program try it to see if
> you can make a connection. I suspect you havn't loaded a TCP/IP
> socket that the SQL*NET needs. You need something like Microsoft
> TCP/IP-32 sockets, ot Novell's Lan Workplace, or FTP Software
> TCP/IP.
I have to make a small correction here.
The connect string you describe is for SQL*Net v1. The syntax is :
t:<hostname or ip address>[/<port number>]:<SID>[,<buffersize>]
<hostname or ip address> stands for the host where the database is installed on.
<port number> is the TCP port number the server process is listening on. This parameter is optional. The default is 1525.
<SID> is the SID of the database you want to connect to.
<buffersize> is the size of the buffer used for communication between SQL*Net and the underlying TCP/IP stack. Default is 4096 for Windows. This parameter is optional.
If you are using SQL*Net v2, the configuration is a completely different story. It would take too long to explain here.
Hope this helps,
Mark Received on Fri Feb 03 1995 - 16:59:59 CET