I’m attempting to write an external BAQ to pull data from a mysql server. I have verified I can connect from our application server via telnet(firewall not blocking).
I can’t get External Datasource Maintence to test the connection successfully, do I need ODBC? Please note I don’t know the syntax to specify the port I assume serverName:port(the error seems to indicate this is incorrect)…
Error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
The parameter is incorrect
Thanks! I know have the external datasource passing the connection test and have enabled the external connection in company maintenance.
Initially I didn’t configure anything in External datasource metadata - do I need to?
In External Business Activity Query I can see all the tables, but it doesn’t list the field. For the joins I just manually entered the field names(no big deal), but to display no fields are listed and there is an error which seems to imply invalid mySQL syntax. Does this mean my ODBC driver not properly configured?
