Ivan wrote:
> What seems to me is that ODBC driver for Access are installed,
> but I don't know if they are installed well and I really don't know how
> to use and test ODBC driver manager.
>
> I've setup a System DSN but things doesn't seem to work...
>
> There are 4 possibilities:
> 1) I didn't do a good job setting up the DSN and other parameters
> on the ODBC Manager in control panel
> 2) There is something else that should be modyfied in the setup of
> my NT machine (autorizations, mdb file in wrong directory, other
> thing to setup)
> 3) Wrong versions
> 4) Access must be installed on the NT machine
>
> I think the most probable problem is point 2)
> Second candidate is point 1)
>
> I'm SURE I do all the coding in ASP in the right way!!!!
What error messages are you getting when you use your ASP script to access
the database?
> Is there someone who can tell me exactly how he/she setted up
> the configuration of ODBC manager in control panel for an Access
> DB?
1. User DSN tab should have a driver for .mdb databases. If not, click Add
(tell me if it's missing).
2. System DSN tab should have the "Name" of your database (anything you want
to call it) and the correct driver listed. If not, click Add and follow
prompts.
If you have an ODBC driver for your database installed and you create a
System DSN for your database, then you "should" be OK. I haven't written ASP
code, but you should be able to access the database after identifying it to
the script. The path to the datasource is set when you do the system DNS
setup, so you shouldn't have to worry about having the right path if the
file is on your own machine. I'm not an NT sysop, so I don't know the system
inside and out, I'm just letting you know what I've done in the past for my
NT workstation. I supposed there could be some "permissions" set on the
system that could be causing your probolem. The error message you get should
give you a clue if that's the case.
Could the problem lay in your PWS setup, rather than your ODBC setup? Can
you get the logical (non database) stuff in your ASP scripts to work?
> Meanwhile I'll update evrything to exclude point 3)
Jack
____________________________________________________________________
--------------------------------------------------------------------
Join The Web Consultants Association : Register on our web site Now
Web Consultants Web Site : http://just4u.com/webconsultants
If you lose the instructions All subscription/unsubscribing can be done
directly from our website for all our lists.
---------------------------------------------------------------------
