C
Craig Buchanan
I have configure my database's connection string the web.config's:
<connectionStrings>
<add name="MyDatabase"
providerName="Microsoft.Jet.OLEDB.4.0"
connectionString="Data Source=.\App_Data\MyDatabase.mdb;Persist
Security Info=False"
/>
Moreover, I can retrieve this setting using this code:
Dim settings As ConnectionStringSettings =
ConfigurationManager.ConnectionStrings("MyDatabase")
Dim cn As New OleDbConnection(String.Concat("Provider=",
settings.ProviderName, ";", settings.ConnectionString))
I have two questions:
1). Is there another way to get the 'full' connection string, rather
than having to concatinate the ProviderName and ConnectionString properties?
2). The '.\App_Data\MyDatabase.mdb' resolves to 'C:\Program
Files\Microsoft\Visual Studio 8\Common7\IDE\App_Data\MyDatabase.mdb'. I
would like this path to be relative to WebService's directory. Is there
a way to do this?
Thanks for your time,
Craig Buchanan
<connectionStrings>
<add name="MyDatabase"
providerName="Microsoft.Jet.OLEDB.4.0"
connectionString="Data Source=.\App_Data\MyDatabase.mdb;Persist
Security Info=False"
/>
Moreover, I can retrieve this setting using this code:
Dim settings As ConnectionStringSettings =
ConfigurationManager.ConnectionStrings("MyDatabase")
Dim cn As New OleDbConnection(String.Concat("Provider=",
settings.ProviderName, ";", settings.ConnectionString))
I have two questions:
1). Is there another way to get the 'full' connection string, rather
than having to concatinate the ProviderName and ConnectionString properties?
2). The '.\App_Data\MyDatabase.mdb' resolves to 'C:\Program
Files\Microsoft\Visual Studio 8\Common7\IDE\App_Data\MyDatabase.mdb'. I
would like this path to be relative to WebService's directory. Is there
a way to do this?
Thanks for your time,
Craig Buchanan