connecting sql server from windows ce application through Activesync without being on network

sql-server connection windows-ce wmdc
Adnan Badar picture Adnan Badar · Jul 27, 2011 · Viewed 8.8k times · Source

I've connected my Motorola MC3090R having Windows CE 5 through cradle (Windows Mobile Device Center) with my laptop having Windows 7 (there is no network), my question is that how i will connect to sql server (it's on my laptop) from my handheld app? what will be my connection string inside my handheld app? as there is no network what ip i will use in the connection string?

please help

Answer

Adnan Badar picture Adnan Badar · Jul 31, 2011

I solved it with this connection string.

m_Desktopconn = New SqlConnection(
  "Data Source=192.168.55.100,1433;Initial Catalog=Testing;Persist Security Info=True;User ID=sa;Password=sa;")

I had two instances MYPC\SQL2005 & MYPC\SQL2008, and then installed SQL 2005 Express on MYPC (Without instance)

Related questions

Login to Microsoft SQL Server Error: 18456

I am getting this error while trying to connect to the SQL Server. Microsoft SQL Server Error: 18456 Can anybody tell me what the error code means?

Read More
How to determine total number of open/active connections in ms sql server 2005

My PHP/MS Sql Server 2005/win 2003 Application occasionally becomes very unresponsive, the memory/cpu usage does not spike. If i try to open any new connection from sql management studio, then the it just hangs at the open connection dialog …

Read More
How to check for database availability

I have the following code to test DB connection, it runs periodically to test for DB availability: private bool CheckDbConn() { SqlConnection conn = null; bool result = true; try { conn = DBConnection.getNewCon(); ConnectionState conState = conn.State; if (conState == ConnectionState.Closed || conState == ConnectionState.…

Read More