Can't Access Access DB

Results 1 to 2 of 2

Thread: Can't Access Access DB

  1. #1
    Join Date
    Dec 1969

    Default Can't Access Access DB

    I have a web service running with this code:<BR><BR><BR><BR>&#060;WebMethod&#062;Function GetEmployeeAll() As System.Data.DataSet<BR>Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _<BR>"dsn=employee_info;User Id = Admin;Mode=Share Deny None;Persist Security Info=False;" <BR> <BR><BR>Dim OleDBConnection As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection(connectionString )<BR><BR>Dim queryString As String = "SELECT * FROM Employees"<BR>Dim OleDBCommand As System.Data.OleDb.OleDbCommand = New System.Data.OleDb.OleDbCommand(queryString, OleDBConnection)<BR><BR>Dim dataAdapter As System.Data.OleDb.OleDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter(OleDBCommand)<B R>Dim dataSet As System.Data.DataSet = New System.Data.DataSet()<BR>dataAdapter.Fill(dataSet) <BR><BR>End Function <BR><BR><BR>Whenever my service tries to connect through the dsn I receive this error:<BR><BR>System.Data.OleDb.OleDbException: Could not find instalable ISAm.

  2. #2
    Join Date
    Dec 1969

    Default RE: Can't Access Access DB

    First off, have you istalled the second .NET service pack? Is not, give it a try.<BR><BR>Or, you can try installing this:<BR><BR>It&#039;s a JET update.<BR><BR>Cheers,<BR>Conrad

Posting Permissions

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