Home
OSS
Freeware
Shareware
 
Seow Phong Studio->Shareware


Web DB Explorer



Great Engine Web DB Explorer is an assistant tool which focus on website database develops and maintain. It use HTTP protocol, which either can easy publish in B/S structure or have maneuverability in C/S structure.

Web DB Explorer is the true thin client database develops tools and not need to install and configure the database client software, just need to copy relevant Web DB Server Script to the website and add new connection on Web DB Explorer.

Web DB Explorer is the database develop tools that support VS.NET and J2EE.The Web DB Server Script can run on IIS, Apache, Tomcat and WebLogic, JBoss etc, Web DB Server Script include ASP, ASP.NET, PHP AND JSP, support Oracle, MS SQL Server, Informix, MySQL and Access.

Web DB Explorer is the online document server, create the remark database and remark the database objects, and shared the remark information to other member of the develop teem.

The software has interface to support multi-languages, all it needs is configuration files, and then it can get the new ability to support a new language.

(Download:Local,C/Net)

 

Search in Google

 

To make a website database, choice SQL Server or Access?


To make a website Database, choice SQL server is better than Access or not? You may say that: the best is select MySQL . But now is discussing the choice in IIS+ASP, not the situation of Apache+PHP. If the software is used in intranet, and the cost of software is not been consider, SQL server is the best. It sounds that it is no need to discuss. But it is not the same to use in internet, because the entire person to make website is to renting visual server. So the familiar combination is PHP+MySQL, ASP+Access or ASP + SQL server. So we can compare the SQL server and Access as flow:

Cost

The cost of vistual server of SQL Server will be 1.5 to 2.5 times to ACCCESS.

Performance

Compare to SQL sever, ACCESS is not better in capability and stability .But pay attention please, and it is not the same to use SQL Server on internet and on intranet. If your SQL server is open, please open "SQL query",connect to SQL server, then execute "EXEC sp_who",you will see thousands of rows return. That means that your SQL server is dealing with hundreds of connection. Then you execute "select count(*) from master. Sysdatabases ", you will see the result will be over hundreds. According to this parameter, it can not think that SQL server is better than ACCESS.

Development

ACCESS is not same level to the SQL server in development capability. ACCESS has no foreign key and Stored Procedures, and the SQL function is not too much as SQL server. And that the interface designs capability of ACCESS is no use in web database design. Further more, ACCESS not provide the SQL sentence write tools such like "SQL query".

Maintenance

SQL server can use "enterprise manager" or "query analyzer" to maintain the database on internet. But first the SQL server must open the TCP/IP and you can connect internet or your proxy server open port 1433 .And when ACCESS translate files to website ,if you have no assistant tools or you can not write ASP script ,you can not maintain it online. The only way is maintain offline by FTP the files to local.

From upwards, I t is advantage in cost when you use ACCESS, the capability is not too worse than others. But the capability of maintain after put into production and capability develop is not enough. And you can use "Web DB Explorer" to make up it. This software can upload the ACCESS files to website and do the function of query, insert, update and delete online in ACCESS ,this capability is not in other database assistant develop tools base on ODBC.

 

Is VB6 still useful

VB6 is Visual Basic 6.0, which is the ultimate version before the introduction of. Net framework. This software is an important part of Microsoft Visual Studio 6.0. It appeared in the 1999 "The Matrix" movie, which is the peak of VB6.

After the emergence of. Net framework, it has been gradually used by C# and Visual Basic.net Instead, even at GitHub it is recognized as VBA, VB programmers of course know that VB6 and VBA are different, for example, VB6 can be compiled into EXE files, VBA is run in Excel, but their syntax is similar, code is easy to transplant, similar to ASP and VBS.

So VB6 this has been declining programming language has no use?

If you want to use VB6 to develop web applications, that is to compile DLL to run in ASP, it is basically useless, because it is very difficult to deploy such an environment on IIS after windows 2008.

