sriKnight Posted May 3, 2012 Share Posted May 3, 2012 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. Link to comment Share on other sites More sharing options...
Zedna Posted May 3, 2012 Share Posted May 3, 2012 Good start is to search helpfile/forum for: SQL ADO DSN Resources UDF ResourcesEx UDF AutoIt Forum Search Link to comment Share on other sites More sharing options...
sriKnight Posted May 3, 2012 Author Share Posted May 3, 2012 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. Link to comment Share on other sites More sharing options...
Zedna Posted May 3, 2012 Share Posted May 3, 2012 (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.asphttp://www.w3schools.com/ado/default.aspEDIT: This forum is full of examples for ALL above mentioned Edited May 3, 2012 by Zedna Resources UDF ResourcesEx UDF AutoIt Forum Search Link to comment Share on other sites More sharing options...
Xenobiologist Posted May 4, 2012 Share Posted May 4, 2012 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 Link to comment Share on other sites More sharing options...
aymhenry Posted June 10, 2012 Share Posted June 10, 2012 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. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now