HttpSqlProvider makes possible connect to a remote database via Http protocol. Client side provider implements ADO.Net IDbConnection, IDbCommnad, IDataReader, IDataRecord interfaces and acts like common Net data provider. Server side component is a ASP.Net application. This software intended to build smart client application working with remote database via public internet infrastructure. Working smart application demo included.
It is .Net custom provider that implements generic ADO.NET interfaces to bring basic .Net Data functionality using the http protocol to connect to remote data sources over the internet public infrastructure.
HttpSqlProvider use special http server CGI module.
Module dynamically generates output content on HttpSqlClient request.
CGI Module configured to connect a selected by administrator database using provided username and password in CGI module configuration parameters.
A remote client can’t change database but only send SQL command and get appropriate result.
HttpSqlClient does not depends on target database. All work do special CGI module hosted on WEbServer.
This demo version used SQL Server 2000 and CGI module configured to use NorthWind demo database preinstalled with SQL Server Developer distribution.
The author also wrote the working Oracle CGI module.
HttpSql protocol based on XML using deflate algorithm described in RFC 1951.
HttpSqlClient library uses open source SharpZipLib zip compression lib.
Server CGI module made as standalone assembly thus it may be hosted under ASP.NET.
Demo version uses custom TinyHttpServer made by author.
It is a piece of #c code that implements Web server funtcionality and works perfect :)
namespace HttpSqlProvider
public class HttpSqlException implements generic SQL error exception
public class HttpSqlConnection implements IDbConnection.
public String ConnectionString connection string property use to indicate connection parameters
Supported keywords:
Server = address of the data source for example Server=http://80.240.4.179:8080/httpsql/server.aspx;
Compress = true | false; Indicates use of data compression. In provided demo program compression must be set true;
HttpSqlConnection does not support transactions.
Public class HttpSqlCommand : IDbCommand implements SQL command functionality.
Transactions not supported.
Not implemented methods:
ExecuteScalar();
Prepare();
Cancel();
HttpsqlCommand supports sql text and procedure execution. Data parameters also supported.
HttpSqlDataParameter : IDbDataParameter implements data parameter.
Data parameter object supports input/output direction and takes only simple type values.
public class HttpSqlDataReader : IDataReader, IDataRecord
Implements forward resultset, supports multiply resultsets.
Method public DataTable GetSchemaTable() returns resultset schema infromation.
HttpSqlDataReader supports only simple types. Oracle CLOB BLOB and large binary data values currently not supported.
Methods
public long GetChars(int i, long dataIndex, char[] buffer, int bufferIndex, int length)
public long GetBytes(int i, long dataIndex, byte[] buffer, int bufferIndex, int length)
not implemented.
About source purchase and support feel Free to write me by email to Arian@mail.tele2.lt.
Demo program connecting to host http://80.240.5.251:8080/httpsql/server.aspx. But address may be changed by my internet provider.
Please notify me in case of address change.
Best regards,
Arian.
File List:
HttpSqlClientDemo/
0b
HttpSqlClientDemo/App.ico
1Kb
HttpSqlClientDemo/AssemblyInfo.cs
2Kb
HttpSqlClientDemo/Form1.cs
4Kb
HttpSqlClientDemo/Form1.resx
2Kb
HttpSqlClientDemo/HttpSqlClient.dll
80Kb
HttpSqlClientDemo/HttpSqlClientDemo.csproj
5Kb
HttpSqlClientDemo/HttpSqlClientDemo.csproj.user
2Kb
HttpSqlClientDemo/HttpSqlClientDemo.exe
20Kb
HttpSqlClientDemo/HttpSqlClientDemo.sln
1Kb
HttpSqlClientDemo/HttpSqlClientDemo.suo
8Kb
HttpSqlClientDemo/readme.txt
3Kb
Similar code
DigiOz MySQL DLL
(Popularity: ) : The DigiOz MySQL DLL is a DLL written in Visual Basic .NET 2005. This DLL allows you to Query, Insert, Update and Delete records in and out of a MySQL Database using the MySQL .NET Connector 1.0.7 or higher. The ... DigiOz MS Access ADODB DLL
(Popularity: ) : The DigiOz MS Access ADODB DLL is a DLL written in Visual Basic .NET 2003. This DLL allows you to Query, Insert, Update, Delete or otherwise execute any valid SQL Statement to a Microsoft Access Database using ADODB .NET Class ... Bean Software Search Control 2.2 - .NET Edition
(Popularity: ) : Enable feature rich database searching in your application! Your users can choose between four ways of searching: any word, all words, phrase or boolean search expression with AND, OR and NOT keywords. Bean Software Search Control is .NET control that ...
Code Library
) : The DigiOz MySQL DLL is a DLL written in Visual Basic .NET 2005. This DLL allows you to Query, Insert, Update and Delete records in and out of a MySQL Database using the MySQL .NET Connector 1.0.7 or higher. The ...