Mysql Linked Server for SQLServer 2000

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::Initialize 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?unsub=3Dgcdmo-myodbc [at] m.gmane.o rg
glpezzoli [ Di, 27 September 2005 17:43 ] [ ID #985585 ]
Datenbanken » gmane.comp.db.mysql.odbc » Mysql Linked Server for SQLServer 2000

Vorheriges Thema: bk commit - MyODBC 3.51 (1.518)
Nächstes Thema: Re: myodbc Digest 26 Sep 2005 13:18:48 -0000 Issue 977