Has anyone considered making a library to connect to MS SQL Server? It would certainly make my life a lot easier! At the moment, I am having to write the queries in ASP webpages and host them on the SQL server!
If someone can think of a better way to get the data from my server, I'd appreciate anything.
I've been using mssql from version 2000.
The client, also the last one, works fine if you stay connected.
An android device connects and disconnects continuously.
A web service is a better solution in my opinion.
I have already developed one.
If you need.
here is :
php.zip ( the php web service )
create_tables.zip ( script to create the table for the example )
TestWsQuery ( the b4a project )
create the table in the database
set up an odbc on the web server
install the php files
follow the instructions to enable mcrypt
see in xn_crypt.php file
configure the http:// .... //
run everything!