How to setup ODBC for SQL server driver on Win95 correctly 
Author Message
 How to setup ODBC for SQL server driver on Win95 correctly

Sorry - I missed the important bit -
you need to examine the protocols installed for sql server and make sure
your dsn on the workstation uses the same one.   named pipes vs tcp/ip, for
example.
regards [Bill]

--
========================================
William Sanders, Programmer/Analyst[VFP/SQL]
TALON Development Team, MIS Department [281-618-3100 X 3516]
EAGLE USA Airfreight, 15350 Vickery Drive, Houston TX 77032

Quote:

>  I met some problem when I setup ODBC for SQL server driver on win95..

>Environment:
>   server: NT SERVER 4.0 installed with MS SQL SERVER 6.5
>   client: win95 installed MS SQL client utility

>I am sure :
>  1.The sql server driver's version is 3.60.0319
>  2.I have started MSSQLSERVER,SQLEXECUTIVE on the server computer.
>  3.I can ping to the server computer from  the win95 computer successfully

>what I chosed when set the DSN:
>  1.authenticity:
>      with sql server authentication using a login id and
>    password entered by user
>  2.client configuration
>      tcpip socket

>Error information:
>  connection failed
>  sql state="080001"
>  sql server error: 6
>  [microsoft][odbc sql server driver][dbmsspxn]specified
>  sql server not found
>  connection failed
>  sql state="01000"
>  sql server error: 11
>  [microsoft][odbc sql server driver][dbmsspxn]connectionopen
>(attachtofileserver())

>what else should I do?
>Could you help me?
>Looking forward to your reply
>Thank you.



Sun, 18 Nov 2001 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. How to setup ODBC for SQL server driver on Win95 correctly

2. Need SQL Server ODBC driver for Win95

3. SQL-Server SP3 ODBC-Driver works on WIN95?

4. SQL 7 Setup: [ODBC Driver Manager] Driver does not support this function

5. Setup Failed - Unable to configure ODBC driver SQL Server

6. Need ODBC driver setup program for sql server 7

7. SQL Server 6.5 Setup does not install Network protocols correctly

8. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]

9. what is ODBC ERROR: [Microsoft][ODBC SQL Server Driver][SQL Server]I/O error 23

10. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]

11. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error

12. odbc error(category :odbc,source:odbc sql server driver,number:S1T00)


 
Powered by phpBB® Forum Software