Confused About Connections

  • Thread starter Thread starter Wayne Wengert
  • Start date Start date
W

Wayne Wengert

What is the difference between an OleDBConnection and an ADODB.Connection? I
am working in a VB Express 2005 application and I want to have a global
connection object throughout but when creating a table in an Acess DB using
ADOX the OleDBConnection won't work and I have to create an
ADODB.Connection. I am confused (as usual!)

Wayne
 
Wayne,

ADOX doesn't work ADO.NET, which the OleDbConnection class is part of. To
use ADOX, you need to go with ADO.
 
Carsten;

Thanks for that information. I ended up using the ADODB connection for the
ADOX stuff and an OleDBConnection for the rest. Is there a "correct" way in
..NET to create an Access DB and table?

Wayne
 
Back
Top