Search code examples
sql-servervisual-studio-2008sql-server-2000windows-ce

Connection fails in debug for Win CE application

I am developing an application for a handheld device with Win CE 7.0 in VS 2008. The application has to connect to SQL Server 2000 database.

I use this connection string "Data Source=999.99.99.99,1433; Initial Catalog = DBname; User Id=UserID; Password=UserPassword; Application Name=Application; "

It works perfectly fine when it runs on the handheld device. But in Debug mode under Visual Studio, that same database connection fails complaining about Login Failed For User, error 18456 state 1.

I already tried User Id = domain\userid, and it did not help.

Does anyone have any idea what can be the cause of this?

Thank you.

Solution

  • How do you connect to your device from VS? Do you use ActiveSync? In the past AS used to have also TCP/IP routing over it, so it may be that when you are connected the connection is routed on the AS connection instead of the wi-fi one.