I have an application which involves multiple generated data forms and a SQL
Server 2000 backend. ON my development workstation everything works fine. So
I copy to a different workstation with a local copy of SQL Server 2000. The
database was just detached on my development workstation and copied to the
other workstation and then reattached to SQL Server.

On the copied to workstation 4 out of 5 data forms work fine. They all use
the same connection string. The fifth that fails gives the messege when you
press the load button:

Messege: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.

Upon getting that messege I put the following code after the connection open
command and it responds correctly with the server version on both
workstations.

MessageBox.Show("ServerVersion: " + this.oleDbConnection1.ServerVersion
+ "\nState: " + this.oleDbConnection1.State.ToString());

So I believe this is an issue related to fill command, the environment on
the second workstation, or some kind of rights issue. I checked to see that
the select command is entered correctly. It was. Any other debug ideas ?

What would I have to do to get the second workstation to see the original
database on the first workstation (across the network) ? That might narrow
the problem down a little bit if it worked.

Randy

Please show the connection string.

You may need to use sp_change_users_login to fixup the username mappings
after reattaching the db.

"rseedle" <rseedle (AT) discussions (DOT) microsoft.com> wrote