|
Subject:
|
Connection string for MSDE
|
|
Posted By:
|
srkarthik_82
|
Post Date:
|
1/24/2007 11:34:17 PM
|
Hi,
I need the connection string in .Net 1.1v, c#, for connecting my database which is in MSDE[Microsoft Database Engine].
My Existing code for connection string:
<add key="BWFM_ConnStr" value="server=MSDENEW; user id=sa; password=buildfolio1819; database=ORQSample;instancename=MSDENEW;"/>
The Error I am getting is:
Keyword not supported: 'instancename'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentException: Keyword not supported: 'instancename'.
Thanks in advance..........
Karhtik
|
|
Reply By:
|
karthiklsimha
|
Reply Date:
|
1/25/2007 12:35:38 AM
|
Hi Karthik,
Try this...
<add key="BWFM_ConnStr" value="Password=buildfolio1819;User ID=sa;Initial Catalog=ORQSample;Data Source=[ServerName\MachineName]\MSDENEW"/>
In the above replace [ServerName\MachineName] with the Machine Name where MSDE (Microsoft SQL Server Desktop Engine) is installed. If you are trying to access MSDE installed in the local machine then use
Source=.\MSDENEW
Regards,
Karthik Simha
|
