cancel
Showing results for 
Search instead for 
Did you mean: 

How to configure a database collection to store data to MYSQL from a 64 bit server

Support_Sydney
Moderator

How to configure a database collection to store data to MYSQL from a 64 bit server

You may experience problems trying to configure a Prognosis database collection to an ODBC ‘MYSQL’ destination on 64 bit Windows Operating Systems.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Support_Sydney
Moderator

Re: How to configure a database collection to store data to MYSQL from a 64 bit server

You may experience problems trying to configure a Prognosis database collection to an ODBC ‘MYSQL’ destination on 64 bit Windows Operating Systems.

Possible Symptom: You may receive the following error:
“Unable to connect to external database”

Explanation: Prognosis uses a 32-bit ODBC connection to these database servers so it is important to ensure you do three things:

1. Install the 32 bit MYSQL ODBC driver (Even if your node is 64 bit)
I.e. “mysql-connector-odbc-5.1.11-win32.msi”

2. Create the empty database in MYSQL and ensure your USER has sufficient permissions to connect from your server.

3. Configure the ODBC connection in the 32 bit copy of the “ODBC Data Source Administrator” tool. On a 64 bit machine you can load both the 32 bit and 64 bit copies of this tool. To load the 32 bit copy of the tool, execute the following command from “Start | Run”:

%WINDIR%\SysWOW64\odbcad32.exe

- Then click into “System DSN” tab and click “Add”. Then select “MySQL ODBC 5.1 Driver” from the list and click finish.

- Key in the appropriate details and as long as the test button works here, then Prognosis or IP Telephony Manager will be able to utilize this DSN Connection.

Note: If this last step fails then it is almost certain that MYSQL settings are preventing connection and Prognosis or IPTM will not work until this test button succeeds.

View solution in original post

1 REPLY 1
Support_Sydney
Moderator

Re: How to configure a database collection to store data to MYSQL from a 64 bit server

You may experience problems trying to configure a Prognosis database collection to an ODBC ‘MYSQL’ destination on 64 bit Windows Operating Systems.

Possible Symptom: You may receive the following error:
“Unable to connect to external database”

Explanation: Prognosis uses a 32-bit ODBC connection to these database servers so it is important to ensure you do three things:

1. Install the 32 bit MYSQL ODBC driver (Even if your node is 64 bit)
I.e. “mysql-connector-odbc-5.1.11-win32.msi”

2. Create the empty database in MYSQL and ensure your USER has sufficient permissions to connect from your server.

3. Configure the ODBC connection in the 32 bit copy of the “ODBC Data Source Administrator” tool. On a 64 bit machine you can load both the 32 bit and 64 bit copies of this tool. To load the 32 bit copy of the tool, execute the following command from “Start | Run”:

%WINDIR%\SysWOW64\odbcad32.exe

- Then click into “System DSN” tab and click “Add”. Then select “MySQL ODBC 5.1 Driver” from the list and click finish.

- Key in the appropriate details and as long as the test button works here, then Prognosis or IP Telephony Manager will be able to utilize this DSN Connection.

Note: If this last step fails then it is almost certain that MYSQL settings are preventing connection and Prognosis or IPTM will not work until this test button succeeds.

View solution in original post