Sign in to follow this  
Followers 0
Guest dorian

databases

5 posts in this topic

Hi there.

I'm a newbie so please forgive me if this has been answered somewhere. I've searched the forum and help and haven't come across this topic.

Is there anyway to attach to a database and read from the tables? Is that something that AutoIt is capable of? (I'm trying to avoid using csv files.) If the answer is yes, can you please direct me to where I may find examples of the correct syntax for the connection string?

Thanks

D

Share this post


Link to post
Share on other sites



AutoIt is not designed to interface with databases. AutoIt can read and write text files, but not binary files or ODBC connections. This is outside of the scope of AutoIt.


David Nuttall
Nuttall Computer Consulting

An Aquarius born during the Age of Aquarius

AutoIt allows me to re-invent the wheel so much faster.

I'm off to write a wizard, a wonderful wizard of odd...

Share this post


Link to post
Share on other sites

Ummm .. this may not be exactly what you're after, but keep an eye on the Scripts and Scraps forum: I'll be posting a note on how to use AU3 to wrap a SYBASE / SQL-Server commandline utility (called isql.exe) so that you can execute SQL queries from a text-editor like Textpad.

You might be able to hack it around for your purposes :D

Share this post


Link to post
Share on other sites

#4 ·  Posted (edited)

Great! Anything that will help me avoid returning to the cumbersome task of extracting data from a csv will be totally appreciated. Thank you.

:D

Edited by dorian

Share this post


Link to post
Share on other sites

#5 ·  Posted (edited)

There are several freeware/open source databases available. Take a look on Source Forge for some examples. Look for Database Client and ODBC Client.

Edit: fixed link.

Edited by Nutster

David Nuttall
Nuttall Computer Consulting

An Aquarius born during the Age of Aquarius

AutoIt allows me to re-invent the wheel so much faster.

I'm off to write a wizard, a wonderful wizard of odd...

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