SQL Database Questions

[sriKnight]

I found a couple of scripts on the forum that allow for a connection to an sql database. I'm stepping into uncharted waters here as I am not a programer at all, but I will do my best to figure this out.

What I am trying to accomplish is this

1) Retrieve information from a sql database

2) Take that information and put in a format where each piece of information is separate and can be insert into controls as needed. (I normally puy my information into excel and build an array prior to my script running.)

3) Take the data and navigate through a particular software placing certain data in certain boxes(the easy part for me)

4) write to the database that the records that have been extracted have had action taken against them

I will be happy to make a donation to AutoIT in exchange for all of the help I am going to need on this project.

[Zedna]

Good start is to search helpfile/forum for:

SQL

ADO

DSN

[sriKnight]

I wish I had the programing knowledge to even to pretend to under the information I just saw when searching for those things. That's where the donation comes into play.

Lets first start with the connection to the database what information would I need to know to create the connection and then what would I have to write in the code for autoit?

[Zedna]

You need to say what type of SQL database you have (Microsoft SQL Server, MS Access, MySql, Sybase ASE, SQLite, ...)

For each type of DB is different DSN string for connection to the database.

Nice tutorials are here:

http://www.w3schools.com/sql/default.asp

http://www.w3schools.com/ado/default.asp

EDIT: This forum is full of examples for ALL above mentioned

Edited May 3, 2012 by Zedna

[Xenobiologist]

Yes Zedna is correct.

Step by step, first of all try to get the database type, and then you'll need the connection parameters and after that a test SQL (select * from table) and show the result via Autoit.

[aymhenry]

if you will have ms-Access in your project use:-

you may also use the same code for other DBs after fixing the string connection.