New to MySQL and getting an error on OpenSource SQL query from SQL 2000
Posted on 2008-06-20
This SQL Server 2005 script:
select * from openquery (MYREMOTEMYSQLSERVER,
'select clientid, client_status_dt from client')
Gives me this error:
OLE DB error trace [Non-interface error: Column 'client_status_dt' (compile-time ordinal 2) of object 'select clientid, client_status_dt from client' was reported to have a DBCOLUMNFLAGS_ISNULLABLE of 0 at compile time and 32 at run time].
Msg 7356, Level 16, State 1, Line 1
OLE DB provider 'OleMySql.MySqlSource.1' supplied inconsistent metadata for a column. Metadata information was changed at execution time.
When I select certain columns such as CLIENTID which is NEVER NULL...then I get the column of data, however if I request data from a column that contains NULLS...I get the above error.
What can I do to prevent the error and get my data?
I'm using MS SQL Server 2005 on SQL 2000 DBs accessing....MySQL on a UNUNTU LINUX box. I do have access to the LINUX server using MySQL SQL Browser,...however I was just trying to see if I can get data returned from my MS SQL SERVER Management Studio program.