Cant connect to an SQL database with vb express

diverdan

Active member
Joined
Jan 2, 2006
Messages
34
Location
London UK
Programming Experience
Beginner
Hi there,

I am having some problems trying to add a database to a vb express project.

I am running sql 2000 but for some reason it only wants to connect to a 2005 express database.

I have tried adding a new database but I get an error message telling me "Connections to SQL server files(*.mdf)require SQL Express 2005 to work properly"

Is it not possible to use this wizard with SQL2000??

Please help as this is causing a major headache!
 
What are you using for the connectionstring? You can't point it directly to the MDF file.... you have to point it at the server, then the database.....the error message sounds like you're trying to connect to the mdf file directly, which is a new to SQL2005 feature.

-tg
 
How I tried connecting was by right clicking on my project and adding a new project.
Then database

Thats when I get the error.

What do I need to do?
 
Back
Top