Database Access Wizard and DSN

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My host wants me store my Access file in a 'data' folder linked using a DSN.

I have set-up the DSN and have this link for it -
d:\websites\domainname\data\database1.mdb

How do I tell Database Access Wizard componet to use this DSN.

Or, is this not possible.

My head is about to expode!!!

Merci
 
Which type of DSN does your host want you to use, File or System? If System, then the host must set
this up.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
The only thing I can 'see' on the setup page is where it says - DSN Type =
Access -

This is on their DSN set-up page, does it help? -

Script access - Each domain is allocated its own unique I_USR account, the
account which permits a web browser to access your web site. This account
also governs access to your database therefore only scripts contained within
a domains web space will have access to your Microsoft Access database.

SGC
 
That doesn't really help, you would need to ask them, and then you would need to make your
connection while you have the live/remote site open in FP. You will not be able to connect to the
database from your local copy of your web.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
OK

Found out it is a 'System' DSN and it has been set-up.
d:\websites\{domainname}\data\database1.mdb
 
When using a System DSN, the actual location of the database is no longer an issue.

You will have to modify the global.asa file to connect to the System DSN, in the following format:

Application("database1_ConnectionString") = "DSN=SystemDSNName;DRIVER={Microsoft Access Driver
(*.mdb)}"
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Hi,

Would it be formed like this -

Application("database1_ConnectionString") =
"DSN=d:\websites\domainname\data\database1.mdb
;DRIVER={Microsoft Access Driver
(*.mdb)}"

SGC
 
What you have indicated below is File DSN.

When using a System DSN, the name/path to the database is never part of the connection string, see
my original example posted below

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Why can't technical people (who know) ever give a straight, simple answer?

Why does everything have to be shrouded in mystery?

Can you please, please give me how the line would look and how I then tell
the Database Access Wizard to use this?

I'm begging for help here....

SGC
 
This is how the line would look when using a System DSN, as I original posted:

Application("database1_ConnectionString") = "DSN=SystemDSNName;DRIVER={Microsoft Access Driver
(*.mdb)}"

Note: SystemDSNName = is the System DSN Name you host (control panel) has assigned to your database.

You may have to manual write or modify a global.asa file, you will not be able to use the FP
Database component, unless you have you live/remote site open in FP and your web host allows you to
see/select your System DSN from a list of System DSNs on the server, most host do not allow this for
security reasons.


--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Back
Top