playing with Database(s) like Sql Server

[Phil]

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.

[Andre]

in short, but NO.

Andre

[SvenP]

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

[JSThePatriot]

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

[ReFran]

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

[Phil]

Thanks.

I will try to have a particular look at (OleDB32.dll), !!!

[scriptkitty]

I gave an example here:

http://www.autoitscript.com/forum/index.php?showtopic=11147

has to use the beta version of autoit atm.