By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,471 Members | 2,264 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,471 IT Pros & Developers. It's quick & easy.

Errors in establishing SQL Server connection - please help

P: n/a
I loaded my Visual Studio, which includes SQL Server version 7.0. I did not
encounter any error messages in the installation.

It created two DSN entries: LocalServer & MQIS

Unfortunately neither are working for me:

Microsoft SQL Server ODBC Driver Version 03.70.0623

Data Source Name: LocalServer
Data Source Description:
Server: (local)
Database: (Default)
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Integrated Security: No
Use Regional Settings: No
Prepared Statements Option: Drop temporary procedures on disconnect
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes

Microsoft SQL Server ODBC Driver Version 03.70.0623

Running connectivity tests...

Attempting connection
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.

TESTS FAILED!

Connection failed:
SQL State: '01000'
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
[connect()].
Connection failed:
SQL State:'08001'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your
network documentation.
I am using Windows 98 SE and Access 2000 and would very much appreciate help
in enabling SQL Pass Through queries. I also have Norton's Firewall
installed (am on DSL).

Thank you,

Marta
(if you email me directly you need to remove the X )
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.