Database Connections

[Guest]

Hi,

I am trying to connect a Access Database with 2 fields: Name and telephone Number for a company to be displayed on a webpage through the Access database.

They host the website on www.addaction.net which has MySQL and PHP.

Does anyone know if I can do the above with Frontpage 2003?

Thanks,
Ravish Amin

 

[Kevin Spencer]

Sure. You will have to write your own code, though.

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

Hi,

I am trying to connect a Access Database with 2 fields: Name and telephone

Number for a company to be displayed on a webpage through the Access
database.

 

[Tom Gahagan]

Hi Ravish.....

For connections to an Access database... (and a lot of others also) see.....

www.connectionstrings.com

It looks as if the host you mentioned is a Unix or Linux setup..... so you
will probably ( I think) not be able to use access (i.e. windows) files. If
that is a must (using access) you will have to find a windows host.

The host company probably has some help on how to use MySql and I bet if you
hunt around you can find some access to mysql conversion utilities if you
already have the data in access.

Best to you.....
Tom Gahagan

Hi,

I am trying to connect a Access Database with 2 fields: Name and telephone

Number for a company to be displayed on a webpage through the Access
database.

 

[jon spivey]

Hi Ravish,
your host is running a Unix server - which doesn't support MS Access
databases. You may be able to get around this by converting you db into
dbase (*.dbf) format - there's an article to in knowledge base covering
this.

Alternative would be to use PHP as your database.

--
Jon
Microsoft MVP - FP

Hi,

I am trying to connect a Access Database with 2 fields: Name and telephone

Number for a company to be displayed on a webpage through the Access
database.

 

[Jimmy]

Alternative would be to use PHP as your database.

I think you meant "MYSQL" as a d/b and PHP as a scripting language.
Perl is most likely also an option, "PerlScript" a maybe.

 

[jon spivey]

Good catch

Cheers,
Jon

I think you meant "MYSQL" as a d/b and PHP as a scripting language.
Perl is most likely also an option, "PerlScript" a maybe.