-
Welcome to B4X forum!
B4X is a set of simple and powerful cross platform RAD tools:
- B4A (free) - Android development
- B4J (free) - Desktop and Server development
- B4i - iOS development
- B4R (free) - Arduino, ESP8266 and ESP32 development
Using MySQL in Basic4PPC
- Thread starter Sistemas
- Start date
- Similar Threads Similar Threads
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
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
Compiling error
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
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
:sign0148: well ... i cant find the file nowhere ... Can you you tell me where is it
placed?
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
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?
Just to the records ... that was an SQL error due to firewall misconfiguration.
Thanks again for your help
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?
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?
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.
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.
Erm, ask your question in the Basic4Android forum (this is the B4PPC forum).
Mike.
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!!