Need help : DSN connection string

  • Thread starter Thread starter Tee
  • Start date Start date
T

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
 
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;"
 
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
 
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
 
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.
 
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.
 
Back
Top