Sign in to follow this  
Followers 0
GreatWest

Connecting to SQL

5 posts in this topic

I have an AutoIt script that is used to write data to a .csv file. I've been thinking about re-writing the script to write the data to an MSSQL database. I've read a lot about using AutoIt with SQL in this forum but I'm a bit confused on how to connect to the SQL database. I've connected to SQL databases before using VB scripts in .asp pages. On the web server we had to setup the ODBC connection. What I'd like to do is have my script setup so it can run on any PC and push the data to the SQL server. Is that possible? Also a lot of the SQL code is still more than I understand. Is there any tutorial that demonstrates how to setup a simple database and connect to it? Any help would be greatly appreciated.

GW

Share this post


Link to post
Share on other sites



#3 ·  Posted (edited)

erm, i think he said MSSQL (MicroSoftSQL), look at the link in Randallc's sig

----------------

but if u did say MySQL just misspelled

there's a link in my siggy

Edited by cdkid

AutoIt Console written in C#. Write au3 code right at the console :D_FileWriteToLineWrite to a specific line in a file.My UDF Libraries: MySQL UDF Library version 1.6 MySQL Database UDF's for AutoItI have stopped updating the MySQL thread above, all future updates will be on my SVN. The svn location is:kan2.sytes.net/publicsvn/mysqlnote: This will still be available, but due to my new job, and school hours, am no longer developing this udf.My business: www.hirethebrain.com Hire The Brain HireTheBrain.com Computer Consulting, Design, Assembly and RepairOh no! I've commited Scriptocide!

Share this post


Link to post
Share on other sites

Oops, im retarted :o lol!

Share this post


Link to post
Share on other sites

Oops, im retarted :o lol!

HA! Aren't we all!

Yes MS (I know bad words) SQL. Thanks for the pointers, I'll check them out. As for being a retard, I'm feeling like one. I pulled out the .asp pages I wrote over two years ago and can't make heads or tales of how I connected to the database. Just like they say, if you don't use it, you lose it! Hopefully I'll be able to wake up some dormant brain cells.

Thanks again,

GW

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