Connecting client to MS-SQL Sever 6.5 via BDE

i...@rof.net

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Connecting client to MS-SQL Sever 6.5 via BDE

I installed the sql-server client on a Win95 machine.
I can work with ISQL/w on client and access the server db's without any
problems (via pipes).

However, when I go to setup the alias in the bde and connect I get
'Cannot locate or connect to SQL server. Unable to connect: SQL server
is unavailable or does not exist. General network error. Check you
documentation. Alias ....'

I should only have to set the Server Name and Database under an MSSQL
alias right?
Any help would be greatly appreciated.

Paul Mun

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Connecting client to MS-SQL Sever 6.5 via BDE

Did you install the SQL Server driver when you installed SQL Links after the
BDE?

You may need to use another protocol such as TCP/IP between computers in
addition to Named Pipes for SQL Links to see the server.

Is the SQL Server service started?

Quote

i...@rof.net wrote in message <34D50B1A.9C506...@rof.net>...

[...]

Quote

>However, when I go to setup the alias in the bde and connect I get
>'Cannot locate or connect to SQL server. Unable to connect: SQL server
>is unavailable or does not exist. General network error. Check you

[...]

Other Threads

1. Problem connecting to MS SQL Server 6.5 using the BDE/ODBC

2. Hi, to connect to MS SQL via BDE

3. Updating in MS SQL Server 6.5 via D2

4. Installing MS SQL SERVER 6.5 Client with Install Shield

5. Connecting to MS SQL 6.5

6. Connecting Delphi4 to MS Sql 6.5

7. Connecting Delphi and MS SQL 6.5

8. Client to MS-SQL 6.5 server over ENET network

9. Connecting to MS SQL 6.5 Server

10. How connect to local MS SQL 6.5?