Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

DarkBASIC Professional Discussion / Apache/MySQL webserver connection

Author
Message
Karlos
23
Years of Service
User Offline
Joined: 18th Nov 2002
Location: United Kingdom
Posted: 15th Sep 2003 19:39
Link
Hi,
Quick question...

I have a mysql database running on a webserver somewhere.

I would like to be able to connect to this database using dbpro without having to install mysql on the client machine.

I suspect that the sql dll could do this but would need local installation.

Alternatively I could write a web wrapper for the database but that would mean dbpro sending and receiving http requests to the webserver.

Any ideas if any of this is possible or if any dlls exist that would help?

Cheers

Karlos

If it ain't broke - try harder.
W2K Pro - Geforce2 MX400 64MB - Athlon 900
Back to top
Profile PM Website
Richard Davey
Retired Moderator
24
Years of Service
User Offline
Joined: 30th Apr 2002
Location: On the Jupiter Probe
Posted: 15th Sep 2003 20:11
Link
This isn't possible with native dbpro and if your MySQL server has any kind of security on it - it's not possible fullstop without writing an interface between the MySQL server, the web server and the client machine.

A DLL could do it, suggest you wait for TCA to reply

Cheers,

Rich

The sky above the port was the colour of television, tuned to a dead channel.
Your brain's just like any other appliance: it works better if you plug it in...
Back to top
Profile PM Email Website
OSX Using Happy Dude
22
Years of Service
User Offline
Joined: 21st Aug 2003
Location: At home
Posted: 15th Sep 2003 20:55
Link
You can use my SQL plug-in, which is good if you know the connection strings needed and the database is already present.

The better way would be the SQLite plug-in - you have full control over the filename and where it is etc - the only downside is that there are no types - everything (and I do mean everything) is treated as a string.


Avatar & Logo by Indi. Come to the UK DBPro Convention in Chichester
Back to top
Profile PM Email Website
David T
Retired Moderator
23
Years of Service
User Offline
Joined: 27th Aug 2002
Location: England
Posted: 15th Sep 2003 22:04
Link
I would write a set of php scripts to interface with the database nad then use something like the blue gui browser gadget to access them.

eg. www.domain.com/add.php?name=JohnDoe&score=45&secure=g7d@fdgt
(the secure bit would be some code that'd verify that it was you accessing and not somebody else)

That'd be easy for editing a database, but if you want to get information that'd require more thought maybe writing data to a text file then using ftp commands?

c:/dos
c:/dos run
run dos run
Back to top
Profile PM Email Website
Karlos
23
Years of Service
User Offline
Joined: 18th Nov 2002
Location: United Kingdom
Posted: 15th Sep 2003 23:46
Link
Cheers all,
Somehow I just knew I would end up with a Mr TaToad plugin. Hopefully my database is not too secure.

Cheers

Karlos

If it ain't broke - try harder.
W2K Pro - Geforce2 MX400 64MB - Athlon 900
Back to top
Profile PM Website
OSX Using Happy Dude
22
Years of Service
User Offline
Joined: 21st Aug 2003
Location: At home
Posted: 16th Sep 2003 13:37 Edited at: 16th Sep 2003 13:43
Link
It should be okay - SQLite doesn't seem to have password locking unfortunately though.


Avatar & Logo by Indi. Come to the UK DBPro Convention in Chichester
Back to top
Profile PM Email Website
Back to top

Login to post a reply

Server time is: 2026-07-26 05:02:34
Your offset time is: 2026-07-26 05:02:34