Can Drupal play nice with Microsoft Access or Cold Fusion
rahr - May 6, 2009 - 13:52
I am working at a company that has several databases and applications. There are currently databases set up in FoxPro, .ASP, Microsoft Access and MS SQL and they are using ESRI for geo maps. There is currently a web site up using Dreamweaver, but we are interested in moving over to a Drupal platform. Will it be possible to access any of our myriad databases through Drupal? We can convert if we can get at least one to work. Any help will be very welcome.
Thanks in advance,
Huckleberry Rahr
=-=
http://drupal.org/requirements
That doesn't really help me.
That doesn't really help me. From my research, we can't have the drupal platform access our Microsoft Access database. We can't move our data to a different database. If anyone can help, that would be great, if not, anyone know where we can look?
ODBC
I solved this by connecting to the database with an ODBC. With Access, the database had to be local, with a SQL database, I can connect to the base server. I created PHP code for the interaction with the database. Overall it worked well. That said, if the information in the Access database was small, it is nice to be able to create a CCK and use Drupals database management system to manage the information, and views for the display.
Huckle