Delphi connection to MS SQL server via TCP/IP 
Author Message
 Delphi connection to MS SQL server via TCP/IP

I have a Delphi 1.0 application running over Novell 4.X Network with MS SQL
server as back end database.  Currently using IPX/SPX protocol to access
server.  Am trying to connect via TCP/IP and so far have been unsuccessful.
 I know I have a TCP/IP connection from workstation to server because I can
use ISQL/W configured for TCP/IP.

Have started with SQL Links and database desktop to just try to see the
server (which works on IPX/SPX machine) but can't on TCP/IP machine.

Anybody with any experience on this?



Mon, 21 Jun 1999 03:00:00 GMT
 Delphi connection to MS SQL server via TCP/IP

I'm not clear on your setup since MS SQL Server does not run on Novell -
only NT. Have you used the MS SQL client configuration utility to select
TCP/IP as the default protocol? Have you installed TCP/IP support w/ MS
SQL setup?

-Bryan

Quote:

> I have a Delphi 1.0 application running over Novell 4.X Network with
MS SQL
> server as back end database.  Currently using IPX/SPX protocol to
access
> server.  Am trying to connect via TCP/IP and so far have been
unsuccessful.
>  I know I have a TCP/IP connection from workstation to server because
I can
> use ISQL/W configured for TCP/IP.

> Have started with SQL Links and database desktop to just try to see
the
> server (which works on IPX/SPX machine) but can't on TCP/IP machine.

> Anybody with any experience on this?



Mon, 21 Jun 1999 03:00:00 GMT
 Delphi connection to MS SQL server via TCP/IP

Quote:

>SQL server is is running on NT Server hung off Novell LAN.  At the
>workstation I have TCP/IP connection to the SQL Server via ISQL/W and EM by
>using client config utility.


>> I'm not clear on your setup since MS SQL Server does not run on Novell -
>> only NT. Have you used the MS SQL client configuration utility to select
>> TCP/IP as the default protocol? Have you installed TCP/IP support w/ MS
>> SQL setup?

>> -Bryan


>> > I have a Delphi 1.0 application running over Novell 4.X Network with
>> MS SQL
>> > server as back end database.  Currently using IPX/SPX protocol to
>> access
>> > server.  Am trying to connect via TCP/IP and so far have been
>> unsuccessful.
>> >  I know I have a TCP/IP connection from workstation to server because
>> I can
>> > use ISQL/W configured for TCP/IP.

>> > Have started with SQL Links and database desktop to just try to see
>> the
>> > server (which works on IPX/SPX machine) but can't on TCP/IP machine.

>> > Anybody with any experience on this?

When you install SQL Server you have to install TCP/IP sockets. It onlys
installs named pipes by default. Use the default socket number and everything
will be fine.

Mark Koenig
Support Systems Analyst, Principle
University of Arizona



Tue, 22 Jun 1999 03:00:00 GMT
 Delphi connection to MS SQL server via TCP/IP

SQL server is is running on NT Server hung off Novell LAN.  At the
workstation I have TCP/IP connection to the SQL Server via ISQL/W and EM by
using client config utility.


Quote:
> I'm not clear on your setup since MS SQL Server does not run on Novell -
> only NT. Have you used the MS SQL client configuration utility to select
> TCP/IP as the default protocol? Have you installed TCP/IP support w/ MS
> SQL setup?

> -Bryan


> > I have a Delphi 1.0 application running over Novell 4.X Network with
> MS SQL
> > server as back end database.  Currently using IPX/SPX protocol to
> access
> > server.  Am trying to connect via TCP/IP and so far have been
> unsuccessful.
> >  I know I have a TCP/IP connection from workstation to server because
> I can
> > use ISQL/W configured for TCP/IP.

> > Have started with SQL Links and database desktop to just try to see
> the
> > server (which works on IPX/SPX machine) but can't on TCP/IP machine.

> > Anybody with any experience on this?



Tue, 22 Jun 1999 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. RAS Connection can't talk to MS SQL Server via TCP/IP

2. Comparing NetBios->TCP/IP vs TCP/IP Sockets running SQL Server ODBC

3. general tcp/IP network error after changing sql server tcp/ip address

4. Connecting MS SQL via TCP/IP port 1433

5. Connecting to SQL Server 7 from SQL S 6.5 via TCP/IP

6. Delphi via Internet (tcp/ip)

7. Problems with an install to use SQL server via tcp-ip

8. Connect to SQL Server 7 via TCP/IP

9. Connecting to SQL Server 7 via TCP/IP

10. SQL Server via TCP/IP

11. Problem connecting with WIN2K machine to SQL Server 7 via TCP/IP

12. Connecting to a SQL Server via internet, TCP/IP


 
Powered by phpBB® Forum Software