TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
nshroff
NA
2
0
SQL Server CE data connectivity
Aug 17 2004 9:51 PM
Hi, some one please help me since 2 days im struggling hard to just make the connection work, but till now im not able to get it done. I just copied the example code for pull method from msdn still not working. I tested my SQL Server virtual directory configuration. and is fine. This is the error im getting =========================== SQL Server CE encountered problems in opening the SQL Server CE database =========================== COde Private Sub btnPull_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPull.Click ' If File.Exists("My Downloadsssce.sdf") Then 'File.Delete("My Downloadsssce.sdf") ' End If 'Dim sqlEngine As New SqlCeEngine("Data Source=My Downloadsssce.sdf") 'sqlEngine.CreateDatabase() Dim rdaOleDbConnectString As String = "Provider=sqloledb; Data Source=NARESH;Initial Catalog=NorthWind; User ID=;Password=" Dim rda As SqlCeRemoteDataAccess = Nothing Try rda = New SqlCeRemoteDataAccess rda.InternetLogin = "" rda.InternetPassword = "" rda.InternetUrl = "http://NARESH/SQLCE/sscesa20.dll" rda.LocalConnectionString = "Provider=Micrsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=My Downloadsssce.sdf" rda.Pull("Employees", "Select * from Employees", rdaOleDbConnectString, RdaTrackOption.TrackingOnWithIndexes, "ErrorTable") MsgBox("Pull Operation Completed", MsgBoxStyle.Information, "Pull") Catch ex As SqlCeException MessageBox.Show(ex.Message) Finally rda.Dispose() End Try End Sub ===================== On searching google i understood that the problem is with the connection string or SQL Server 2000 user account. I didnt find much info about this error. Please someone who knows about pocket pc development help me out. I need to finish this project asap. I searched all the forums and articles but could able to fix it. It would be very very greatfull if someone can guide me thru in SQL Server CE Database connectivity. Thank You, NKS
Reply
Answers (
0
)
creating a graphcs object
Socket.Bind: Exception on PC's with different IP-Addresses.