databases

[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

[Nutster 3]

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.

[trids 2]

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

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

Edited June 9, 2004 by dorian

[Nutster 3]

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 June 9, 2004 by Nutster