dbTalk Databases Forums  

dblib connection to AS400

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss dblib connection to AS400 in the microsoft.public.sqlserver.clients forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Blake Cheatham
 
Posts: n/a

Default dblib connection to AS400 - 07-01-2003 , 12:50 PM






I have C applications used in a SQL Server / DB2 batch
processing scenario that use dblib through SNA Server and
an unsupported application from Sybase called MDI Gateway.

I would like to know if anyone has been able to use dblib
to connect to IBM DB2 on AS400 without using SNA server or
another piece of middleware.

Reply With Quote
  #2  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: dblib connection to AS400 - 07-08-2003 , 04:00 AM






Quote:
I cannot see but that this can only
work, if there is something listening to TDS and passes the
queries on to DB2.

Which is exactly what MDI's database gateway does :-). Without a gateway, the app has to be
re-written to use ODBC or OLEDB and then using an appropriate ODBC/OLEDB driver.

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=d...blic.sqlserver


"Erland Sommarskog" <sommar (AT) algonet (DOT) se> wrote

Quote:
Blake Cheatham (rbcheath (AT) gapac (DOT) com) writes:
I have C applications used in a SQL Server / DB2 batch
processing scenario that use dblib through SNA Server and
an unsupported application from Sybase called MDI Gateway.

I would like to know if anyone has been able to use dblib
to connect to IBM DB2 on AS400 without using SNA server or
another piece of middleware.

I have never worked with DB2 or AS400. However, since DB-Library
is a client library which is written specifically to talk TDS, the
proprietary protocol that Sybase and MS SQL Server use, I dare say
that the answer is negative. I cannot see but that this can only
work, if there is something listening to TDS and passes the
queries on to DB2.



--
Erland Sommarskog, SQL Server MVP, sommar (AT) algonet (DOT) se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.