Need help : DSN connection string

[Tee]

Hi,

I need some help here for DSN connection string.
I know it's not recommended to use DSN, even I dont like it as well ...
but for now, my situation is I am using a shared hosting. I do not have
write access to my web root folder, I have a folder specialy for database.
I am currently using access, it is just for testing purpose.

here's the info:

ms access database password : testdb
dsn name : testdb

can anyone tell me what is the connection string ?

thanks,
Tee

[Dino Chiesa [Microsoft]]

You don't need write access to c:\, to use DSN-less connection strings.

To see sample connection strings, try
www.connectionstrings.com

eg,
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\dbdir\dbfile.mdb;User
Id=whatever;Password=testdb;"
"Tee" <th*@streamyx.com> wrote in message
news:Om**************@TK2MSFTNGP12.phx.gbl...

Hi,

I need some help here for DSN connection string.
I know it's not recommended to use DSN, even I dont like it as well ...
but for now, my situation is I am using a shared hosting. I do not have
write access to my web root folder, I have a folder specialy for database.
I am currently using access, it is just for testing purpose.

here's the info:

ms access database password : testdb
dsn name : testdb

can anyone tell me what is the connection string ?

thanks,
Tee

[Tee]

I know about DNS less connection string ... but now the problem is the
database folder is not inside the wwwroot ...
if I really have to get to that folder, I must use ../db/dbfile.mdb ...
but now another problem comes, I cannot exit the top root by using ../ ...
and if I place the database inside my wwwroot folder, I don't have write
access. I need write data to the database as well.

Thanks,
Tee
"Dino Chiesa [Microsoft]" <di****@online.microsoft.com> wrote in message
news:eP**************@TK2MSFTNGP11.phx.gbl...

You don't need write access to c:\, to use DSN-less connection strings.

To see sample connection strings, try
www.connectionstrings.com

eg,
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\dbdir\dbfile.mdb;User
Id=whatever;Password=testdb;"
"Tee" <th*@streamyx.com> wrote in message
news:Om**************@TK2MSFTNGP12.phx.gbl...

Hi,

I need some help here for DSN connection string.
I know it's not recommended to use DSN, even I dont like it as well ...
but for now, my situation is I am using a shared hosting. I do not have
write access to my web root folder, I have a folder specialy for database. I am currently using access, it is just for testing purpose.

here's the info:

ms access database password : testdb
dsn name : testdb

can anyone tell me what is the connection string ?

thanks,
Tee

[Dino Chiesa [Microsoft]]

can you not use string manipulation to build the proper folder name?
or Server.MapPath()
or ..

Your hoster maybe has a FAQ somewhere illustrating how to do this on that
site?
-D
"Tee" <th*@streamyx.com> wrote in message
news:eK**************@TK2MSFTNGP09.phx.gbl...

I know about DNS less connection string ... but now the problem is the
database folder is not inside the wwwroot ...
if I really have to get to that folder, I must use ../db/dbfile.mdb ...
but now another problem comes, I cannot exit the top root by using ../ ...
and if I place the database inside my wwwroot folder, I don't have write
access. I need write data to the database as well.

Thanks,
Tee
"Dino Chiesa [Microsoft]" <di****@online.microsoft.com> wrote in message
news:eP**************@TK2MSFTNGP11.phx.gbl...

You don't need write access to c:\, to use DSN-less connection strings.

To see sample connection strings, try
www.connectionstrings.com

eg,
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\dbdir\dbfile.mdb;User
Id=whatever;Password=testdb;"
"Tee" <th*@streamyx.com> wrote in message
news:Om**************@TK2MSFTNGP12.phx.gbl...

Hi,

I need some help here for DSN connection string.
I know it's not recommended to use DSN, even I dont like it as well .... but for now, my situation is I am using a shared hosting. I do not have write access to my web root folder, I have a folder specialy for database. I am currently using access, it is just for testing purpose.

here's the info:

ms access database password : testdb
dsn name : testdb

can anyone tell me what is the connection string ?

thanks,
Tee

[Tee]

I am using server.MapPath ... and it really dont let me exit the root by
using ../ ...

as now the the db folder & wwwroot folder are on the same level ... sorry if
you couldn't understand what I meant ...

it is, when I ftp login, I see 2 folder, wwwroot & db ...
so I cannot exit wwwroot and read data in db folder by using ../db/data.mdb
....

please help ...

thanks.


"Dino Chiesa [Microsoft]" <di****@online.microsoft.com> wrote in message
news:uc**************@TK2MSFTNGP11.phx.gbl...

can you not use string manipulation to build the proper folder name?
or Server.MapPath()
or ..

Your hoster maybe has a FAQ somewhere illustrating how to do this on that
site?
-D
"Tee" <th*@streamyx.com> wrote in message
news:eK**************@TK2MSFTNGP09.phx.gbl...

I know about DNS less connection string ... but now the problem is the
database folder is not inside the wwwroot ...
if I really have to get to that folder, I must use ../db/dbfile.mdb ...
but now another problem comes, I cannot exit the top root by using ../ ....

and if I place the database inside my wwwroot folder, I don't have write
access. I need write data to the database as well.

