SQLCeConnection

Tech-Archive recommends: Fix windows errors by optimizing your registry

This is the code I am using:

Private Sub frmInventoryTransfer_Load(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles MyBase.Load
Dim objConn As SqlCeConnection = Nothing
Dim objEngine As SqlCeEngine = Nothing
Dim objComm As New SqlCeCommand
Dim objDataReader As SqlCeDataReader = Nothing
Dim txtItemNumber As String
'Dim objDrItems As SqlCeDataAdapter
'"User ID=DSUSER;PASSWORD=silentk;Data
Source=NTSERVER-2;Initial
'Catalog=Direct Source System;Persist Security
Info=False;Packet
'Size=4096"
'objEngine.LocalConnectionString = "Data Source=NTSERVER-2"
'objEngine.CreateDatabase()
objEngine = New SqlCeEngine("Data
Source=NTSERVER-2;password=silentk;user ID='DSUSER'")
'objEngine.CreateDatabase()
'objEngine.Dispose()
objConn = New SqlCeConnection("Data
Source=NTSERVER-2;password=silentk")
objConn.Open()
objComm = objConn.CreateCommand()
objComm.CommandText = "SELECT * FROM Products"
objComm = New SqlCeCommand(objComm.CommandText, objConn)
objDataReader = objComm.ExecuteReader

While objComm.ExecuteNonQuery = True
txtItemNumber = objComm.ExecuteNonQuery
End While
objConn.Close()

MsgBox(txtItemNumber)
End Sub

I get the following error:

An unhandled exception of type 'System.ArgumentException' occurred in
System.Data.SqlServerCe.dll

Additional information: Unknown connection option in connection string:
user id.

.

Relevant Pages

  • Event Log Collation
    ... Dim objFSO, objFile, strServers, arrServers, strServer ... Dim objWMIService, colEvents, objEvent ... Dim strTableName, strSqlSvrName, objConn, strDBName, strSql, objCmd ...
    (microsoft.public.windows.server.scripting)
  • OLEDB-Zugriff auf MS-SQL Server2005 Express Edition mit VB.NET
    ... VB.NET und SQL-Server ein. ... Function getConn(ByVal strDBName As String) As ... Dim strConn As String ... Dim objConn As System.Data.OleDb.OleDbConnection ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • AC2003: ODBC-Zugriff auf Excel
    ... Dim objConn As ADODB.Connection ... Dim objComm As New ADODB.Command ... Set objConn = Connect2 ... Optional strPfad As String = "") As ADODB.Connection ...
    (microsoft.public.de.access)
  • RE: Converting VB to C#
    ... Dim x as Label = e.Item.FindControl ... Function getDetailas SqlDataReader ... Dim objConn as New SqlConnection ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: OLEDB-Zugriff auf MS-SQL Server2005 Express Edition mit VB.NET
    ... Function getConn(ByVal strDBName As String) As ... Dim strConn As String ... Dim objConn As System.Data.OleDb.OleDbConnection ... Fehler bei der Anmeldung für den Benutzer ''. ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)