OLEDB, 64-bits?

Rawbat · #1 (**permalink**) 06-23-09, 16:15

I never had much luck way back when using OLEDB to create a Linked Server to Pervasive from SQL Server, so always defaulted back to ODBC.
Now I got a 64-bit SQL Server, and realise there is no ODBC-driver for 64-bits.

Is there any OLEDB driver for 64-bits?
And if there is, how do I go about making an OLEDB Linked Server work?
Perhaps it got easier the past 5-6 years...

(googled and browsed pervasive, all I found was kinda leaning towards the negative side)

mirtheil · #2 (**permalink**) 06-23-09, 16:21

There is not a 64 bit OLEDB driver or ODBC driver. Pervasive is working on it but it's not out yet.

Rawbat · #3 (**permalink**) 06-23-09, 17:44

Quote:

Originally Posted by mirtheil

There is not a 64 bit OLEDB driver or ODBC driver. Pervasive is working on it but it's not out yet.

Thanks you for the quick reply, mirtheil.

I'll look into having a small 32 bit SQL Server installation instead, or in between.
Has OLEDB gotten better, or should I stick with ODBC?

mirtheil · #4 (**permalink**) 06-23-09, 18:12

Personally, I stay away from OLEDB but from what I've seen, they are about the same now. Then again, I mainly use the ADO.NET provider now and don't use ODBC or OLEDB as much.

Internet Services

Web Development

Digital Marketing

Consumer Tech