2009-6-6 14:05
pericles
ODBC Connecting Error
以下列出連接 ODBC 出現 Error 事的處理:
Q.1. "Request return with SQL_ERROR"
Sol.
1. 檢查 Server / User / Password 及 Port 位址 是否正確
2. 當所有有關資料 , 包括 Server / User / Password 均正確了, 且在另一台電腦也能夠連接上的情況下 , 可以嘗試是否 Firewall 問題
a. In DOS Pormpt : netstat -a
及 : telnet localhost 3307
If there's no answer, then connection is blocked or no program listening on port 3307.
2009-6-6 14:20
pericles
Try to remove Microsoft Firewall Socket Provider from registry.
Try to remove Microsoft Firewall Socket Provider from registry.
I did it with Autoruns ([url]www.systeminternals.com).[/url]
Or download from [url]http://www.pericles.net/download/tools/Autoruns.zip[/url]
The registry key:
HKLM\System\CurrentControlSet\Services\WinSock2\Parameters\Protocol_Catalog9