Dreamweaver and access db

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
ATH0
Forum Newbie
Posts: 19
Joined: Mon Oct 03, 2005 12:39 pm

Dreamweaver and access db

Post by ATH0 »

Aloha!

Till now i'v been working with mysql db and dreamweaver and now i have to switch the db to MS access.
I have made all db connections with "dreamweaver db connection wizard" but the only db option is MYSQL.

How to switch to access db ?

Basicly, how to connect to access db thru dreamweaver ?
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post by JAM »

I think there is a good walkthrough in the manual, regarding ODBC neverless.
User avatar
m3mn0n
PHP Evangelist
Posts: 3548
Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada

Post by m3mn0n »

Moved topic to databases forum.
ATH0
Forum Newbie
Posts: 19
Joined: Mon Oct 03, 2005 12:39 pm

Post by ATH0 »

can you post me the part for php, becuse i can find it.
I have successfully connect myself thru JSP (and test.mdb) but i can make the same stuff with php...
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post by JAM »

ATH0 wrote:can you post me the part for php, becuse i can find it.
I have successfully connect myself thru JSP (and test.mdb) but i can make the same stuff with php...
I was referring to the paperback version... And no, I wont type it off for you. :wink:
Basicly it is something similiar to this if I recall correct. It's been awhile so forgive me if it's old news.
I think that Dreamweaver installs a DSN upon installing the software, so you might only need to change that one to fit your needs.

Edited:
When I think about it... You are able to do it using JSP, but not PHP. Are you sure that you indeed are using the correct PHP functions to connect, select data etc.? Perhaps stupid question, but hey...
ATH0
Forum Newbie
Posts: 19
Joined: Mon Oct 03, 2005 12:39 pm

Post by ATH0 »

:) No you dont have to type it.

Let me put it this way:

PHP --> MYSQL --> OK
PHP --> ODBC --> FALSE

JSP --> MYSQL --> OK
JSP --> ODBC --> OK


Anyway, i will try it few more times.
Post Reply