Web Development

Ask something
Discussion Locked

SQL Server 2K Personal Ed Connectivity

0 helpful
1 reply

by ptgcpar

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

1 reply

by ewmiller

Try this.
Create a system DSN that connects to the database. You can test this at the end of the DSN creation wizard so you will know that you have it set up right.
Next, change your .ConnectionString property on your ADO connection to:
DSN="your_dsn_name;UID=your_user_id;PWD=your_pwd"
Your program should now connect to the database. You can add code to your project to check for the existence of the DSN and if it is not there, you can add it programatically.
From a reuse standpoint, you should probably encapsulate your data access code in a dll or something similiar depending on your requirements.
ewm

This discussion is closed to new replies.