Hi,
I would like to know about, using MS Access as the Source/Target DB.
To get connectivity to MS Access Source/Target, i will be using ODBC Stage. But, i am not sure of ODBC Configuration requirements.
I need some information about ODBC Configuration for MS Access and the setup procedures.
Thanks.
MS Access Source
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The first thing you're going to need to find is a UNIX-based ODBC driver that can connect to MS Access. Do you have one of these? If so, the documentation that accompanies it will instruct you in the entries that are required in the odbc.ini file. You must also edit the uvodbc.config file in your project to reflect the fact that this data source is an ODBC (rather than UniVerse) data source, so that the driver will be loaded.
No ODBC driver for MS Access ships with DataStage. You'll have to source a third party driver.
No ODBC driver for MS Access ships with DataStage. You'll have to source a third party driver.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Another option is to hook the MS-Access mdb file into a SQL-Server instance, then use the unix --> ODBC SQL-Server driver --> SQL-Server --> MS-Access route to get at the data.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Better yet move your Access data tables into SQL Server and don't use Access. If your Access database has some forms and reports you can link the SQL Server data tables back into Access and make Access the front end of a client server app.
The only problem I've had with this in the past is with identity or sequence number fields as SQL Server and Access create these numbers at different times. A small amount of code changes fixed this.
The only problem I've had with this in the past is with identity or sequence number fields as SQL Server and Access create these numbers at different times. A small amount of code changes fixed this.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn