linked server query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

linked server query

Author

Topic

sgames
Starting Member

3 Posts

Posted - 2009-08-06 : 12:16:34

When i am trying to query linked server(mySql) from Sql server i am getting the following error.

[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ].
Msg 7399, Level 16, State 1, Line 2
OLE DB provider 'MSDASQL' reported an error.

but the dsn name is same in both servers is same.

test connection is successful

jholovacs
Posting Yak Master

163 Posts

Posted - 2009-08-06 : 15:03:07

What do you mean the DSN is the same in "both" servers? I don't think it should be the same.

Additionally, is this a new setup? Has the MySQL server been configured to allow remote connections? Are you providing credentials in the connection string?

SELECT TOP 1
w.[name]
FROM
dbo.women w
INNER JOIN
dbo.inlaws i
ON
i.inlaw_id = w.parent_id
WHERE
i.net_worth > 10000000
AND
i.status IN ('dead', 'dying')
AND
w.husband_id IS NULL
ORDER BY
w.hotness_factor DESC

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources