Hello,
I've set up an ADO connection to a SQLServer, but although it works great, I'm not really sure if it is the best approach to use.
Even though I use ADO, it also lists OleDB in the connection string. Does this make it an OleDB connection then?
I've only recently started to venture outside of the comfortable Excel/Access environment, so I dont really know much about different strategies.
In short:
can someone explain a bit about different types of connections and their advantages?
Cheers,
Roel
I've set up an ADO connection to a SQLServer, but although it works great, I'm not really sure if it is the best approach to use.
Even though I use ADO, it also lists OleDB in the connection string. Does this make it an OleDB connection then?
I've only recently started to venture outside of the comfortable Excel/Access environment, so I dont really know much about different strategies.
In short:
can someone explain a bit about different types of connections and their advantages?
Cheers,
Roel