Hi all,
with a little help from my friends, I am trying to construct a
connectionstring from a relative path in web.config.
It contains
<add key="conAccess" value="microsoft.jet.oledb.4.0;data
source=data/database.mdb" />
In my webform I constructed a fucntion
Public Function getConnectionString() As String
Dim conString As String =
System.Configuration.ConfigurationSettings.AppSett ings.Item("conAccSucculent
en")
Dim relPathPositie As Integer = conString.IndexOf("data source=") +
12
Dim puntKommaPositie As Integer = conString.IndexOf(";"c,
relPathPositie)
Dim relPath As String
If puntKommaPositie = -1 Then
relPath = conString.Substring(relPathPositie)
Else
relPath = conString.Substring(relPathPositie,
puntKommaPositie - relPathPositie)
End If
Dim absPath As String = Server.MapPath("~\" & relPath)
Return absPath
End Function
This returns the correct absolute path (tested) which I then use in
Dim conAccessSucculenten As New OleDbConnection(getConnectionString())
No way José, whatever I trie I keep on getting
Format of the initialization string does not conform to specification
starting at index 0.
Any Idea where I'm going wrong?
Jan