Hi,

I'm developing smart device application in VB.NET.

I couldn't make the connection with MSDE.

I used the following connection string.

myConnection = "server=10.0.0.8;Integrated Security=SSPI;User ID=sa;Initial Catalog=Example;Data Source=PPL\SQLSERVER;Trusted_Connection=yes;"

MSDE is on the same machine where i'm developing my apps. & testing the result with emulator. (NOt using RDA or Replication).Simply using ADO.NET commands to select a table from MSDE engine.

Please help me to solve this. I need it urgently.

Note:
1) Windows apps working well with this connection string.

Thank You.

This message was edited by rlc at 2006-1-3 6:32:21

---

opps ... no coffee yet.

: : myConnection = "server=10.0.0.8;Integrated Security=SSPI;User ID=sa;Initial Catalog=Example;Data Source=PPL\SQLSERVER;Trusted_Connection=yes;"

Try this...


myConnection="SERVER=10.0.0.8;DATABASE=Example;Integrated Security=SSPI;"

Test your connection with OSQL to verify the information. Make sure ifyou have a instance name it is appended after the server name '10.0.0.8\myInstance'.

~rlc