I'm trying to modify the connection string made by the dataadapter wizard to
a relative path. My current datasource is this:

""C:\Inetpub\wwwroot\database\database.mdb""

How can i change so when its on the server it will look for the directory
"database" in the root of the virtual directory?


cheers

Dim cn As OleDb.OleDbConnection

cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath(ConfigurationSettings.AppSettings("path"))) ' -->>>
c:\inetpub\wwwroot\global\data\project1.mdb

web.config...

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="path" value="/global/data/project1.mdb" />
</appSettings>

<system.web>
.... etc

HTH,
Greg

"john smithers" <(E-Mail Removed)> wrote in message
news:8E6CC9A6-1A01-4427-9957-(E-Mail Removed)...
> I'm trying to modify the connection string made by the dataadapter wizard
to
> a relative path. My current datasource is this:
>
> ""C:\Inetpub\wwwroot\database\database.mdb""
>
> How can i change so when its on the server it will look for the directory
> "database" in the root of the virtual directory?
>
>
> cheers

thx for the reply but i'm looking at the "web form designer generated code"
and have found the oledbdataconnections and just want to modify this. What
i'm really having problem with is the syntax.

'
'OleDbConnection1
'
Me.OleDbConnection1.ConnectionString = "Jet OLEDB:Global Partial
Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDBatabase L" & _
"ocking Mode=0;Data
Source=""C:\Inetpub\wwwroot\db\database.mdb"";Jet OLEDB:Engine " & _
"Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System
database=;Jet OLEDB:S" & _
"FP=False;persist security info=False;Extended
Properties=;Mode=Share Deny None;J" & _
"et OLEDB:Encrypt Database=False;Jet OLEDB:Create System
Database=False;Jet OLEDB" & _
"on't Copy Locale on Compact=False;Jet OLEDB:Compact Without
Replica Repair=Fal" & _
"se;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1"


Data source - i need to change to a relative path like
server.mappath(/database/database.mdb) but everything i've tried keeps
bringing up syntax errors.

















"Greg Burns" wrote:

> Dim cn As OleDb.OleDbConnection
>
> cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> Server.MapPath(ConfigurationSettings.AppSettings("path"))) ' -->>>
> c:\inetpub\wwwroot\global\data\project1.mdb
>
> web.config...
>
> <?xml version="1.0" encoding="utf-8" ?>
> <configuration>
> <appSettings>
> <add key="path" value="/global/data/project1.mdb" />
> </appSettings>
>
> <system.web>
> .... etc
>
> HTH,
> Greg
>
> "john smithers" <(E-Mail Removed)> wrote in message
> news:8E6CC9A6-1A01-4427-9957-(E-Mail Removed)...
> > I'm trying to modify the connection string made by the dataadapter wizard
> to
> > a relative path. My current datasource is this:
> >
> > ""C:\Inetpub\wwwroot\database\database.mdb""
> >
> > How can i change so when its on the server it will look for the directory
> > "database" in the root of the virtual directory?
> >
> >
> > cheers
>
>
>

Changing the desinger generated code is asking for trouble. The designer
will just overwrite it again when you least expect it.

Greg

'OleDbConnection1
'
Me.OleDbConnection1.ConnectionString = "Jet OLEDB:Global Partial
Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDBatabase L" & _
"ocking Mode=0;Data
Source=" & Server.MapPath("/db/database.mdb") & ";Jet OLEDB:Engine " & _
"Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System
database=;Jet OLEDB:S" & _
"FP=False;persist security info=False;Extended
Properties=;Mode=Share Deny None;J" & _
"et OLEDB:Encrypt Database=False;Jet OLEDB:Create System
Database=False;Jet OLEDB" & _
"on't Copy Locale on Compact=False;Jet OLEDB:Compact Without
Replica Repair=Fal" & _
"se;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1"


