Using MySQL in Basic4PPC

Sistemas

Member
Licensed User
Hi all,
I have created a document to explain how to use a MySQL database in a Basic4PPC application. I hope it helps.
Sistemas
 

Attachments

  • How to use MySQL in Basic4PPC.zip
    303.8 KB · Views: 1,688
Last edited:

linum

Active Member
Licensed User
You are da man!

I was looking for a tutorial for using MySQL. I'll give this a shot. Thanks...
 

specci48

Well-Known Member
Licensed User
Longtime User
Well done! :sign0098:

@Erel: What about moving this thread to the tutorial section?


specci48
 

operprincipal

Member
Licensed User
Longtime User
Compiling

It's work fine on ide ... but when i try to compile it gives me an error saying that it can't find the

microsoft.data.obdc.dll

Can you help me on that?
Thanks
 

operprincipal

Member
Licensed User
Longtime User
Compiling error

You need to install this.


specci48

Thanks for your reply. It keeps giving me the same error but when i run the program without compiling it, works fine

Sub Globals
End Sub
Sub App_Start
form1.Show
con.New1
con.Open("DSN=STUFF;")
cmd.New1("",con.Value)
con.BeginTransaction(cmd.Value)
Cmd.CommandText="SELECT * FROM associados"
cmd.ExecuteTable("table1",0)
Cmd.CommandText="SELECT * FROM pagamentos"
cmd.ExecuteTable("table2",0)
Con.EndTransaction
End Sub
 

operprincipal

Member
Licensed User
Longtime User
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

:icon_clap: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):sign0148:

The non compiled version still works.

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

operprincipal

Member
Licensed User
Longtime User
:icon_clap: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):sign0148:

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

New Member
No puedo decargar Basic4PPC ODBC library

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

New Member
Licensed User
Error with ODBC -

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

Active Member
Licensed User
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

Member
Licensed User
Longtime User
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.
 

alanyu

Member
Licensed User
Hi all,
I have created a document to explain how to use a MySQL database in a Basic4PPC application. I hope it helps.
Sistemas

I'm trying to access a MySQL database
My operating system is Windows 7, when I started in desktop applications, everything is fine, only when I want to compile all test.EXE, the following message appears:
---------------------------
External compiler error
---------------------------
Error compiling program.
Error message: error CS0012: The type 'System.ComponentModel.Component' is defined in an assembly that is not referenced. You must add a reference to assembly 'System, Version = 1.0.3300.0, Culture = neutral, PublicKeyToken = b77a5c561934e089'.
---------------------------
Microsoft.Data.ODBC.dll program is also installed.
Please help me!Thanks!!
 
Top