Using MySQL in Basic4PPC

[operprincipal]

Originally Posted by Pachuquin

You have to install the ODBC .Net provider first.

Then you will usually find the microsoft.data.odbc.dll file in:

C:\Program files\Microsoft.NET\Odbc.Net

Thanks so much! I've done that and after i move from there the pachodbc.dll i finally got the compilation executed. Only now i've error when runing the exe

Error [HY000] [MySql] [ODBC 5.1 Driver] Can't connect to MySQL Server on 'xxx.xxx.xxx.xxx9 (10060)

The non compiled version still works.

Then again ... can you help me on this?

[operprincipal]

Originally Posted by operprincipal

Thanks so much! I've done that and after i move from there the pachodbc.dll i finally got the compilation executed. Only now i've error when runing the exe

Error [HY000] [MySql] [ODBC 5.1 Driver] Can't connect to MySQL Server on 'xxx.xxx.xxx.xxx9 (10060)

The non compiled version still works.

Then again ... can you help me on this?

Just to the records ... that was an SQL error due to firewall misconfiguration.
Thanks again for your help

[satmalaka]

He descargado el pdf en el que indicais como hacer para conectar con la BD pero cuando intento descargar" Basic4PPC ODBC library" me indican que no tengo privilegios. Que puedo hacer? Gracias.

[chavarrya]

Hi!
I've follow the mysql guide to connect MySQL BD, but I can't get to connect this one.
I've create de DSN, copy and paste the code in the pdf file but it doesn't work.
I've added the patchODBC and create de con, cmd and reeder Objet as told the manual but it didn't work.
Some suggestion?

[pdabasic]

Hy EveryBody!

How can I use this solution If I would like to connect to mysql on my desktop with my pda via Wlan?

Thanks

[AFSSoftware]

Thx for tutorial,
but i am new in Basic4Android and have a problem with following commands:

'PachODBC.dll must be added manually as a component
'Objects con, cmd, reader must be added manually

What should i do?

Until now i added the pachODBC.dll to my Libaries folder and install Microsoft.Data.Odbc.

[mjcoon]

Originally Posted by AFSSoftware

...but i am new in Basic4Android and have a problem with following commands:

What should i do?

Erm, ask your question in the Basic4Android forum (this is the B4PPC forum).

Mike.