SQLConnection Error with ActiveSync 3.7

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I am trying to create a simple SQLConnection from my pda. I can get
the SQLCE to work fine on the pda. When I try to create a connection
to my SQL Server 2000 ,on my local drive, I get SQLException. Is
there something special I need to put into the connection string
telling it I am using ActiveSync. I have attached my Connection
string.

WorkStation Id=W10058;Integrated Security=SSPI;Data
Source=W10058;Database=MillPipe
 
Your connection string looks fine. Did you try setting user id and password
(just as a test to see if it something going on with Windows
Authentication)?

What is the exact SQLException?

Andy Sjostrom
Microsoft MVP - Mobile Devices
 
I tried the User ID and Password, got the same error.

Error...
A managed SqlException occurred at Application::Run+0x1a

Application::Run+0x1a
frmstart::Main+0xd

Ok to terminate
 
I got mine to connect using my local IP address. My SQLException was for the server name. It could not find it by just the name.
 
Back
Top