Using mdb files on linux machine with CI

#1
[eluser]varun[/eluser]
Hi

We are using RHEL 5.0 as our production server and windows XP for development with framework CI.
Some of our databases are in MDB format which we need to process. Is there any way to process mdb files under Linux and CI environment.

(.mdb is generated at run time by some other application.)

I am completely lost. Any help is highly appreciated.

#2
[eluser]kgill[/eluser]
.mdb files are microsoft access databases - AFAIK you aren't going to get that to run under linux without purchasing some 3rd party software for ODBC. CI doesn't even enter into the picture at this point, your first hurdle is going to be trying to get at the data from linux.

#3
[eluser]renownedmedia[/eluser]
Export from access into like a CSV then import that. There are also commercial converters. But, yes, don't expect CI to talk directly to your mdb's

#4
[eluser]got 2 doodle[/eluser]
you might find something for PERL that can handle .mdb

Certainly there are libs for ODBC

The export option suggested is probably the path of least resistance :-)


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.