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
Connecting to web mysql database
Moderator: Neosoft Support
- HackinHoodLogicsTm
- Posts: 131
- Joined: Wed Aug 28, 2013 7:03 am
- Location: Ghana
- Contact:
Re: Connecting to web mysql database
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
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!
-
- Posts: 1596
- Joined: Mon Apr 04, 2005 4:13 pm
- Location: Buenos Aires, Argentina
- Contact:
Re: Connecting to web mysql database
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
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
- HackinHoodLogicsTm
- Posts: 131
- Joined: Wed Aug 28, 2013 7:03 am
- Location: Ghana
- Contact:
Re: Connecting to web mysql database
Thank you very much. It works.
You saved my day
You saved my day