Question Locked

DSN connection failure with SQLEXPRESS in local net

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have 12 workstations in the network and all but one can connect to my SQLEXPRESS instance. When I try to create a DSN in the ODBC tool I get the following error.

Connection Failed
SQLState '01000'
SQL Server Error: 11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Socket]ConnectionOpen(Connect())
Connection Failed
SQLState '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Socket]Specified SQL Server not found

Due to the fact that all of the other workstations are capable of connecting and interacting with the SQL server I am certain that I have a client problem. The problem workstation is able to read/write to the host that is running SQLEXPRESS, but, I can connect to the SQLEXPRESS. There are no firewalls active on either host (workstation or SQL Host) and they are all in the same subnet i.e., 192.168.35.0 network.

Please help

Ron

2 replies

by Former member

OLE DB connections

You can use an OLE DB provider to communicate with your database. Creating a direct database-specific OLE DB connection can improve the speed of your connection by eliminating the ODBC layer between your web application and the database.

If you don't specify an OLE DB provider for your database, ASP uses the default OLE DB provider for ODBC drivers to communicate with an ODBC driver, which in turn communicates with the database.

OLE DB is available only on Windows NT, 2000, or XP.

Different OLE DB providers exist for different databases. You can obtain OLE DB providers for Microsoft Access and SQL Server by downloading and installing the Microsoft Data Access Components (MDAC) 2.5 and 2.7 packages on the Windows computer running IIS. You can download the MDAC packages for free from the Microsoft website at http://msdn.microsoft.com/data/mdac/downloads/.

NOTE

Make sure you install MDAC 2.5 before installing MDAC 2.7.

You can download OLE DB providers for Oracle databases from the Oracle website at www.oracle.com/technology/software/tech/windows/ole_db/index.html (registration is required).

In Dreamweaver, you create an OLE DB connection by including a Provider parameter in a connection string (see Creating a DSN-less connection). For example, here are parameters for common OLE DB providers for Access, SQL Server, and Oracle databases, respectively:

Provider=Microsoft.Jet.OLEDB.4.0;...
Provider=SQLOLEDB;...
Provider=OraOLEDB;...

For the parameter value of your OLE DB provider, see your provider vendor's documentation, or consult your system administrator.
http://livedocs.adobe.com/dreamweaver/8/using/wwhelp/wwhimpl/common/html/wwhelp.htm?context=LiveDocs_Parts&file=28_conn5.htm

Please post back if you have any more problems or questions.

This discussion is closed to new replies.