Go Down

Topic: (Urgent) Arduino -> Vb 6.0 -> Sql + php (Read 2 times) previous topic - next topic

Murinto92

Hi, all
need your help..
how to connect vb 6.0 to sql and php ??

florinc

Does this have anything to do with Arduino?

Murinto92

Hi,, florinc
I use Arduino to detect temperature in CPU, i use sensor DS18B20..
I have finished to send data from arduino to vb 6..

now i need help,
to send data to sql + php??
do you have any idea florinc???

Thanks
Murinto

pylon

Ask this on a VB6 forum. This is not related to Arduino.

dxw00d

You're best bet, given that you have already read data from the Arduino into VB, would be to ask at a VB forum.

Slightly off-topic, why are so many people still using VB6? Is it because it was the last native code version, or is there some other reason?

florinc

I imagine you want to provide the temperature data you collected (with Arduino) when there is an http request.
This is how I would do it: get VB to write the data to database (sql), then write the php page to retrieve data from the database (sql).

I don't think you will get anyone around here to write the php/sql code for you though. There must be plenty of samples out there.

Murinto92

To dxw00d and pylon : Thanks brother,,, do you know the address of the site forum...

To florinc :Thats right bro,, can you help me to finished this project??





PaulS

Quote
I will learn php and sql programming...

So, you're VB application is going to create a PHP script to write to a MySQL database, and execute that, instead of executing the instructions to write directly to a SqlServer database?

Well, good luck with that.

Don't get me wrong. I like PHP and MySQL. But, unless you are using PHP to communicate with the serial port (and that does not work on Windows), then using PHP to communicate with the database is just an unnecessary complexity. If you are even considering using VB6, then clearly you are on Windows, and PHP is not the right tool (for accessing the serial port/data).

Murinto92

Quote
Don't get me wrong. I like PHP and MySQL. But, unless you are using PHP to communicate with the serial port (and that does not work on Windows), then using PHP to communicate with the database is just an unnecessary complexity. If you are even considering using VB6, then clearly you are on Windows, and PHP is not the right tool (for accessing the serial port/data).



I use Wamp Server (phpmyadmin) ..
First I transfer data from Arduino to visual Basic 6.
Then immediately write the data to the database server.
continued from the database that displays the results of the temperature sensor to the website ..

If that's principally, if I could?

Thanks...

PaulS

Quote
First I transfer data from Arduino to visual Basic 6.
Then immediately write the data to the database server.

Which database? MySQL or SQLServer? I don't know if MySQL provides a way for VB applications to write to the database. I know that SQLServer does.

PHP is not involved in the data acquisition process at all, if I understand you correctly.

PHP is involved in the data display process, but that is a completely separate issue. Making PHP get data from a SQLServer instance might be an interesting challenge.

florinc

Quote
I don't know if MySQL provides a way for VB applications to write to the database

Through ODBC (on Windows) you can get access to any database/datasource you like for which ODBC drivers are provided, including MySQL.

Quote
Making PHP get data from a SQLServer instance might be an interesting challenge.

http://msdn.microsoft.com/en-us/library/cc793139(v=sql.90).aspx

Murinto92

Quote
Through ODBC (on Windows) you can get access to any database/datasource you like for which ODBC drivers are provided, including MySQL.


ODBC ??
I do not know about it. can you explain about it???

dxw00d

ODBC - Open DataBase Connectivity - http://en.wikipedia.org/wiki/ODBC

Basically it's an abstraction layer that sits between an application and a database engine (Oracle RDBMS, MS SQL Server, mySQL, MS Access, and many others). It means the application doesn't need to know the specifics of the DB engine. Theoretically, if the application only issued ANSI SQL statements, then ODBC would allow any ANSI SQL DB engine to be targeted, without changes to the application.

Go Up