If you want to use VB6 to develop Windows desktop program with fashionable interface, it is useless, because the UI developed by VB6 is relatively old.

But if you don't require the UI of Windows desktop program, you will find that VB6 has unexpected vitality.

As long as windows has two files msvbvm60.dll and stdole2.tlb in the directory %windir%\system(32-bit) or %windir%\syswow64(64 bit), the EXE compiled by VB6 can run directly. Fortunately, even in the latest version of windows 2019 or windows 10, both 32-bit and 64 bit versions have pre installed these two files, which is obviously better than using the. Net framework The compiled exe files have stronger adaptability in different Windows versions, because the. Net framework pre installed in different Windows versions is different. Some even need to download the installation package to install.

It seems that the EXE file compiled with VB6 is still very beautiful, but to run well on different versions of windows, the following conditions need to be met:

Using the compile to P-code compilation method, the compiled EXE file is smaller and has better compatibility. In addition to WIN98/95/Me and WinNT, it has been tested on the server version of Windows 2000/2003/2008/2012/2016 /2019 and the desktop version of Windows XP/Vista/7/8/8.1/10, which can be run directly without additional preparation.

Do not refer to ActiveX DLLs directly, because the binary versions of these ActiveX DLLs in different versions of windows may not be fully compatible. If they are not compatible, they can not be used. The solution is to use them in the way of CreateObject, which will greatly improve the compatibility. However, use CreateObject In the GUI programming process, you can't think of listing the properties and methods, which is inconvenient to use. The solution is to create an "objectified" class, encapsulate the interface of ActiveX DLL, so that we can partially realize the programming experience of directly referring to ActiveX DLL.

Specific use cases can be found in the PigObjFs repository on my GitHub.

The following is a list of several ActiveX DLLs that come with windows. If you don't need to register with Regsvr32, you can use them in an object-oriented way.

64 bit windows as an example

Microsoft ActiveX Data Objects 6.1 Library
Microsoft Scripting Runtime
Microsoft XML, v6.0

With Windows API functions, most VB6 can be used, and only a few need VC to use them. The similar writing method is as follows:

Private Declare Function GetComputerName Lib "kernel32" Alias "GetComputerNameA" (ByVal lpBuffer As String, nSize As Long) As Long

Do not use the installation package to make software, because the produced installation package EXE file may not be able to run on different versions of windows, and there are 32-bit and 64 bit differences.

For the use of OCX files, the OCX files used by the program should not be copied to the public directory such as% windir% \ \ system or windir% \ \ syswow64, so as to avoid conflicts with other software. Only store the OCX file compiled by VB6 in the same directory.

After completing the above preparation, the EXE file and OCX file compiled by VB6 are stored in the same directory and compressed into a ZIP file, which can be released and used. On different Windows versions, you just need to UNZIP and run exe directly.

 

The best Database document is binding with Database structure

 

Database documents are highest frequency use document during the development of software. Usually these documents are saving in Word or Excel, and maintain by document manager. The developer must check these documents continually, and it is very inconvenience.

You can use Great Engine Web DB Explorer ("This software" is been named as below) can solve the problem of this side . This software can be used as document online server. When you install server script the remark database (webdb_mdb.asp) will be install at the same time. This file must in the same directory with webdb.asp . Though many Web DB Explorer instances can install in one IIS server, but our advice is install one , and make it easy to manage .

This software provides a Database structure view box like a tree. You can view columns, index, primary key, foreign key of the table, view and Stored Procedures and adding remarks to these objects, then the online database documents will be make.

Through view the table, view, Stored Procedures and view the structure of table (view), Stored Procedures, you can check the detail of database documents online. This software provides a very useful function, that you can see the remarks of correlation fields in status bar while you?¡¥re editing the table. It can reduce the times of check the documents.

 


Copyright © 2005-2022 Seow Phong & Great Engine Studio All Rights Reserved