Sign in to follow this  
Followers 0
incubi

Progress Intersolv DSN

4 posts in this topic

Well I wanted my first post to be a positive one so I hope this helps someone.

I'm new to AutoIT but wanted to test it. Our company runs an OLD copy of Progress database (8.3b) and the ODBC driver is Intersolv 3.11 with a days worth of reading this forum I was able to connect and query the database.

It was very easy in the end. :D

$DB = ObjCreate("ADODB.Connection")

$DB.Open("DSN=dsn_name" & ";UID=user" & ";PWD=pass")

$sql = "Select cell From cell Where true"

$Results = $DB.Execute($sql)

This is from another post.

$sql = "Select cell From cell Where true"

$QueryResults = $myDB.Execute($sql)

With $QueryResults

If .RecordCount Then

While Not .EOF

$Cell= .Fields("cell").Value

$Description = .Fields("description").Value

$Output = $Output & $Cell & @TAB & $Description &@CRLF

.MoveNext

WEnd

EndIf

EndWith

MsgBox(0,"",$Output)

$DB.Close

Share this post


Link to post
Share on other sites



Welcome to AutoIt.

:D

Thank you!

Would you have any ideas where I could be some examples or ideas how to code a data grid window?

Now that I'm connected to our database I should probably do something with it :D

Share this post


Link to post
Share on other sites

Thank you!

Would you have any ideas where I could be some examples or ideas how to code a data grid window?

Now that I'm connected to our database I should probably do something with it :D

Depends on what you mean by "data grid window".

You can layout controls in a GUI with a rectangular pattern with the standard GUI functions.

Grid controls as drawn by some forms based application suites are not accessible to AutoIt because they are owner-drawn by the controlling app, not by the standard Windows APIs.

AutoIt also already has a pretty effective UDF for working with Excel spread sheets.

Can you define your term a little more?

:D


Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law

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