Mysql Linked Server for SQLServer 2000

Mysql Linked Server for SQLServer 2000

am 27.09.2005 17:43:31 von glpezzoli

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@m.gmane.o rg