Results 1 to 2 of 2

Thread: sql connect

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Jan 2007
    Posts
    30

    sql connect

    I need some help on the following problem. When I create a windows application and run it on a desktop the following code works. But when I create a Win CE application and run the following on a PDA I get "server doesnt exist ...".

    Dim oSQLConn As Data.SqlClient.SqlConnection = New Data.SqlClient.SqlConnection()
    oSQLConn.ConnectionString = "Data Source=66.69.4.21\SQLEXPRESS;Initial Catalog=ScanIt;User Id=sa;Password=12345;"
    oSQLConn.Open()

    Thanks,
    Nelson

  2. #2
    Frenzied Member
    Join Date
    Oct 2005
    Posts
    1,286

    Re: sql connect

    Hi,
    try something like Persist Security Info=False;Integrated Security=False;Server=delldesktop,39250;initial catalog=SunlightStock;user id=sa;password=;

    I wrote an article here on accessing a remote database from a PPC

    Pete

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width