well, looks like I found the mysql stuff but I can't get it to work. I need some good working examples please.
the sql database is on a non standard port so first thing is would I have to do it this way? 192.168.11.55:3366
but when I do this it fails, the example provided by jdbcsql really well, is lacking. The example also fails. The query seems to be the point of failure.
Dim QQ As String="SELECT cName FROM Customers WHERE Custid ='SCL'"
Log("Just in")
Wait For (Connect) Complete (Success As Boolean)
If Success Then
Try
Dim sf As Object = mysql.ExecQueryAsync("mysql", QQ, Array(300))
Log("starting "&QQ)
Wait For (sf) mysql_QueryComplete (Success As Boolean, Crsr As JdbcResultSet)
<-------------- this is where it fails but this is unchanged from example
If Success Then
Log ("success Connect")
Do While Crsr.NextRow
X.MsgboxAsync(Crsr.getstring("cName"),"Testes")
Loop
Crsr.Close
Else
Log("failed")
End If
Catch
Success = False
Log(LastException)
End Try
CloseConnection
End If
Log("finished sub")
Return Success
this is a great problem
if you can't install any script/program in the server, you need to ask at server administrator if there are some API (or other) for to connect to database
Sorry, I don't see any other solution
let me put this to rest.
NOTHING CAN OR WILL BE INSTALLED ON SERVER
The system is off limits. It is a production system and if it goes down for any reason, remote system control goes down, point of sale systems go down, Security systems go down, Web site inquiry system goes down. so please just know that rule #2 is solid and in place because I deemed "DO NOT TOUCH THIS COMPUTER" and that includes me. This is a critical system and not one to screw around with. Nor to divert more resources for unnecessary scripting. Please stop asking to ignore that rule.
For those other ones confused I meant using jdbcSQL is what I am using. sorry for confusion there. I just need to get connection to mysql. in VS I wrote my own wrapper to provide easy access to mysql, in Linux Gambas I did the same thing. Now I have to do it in Android but still have to get connected to write the wrapper. This is where I hit walls and large learning curves but so far this is the only thing eluding me.
I thank those here for the help, I just hope I find success in this.