Connecting to web mysql database

General questions about NeoBook

Moderator: Neosoft Support

Locked
User avatar
HackinHoodLogicsTm
Posts: 131
Joined: Wed Aug 28, 2013 7:03 am
Location: Ghana
Contact:

Connecting to web mysql database

Post by HackinHoodLogicsTm »

Hi Fellow Neobookers.

Please can anyone suggest or show me how to connect NeobookDB Pro to my web sql database.
I would like to migrate from Local Access DB to My Web MSQL Database and I don't know how?

Please every suggestion would be highly appreciated.

Thank you
I am proud to be a Neobooker!!!
www.neosoftware.com
Special Thanks To
Mr. David Riley
Ghatoo
Posts: 12
Joined: Sun Feb 10, 2008 9:35 am

Re: Connecting to web mysql database

Post by Ghatoo »

Hola saludos, yo lo hago así....
1. Crear con Mysql una DB en un host (remote server)
2. Utilizar dbpOpenDatabase del plugin NeoBookDBPro
3. En la ventana de control del plugin ir al boton "Connection String Wizards"
4. Utilizar la opción MySQL connection Wizards
5. Ingresar (Nombre del servidor ejemplo "www.yourhost.com"), (nombre de la DB remota), (Usuario y Password)
6. Probar la conexión
7. Listo...todo lo demás igual al código utilizado en local

Hello greetings, I do so ...
1. Create with Mysql a DB on a host (remote server)
2. Use dbpOpenDatabase of the NeoBookDBPro plugin
3. In the plugin control window go to the "Connection String Wizards" button
4. Use the option MySQL connection Wizards
5. Enter (name of the example server "www.yourhost.com"), (name of the remote DB), (User and Password)
6. Test the connection
7. Ready ... everything else equal to the code used in local :)
Por favor no dejen morir a NeoBook! Please do not let NeoBook die!
David de Argentina
Posts: 1596
Joined: Mon Apr 04, 2005 4:13 pm
Location: Buenos Aires, Argentina
Contact:

Re: Connecting to web mysql database

Post by David de Argentina »

Hi overthere,

You must be sure your hosting allows to get external mysql connections (usually at ports 3306 or 3307)

Almost all free webservers does not allow this kind of connections.

The another way (the simple way) is using PHP.

My 0.01

David de Argentina
User avatar
HackinHoodLogicsTm
Posts: 131
Joined: Wed Aug 28, 2013 7:03 am
Location: Ghana
Contact:

Re: Connecting to web mysql database

Post by HackinHoodLogicsTm »

Thank you very much. It works.
You saved my day :)
I am proud to be a Neobooker!!!
www.neosoftware.com
Special Thanks To
Mr. David Riley
Locked