MySQL Forums
Forum List  »  Microsoft SQL Server

MSDASQL return error :ssl.type
Posted by: liou zhaoxing
Date: July 17, 2010 02:32AM

I am using the MySQL ODBC driver version mysql-connector-odbc-5.1.6-win32 to export data from MySQL version 5.1.48 to SQL Server 2000 and am having problems with fields.
the step is as follows below:
ON MSSQL server 2000:
USE master
GO
-- To use system data source name:
EXEC sp_addlinkedserver
@server = 'test_mysql_datasource',
@srvproduct='any_name',
@provider = 'MSDASQL',
@datasrc = 'mysql'
GO
I'm using the Openquery function in SQL Server to execute the query.

Below is my very simple select query . but is being returned an error:

select * from openquery(xx,'select * from mysql.host');
%服务器: 消息 7347,级别 16,状态 1,行 1
%OLE DB 提供程序 'MSDASQL' 返回了固定长度列 '[MSDASQL].ssl_type' 的意外数据长度。预期的数据长度为 18。而返回的数据长度为 0。
the meaning of the above is :the program MSDASQL return unexpected length of data.
and expected length of data is 18 but return is zero
and but if the result is empty set,there is no error report.
is there any settigns that i dont't notice?

I would appreciate any help you could provide.






Thanks,

Options: ReplyQuote


Subject
Written By
Posted
MSDASQL return error :ssl.type
July 17, 2010 02:32AM
QQ
July 18, 2010 01:44PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.