Sign in to follow this  
Followers 0
pablo

About Database Connectivity

3 posts in this topic

Hi there,

I am new to AutoIt v3.

In the past I have used VB6, ADO and Access.

Currently I have been making applications using VBscript and HTA.

Also looked into creating apps with PHP.

But I really like AutoIt v3!

After downloading AutoIt v3, I quickly learned how to create

GUI's and associate events and used controls such as FileOpen and FolderOpen(i think that is the syntax).

I think AutoIt can be an amazing full fledged language!

There are 4 thing I would like to know:

(1) Where can you find the syntax required to do ADO(I searched the forum and saw some posts on database connectivity) but I could not find any tutorials on the tutorial site.(I wish to connect to Firebird database)

Please direct me where to find information on this.

(2) Once connected to a database is there a GRID like GUI component to display the retrieved data?

(3) How to display html links on a form, and when clicked behave like it would on HTML page.

(4) Is there a grid like component that actually looks and behaves like an excel sheet to be embedded into a windows form?

I would really appreciate if you could direct me to tutorials on this if they exist.

Sincerely,

Pablo

Share this post


Link to post
Share on other sites



(1) Where can you find the syntax required to do ADO(I searched the forum and saw some posts on database connectivity) but I could not find any tutorials on the tutorial site.(I wish to connect to Firebird database)

Hi Pablo,

i found this a while ago but i cant remember where but here it is :

there is a couple of my bla bla in side duno where is the original script,

; ADODB_GUI, v1.0
; Author: Chris Haney
;
; GUI wrapper example for "Database.au3" UDF.
; This will only run in the beta version of autoit, at the present time.

#include <GUIConstants.au3>
#include <Database.au3>

opt("TrayIconDebug", 0)   ;0=no info, 1=debug line info
opt("ExpandEnvStrings", 1)   ;0=don't expand, 1=do expand
opt("ExpandVarStrings", 1)   ;0=don't expand, 1=do expand

; Declare Global variables
Dim $username = "", $password = "", $aRecords, $list, $i, $i1, $i2, $button1
Dim $databaseread = IniRead("c:\delfin\system\control.sys", "Database", "Path", "")
Dim $query = "select username, passwd from cci_credit_check"; for all but text connections
Dim $DSN = "DRIVER=Firebird/InterBase(r) driver; UID=SYSDBA; PWD=password; DBNAME="& $databaseread &";"; SQL connector
;~ MsgBox(0, "" ,$databaseread)
$aRecords = _ReadData($DSN, $query)

; Create a listview of all the records


    For $i = 0 to UBound($aRecords,2)-1
        $i2 = 0 + 1
        $username = ""
        $username = $aRecords[$i][$i1]
        $password = $aRecords[$i][$i2]
        
    Next; $i
GUICreate("Users", 500, 500)
GUISetState (@SW_SHOW)

While 1
    $msg = GUIGetMsg()
    
    
    
    If $msg = $GUI_EVENT_CLOSE Then ExitLoop

    


WEnd
MsgBox(0, "Values","Your Username is : " & $username & @CRLF & "Your Password is : " & $password )

You'll need the Firebird ODBC driver

Cheers.

Share this post


Link to post
Share on other sites

Hi,

If you look at the lonks in my signature,there are zip files for

1. Access connection; try the GuiListView display there.

2. SQL; shows GuiListView and embedded Excel at once from SQLite.

@ptrex used an SQL database with Excel display too, but not sure if it still works (might be ibn the SQL command examples in the help file now; I haven't looked)

Best, randall

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0