Page 1 of 1
Dreamweaver and access db
Posted: Wed Nov 16, 2005 9:35 am
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 ?
Posted: Wed Nov 16, 2005 9:56 am
by JAM
I think there is a good walkthrough in the manual, regarding ODBC neverless.
Posted: Wed Nov 16, 2005 10:05 am
by m3mn0n
Moved topic to databases forum.
Posted: Wed Nov 16, 2005 11:28 am
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...
Posted: Wed Nov 16, 2005 12:51 pm
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.
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...
Posted: Thu Nov 17, 2005 2:48 am
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.