"Data source name not found and no default driver specified!!!"

[abcdefg987]

On my form i have a datagrid control with an Adodc control, the adodc control is connected to a database using the app.path function(in run-time, under the "form_load" sub)... the datagrid is connected to the adodc control from the record source property...

but... whenever i try running the program an error comes up... saying

"Data source name not found and no default driver specified"

This is what my coding looks like:

Private Sub Form_Load()
connection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Database.mdb;Persist Security Info=False"
Adodc1.ConnectionString = connection
End sub

Could someone please help me!!!!!?????

[VictorN]

And what does App.Path contain?

[VictorN]

And one of the possible reasons is here: http://livedocs.adobe.com/dreamweave...e=31_trou5.htm

[abcdefg987]

i used app.path to find the database's location instead of typing the entire file path!

[VictorN]

i used app.path to find the database's location instead of typing the entire file path!

Well, it is clear enough!
But I asked you NOT "what for" are you using it. I asked you:

... what does App.Path contain?

In other words: what exactly was the connection string you were assigning to Adodc1.ConnectionString ?

[abcdefg987]

ohh!! ooops!!
i'm not to sure if i understood ur question but... i think
app.path contains....... C:\Users\Arjun Puri\Desktop\Database.mdb

[VictorN]

... i think
app.path contains....... C:\Users\Arjun Puri\Desktop\Database.mdb

You "think" or it does contain this path?
Did you check whether this DB was locked?

[dglienna]

Why would you put the app (and db?) on THE DESKTOP? Probably can't WRITE to that folder

If you're using Vista+, install everything to AppData instead