I am using VB 6 code that has run well on a W2K network against SQL 2K standard edition. The code simply declares an ADODB connection, and then attempts to use the open method against it. Syntactically I think it is ok. The connection string was modified to refer to the local server (on a Dell PC) and a new database name. The error occurs when the .Open statement is executed. The error is that the SQL Server cannot be found or access denied. The server install of personal edition when smoothly and I have full operability with Enterprise Manager (have created, dropped, ran scripts against tables and so forth). I have renamed the computer and the database to no avail. I have added my “domain\user” to the user security with full blast authority to no avail.
I would appreciate any help I can get…Thanks.