Hi all, Does anyone know how or whether there are third party tools that allow communication between IBM and SQL Server and vice versa? If you know, please advise. Thank you.
Would you explain what software from IBM do you want to connect? Luis Martin ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true. Bertrand Russell
Without knowing more, we use IBM's DBConnect server to connect our SQL Servers and our IBM mainframe. Using DBConnect, we can then use DTS, or code, to communicate between them. ----------------------------- Brad M. McGehee, MVP Webmaster SQL-Server-Performance.Com
I think Client Access Driver is used to connect SQL server from DB2. You would get more information from IBM site for details. HTH _________ Satya SKJ Moderator SQL-Server-Performance.Com
quote:Originally posted by LuisMartin Would you explain what software from IBM do you want to connect? Luis Martin ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true. Bertrand Russell Hello, Thanks for replying. I want something that communicates with Unix and SQL Server and vice versa. Any idea?
http://www.unixodbc.com/ might be a first step. There are other around. Basically you can also have something like a shared directory and something like samba, output your data to files on that directory and pull with with DTS into SQL Server. Frank http://www.insidesql.de http://www.familienzirkus.de
MS doesn't have any such facility from db-library, odbc, oledb for SQL server and I believe using following approach you can try: Use TDS 4.2 which shared with sybase and comply application to connect with this protocol. Third party tools like MERANT using ODBC, OPENLINK and its drivers, I think weblogic server and jdbc drivers also may help. Configure web appl. to access SQL and make unix client to connect to web box. _________ Satya SKJ Moderator SQL-Server-Performance.Com
