Moving app from Win NT to Win 2000

[CosmoKramer]

I have inherited an app that uses the following connect string in an .ini file:

DB_CONNECT="Provider=SQLOLEDB;Network Address=172.16.5.238;Network Library=Dbmssocn;Database=SmhCensus"

This app runs fine on an NT client, but not on a Windows 2000 one. I don't receive any error messages, it just doesn't run the program. Is there anything I have to change in this connect string??

The database is SQL Server 7.0

 

[fluteplr]

Are you sure the MDAC has been loaded on the 2000 client. There are no changes to OLEDB connection strings between NT4 and 2000.

 

[CosmoKramer]

Yes, I ran the "MDAC Component Checker" downloaded from MS's web site and it said I have version 2.6 installed....

 

[fluteplr]

When you say the program does not run. I am assuming nothing comes up at all. Why do you think this has anything to do with the connection to the database?

Could there be some other problem with the program running on 2000? Have you contacted the company/programmer who provided the program>

 

[CosmoKramer]

This is a home-grown VB app that someone wrote who is no longer with the company.

The user is prompted with a login screen and after they enter the login, nothing else happens. A datasheet view of a SQL Server table should be returned.......