How to connect to MSDE with C#

9 Feb 2006 6:35 PM

aboutjav.com

Hi,

I am new with ADO.net and MSDE. I work with SQL server, but our project
requires an export to MSDE. Currently, my connection string is

DbConn = new OleDbConnection("Provider=SQLOLEDB.1;Data
Source="+strSqlServerName+"; Initial Catalog="+strSqlServerDbName+";
uid="+m_strDbUserName+";pwd="+m_strDbPassword);

How do I modify this to find my MSDE database and connect to it? Also,
how do I find the name of the MSDE database server on my PC?

Thanks,

AJ

9 Feb 2006 7:00 PM

W.G. Ryan - MVP

<aboutjav.***@gmail.com> wrote in message

news:1139510142.047823.286330@o13g2000cwo.googlegroups.com...
> Hi,
>
> I am new with ADO.net and MSDE. I work with SQL server, but our project
> requires an export to MSDE. Currently, my connection string is
>
> DbConn = new OleDbConnection("Provider=SQLOLEDB.1;Data
> Source="+strSqlServerName+"; Initial Catalog="+strSqlServerDbName+";
> uid="+m_strDbUserName+";pwd="+m_strDbPassword);
>
>
> How do I modify this to find my MSDE database and connect to it?

-http://www.connectionstrings.com/ (expand the Sql Server 2005 node)
Also,

> how do I find the name of the MSDE database server on my PC?

-http://www.codeproject.com/cs/database/SubmitSQLInfoEnumerator.asp

Show quote

>
> Thanks,
>
> AJ
>

10 Feb 2006 11:23 AM

Val Mazur (MVP)

Hi,

MSDE is a SQL Server, but just a light version of it and some limitations.
It means, to connect to it from your code, you are using exact same
connection. There is no difference. You suppose to see service running for
your MSDE and there you could check your MADE server name.

--
Val Mazur
Microsoft MVP
http://xport.mvps.org

<aboutjav.***@gmail.com> wrote in message

Show quote

news:1139510142.047823.286330@o13g2000cwo.googlegroups.com...
> Hi,
>
> I am new with ADO.net and MSDE. I work with SQL server, but our project
> requires an export to MSDE. Currently, my connection string is
>
> DbConn = new OleDbConnection("Provider=SQLOLEDB.1;Data
> Source="+strSqlServerName+"; Initial Catalog="+strSqlServerDbName+";
> uid="+m_strDbUserName+";pwd="+m_strDbPassword);
>
>
> How do I modify this to find my MSDE database and connect to it? Also,
> how do I find the name of the MSDE database server on my PC?
>
> Thanks,
>
> AJ
>

10 Feb 2006 5:20 PM

William (Bill) Vaughn

With ADO.NET you should use the SqlClient SQL Server provider for all
versions of SQL Server 7.0 or higher. See my blog for a detailed checklist
on getting connected.

--
____________________________________
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.
__________________________________

<aboutjav.***@gmail.com> wrote in message

Show quote

news:1139510142.047823.286330@o13g2000cwo.googlegroups.com...
> Hi,
>
> I am new with ADO.net and MSDE. I work with SQL server, but our project
> requires an export to MSDE. Currently, my connection string is
>
> DbConn = new OleDbConnection("Provider=SQLOLEDB.1;Data
> Source="+strSqlServerName+"; Initial Catalog="+strSqlServerDbName+";
> uid="+m_strDbUserName+";pwd="+m_strDbPassword);
>
>
> How do I modify this to find my MSDE database and connect to it? Also,
> how do I find the name of the MSDE database server on my PC?
>
> Thanks,
>
> AJ
>