MySQL linked server on SQL Server 2000

Hi folks,

I'm having a spot of bother creating a linked MySQL server on SQL2K.

I'm using the following code on an SP4 SQL2K instance. MySQL 5.1 is installed on the same box, and I've installed the MySQL ODBC 3.51 Driver.

sp_addlinkedserver
'myAlias'
, 'MySQL'
, 'MSDASQL'
, Null
, Null
, 'Driver={MySQL ODBC 3.51 Driver};DB=myDatabase;UID=myUserName;PWD=myPassword;SERVER=localhost;'
go

EXEC sp_addlinkedsrvlogin
@rmtsrvname = 'myAlias',
@useself = 'TRUE',
@locallogin = NULL
GO

-- List the tables on the linked server
EXEC sp_tables_ex 'myAlias'
GO

sp_tables_ex throws the following error:

OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.].
Msg 7399, Level 16, State 1, Procedure sp_tables_ex, Line 13
OLE DB provider 'MSDASQL' reported an error. The provider did not give any information about the error.


BUT if I use the exact same syntax on a SQL2005 server, it works just fine.

Any ideas?

.

Relevant Pages

  • MySQL linked server on SQL Server 2000
    ... I'm having a spot of bother creating a linked MySQL server on SQL2K. ... I'm using the following code on an SP4 SQL2K instance. ... MySQL 5.1 is installed on the same box, and I've installed the MySQL ODBC 3.51 Driver. ... OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.]. ...
    (microsoft.public.sqlserver.connect)
  • MySQL ODBC auf Win 64bit
    ... habe einen Win2003 R2 SP2 Server, auf dem ich Active Server Pages mit ... Das produziert immer diesen Fehler: ... Ein Provider ist nicht angegeben, ... MySQL als 64bit und 32bit, ...
    (de.comp.datenbanken.mysql)
  • Re: Inserting into a SQL database - any provider
    ... Server, ... Actually the MySql client is open source, if this is the only provider left ... database abstraction layer, but maybe less effort. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: MySQL/PHPMyAdmin on FC3 Connection Problem
    ... // You can disable a server config entry by setting host to ''. ... MySQL server ... MySQL control user settings ... table to describe the display fields ...
    (Fedora)
  • Re: Perflib errors in event logs after SP2 installation
    ... the server does seem to be working fine. ... System account is a potential security risk. ... Policy provider runs under the Local System account, ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
Loading