Re: 2 connection strings, one SQL one network MDB

<add name="MDB_cn" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\MyServer\MyFolder\MyDB.mdb;User Id=someuser;Password=somepassword" providerName="System.Data.Oledb" />

here's a good site for connection strings
http://www.connectionstrings.com/?carrier=access



--
Misbah Arefin
https://mcp.support.microsoft.com/profile/MISBAH.AREFIN
http://dotnethitman.spaces.live.com
http://www.linkedin.com/in/misbaharefin




"Plateriot" <Plateriot@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:A452D5B4-5C22-4D2D-863D-59C940F7608A@xxxxxxxxxxxxxxxx
I have a website in which I connect to a SQL SERVER via SQL username and
password

I added another connection string in hopes of connecting to a Networked MDB
to get updates to the SQL Server.

This 2nd connection string has a generic username and password, provided to
me by the System administrator.

Where in my 2nd connection string do I add the generic username and password
provided by the System administrator?

Here's the connection string piece of my Web.Config:


<connectionStrings>
<add name="SQL_cn" connectionString="Data Source=MYSERVER;Initial
Catalog=MYDb;Persist Security Info=True;User
ID=myusername;Password=mypassword" providerName="System.Data.SqlClient"/>
<add name="MDB_cn" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\\MyServer\MyFolder\MyDB.mdb" providerName="System.Data.Oledb"/>
</connectionStrings>

.