I have to be doing something basic wrong here!
I have 2 PCs (named comp1 and comp2) connected in a network (via Ethernet switch),
in order to test MSDE based solution.
Solution installs fine on PC - comp2 (i.e. MSDE installs, database files attach OK to MSDE),
and if you use ODBC Data Sources in the Control Panel to set up a SQL datasource
with the pre-determined name, pointing to the (local) 'SQL' server, the application works fine!
I want comp1 (Windows 98) to be the server, and comp2 (Windows ME) the client -
or the other way round, it doesn't matter.
How do I achieve this?!!
When I try to use the ODBC Control Panel icon on comp 2 to define the 'SQL Server' as:
\\comp1
I get the error:
"Connection failed:
SQLState: '01000'
SQL Server Error 11001
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (gethostbyname()()).
Connection failed.
SQLState: '08001'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation."
The network appears to be functioning OK, and the 2 PCs are mutually visible to each other.
As both the PCs are non-Windows NT, I have set the default communication protocol
to TCP/IP on port 1433, as standard, using the SQL Server Client Network Utility,
and I have checked with the 'Client Configuration' button when attempting to create the
Data Source with ODCB Control Panel icon that this is also the setting.
I have not yet changed the 'sa' password, so I am not expecting that it is a password-related issue.
I would very much appreciate any help!
Many thanks.
I have 2 PCs (named comp1 and comp2) connected in a network (via Ethernet switch),
in order to test MSDE based solution.
Solution installs fine on PC - comp2 (i.e. MSDE installs, database files attach OK to MSDE),
and if you use ODBC Data Sources in the Control Panel to set up a SQL datasource
with the pre-determined name, pointing to the (local) 'SQL' server, the application works fine!
I want comp1 (Windows 98) to be the server, and comp2 (Windows ME) the client -
or the other way round, it doesn't matter.
How do I achieve this?!!
When I try to use the ODBC Control Panel icon on comp 2 to define the 'SQL Server' as:
\\comp1
I get the error:
"Connection failed:
SQLState: '01000'
SQL Server Error 11001
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (gethostbyname()()).
Connection failed.
SQLState: '08001'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation."
The network appears to be functioning OK, and the 2 PCs are mutually visible to each other.
As both the PCs are non-Windows NT, I have set the default communication protocol
to TCP/IP on port 1433, as standard, using the SQL Server Client Network Utility,
and I have checked with the 'Client Configuration' button when attempting to create the
Data Source with ODCB Control Panel icon that this is also the setting.
I have not yet changed the 'sa' password, so I am not expecting that it is a password-related issue.
I would very much appreciate any help!
Many thanks.