Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

All contents are copyright of their authors.

compiler does not like teh word "Provider" in my connectionString

Home
Forums
Learn iOS Programming

compiler does not like teh word "Provider" in my connectionString

schmintan

22yAsked Apr 16, 2004, 5:56 AM3.6kLearn iOS Programming

im new to this connecting to databases. i have in my connection string: connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:/db1.mdb"; i get an error during compilation saying " An unhandled exception of type 'System.ArgumentException' occurred in system.data.dll Additional information: Keyword not supported: 'provider'." anyone know how to get around it ?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

kovan22y ago
FYI: any adapter that is related to SQL server (having sql infront of it) does not support "Providers"
schmintan22y ago
im such a stupid head. i was using SqlDataAdaptop instead of OleDbDataAdaptor. im real sorry for botherin you all..
schmintan22y ago
changed it to this : connectionString ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\db1.mdb; "; still the same error as i posted earlier.thanks for trying though
Andrzej Wegierski22y ago
Maybe slash instead of backslash in DataSource? See connectionstrings