Results 1 to 4 of 4

Thread: Problems connecting to Access database

Threaded View

  1. Feb 4th, 2005, 06:24 PM #1
    oobern
    oobern is offline

    Thread Starter
    Member
    Join Date
    Dec 2004
    Posts
    44

    Resolved Problems connecting to Access database

    I am having a wierd error when trying to connect to a database. I have been using the same code all the time to connect but still get error .

    "[Microsoft][ODBC Driver Manager], data source name not found and no default driver specified"

    Below is my code:
    Set oConn = New ADODB.Connection
    Set ors = New ADODB.Recordset
    cs = "Provider=Microsoft.Jet.OLEDB.4.0;" _
    & "Data Source=" & App.Path & "\Database.mdb"
    'oConn.Mode = adModeReadWrite
    oConn.Open , cs
    ors.Open "tblCategory", cs, adOpenStatic

    I have made sure that my references were corrrect. Can someone give me a hand on what this may be. Thanks in advance.

    oobern
    Last edited by oobern; Feb 4th, 2005 at 07:21 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width