LOULOU Posted December 12, 2005 Share Posted December 12, 2005 Who can help me to open a dsnless database and after querying with com object I don't arrive Thanks Link to comment Share on other sites More sharing options...
BigDaddyO Posted December 12, 2005 Share Posted December 12, 2005 What type of database are you trying to open? SQL MYSQL Access ??? Link to comment Share on other sites More sharing options...
akmm88 Posted December 12, 2005 Share Posted December 12, 2005 I want konws access too. Link to comment Share on other sites More sharing options...
BigDaddyO Posted December 12, 2005 Share Posted December 12, 2005 huh? Link to comment Share on other sites More sharing options...
herewasplato Posted December 12, 2005 Share Posted December 12, 2005 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=19006chat: http://www.autoitscript.com/forum/index.php?showtopic=18930 [size="1"][font="Arial"].[u].[/u][/font][/size] Link to comment Share on other sites More sharing options...
sykes Posted December 12, 2005 Share Posted December 12, 2005 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*** We have enough youth. How about a fountain of SMART? Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now