programming question about interacting with MSSQL and MySQL

[mantisspider]

Hi guys, i got a programming and internet protocal thingy question, anyone able to shed any light pls?

Can applications written for the amiga interact with MSSQL or MySQL databases on the net?
In whatever programming language.

cheers

[amiga1260]

You could program with php and use a webbrowser to interact. It is possible to use C(++) or Java to program applications for the Amiga to interact with MySQL and MSSQL, but I do not try it.

[mantisspider]

Im already using a web browser but I want to use a non web based interface so that high res graphics and videos can be used.
Decent audio and graphics is needed :-S but nice fast interaction between the client and the database too :-( tricky?

[pappavis]

In 1997 I manged to compile mSQL to the AMiga with Geek Gadgets.  Its been updated but not in anything like 6 years or so...
Its not exactly what you want.. since there is no java on AmigaOS your efforts are hopeless.  Forget it, dont waste your time...

[mantisspider]

cheers man

[mantisspider]

Hi guys,

the game i am working on is here:
http://www.silibil.com/game.htm

its only a rough with javascript and no server side stuff... but is only to test the idea

its a mix of "its only rock n roll" and rock star ate my hampster"

:-)

[amiga1260]

There are some Java compilers for the amiga. Check it out on Aminet.

And here is a C library to program a server/client side:
 
http://www.aminet.net/dev/gg/sqlite.readme

[RobinC]

SQL stands for Structured Query Language - it's a standard for interacting with database servers. Of those you've mentioned MySQL, MSSQL, there are also other ones like Oracle etc. Each of these has a huge overlap of commands, but there are some that are slightly different, so choose one and stick to it (personally I use MySQL, but so long as you know the command set for what you use you'll be ok).

Being a standard means it is well documented, if you look up the rfc on SQL (sorry, not got the number handy) it'll explain all protocol stuff, the other option is to find a link library etc if you're going to use something like C. PHP has a module to use it, and no doubt there are modules for other languages to. If you want to get down and dirty then do the communications layer yourself, it's not *that* hard.

Robin

[mantisspider]

cheers robin