Java Question Ms Sql

[Andriod]

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.

Thanks

 

[NJDude]

Have you read THIS?

 

[stefanobusetto]

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.

 

[Andriod]

@NJDude: I hadn't seen that one - only the php one.

@stefanobusetto: I'd like to see your solution if you'd care to share!


Thanks for your comments.

 

[stefanobusetto]

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!