Very Computer

Thanks,

Joe

I believe that IBM has a DB2 provider. Both IBM and we have ODBC drivers
for DB2. ( Ours comes with HIS Server ) I think that DataDirect has DB2
Drivers/providers as well.

I hope this helps,

Russ Gray
Microsoft Developer Support

This posting is provided AS IS with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Thanks for your reply (below).  Could you please tell me
if OLEDB is more robust than ODBC?  We are trying to
connect to a DB 2 database to create linked Access 2002
tables.

Is there an article that you could recommend that explains
the more distinct differences between the two technologies?

Thanks,

Joe

Quote:>-----Original Message-----

>I believe that IBM has a DB2 provider. Both IBM and we
have ODBC drivers
>for DB2. ( Ours comes with HIS Server ) I think that
DataDirect has DB2
>Drivers/providers as well.

>I hope this helps,

>Russ Gray
>Microsoft Developer Support

>This posting is provided "AS IS" with no warranties, and
confers no rights.

>Are you secure? For information about the Microsoft

Quote:>Protection Program and to order your FREE Security Tool
Kit, please visit
>http://www.microsoft.com/security.

>.

there are further ODBC/JDBC/OLEDB data access drivers for DB2 available
at http://www.openlinksw.com. Please feel free to poast any questions / requests.

Best Regards,

Jan Csisko
Professional Services Consultant(UK) Tel: +44 (0)20 8681 7701
OpenLink Software  Home Page: http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
Online ODBC HOWTOs at: http://demo.openlinksw.com

Quote:> I believe that IBM has a DB2 provider. Both IBM and we have ODBC drivers
> for DB2. ( Ours comes with HIS Server ) I think that DataDirect has DB2
> Drivers/providers as well.

> I hope this helps,

> Russ Gray
> Microsoft Developer Support

> This posting is provided ?AS IS? with no warranties, and confers no rights.

> Are you secure? For information about the Microsoft Strategic Technology
> Protection Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.

Hi Joe

I don't know of any articles that discuss the differences between OLEDB vs
ODBC. Basically, OLEDB is more flexible in that it's not locked into the
row/column kind of data that ODBC is. For instance, the OLEDB provider for
OLAP returns 3 dimensional results. And you could write an OLEDB provider
(someone may already have) that knows about map co-ordinates and can return
data based on the distance from a point, like all ice cream shops within a
given distance from a building ( is it lunchtime yet? :-).

As for robustness, I'd have to give ODBC a slight edge. It's been around
forever and has had most of the bugs hammered out. OLEDB has been around a
while too tho, and is the wave of the future.

This may be moot tho, given what you're doing. I believe that Access can
only use ODBC for linking tables, at least in the current incarnation.
Perhaps the next version of access will know about OLEDB.

I hope this helps,

Russ Gray
Microsoft Developer Support

This posting is provided AS IS with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.