Jump to content
Sign in to follow this  
Phil

playing with Database(s) like Sql Server

Recommended Posts

Hi all,

Is it possible with Autoit to do some read, update and delete on table coming from a sql server database or any other via ODBC ???

Thanks in advance.

Share this post


Link to post
Share on other sites

in short, but NO.

Andre


What about Windows without using AutoIt ?It would be the same as driving a car without an steering Wheel!

Share this post


Link to post
Share on other sites

in short, but NO.

Andre

<{POST_SNAPBACK}>

Andre,

That's not quite right. With the latest AutoIt3 beta version you can use ADO to access ODBC databases.

Here is some pseudo code borrowed from 'dwerznec' who posted it in the 'developers' forum (http://www.autoitscript.com/forum/index.php?showtopic=10627&st=0)

$DSN_Connect="Your DSN here"

Func getDistinct($DSN_Connect)

$adoCon = ObjCreate ("ADODB.Connection")
$adoCon.Open ($DSN_Connect)
$adoRs = ObjCreate ("ADODB.Recordset")
$adoSQL = "SELECT DISTINCT Ger├Ątetyp FROM [HW-Invent]"
$adoRs.CursorType = 2
$adoRs.LockType = 3
$adoRs.Open($adoSql, $adoCon)

With $adoRs

If .RecordCount Then

While Not .EOF
$cmboVal[2] = $cmboVal[2] & .Fields("Ger├Ątetyp").Value & "|"
.MoveNext
WEnd

EndIf

EndWith

$adoCon.Close

EndFunc

Regards,

-Sven

Share this post


Link to post
Share on other sites

It may not be the smoothest way but there are also other programs out there that can use SQL to manipulate a database, that can be automated using AutoIt.

This is what I have used in the past.

AnalogX SQLCMD

There are other SQLCMD.exe programs out there, that may be more updated. In my few minutes of looking the above back up I noticed that either there are some other ones that have copied the name, or that the articles are talking about that one.

JS


AutoIt Links

File-String Hash Plugin Updated! 04-02-2008 Plugins have been discontinued. I just found out.

ComputerGetInfo UDF's Updated! 11-23-2006

External Links

Vortex Revolutions Engineer / Inventor (Web, Desktop, and Mobile Applications, Hardware Gizmos, Consulting, and more)

Share this post


Link to post
Share on other sites

in short, but NO.

Andre

<{POST_SNAPBACK}>

That's not quite right ...

With the ADO Object (OleDB32.dll), which is installed on every WinPC - at least W98SE and higher -, you can query every DB with any scripting language.

Best regards, Reinhard

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  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...