Thanks,
Tee
"Dino Chiesa [Microsoft]" <di****@online.microsoft.com> wrote in message
news:eP**************@TK2MSFTNGP11.phx.gbl...

You don't need write access to c:\, to use DSN-less connection strings.
To see sample connection strings, try
www.connectionstrings.com

eg,
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\dbdir\dbfile.mdb;User
Id=whatever;Password=testdb;"
"Tee" <th*@streamyx.com> wrote in message
news:Om**************@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I need some help here for DSN connection string.
> I know it's not recommended to use DSN, even I dont like it as well

... > but for now, my situation is I am using a shared hosting. I do not have > write access to my web root folder, I have a folder specialy for

database.

> I am currently using access, it is just for testing purpose.
>
> here's the info:
>
> ms access database password : testdb
> dsn name : testdb
>
> can anyone tell me what is the connection string ?
>
> thanks,
> Tee
>
>

[William LaMartin]

If you are using the 1.1 version of the framework, then in help look up OBDC
Data Sources then Connections. I think this will tell you how to do want
you to do.

If you are using the 1.0 framework, you will have to download the ODBC .Net
Data provider from Microsoft at
http://msdn.microsoft.com/library/de...vframework.asp
"Tee" <th*@streamyx.com> wrote in message
news:Om**************@TK2MSFTNGP12.phx.gbl...

Hi,

I need some help here for DSN connection string.
I know it's not recommended to use DSN, even I dont like it as well ...
but for now, my situation is I am using a shared hosting. I do not have
write access to my web root folder, I have a folder specialy for database.
I am currently using access, it is just for testing purpose.

here's the info:

ms access database password : testdb
dsn name : testdb

can anyone tell me what is the connection string ?

thanks,
Tee

[Kevin Spencer]

All you need to do is find out the absolute file path the the .mdb file and
use that. Ask your hosting service if you don't know it.

--
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Tee" <th*@streamyx.com> wrote in message
news:Og**************@TK2MSFTNGP11.phx.gbl...

I am using server.MapPath ... and it really dont let me exit the root by
using ../ ...

as now the the db folder & wwwroot folder are on the same level ... sorry if you couldn't understand what I meant ...

it is, when I ftp login, I see 2 folder, wwwroot & db ...
so I cannot exit wwwroot and read data in db folder by using .../db/data.mdb ...

please help ...

thanks.


"Dino Chiesa [Microsoft]" <di****@online.microsoft.com> wrote in message
news:uc**************@TK2MSFTNGP11.phx.gbl...

can you not use string manipulation to build the proper folder name?
or Server.MapPath()
or ..

Your hoster maybe has a FAQ somewhere illustrating how to do this on that

site?
-D
"Tee" <th*@streamyx.com> wrote in message
news:eK**************@TK2MSFTNGP09.phx.gbl...

I know about DNS less connection string ... but now the problem is the
database folder is not inside the wwwroot ...
if I really have to get to that folder, I must use ../db/dbfile.mdb .... but now another problem comes, I cannot exit the top root by using ../ ... and if I place the database inside my wwwroot folder, I don't have write access. I need write data to the database as well.

Thanks,
Tee
"Dino Chiesa [Microsoft]" <di****@online.microsoft.com> wrote in message news:eP**************@TK2MSFTNGP11.phx.gbl...
> You don't need write access to c:\, to use DSN-less connection strings. >
> To see sample connection strings, try
> www.connectionstrings.com
>
> eg,
> "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\dbdir\dbfile.mdb;User
> Id=whatever;Password=testdb;"
>
>
> "Tee" <th*@streamyx.com> wrote in message
> news:Om**************@TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I need some help here for DSN connection string.
> > I know it's not recommended to use DSN, even I dont like it as

well ...

> > but for now, my situation is I am using a shared hosting. I do not

have

> > write access to my web root folder, I have a folder specialy for
database.
> > I am currently using access, it is just for testing purpose.
> >
> > here's the info:
> >
> > ms access database password : testdb
> > dsn name : testdb
> >
> > can anyone tell me what is the connection string ?
> >
> > thanks,
> > Tee
> >
> >
>
>

[William LaMartin]

That should have read ODBC Data Sources

"William LaMartin" <la******@tampabay.rr.com> wrote in message
news:Os**************@TK2MSFTNGP10.phx.gbl...

If you are using the 1.1 version of the framework, then in help look up OBDC Data Sources then Connections. I think this will tell you how to do want
you to do.

If you are using the 1.0 framework, you will have to download the ODBC ..Net Data provider from Microsoft at
http://msdn.microsoft.com/library/de...vframework.asp

"Tee" <th*@streamyx.com> wrote in message
news:Om**************@TK2MSFTNGP12.phx.gbl...

Hi,

I need some help here for DSN connection string.
I know it's not recommended to use DSN, even I dont like it as well ...
but for now, my situation is I am using a shared hosting. I do not have
write access to my web root folder, I have a folder specialy for database. I am currently using access, it is just for testing purpose.

here's the info:

ms access database password : testdb
dsn name : testdb

can anyone tell me what is the connection string ?

thanks,
Tee