Sunday, February 19, 2012

Error 25 invalid connection string

here is the string:
Data Source=.\MSSQLSERVER;AttachDbFilename="C:\Program Files\Microsoft
SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf";Integrated
Security=True;Connect Timeout=30;User Instance=True
i am trying to connect visuyal c# express with sql server 2005 develop
edition
Can someone point what is wrong with my connection stringTry adding the "Initial Catalog=AdventureWorks" key-value pair. What's the
exception message?
See Chapter 9.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"pierre" <pf@.arobas.net> wrote in message
news:uEARym9THHA.4928@.TK2MSFTNGP03.phx.gbl...
> here is the string:
> Data Source=.\MSSQLSERVER;AttachDbFilename="C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf";Integrated
> Security=True;Connect Timeout=30;User Instance=True
> i am trying to connect visuyal c# express with sql server 2005 develop
> edition
> Can someone point what is wrong with my connection string

No comments:

Post a Comment