does autoit support querry from SQL Server Management Studio

[iahngy]

I m so new with sql querry and using autoit to the sql db...I wonder if autoit support syntax to get data from SQL server management studio ?

[jchd]

You can query almost all database engines by using ODBC (ADO) support.

[iahngy]

I saw in autoit help , it has functions for SQLite instead...from SQLite.au3 such as _SQLite_Changes .........can I use them for SQL server studio.

Can you give me an example? I m browsing your signature's tutor sites.

[iahngy]

so I hve this info to connect to a server  , for example, me.home.com , user id , and pwd..

how do I con to that db using the info given using autoit?

I ll try to contact a person who know how to querry that db ...I m bugging again morrow.

 

 

 

 

Edited February 20, 2014 by iahngy

[spudw2k]

I'm not aware of a UDF for ADO that is included with the AutoIt package, but there are some examples folks have posted on the forum.  I have an example in my signature that uses ADO to perform SQL queries with an Access (JET) DB which could be adapted to interface with a SQL Server.

Maybe this will help get you started, but search the forum for more examples.

In order to connect to a SQL Server you would change what you feed the _OpenConnection() func appropriately.

$adCurrentProvider = $adProviderSQLOLEDB
$adCurrentDataSource = "Server-Name"
$varTrusted = 1
$varCatalog = "DB_NAME"
$varUsername = "Username"
$varPassword = "Password"

_OpenConnection($adCurrentProvider,$adCurrentDataSource,$varTrusted,$varCatalog,$varUsername,$varPassword)

Hope that helps.

 

edit:
Haven't ran this code in a while and it didn't go so well for me (as far as the JET DB example).

Was running with x64 and.  Works fine with x86.

I don't have a SQL server to test with, but in theory it should (and did) work with SQL Servers in the past.  Best look for other examples.

Edited February 20, 2014 by spudw2k

[iahngy]

I finally can connect to the db ..how can I get the data from the items I selected ? ..sorri I am afraid to display real db name from work..might got trouble If I put real stuff on heheh.

$links='driver={SQL Server};Server=me.home.com; database=lab;pwd=lab123; uid=public';
$vcon = ObjCreate ("ADODB.Connection") ; <== Create SQL connection
 

$vcon.open($links)
$sQuery = 'select material_name, lot_name, temperature, updated_datetime from lab.view' & _
 'where material_name = "ha403048m00372" order by updated_datetime desc'
 $result = $vcon.Execute($sQuery)

Edited February 24, 2014 by iahngy

[iahngy]

I finally got it display after search forum and found _sql.au3 from Chris L...I found out sql script doesn't take double quote ". haha

 $aResult = $result.GetRows()
 _ArrayDisplay($aResult)

     

Edited February 24, 2014 by iahngy

[spudw2k]

Good deal.  Glad to hear you worked it out.