October 22, 2001 at 1:54 am
How can I make a linked server connection to mysql via ODBC? The ODBC-connection works well with DTS or ACCESS. But SQL2000 refuses with following error:
"Error 7399. OLEDB-provider MSDASQL reported an error. Drivers SQLSetConnectAttr failed.Can't connect on server MYSERVERNAME (10060)". I tried all security contexts.
October 22, 2001 at 10:35 am
Does it work from the local server? If it does, then this doesn't make sense.
Steve Jones
October 29, 2001 at 3:01 am
Thank you, Steve. You are right. I use another gateway on my client from where I can connect to mysql. But the sql-server uses another one. It took me some days to convince the administrator to give me a route and open the 3306-mysql-port, but now it works fine.
October 29, 2001 at 10:33 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply