In my experiences, they're just going to tell me that the bug exists in the MySQL ODBC driver shoving the ownership back on Oracle. I guess I could try, but...

Tried this

SELECT * FROM OPENQUERY(SHORETEL_CDR, 'SELECT 1')

and get the same error even still.

Found this

http://connect.microsoft.com/SQLServer/feedback/details/615000/sql-server-2008-r2-linked-server-to-db2-using-microsoft-oledb-provider-for-odbc-fail

and this

http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/f9ddbb1e-b276-47e7-a85a-475c1e8c6793/[/url]

Both of which suggest to turn off prefetch. Tried that with no luck....

:crying: Went through the instructions for granting the sql service access to the necessary components, and restarted the sql server. Still not resolved. On a positive note, the error message...

Geez, this just is NOT my week. Found another bloody workaround for this issue in this other workaround, but this is getting ridiculous.

So apparently, MSDAINITIALIZE and some other components...

Ugh, so I'm not out of the woods yet actually... Still facing pretty much the same problem.

When Allow In Process disabled, Testing the connection works now and returns no...

Hey, here's some progress, following that MS article I found, it seems that the SPID problem occurs only if the driver is setup to run in process.

Changing the setting @...

Thanks for the info, every little bit helps.

At this point I think I'm willing to fork up some $ and resolve this with a 3rd party solution. Assuming that...

I suspect the problem is somehow related to this bug

http://bugs.mysql.com/bug.php?id=63386

My version is 5.0.8 enterprise, and this bug was reported in version is 5.1.9

Seems like the MySQL database version...

Thanks for trying to help. Unfortunately I cannot install a 32bit driver on a windows 2008 R2 64 windows box successfully. The driver doesn't even show up as an option...

MySQL workbench 5.2.40 CE Revision 8790

installed with mysql-workbench-gpl-5.2.40-win32.msi

ODBC Driver version displays MySQL ODBC 5.1 Driver

installed from mysql-connector-odbc-5.1.11-winx64.msi

both were downloaded about a week ago

MySQL results of SHOW VARIABLES LIKE "%version%";

protocol_version: 10

version: 5.0.84sp1-enterprise-nt-log

version_comment: MySQL Enterprise Server - Pro Edition (Commercial)

version_compile_machine: ia32

version_compile_os: Win32

Microsoft SQL Server Standard Edition (64-bit) 2008

Microsoft SQL Server version listed in Server...

Yes, I've got workbench setup for server administration and development. Connecting fine added my user and granted permissions to it for the SQL server IP there which I used to...

unfortunately, that post isn't much help. It's actually less detailed than the other 2 tutorials already referenced here. And further, it doesn't describe the symptoms that we are experiencing. Following...

I have exactly the same problem, SPID and all. Followed the same tutorial, and tried another one with the same result as well.

working with sql 2008 r2 64x. Doesn't...