MySQL ODBC Connector - Mysql Linked Server for SQLServer 2000

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Mysql Linked Server for SQLServer 2000

glpezzoli@tin.it

2005-09-27, 11:23 am

I have 2 machines, a SQLServer 2000 and a MySQL Server (4.0.18, Unix, red=

hat)

I created a DSN in SQLServer machine with myODBC 3.51.6.
I created a linked server in SQLServer
I wrote a stored procedure in SQLServer accessing MySQL server.

With myODBC 3.51.6 works for 300/400 queries. After this number of querie=
s
i get the
error mySQL client out of memory

With myODBC 3.51.11-2 i have an error accessing mysql server from
Enterprise Manager (Linked servers)
Error 7399 OLE/DB Provider: IDBInitialize::Initi
alize returned 0x8000fff

Witch parameters of MyODBC 3.51.11-2/Linked server must i check/uncheck t=
o
have
SQLSErver work with MySQL ?

Thanks in advance
Gianluca

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc? unsu...sie.nctu.edu.tw

Sponsored Links