Using MySQL in Basic4PPC

[Sistemas]

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

 

[linum]

You are da man!

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

 

[specci48]

Well done! :sign0098:

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


specci48

 

[Erel]

Thank you for sharing this :icon_clap:

Moved to 'Tutorials'.

 

[operprincipal]

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

 

[specci48]

microsoft.data.obdc.dll

Can you help me on that?
Thanks

You need to install this.


specci48

 

[operprincipal]

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

 

[Pachuquin]

Have you try to copy microsoft.data.obdc.dll to your application folder?

 

[operprincipal]

Have you try to copy microsoft.data.obdc.dll to your application folder?

:sign0148: well ... i cant find the file nowhere ... Can you you tell me where is it
placed?

 

[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

 

[operprincipal]

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]

: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]

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]

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]

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]

...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.

 

[alanyu]

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!!