FireWorx wrote:But on IOS? The only person that has said he does it is Bangkok, and he hasn't posted exactly how, although he says he uses a socket server. I am not sure how that works.
Dave
Watch out : i didn't say it was working with iOS, because i don't use it.
But let's assume LiveCode iOS doesn't have ODBC driver or native MS SQL driver capabilities... therefore can not directly connect to a MS SQL database, then what would be your options ?
Let's assume, you need something working on a local network (your company)
You have 2 solutions :
-webservice
-socket server (if LiveCode iOS handles socket, which i don't know)
-webservice
-set up a web server (with Apache, or the very good and simple Abyss on Windows, Linux)
-install LiveCode Server (that will allow you to write "cgi" like regular LiveCode script)
-install on the web server machine, the drivers to connect to the MS SQL database
The scheme is easy :
-iOs sends http queries to the local webserver. Something like :
Code: Select all
put URL "http://192.9.202.1/mycgi.irev?"&myparameters into myresult
-the cgi, takes the parameters, connects to the MS SQL db, sends the SQL query, takes the results, and "display" (just a put) the results on the webpage
-iOS gets the results
-socket server
-in this solution, no need LiveCode Server
-easy : you replace http queries by data sent directly to some socket, to a server
-set up a server (Windows, Linux) with a special LiveCode application on it
-set up the drivers for MS SQL
-this server, will "listen" to a special port number
Code: Select all
on mouseUp
accept connections on 8192 with message "connection"
end mouseUp
on Connection theIP
read from socket theIP until return with message "incoming"
end Connection
on contacted theIP,theMessage
if char 1 of theMessage ="1" then
--- here connects to DB
--- sends the query
write myResult&"#" to socket TheIP with message "finish"
exit to top
end if
end contacted
-the iOS application opens connexion on this port number, sends the query, waits for result, and close the connexion
Code: Select all
on mouseup
open socket to "192.9.202.1:8192" with message "iamconnected"
end mouseup
on iamconnected theSocket
write "1"&myparameters&return to socket theSocket
read from socket theSocket until "#" with message "displayResult"
end iamconnected
on displayResult theIP theMessage
close socket theIP
answer theMessage
end displayResult
In both solutions, you need a server. It will do the dirty work. iOS applications will be only "client". it's good for security : no need to share DB passwords for instance on many applications. You have only one. And it's easier to maintain. If you need to modify a SQL query... you do it only once, on the server. The clients do not need to be uptated/changed.