sql server connect: I saw a previous post regarding a similar situatiuon I have but do not have
a solution yet.

In my case, I have created and instance of MSDE2000A and it runs fine with
securitymode=sql
and sapwd set etc.

In my application, I connect to the instance of the server and the
application runs fine.

When I try and run the application on another machine, I set up an instance
but the instance has the computername added ie. pcname\myinstance.

My VB.NET code is trying to locate originalpcname\myinstance.

Would someone mind please explaining what I need to do to be able to run the
app on a different machine.

Thanks in advance

Can you use a UDL to generate a connection string which you can use in your
application?

Vikram Jayaram
Microsoft, SQL Server

This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.