access database connection curious query!!!

[son]

hi hope all is well..

 

i have a microsoft access database and i am using asp.net web applications.. i have connected to my database using from the menu tools>connect to database option>server explorer and i did a connection to my database and its working fine ( i am using microsoft.jet.oledb.4.0 as my provider) normally when i use sql server 2000 and use a database from sql server 2000 my connection settings are in the web.config file and for example are as follows:

<appSettings>

<add key="NorthwindConnection" value="user id=sa;password=;initial catalog=Northwind;data source=;Connect Timeout=60;max pool size=400"/>

</appSettings>

 

can someone tell me why when i am connecting to my microsoft access database , is not showing in the webconfig file like when i use sql server 2000 ? when i rightclick in my server explorer and go on my access database connection and right click its shows the database connections properties window

can someone please explain to me why.. ? thanks in advance sonia.. take care

[PlausiblyDamp]

If you have dragged the connection to a web form then select the connection object and on the property grid expand dynamic properties. From there you should be able to make the connection string dynamic (i.e. moved to web.config)

[son]

hi thanks for your reply.. i just did as u recommended in the dynamic properties in connectionstring property i choose my oledbconnection1.connectionstring, in the advanced property i choose OleDbConnection1.ConnectionString as my key. then after i do that in my dynamic property there is nothing.. i saved everything went into the webconfig file and here is what is showing as my connection

<appSettings>
	<!--   User application and configured property settings go here.-->
	<!--   Example: <add key="settingName" value="settingValue"/> -->
	<add key="OleDbConnection1.ConnectionString" value="" />
</appSettings>

 

is it right or not? also i went to see if my connection is still showing in the properties window of my connection in the connect window and its still is .. is it suppose to be like that...? thanks in advance and also for your help...

[PlausiblyDamp]

In the property grid does the connectionstring property have a funny blue icon next to it? If so things are working. Easiest way to check is run the app & test, then change the web.config and test again to see if it fails.

[son]

thanks loads...

 

hi thanks loads.. ur really helpful.. me really appreciate it... once again thanks..

yep me do have that funny blue icon... yep its working fine...

 

thanks and take care ;)

In the property grid does the connectionstring property have a funny blue icon next to it? If so things are working. Easiest way to check is run the app & test' date=' then change the web.config and test again to see if it fails.[/quote']