Knowledgebase
How do I convert my DMXReady application to use MySQL?
Posted by DMXReady Admin on 19 December 2013 08:28 PM
Q. How do I convert my DMXReady application to use MySQL?
A. You may choose to convert your DMXReady application by following the steps below. Please note that since every server is different, you should contact your webhost provider to confirm all details about using MySQL.
  1. Setup your MySQL database on your host server
  2. Import the MySQL database dump file for your respective app using a FREE conversion software like: http://www.bullzip.com/products/a2m/info.php
  3. Adjust the DSNLESS connection string to connect to the MySQL database. The DSNLESS connection string is located in the "/Connections" folder.

Below is a sample connection script used by the Links Manager to connect to a MySQL database. The same logic would apply to all DMXReady apps. Check with your webhost provider to ensure that this connection string will work with your server.

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
MM_LinksManager_STRING = "driver={MySQL ODBC 3.51 Driver};database=*****;server=*****;uid=*****;pwd=*****;option=3;"
%>

You can learn more about converting your database here:
  1. http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_16575&sliceId=2
  2. http://www.kitebird.com/articles/access-migrate.html (includes a self-evaluation to find out if conversion is right for you)

For help with upsizing your database to MS SQL, See here: http://dmxready.helpserve.com/Knowledgebase/Article/View/9/0/can-a-dmxready-application-be-converted-to-work-with-ms-sql

 

(3163 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Help Desk Software by Kayako dmxready.helpserve.com