Does anyone know of a way to read to/write from a Microsoft Access database from DataStage running on Unix?
I appreciate your help.
Tony
Read/Write MS Access Database from Unix
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
I believe that you need a 3rd party ODBC product to get to Access from Unix. A list of ODBC products is available at www.iodbc.org, they list about 100 ODBC products. An example is Automation Technology which provides ODBC drivers to MS Access from non Windows platforms.
You could also look at www.mysql.com and http://mdbtools.sourceforge.net/ or www.easysoft.com who have an ODBC to ODBC bridge that let's your Unix machine access ODBC drivers on a Windows machine.
Vincent McBurney
Data Integration Services
www.intramatix.com
You could also look at www.mysql.com and http://mdbtools.sourceforge.net/ or www.easysoft.com who have an ODBC to ODBC bridge that let's your Unix machine access ODBC drivers on a Windows machine.
Vincent McBurney
Data Integration Services
www.intramatix.com
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA
Hey Mark,
DataStage ships with ODBC drivers (for Unix) for many common DBMS systems. I believe that SQL Server is among them. They don't have an Access driver for Unix, however. [:(]
Assuming you meant DataStage project when you said UNIX server project. If you didn't mean DataStage, Merant (?) makes the UNIX ODBC drivers that come with DataStage. I'm sure they can hook you up for a small fee [:)]
Tony
DataStage ships with ODBC drivers (for Unix) for many common DBMS systems. I believe that SQL Server is among them. They don't have an Access driver for Unix, however. [:(]
Assuming you meant DataStage project when you said UNIX server project. If you didn't mean DataStage, Merant (?) makes the UNIX ODBC drivers that come with DataStage. I'm sure they can hook you up for a small fee [:)]
Tony