ray.wurlod wrote:You have the alternative of accessing through SQL Server.
Accessing .xls or .mdb files in a Unix directory
Moderators: chulett, rschirm, roy
can you please describe me how to do this?
Thanks,
Chad
__________________________________________________________________
"There are three kinds of people in this world; Ones who know how to count and the others who don't know how to count !"
Chad
__________________________________________________________________
"There are three kinds of people in this world; Ones who know how to count and the others who don't know how to count !"
-
- Participant
- Posts: 145
- Joined: Fri May 02, 2003 9:59 am
- Location: Seattle, Washington. USA
You can use SQL Server to create a linked server to an ODBC driver. You would then create views on the sql server that select data from the linked servers. At that point they appear to DataStage as normal views in a SQL Server database. You can then use the SQL Server ODBC driver on the Unix server.mctny wrote:can you please describe me how to do this?ray.wurlod wrote:You have the alternative of accessing through SQL Server.
Shawn Ramsey
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
thank you very much Shawn. does anybody know how to make a direct connection from SQL server to MS Access?
shawn_ramsey wrote:You can use SQL Server to create a linked server to an ODBC driver. ....mctny wrote:can you please describe me how to do this?ray.wurlod wrote:You have the alternative of accessing through SQL Server.
Thanks,
Chad
__________________________________________________________________
"There are three kinds of people in this world; Ones who know how to count and the others who don't know how to count !"
Chad
__________________________________________________________________
"There are three kinds of people in this world; Ones who know how to count and the others who don't know how to count !"