Sign in to follow this  
Followers 0
sriKnight

SQL Database Questions

6 posts in this topic

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.


No, I'm not a programer.Yes, I am a noob.You know what the difference is between you and me?I make this look good.

Share this post


Link to post
Share on other sites



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?


No, I'm not a programer.Yes, I am a noob.You know what the difference is between you and me?I make this look good.

Share this post


Link to post
Share on other sites

#4 ·  Posted (edited)

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 by Zedna

Share this post


Link to post
Share on other sites

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.


Scripts & functions Organize Includes Let Scite organize the include files

Yahtzee The game "Yahtzee" (Kniffel, DiceLion)

LoginWrapper Secure scripts by adding a query (authentication)

_RunOnlyOnThis UDF Make sure that a script can only be executed on ... (Windows / HD / ...)

Internet-Café Server/Client Application Open CD, Start Browser, Lock remote client, etc.

MultipleFuncsWithOneHotkey Start different funcs by hitting one hotkey different times

Share this post


Link to post
Share on other sites

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.

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