Jump to content

databases


Guest dorian
 Share

Recommended Posts

Guest dorian

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

Link to comment
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...

Link to comment
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

Link to comment
Share on other sites

Guest dorian

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
Link to comment
Share on other sites

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...

Link to comment
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
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...