The following error appears while trying to perform Cross Connection Query :-
SQL Server to Excel File = Invalid data source definition: ConnectionOpen (Connect()).;Invalid connection string attribute;SQL Server does not exist or access denied.
Oracle to Excel File = Cross Query Database Error: Invalid data source definition: ORA-12170: TNS:Connect timeout occurred.
Oracle to SQL Server = Cross Query Database Error: Invalid data source definition: ORA-12170: TNS:Connect timeout occurred.
Below ports and programs are blocked at the firewall :-
Port 1521 - C:\Program Files\Quest Software\Toad Data Point 5.6\DataHub\bin\mysqld.exe
- C:\Program Files\Quest Software\Toad Data Point 5.6\DataHub\hubproxy\hubproxy.exe
Port 1433 - C:\Program Files\Quest Software\Toad Data Point 5.6\DataHub\bin\mysqld.exe
- C:\Program Files\Quest Software\Toad Data Point 5.6\DataHub\hubproxy\hubproxy.exe
1. Ensure the ODBC drivers are already installed for the datasource (Oracle, MSSQL, MySQL, etc)
2. Check and whitelist both mysqld.exe and hubproxy.exe processes at firewall.
