Thank you Stewart!
Leonid Frumker
stewart.hanna@ascentials
oftware.com To:
datastage-users@oliver.com
cc:
11/24/2003 11:38 PM Subject: RE: Using MS Access
Please respond to
datastage-users
Leonid,
MS Access is a client only database, it provides no support for remote (via
a network) clients to connect other than via shared drive or folder
mapping.
If you have a SQL Server instance you can linked MS Access db's and expose
them like a virtual DB in SQL Server. Having done this, you can then use
the
SQL Server ODBC driver supplied with DataStage to get at this data. We have
a local customer doing it this way successfully.
Alternatively there are many ODBC bridges or gateway solutions in the
market
place which proved a Server like middleware layer which allow you to expose
MS Access databases to remote clients.
Good luck
Stewart
-----Original Message-----
From: Kim Duke [mailto:
Kim_G_Duke@Yahoo.com]
Sent: Friday, 21 November 2003 8:20 AM
To:
datastage-users@oliver.com
Subject: RE: Using MS Access
Leonid
Microsoft does not supply ODBC drivers for their products. You may be able
to find them from a third party. There are a lot of ways to get the data
into Access through links or importing sequential files.
Thanks Kim.
Kim Duke
DsWebMon - Safely Monitor DataStage from the Web
www.Duke-Consulting.com
-----Original Message-----
From:
lfrumke@sears.com [mailto:
lfrumke@sears.com]
Sent: Thursday, November 20, 2003 2:38 PM
To:
datastage-users@oliver.com
Subject: Using MS Access
Does DataStage work with MS Access? I did not see any ODBC drivers in
..odbc.ini for MS Access. We are running DS 6.0 on Solaris box.
Thank you,
Leonid Frumker