Does anyone know if you can connect and use SQL 2000 Server with VB Epress 2005 datasources tab wizard I use the datasources tab to try to connect but it keeps failing to connect. VB6 seems to connect fine using the data environment wizard.
I can connect to the SQL 2000 database with code without any problems in VB Epress 2005.

USING SQL 2000 with VB 2005 Express
dawnhornby
Express editions have design support for local data only (.mdf and .mdb files).
The version/feature matrix is located here:
http://lab.msdn.microsoft.com/vs2005/productinfo/productline/default.aspx
hope that helps
newbob
kleistweg
How exactly are you trying to connect to it