DSNLESS AND DB DATABASE

[LOULOU]

Who can help me to open a dsnless database and after querying with com object I don't arrive

Thanks

[BigDaddyO]

What type of database are you trying to open?

SQL

MYSQL

Access

???

[akmm88]

I want konws access too.

[BigDaddyO]

huh?

[herewasplato]

huh?

akmm88 is asking about getting to an access database via AutoIt as in these two posts:

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

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

[sykes]

The following is an example of connecting and communicating with an access database:

$adoCon = ObjCreate("ADODB.Connection")
$adoCon.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=test.mdb;")
$adoRS = ObjCreate("ADODB.Recordset")
$adoRS.CursorType = 2
$adoRS.LockType = 3
$adoRS.Open("SELECT * FROM tblData", $adoCon)
$adoRS.AddNew
$adoRS.Fields("fldData").Value = 'your value here'
$adoRS.Fields("fldInfo").Value = 'your value here'
$adoRS.Update
$adoRS.Close
$adoCon.Close

It writes data to 'fldData' and fldInfo' in the table 'tblData'

You can find tons of examples of this type by just searching the forum

***Note this uses the latest beta***