Format of the initialization string does not conform to specification starting at index 0.

[openleren]

Hi all,
with a little help from my friends, I am trying to construct a
connectionstrin g from a relative path in web.config.
It contains
<add key="conAccess" value="microsof t.jet.oledb.4.0 ;data
source=data/database.mdb" />

In my webform I constructed a fucntion

Public Function getConnectionSt ring() As String
Dim conString As String =
System.Configur ation.Configura tionSettings.Ap pSettings.Item( "conAccSucculen t
en")
Dim relPathPositie As Integer = conString.Index Of("data source=") +
12
Dim puntKommaPositi e As Integer = conString.Index Of(";"c,
relPathPositie)
Dim relPath As String
If puntKommaPositi e = -1 Then
relPath = conString.Subst ring(relPathPos itie)
Else
relPath = conString.Subst ring(relPathPos itie,
puntKommaPositi e - 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 conAccessSuccul enten As New OleDbConnection (getConnectionS tring())

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

[Martin Dechev]

Hi, Jan,

Are you sure there is a semicolon (;) at the end of the string after you
reconstruct it?

What is the connectionstrin g at the end any way?

Greetings
Martin
"openleren" <op*******@skyn et.be> wrote in message
news:41******** *************@n ews.skynet.be.. .

Hi all,
with a little help from my friends, I am trying to construct a
connectionstrin g from a relative path in web.config.
It contains
<add key="conAccess" value="microsof t.jet.oledb.4.0 ;data
source=data/database.mdb" />

In my webform I constructed a fucntion

Public Function getConnectionSt ring() As String
Dim conString As String =
System.Configur ation.Configura tionSettings.Ap pSettings.Item( "conAccSucculen t en")
Dim relPathPositie As Integer = conString.Index Of("data source=") + 12
Dim puntKommaPositi e As Integer = conString.Index Of(";"c,
relPathPositie)
Dim relPath As String
If puntKommaPositi e = -1 Then
relPath = conString.Subst ring(relPathPos itie)
Else
relPath = conString.Subst ring(relPathPos itie,
puntKommaPositi e - 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 conAccessSuccul enten As New OleDbConnection (getConnectionS tring())

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