|
Do you have a Windows application that needs to access a
database on the Web? How would you like to be able
to open a connection to a SQL Server, Oracle or MySQL
database that resides on any server on the Internet, and
issue SQL commands and obtain query results?
Sounds pretty good, huh? This is exactly what the
SqlWeb COM DLL does. You only need to copy a few
ASP or PHP files up to your webserver and away you go!
This diagram shows how the COM DLL connects to your
database through a webserver. You only need to
copy our server files (ASP or PHP) to your webserver so
the COM DLL can use them to access the database.
They act as the gateway between the database and the
outside world.
Since it is a COM DLL, it is usable by most common Windows programming
languages (eg. .NET, VB, C++, Delphi, etc.). In fact, our
SqlWeb Explorer product uses this COM DLL for all of
its database access.
- Supports secure SSL connections
- Supports Proxy server connections
The SqlWeb object model is very similar to
ADO (Microsoft ActiveX Data Objects). The main
SqlWeb COM object is
SqlWeb. You use this object to issue SQL commands.
If the command is a row-returning query, the results are
returned in a Dataset object, which is made up of
rows and columns. This object is very similar to
the ADO Recordset object. You access the Dataset
Column objects via the Dataset Columns collection
(like ADO Field and Fields). You use methods on
the Dataset to move through the dataset, such as
MoveFirst
and MoveNext. Like ADO, using SqlWeb is very
easy.
Here is a Visual Basic sample that demonstrates opening the sample
Northwind database on our webserver, issuing a row-returning SQL query and
displaying the results.
Dim sqlWeb As New SqlWeb
Dim ds As Dataset
Dim col As Column
Dim nRet As Long
mSqlWeb.Path = "SqlWeb"
mSqlWeb.Host = "www.eztools-software.com"
mSqlWeb.Connect "Provider=SQLOLEDB.1;Data Source=(local);User
Id=Eval;Password=12345;Initial Catalog=Northwind", "", eStAsp
nRet = mSqlWeb.Execute("SELECT * FROM Employees", eCtText, ds, 100)
If Not ds.EOD Then
For Each col In ds.Columns
Debug.Print "Column Name: " &
col.Name
Next
While Not ds.EOD
For Each col In ds.Columns
Debug.Print
col
Next
Debug.Print vbCrLf
ds.MoveNext
Wend
End If
sqlWeb.Disconnect
|
As you can see, using SqlWeb in your programs is very easy.
No other solution works as simply and reliably. Why not download the DLL
and test against our sample database on our webserver?
|
|
See how to build Dynamic WPF
Database Products