Problems connecting to Access database

[oobern]

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

[Syberius]

This is the connection code I have been using for my database programming in ADO.

visual basic code: Dim dbFile As String ' Holds the path to the database file
' Asign data
dbFile = App.Path & "\lecture.mdb"
Set adoConnection = New ADODB.Connection
adoConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" &
"Data Source=" & dbFile & ";" & "Persist Security Info=False"

I am not entirely sure if the Persist and Security Info need to be in the string or not but that does apear to work.

Syberius,

[oobern]

Thank you very much. I modified your code and it worked!!!. Between your code and mine there is really no difference from what i can see. But you method works, so i think i will put the whole path and database file to a variable and pass that to the connection string from now on. Thanks again

[Syberius]

It probably has something to do with the string but im no expert on OLE so I cannot say for sure.

Glad it is working for you.

Oh, I edited the code above to split the lines, was all on one big line before for some reason.

Syberius.