connection string to MSDE database - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

connection string to MSDE database

tpadhutpadhu Posts: 43Member
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=PPLSQLSERVER;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.


Comments

  • rlcrlc Posts: 448Member
    [b][red]This message was edited by rlc at 2006-1-3 6:32:21[/red][/b][hr]
    opps ... no coffee yet.
  • rlcrlc Posts: 448Member
    : : myConnection = "server=10.0.0.8;Integrated Security=SSPI;User ID=sa;Initial Catalog=Example;Data Source=PPLSQLSERVER;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.8myInstance'.

    ~rlc
Sign In or Register to comment.