"john smithers" <(E-Mail Removed)> wrote in message
news:00580164-8444-4EF5-83A2-(E-Mail Removed)...
> thx for the reply but i'm looking at the "web form designer generated
code"
> and have found the oledbdataconnections and just want to modify this. What
> i'm really having problem with is the syntax.
>
> '
> 'OleDbConnection1
> '
> Me.OleDbConnection1.ConnectionString = "Jet OLEDB:Global Partial
> Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDBatabase L" & _
> "ocking Mode=0;Data
> Source=""C:\Inetpub\wwwroot\db\database.mdb"";Jet OLEDB:Engine " & _
> "Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System
> database=;Jet OLEDB:S" & _
> "FP=False;persist security info=False;Extended
> Properties=;Mode=Share Deny None;J" & _
> "et OLEDB:Encrypt Database=False;Jet OLEDB:Create System
> Database=False;Jet OLEDB" & _
> "on't Copy Locale on Compact=False;Jet OLEDB:Compact Without
> Replica Repair=Fal" & _
> "se;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1"
>
>
> Data source - i need to change to a relative path like
> server.mappath(/database/database.mdb) but everything i've tried keeps
> bringing up syntax errors.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> "Greg Burns" wrote:
>
> > Dim cn As OleDb.OleDbConnection
> >
> > cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
&
> > Server.MapPath(ConfigurationSettings.AppSettings("path"))) ' -->>>
> > c:\inetpub\wwwroot\global\data\project1.mdb
> >
> > web.config...
> >
> > <?xml version="1.0" encoding="utf-8" ?>
> > <configuration>
> > <appSettings>
> > <add key="path" value="/global/data/project1.mdb" />
> > </appSettings>
> >
> > <system.web>
> > .... etc
> >
> > HTH,
> > Greg
> >
> > "john smithers" <(E-Mail Removed)> wrote in
message
> > news:8E6CC9A6-1A01-4427-9957-(E-Mail Removed)...
> > > I'm trying to modify the connection string made by the dataadapter
wizard
> > to
> > > a relative path. My current datasource is this:
> > >
> > > ""C:\Inetpub\wwwroot\database\database.mdb""
> > >
> > > How can i change so when its on the server it will look for the
directory
> > > "database" in the root of the virtual directory?
> > >
> > >
> > > cheers
> >
> >
> >

I realise playing around in generator code is not the smartest move, thus,
how can I make the dataadapters call a relative path to the database?

"Greg Burns" wrote:

> Changing the desinger generated code is asking for trouble. The designer
> will just overwrite it again when you least expect it.
>
> Greg
>
> 'OleDbConnection1
> '
> Me.OleDbConnection1.ConnectionString = "Jet OLEDB:Global Partial
> Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDBatabase L" & _
> "ocking Mode=0;Data
> Source=" & Server.MapPath("/db/database.mdb") & ";Jet OLEDB:Engine " & _
> "Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System
> database=;Jet OLEDB:S" & _
> "FP=False;persist security info=False;Extended
> Properties=;Mode=Share Deny None;J" & _
> "et OLEDB:Encrypt Database=False;Jet OLEDB:Create System
> Database=False;Jet OLEDB" & _
> "on't Copy Locale on Compact=False;Jet OLEDB:Compact Without
> Replica Repair=Fal" & _
> "se;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1"
>
>
> "john smithers" <(E-Mail Removed)> wrote in message
> news:00580164-8444-4EF5-83A2-(E-Mail Removed)...
> > thx for the reply but i'm looking at the "web form designer generated
> code"
> > and have found the oledbdataconnections and just want to modify this. What
> > i'm really having problem with is the syntax.
> >
> > '
> > 'OleDbConnection1
> > '
> > Me.OleDbConnection1.ConnectionString = "Jet OLEDB:Global Partial
> > Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDBatabase L" & _
> > "ocking Mode=0;Data
> > Source=""C:\Inetpub\wwwroot\db\database.mdb"";Jet OLEDB:Engine " & _
> > "Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System
> > database=;Jet OLEDB:S" & _
> > "FP=False;persist security info=False;Extended
> > Properties=;Mode=Share Deny None;J" & _
> > "et OLEDB:Encrypt Database=False;Jet OLEDB:Create System
> > Database=False;Jet OLEDB" & _
> > "on't Copy Locale on Compact=False;Jet OLEDB:Compact Without
> > Replica Repair=Fal" & _
> > "se;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1"
> >
> >
> > Data source - i need to change to a relative path like
> > server.mappath(/database/database.mdb) but everything i've tried keeps
> > bringing up syntax errors.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > "Greg Burns" wrote:
> >
> > > Dim cn As OleDb.OleDbConnection
> > >
> > > cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
> &
> > > Server.MapPath(ConfigurationSettings.AppSettings("path"))) ' -->>>
> > > c:\inetpub\wwwroot\global\data\project1.mdb
> > >
> > > web.config...
> > >
> > > <?xml version="1.0" encoding="utf-8" ?>
> > > <configuration>
> > > <appSettings>
> > > <add key="path" value="/global/data/project1.mdb" />
> > > </appSettings>
> > >
> > > <system.web>
> > > .... etc
> > >
> > > HTH,
> > > Greg
> > >
> > > "john smithers" <(E-Mail Removed)> wrote in
> message
> > > news:8E6CC9A6-1A01-4427-9957-(E-Mail Removed)...
> > > > I'm trying to modify the connection string made by the dataadapter
> wizard
> > > to
> > > > a relative path. My current datasource is this:
> > > >
> > > > ""C:\Inetpub\wwwroot\database\database.mdb""
> > > >
> > > > How can i change so when its on the server it will look for the
> directory
> > > > "database" in the root of the virtual directory?
> > > >
> > > >
> > > > cheers
> > >
> > >
> > >
>
>
>

