Results 1 to 2 of 2

Thread: connection problem

  1. #1

    Thread Starter
    Hyperactive Member schuurke28's Avatar
    Join Date
    Feb 2001
    Posts
    402

    connection problem

    what is wrong with this code? I'm getting this error:

    An unhandled exception of type 'System.ArgumentException' occurred in system.data.dll

    Additional information: Format of the initialization string does not conform to the OLE DB specification. Starting around char[34] for connection string of 'Provider=Microsoft.Jet.OLEDB.4.0; Password="; Data Source=C:\dbWijn.mdb;'.

    code:
    Imports System.data
    Imports System.Data.OleDb

    Public Class Form1
    Inherits System.Windows.Forms.Form

    #Region " Windows Form Designer generated code "

    Public Sub New()
    MyBase.New()

    'This call is required by the Windows Form Designer.
    InitializeComponent()

    'Add any initialization after the InitializeComponent() call

    End Sub

    'Form overrides dispose to clean up the component list.
    Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
    If disposing Then
    If Not (components Is Nothing) Then
    components.Dispose()
    End If
    End If
    MyBase.Dispose(disposing)
    End Sub

    'Required by the Windows Form Designer
    Private components As System.ComponentModel.Container

    'NOTE: The following procedure is required by the Windows Form Designer
    'It can be modified using the Windows Form Designer.
    'Do not modify it using the code editor.
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
    '
    'Form1
    '
    Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
    Me.ClientSize = New System.Drawing.Size(292, 266)
    Me.Name = "Form1"
    Me.Text = "Form1"

    End Sub

    #End Region
    Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Password=""; Data Source=C:\dbWijn.mdb;"
    Dim conPubs As OleDbConnection = New OleDbConnection(connString)

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    Try
    conPubs.Open()

    Catch err As Exception
    MsgBox(err.ToString)

    Finally
    conPubs.Close()

    End Try
    End Sub
    End Class

  2. #2
    Banished Cander's Avatar
    Join Date
    Dec 2000
    Location
    Why do you care?
    Posts
    6,913
    take out the double quotes after password=
    Stack Overflow
    See the features of Visual Studio 2010 and C# 4.0: The 10-4 show on Channel9

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width