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!

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


specci48

[Erel]

Thank you for sharing this

Moved to 'Tutorials'.

[operprincipal]

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]

Originally Posted by operprincipal

microsoft.data.obdc.dll

Can you help me on that?
Thanks

You need to install this.


specci48

[operprincipal]

Originally Posted by specci48

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]

Originally Posted by Pachuquin

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

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