John, I never use the wizards so haven't ran into this problem. My gut
response is to say you can't with the wizard (without modify its generated
output, which is BAD), but somebody will just prove me wrong. :^)

I found this article on google:
http://tinyurl.com/4uts9

It shows how to get the wizard generated code to read your web.config for
the datasource value. This avoids "messing" with the designer code
manually, but also doesn't answer your question. (In other words, not sure
how you would get Server.MapPath to act on your web.config value using this
method).

Sorry,
Greg


"john smithers" <(E-Mail Removed)> wrote in message
news:28738814-9E79-4DE9-A20A-(E-Mail Removed)...
>I realise playing around in generator code is not the smartest move, thus,
> how can I make the dataadapters call a relative path to the database?
>
> "Greg Burns" wrote:
>
>> Changing the desinger generated code is asking for trouble. The designer
>> will just overwrite it again when you least expect it.
>>
>> Greg
>>
>> 'OleDbConnection1
>> '
>> Me.OleDbConnection1.ConnectionString = "Jet OLEDB:Global Partial
>> Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDBatabase L" & _
>> "ocking Mode=0;Data
>> Source=" & Server.MapPath("/db/database.mdb") & ";Jet OLEDB:Engine " & _
>> "Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System
>> database=;Jet OLEDB:S" & _
>> "FP=False;persist security info=False;Extended
>> Properties=;Mode=Share Deny None;J" & _
>> "et OLEDB:Encrypt Database=False;Jet OLEDB:Create System
>> Database=False;Jet OLEDB" & _
>> "on't Copy Locale on Compact=False;Jet OLEDB:Compact Without
>> Replica Repair=Fal" & _
>> "se;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1"
>>
>>
>> "john smithers" <(E-Mail Removed)> wrote in message
>> news:00580164-8444-4EF5-83A2-(E-Mail Removed)...
>> > thx for the reply but i'm looking at the "web form designer generated
>> code"
>> > and have found the oledbdataconnections and just want to modify this.
>> > What
>> > i'm really having problem with is the syntax.
>> >
>> > '
>> > 'OleDbConnection1
>> > '
>> > Me.OleDbConnection1.ConnectionString = "Jet OLEDB:Global
>> > Partial
>> > Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDBatabase L" & _
>> > "ocking Mode=0;Data
>> > Source=""C:\Inetpub\wwwroot\db\database.mdb"";Jet OLEDB:Engine " & _
>> > "Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System
>> > database=;Jet OLEDB:S" & _
>> > "FP=False;persist security info=False;Extended
>> > Properties=;Mode=Share Deny None;J" & _
>> > "et OLEDB:Encrypt Database=False;Jet OLEDB:Create System
>> > Database=False;Jet OLEDB" & _
>> > "on't Copy Locale on Compact=False;Jet OLEDB:Compact Without
>> > Replica Repair=Fal" & _
>> > "se;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1"
>> >
>> >
>> > Data source - i need to change to a relative path like
>> > server.mappath(/database/database.mdb) but everything i've tried keeps
>> > bringing up syntax errors.
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > "Greg Burns" wrote:
>> >
>> > > Dim cn As OleDb.OleDbConnection
>> > >
>> > > cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
>> > > Source="
>> &
>> > > Server.MapPath(ConfigurationSettings.AppSettings("path"))) ' -->>>
>> > > c:\inetpub\wwwroot\global\data\project1.mdb
>> > >
>> > > web.config...
>> > >
>> > > <?xml version="1.0" encoding="utf-8" ?>
>> > > <configuration>
>> > > <appSettings>
>> > > <add key="path" value="/global/data/project1.mdb" />
>> > > </appSettings>
>> > >
>> > > <system.web>
>> > > .... etc
>> > >
>> > > HTH,
>> > > Greg
>> > >
>> > > "john smithers" <(E-Mail Removed)> wrote in
>> message
>> > > news:8E6CC9A6-1A01-4427-9957-(E-Mail Removed)...
>> > > > I'm trying to modify the connection string made by the dataadapter
>> wizard
>> > > to
>> > > > a relative path. My current datasource is this:
>> > > >
>> > > > ""C:\Inetpub\wwwroot\database\database.mdb""
>> > > >
>> > > > How can i change so when its on the server it will look for the
>> directory
>> > > > "database" in the root of the virtual directory?
>> > > >
>> > > >
>> > > > cheers
>> > >
>> > >
>> > >
>>
>>
>>