moving EXE from MSDE PC to SQL Server PC



Hi,

I am developing a VB application on my PC using MSDE and have been using Windows Trusted Connection and localhost

sqlConn = New SqlConnection("server=localhost;trusted_connection=true;database=Pubs")

Then I copied the EXE to the PC running SQL server 2000 and I get an error message

"SQL Server does not exist or access denied"

I suspect the I shouldn't use "localhost" and use the computer's name but I am not sure how to code it so that it will work on my PC (call Rick) and on the server (called Server)

Richard
.


Loading