Hello All,

I am pulling what little hair I have left out trying to get DNN434 working with SQL SErver Express.

What is up with this  "AttachDbFilename" parameter.    I have searched the web and MS and have seen samples of the connection string.   Here is what I am using.

connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DNN4.mdf;Database=DNN4;Trusted_Connection=Yes;"

I read on another site  that express will attempt to attach the "mdf"  to the server. I also read that if it is already attached it will try to connect but only if you also supply the "Database=DNN4" parameter.

Is this the only valid connection string.   Can someone give me an example of a connect string that can be used if the DB already exists and using SQL authentication with a User ID and PW, please?

I'm getting ready to chuck Express and go back to 2000.

Any help is greeatly appreciated.

BillD42,

I too had problems connecting to SQLExpress.  I got the following to work

Provider=SQLNCLI; Server=.\SQLEXPRESS; Database=Whatever; uid=xxxx; pwd=yyyy;

This assumes you connected to the Database using something like SQL Server Management Studio and set the userid and password accordingly.

The User Instance and AttachDBFilename give you the same single file database experience asAccess - from what I can best determine.  I spend most of my time SQL 2000 and SQL 2005, so my knowledge of SQLExpress is limited at best.

Hope this helps
Paul
www.tressleworks.ca (home of SQLGridSelectedView)