Chad Crawford (1/20/2010)
Lynn Pettis (1/20/2010)
Have to ask, are you running SQL Server 2005 x64 or SQL Server 2005 x32? If you got the linked server to work using the x64 MySQL ODBC driver I would be very interested in what settings you used, as well as which version.
I had no problems setting up the MySQL ODBC driver and linked server using SQL Server 2005 x32.
Both. x64 in prod, x32 in dev and we set up the linked server on both.
On x64, we're using version 5.1 of the odbc driver.
Collation Compatible False
Data Access True
RPC Out False
Use Remote Collation True
Collation Name *blank* (the value, not the text :-))
Connection Timeout 0
Query Timeout 0
Lazy Schema Validation False
And on the MSDASQL Provider:
Dynamic parameter disabled
Nested queries enabled
level zero only enabled
allow inprocess enabled
non transacted updates disabled
index as access path disabled
disallow adhoc access disabled
supports 'Like' operator enabled
On the ODBC Datasource, I have the following values set:
Returned Matched Rows instead of affected rows
Allow big result sets
treat bigint columns as int columns
enable seafe otpoins
Don't prompt with connecting
Include table name in SQLDescribeCol()
Disable transaction support
--all other options blank or disabled.
I'm not the admin on the MySQL side, but I can do any other testing to see if something works here that doesn't there, I'm willing.
@jcrawf02: :-D Thanks. It's so seldom I get to offer anything that I jump on something that even looks close.
EDITED: Added the driver version and ODBC settings