Connecting to SQL Server from Pocket PC

[ookete]

I am creating an application on a Pocket PC where I need to connect to SQL Server directly over a WLAN. I'm not using SQL Server CE to syncrhonize, but just want to do simple read/writes directly to SQL Server. I can ping the server itself just fine, but for some reason I can't make an ADO connection work in my application.

Does anyone know a way I can test my DB connection outside of my application? I just want to see if I can actually connect to the DB. I don't have anything like Query Analyzer or Enterprise Manager on the Pocket PC... the only thing like that I could find was the SQL Server CE QAnalyzer, and that is for the CE replicated database.

Thank you for any advice. I am new to this whole Pocket PC programming. If this question better suits another forum, let me know.

 

[gmmastros]

I don't know anything about PocketPC (but I hope to get in to it soon).

Whenever I have a problem connecting to SQL Server, I attempt to set up an ODBC connection. I don't know if ODBC is an option with Pocket PC, but I suggest you look there first.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[DotNetGnat]

try setting up a UDL.

-DNG