I connect to SQL2000 database by Visual Basic. It run well on OS 98 and 2000 but it can't run on window XP with the same configure(MDAC, Visual Basic, Service Pack Version).
The error occurs when the default database(Initial Catalog) changed as the following code:
SqlCnn as new adodb.connection
SqlCnn.open "Connection String" ' Default database is "Product"
SqlCnn.Default Database = "Customer" ' Error occurs at this line of code.
Do you have any ideas to solve this problem?
thank you very much in advance.