ADODB.connection

[richarddenton]

Hi,

I am trying to connect to Access without using the connection wizard but the code which I have taken from TechGnome's tutorial won't work as the ADODB.connection is not defined.

Am I missing something really basic here i.e. a reference to ADO.net? Help will be much appreciated.

Richard

 

[TechGnome]

Ahhh, grasshopper, that is because you have snatched the wrong rock from the worng stream. the ADODB tutorials are for VB6...... you want the ADO.NET tutorials...
Here...
http://www.developerkb.com/modules/wfsection/article.php?articleid=52
And here...
http://www.developerkb.com/modules/wfsection/article.php?articleid=58

-tg

 

[richarddenton]

Thanks, I'm really struggling with connecting to databases. I haven't had any training and feel that if I can get some help with the fundamentals that I'll be a lot better off.

If possible will you keep an eye on this thread as undoubtedly I will continue to become unstuck.

Richard

 

[fpineda101]

You can reference www.connectionstrings.com for your connection string for different databases.