September 5, 2002 at 10:49 am
This may seem like a retro question... We have a VB app for small businesses running on MSDE. The app is often installed on Win98 and we are encountering problems connecting from the VB clients to the database which typically resides on another PC on the LAN.
When the VB client is installed on the same machine as the database, there is no issue. But client installations on other networked machines typically fails to connect to the database. We have however discovered that the problem may be overcome by installing MSDE on the client machine as well.
The errors encountered are one of the two:
1. Data Source Name not found and no default driver specified.
2. [DBMSSOCN] General network error. Check network documentation.
However, one should note that the application does not use DSNs. We have tried creating DSN entries and testing the connection... it works. But from the application, it fails.. with or without DSN use.
Any idea what can be done to enable database connection?
Paul
D. Paul
Satyam Infoway Ltd
Chennai
September 5, 2002 at 10:55 am
Have you tried just installing MDAC 2.5 or higher on these Windows 98 clients? You can grab MDAC at http://www.microsoft.com/data/
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
September 5, 2002 at 11:22 am
Yes, tried installing MDAC. the error mesg changed from (1) in my posting to (2). Any ideas?
D. Paul
Satyam Infoway Ltd
Chennai
September 5, 2002 at 8:56 pm
Is the MSDE using the TCP/IP net-lib? It should be, but check to see if it's listening on port 1433 on the PC running MSDE.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
September 5, 2002 at 10:18 pm
Yes, MSDE is using TCP/IP net-lib. And it is listening to Port 1433.... strange, wouldn't you say that it still does not work...? Am at a loss to understand why?
D. Paul
Satyam Infoway Ltd
Chennai
September 6, 2002 at 7:03 am
Very much so, especially since the DSN works and installing a relatively new version of MDAC does not. This one of those weird sorts of cases where you may want to open a ticket with Microsoft. If they have an answer, the headaches you solve will quickly pay for the fee.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply