SQLConnection Error with ActiveSync 3.7

[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

 

[Andy Sjostrom]

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

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

There is no message associated with the SQLException when it's thrown in my case.

 

[Guest]

Bill:

Have you found a solution to your problem yet?

 

[Guest]

do you have the dns severs setup in your network card connection setup?