Connect to SQL Server 2005 at Vista from device with WM5.0

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kent - 04 Dec 2007 11:45 GMT

Hi
We have developed an application with vb2005 running under WM5.0 how
connects direct to SQL Server 2005 using WLAN (Using system.data.sqlclient
ver 3.0.3600 from ..\Smartdevices\sdk\SQL
Server\Client\v2.0\system.data.sqlclient.dll).
Everything works perfect when we connect to an SQL Server 2000 (ver 8.)
But we can't connect to SQL Server 2005
We dont know where to start debugging this problem
Can anyone give us a hint, please this is getting real urgent now.

Best regards / Kent

Reply to this Message

Ginny Caughey [MVP] - 04 Dec 2007 12:22 GMT

Kent,

Do you have tcpip enabled for your SQL 2005 server? It is off by default.

Signature

Ginny Caughey
Device Application Development MVP

> Hi
> We have developed an application with vb2005 running under WM5.0 how
[quoted text clipped - 7 lines]
>
> Best regards / Kent

Reply to this Message

Kent - 04 Dec 2007 13:02 GMT

Yes I have both Tcpip and named pipes enabled, i've also tried with only
tcpip but still no connection
/ Kent

> Kent,
>
[quoted text clipped - 11 lines]
> >
> > Best regards / Kent

Reply to this Message

Mostafa Adel - 14 Jan 2008 09:54 GMT

did you get any other replies, or at least where you able to fix this
problem, cuz i'm having the same problem as well.

Thanks

> Yes I have both Tcpip and named pipes enabled, i've also tried with only
> tcpip but still no connection
[quoted text clipped - 15 lines]
> > >
> > > Best regards / Kent

Reply to this Message

Ginny Caughey [MVP] - 14 Jan 2008 12:45 GMT

Mostafa,

The things most likely to cause problems connecting to SQL 2005 from a
mobile device are:

1. lack of connectivity - no internet connection
2. SQL Server tcp/ip not enabled
3. Not specifying the ip and port addresses in the connection string (don't
use machine name)
4. Not providing \\domainName\UserID and password in connection string if
using integrated security

If you've checked all of these things, make sure you can access the SQL
Server using the ip address and port from another desktop computer as that
will sometimes help you find the problem.

Signature

Ginny Caughey
Device Application Development MVP

> did you get any other replies, or at least where you able to fix this
> problem, cuz i'm having the same problem as well.
[quoted text clipped - 23 lines]
>> > >
>> > > Best regards / Kent

Reply to this Message