Driver vs Provider?

I had a problem and i searched the net and came up with this

---copy and paste from website--
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xda8 Thread 0x49c DBC 0x254d024 Jet'.

Resolution
----------

To resolve this error modify your connection string to "microsoft.jet.oledb...." instead of "{microsoft access...}". The example is given below:

set conn = server.createobject("ADODB.Connection")
conn.Open = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ= {path to your database}

The above connection string is very flaky and should be replaced with the below one.

set conn = server.createobject("ADODB.Connection")
conn.Open = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source= {path to your database}

--end copy--


what are your thoughts on this, which way is the best to connect to your db?

The OLEDB give u a native connection to your database avoiding the extra layer of the ODBC. It is faster then using DSN and/or DSN-Less connections.

As for a thorough explanation of why? how? I'm affraid I can't help you there. A good google search might give you more info then me.

Hope this helps!
Sincerely

Vlince

Ahh i see, thank you