This may simply be an EBKAC (Error between keyboard and chair) issue, but I'm hoping someone can point me in the right direction?
I've written a self-hosted WCF service using dotConnect Universal Trial to connect to a MySQL database (I may switch databases later). Everything seems to work just fine on my local development machine. However, when I copy the console service application over to a different test machine and start the service, I receive the following exception:
The MySQL database service is running and listening on port 3566 (non-standard port). The server is actually an embedded database server within another application. I'm adding to its functionality through my own schema. I can make a connection to it without a problem (either on that machine or from my development machine) using MySQL Workbench using the exact same settings and credentials. My UniConnection connection string to the database is:Can't connect to MySQL server on 'localhost' (10061): Authentication failed. See server logs for more details.
Code: Select all
Provider=MySQL;direct=true;host=localhost;port=3566;user=test;password=test
1) I used the licensing wizard to include the licenses.licx resource in my project.
2) I added the DbProviderFactories section to my App.Config and updated the version to the correct version.
3) I rebuilt my project. It still works on my local machine.
4) I copied over the service files, as well as Devart.Data.dll, Devart.Data.Universal.dll, and Devart.Data.Universal.MySql.dll
However, when I run the console app, I get the above error when I try to access the service's webpage. It says to check the server logs, but there's nothing in MySQL's server logs saying it even tried to connect.
At this point, I'm only deploying in a test environment. Of course, I'd use a full version in production; but I'm confused as to why I can't connect to the server from dotConnect Universal when I can connect via MySQL Workbench.
Any ideas??
Thanks!
-John