Hi

I need to access an MSDE database on a computer on the LAN. The lan uses static IP addresses, and is a simple windows workgroup (peer to peer) setup.

I am having trouble getting my VB application to connect to the MSDE on another computer.

It works on a network with a domain such as NT4 server.

The connection string I use look like this...

Code:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & SQLuser & ";Password=" & SQLpassword & ";Initial Catalog=" & SQLcatalog & ";Data Source=" & SQLserver
The above code works fine with a domain. SQLpassword, SQLuser, SQLcatalog and SQLserver are string variables that are used to build the connection string.

Any help would be greatly appreciated.

Thanks