trying to us RELATIVE PATH ON MY CONNECTION STRIN

[RAW]

Hi Im trying to us relative path in my connection string instead of absolute
what Im doing wrong this is my code

Sub Page_Load() Dim strConnection as String =
"Provider=Micro soft.Jet.OLEDB. 4.0;" strConnection += "Data
Source=Server.M apPath("../dbcontainer/content.mdb") data_src.text =
strConnection

[Alvin Bruney]

What is the exception and what does server.mapppath return?

This by the way is not a good idea to build a connection string because you
will not be taking adantage of the connection pooling in the framework.
Connection pooling uses a exact match algorithm. Most times, building
strings does not result in a exact match.

regards

--
-----------
Got TidBits?
Get it here: www.networkip.net/tidbits
"RAW" <de****@terra.c om> wrote in message
news:ur******** ******@TK2MSFTN GP12.phx.gbl...

Hi Im trying to us relative path in my connection string instead of absolute what Im doing wrong this is my code

Sub Page_Load() Dim strConnection as String =
"Provider=Micro soft.Jet.OLEDB. 4.0;" strConnection += "Data
Source=Server.M apPath("../dbcontainer/content.mdb") data_src.text =
strConnection

[RAW]

simple questions
with a simple answers

relative connection
Dim strConnection as String = "Provider=Micro soft.Jet.OLEDB. 4.0; Data
Source="& _ 'Server.MapPath ("../NEWMGS/dbcontainer/content.mdb")

Absolute connection
Dim strConnection as String = "Provider=Micro soft.Jet.OLEDB. 4.0; Data
Source=D:\works \WEBS\NEWMGS\db container\conte nt.mdb" DIM setNiveles AS
INTEGER DIM setContenido AS STRING DIM setPagina AS STRING

"Alvin Bruney" <vapordan_spam_ me_not@hotmail_ no_spamhotmail. com> wrote in
message news:ep******** ******@TK2MSFTN GP09.phx.gbl...

What is the exception and what does server.mapppath return?

This by the way is not a good idea to build a connection string because you will not be taking adantage of the connection pooling in the framework.
Connection pooling uses a exact match algorithm. Most times, building
strings does not result in a exact match.

regards

--
-----------
Got TidBits?
Get it here: www.networkip.net/tidbits
"RAW" <de****@terra.c om> wrote in message
news:ur******** ******@TK2MSFTN GP12.phx.gbl...

Hi Im trying to us relative path in my connection string instead of

absolute

what Im doing wrong this is my code

Sub Page_Load() Dim strConnection as String =
"Provider=Micro soft.Jet.OLEDB. 4.0;" strConnection += "Data
Source=Server.M apPath("../dbcontainer/content.mdb") data_src.text =
strConnection