Exforsys

Online Training

connect to sql server using compact framework

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 ...


Go Back   Exforsys > Database > SQL Server

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-25-2007, 08:29 AM
Junior Member
 
Join Date: Feb 2007
Posts: 2
jason2 is on a distinguished road
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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


All times are GMT -4. The time now is 03:03 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0
Copyright 2004 - 2007 Exforsys Inc. All rights reserved.