Data Source???????

Hello Experts,

I am new to this techology.

I am developing an application-in which i am uisng vb.net as the front end and ms-access at the back end.

My database name is: db1.mdb and table name is: student

When i tried to connect with the ms-access database in one-oledbdatadapter- wizard - it asks to enter value for "Data Source"- i don't know what it wants. i gave my db name then the table-but it replied -something like "invalid path/file name"

Plz help me what can i do

Thank You

Answer this question

Data Source???????

Armin_

The connection string in your OleDbConnection should look something like -

Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\Access_Data_Files\SAMPLE.MDB; User ID=admin; Password=;

The Data Source value should be the full path to your Access MDB file.

Disclaimer: This posting is provided "AS IS" with no warranties, and confers no rights
Manonbbar

Can anyone advise on how I go about compiling an ODBC Connection String for MS2003 Access, and indeed, whether it's worth it. The DNS bit's giving me the hang-up. The help file for DNS is quite light on XPH. But SQL, can't fault it, nope siree BoB
Tommief

Thankyou Pravee

cheers
winterforever
you are suppose to mark siraj lala's post as answer not yours.
David Jordan

Hello Sohail Iqbal , I am sorry. Now i changed it. Thank You!
Priya Lakshminarayanan - MSFT
Hello Mr.Siraj Lala

Thanks for your reply.

I will try your advice. If it didn't work, i would post here again.

Thanks for your reply

Thank You
Roman Koreshkov
V. Handy web-site http://www.connectionstrings.com/
Rich Baker
Many thanks Anarchy. Perhaps we both have the same ends The means is another matter entirely.
Data Source???????

Answer this question