access access

how to setup access to access database

[j_haus]

hi,

i am new to this internet programming thing so forgive me if i sound like an idiot. i am trying to read/write from an html page to an Access database with Perl. Does the DSN have to be setup on the webserver or all the PCs accessing the website or what?? I dont think i quite understand how that works with the DSN.

a little help?

j

[Lisa]

So you are using Perl on Windows is that correct?

[j_haus]

i would guess so. its running from my tripod site. http://j_haus.tripod.com/tms/newrequest.html i want this doc to be submitted to my database. i loaded the DBI.pm to my cgi-bin but i dont know how the DSN works.

j

[Lisa]

j_haus,
Welcome to WebmasterWorld. We have a policy of no details. Just general information. Take a look closer at the terms of service.

Ok, now back to the question.
Your server is Apache:

HTTP/1.1 200 OK
Date: Fri, 31 May 2002 19:18:42 GMT
Server: Apache/1.3.12 (Unix) mod_gzip/1.3.19.1a
Set-Cookie: CookieStatus=COOKIE_OK; path=/; domain=.<URL striped>; expires=Sat, 31-May-2003 19:18:42 GMT
P3P: policyref="http://<URL striped>/w3c/p3p.xml", CP="IDC DSP COR CURa ADMa DEVa CUSa PSAa IVAa CONo OUR IND UNI STA"
Set-Cookie: MEMBER_PAGE=<URL striped>; path=/; domain=.<URL striped>
Set-Cookie: REFERRER=(null); path=/; domain=.<URL striped>
Connection: close
Content-Type: text/html

You will not be able to have a Micorsoft Access database on a unix server. I am not sure what other database options your host has or if it has any. A free host may not have any. You may be able to use a flat file. But I am not sure if your host even supports server-side scripting. Can you provide me with more information about what your host supports.

[j_haus]

ok, thanks for the info. thats all i need. i figured that the free host might not provide database support but thought id try anyways. i am setting up a domain for my company with a pay service so ill make sure they have support.

thanks for the help.

j

[ndjp]

For future reference, you actually can access Microsoft Access or SQL Server databases from Unix using OpenAccess (http://www.atinet.com/Products/OpenRDA/ODBC_UNIX/ODBC_Unix.asp).