Jump to content

simple ado sql manager


ldb68

Recommended Posts

The project is a simple sql manager using ADO compoment (eg. yuo can use any database via odbc connection).

 

It show a tree with database tables.

It build the sql statement for selecting rows.

You can save/edit/delete row.

You can build insert/update query.

Rudimental autofit colunn show.

 

 

In the same isapi / exe folder add a "dsn.ini" text file with string connection for the database, es.

 

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=casavalentina;Data Source=HOME-PC\SQLEXPRESS;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=HOME-PC;Use Encryption for Data=False;Tag with column collation when possible=False;

AjaxSQL.zip

post-13-0-00373700-1318499395_thumb.jpg

  • Upvote 2
Link to comment
Share on other sites

  • 2 weeks later...
  • 1 month later...

hello

 

your project is very useful and shows the power of unigui in any circonstances?

I connected your sql ado to an DB2 As400 Middle-ware and it works wonderfully.

Really a good job

 

thanks for all

 

Eric

Link to comment
Share on other sites

  • 2 months later...

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
×
×
  • Create New...