This is a discussion on connect to sql server using compact framework within the SQL Server forums, part of the Database category; hi, i try to build a app for a pda device and i want that app comunicate with a sql ...
|
|||||||
|
|||
|
connect to sql server using compact framework
hi,
i try to build a app for a pda device and i want that app comunicate with a sql server on other machine. Now i have problems with very small resources with the compact framework anyone know who can i connect to a sql server with compact framework and execute some sql commands? i have this code: Dim l_sqlConn AsNew System.Data.SqlClient.SqlConnection("Persist Security Info=False;Integrated Security=False;Server=192.168.2.114;initial catalog=new_one;user id=sa;password=1234;") l_sqlConn.Open() Dim l_sqlCmd As System.Data.SqlClient.SqlCommand l_sqlCmd = l_sqlConn.createCommand l_sqlCmd.CommandText = "SELECT * FROM clientes" but they display this error: sql server does not exist or acess denied can you helpme and tell me what i doing wrong? thanks a lot |
| Sponsored Links |
![]() |
| Bookmarks |
| Thread Tools | Search this Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| SQL SERVER CE | NareshShroff | Microsoft .NET Tutorials and Articles | 0 | 08-18-2004 05:32 AM |
| SQL Server CE 2.0 installation Problem | NareshShroff | SQL Server 2005 Tutorials | 2 | 07-17-2004 07:55 AM |
| Solaris x86 FAQ 2/2 | Dan Anderson | Tech FAQ | 0 | 04-27-2004 08:24 PM |
| Sybase FAQ: 1/19 - index | David Owen | Tech FAQ | 2 | 04-20-2004 10:45 AM |
| Kerberos FAQ, v2.0 (last modified 8/18/2000) | Ken Hornstein | Tech FAQ | 0 | 04-17-2004 08:28 AM |