blumi Posted July 27, 2011 Share Posted July 27, 2011 I want to use Autoit to connect to a SQL Server and do some queries. I have found some UDFs but I want to do it without them. Are there some good links or tutorials for SQL and AutoIt without the UDFs? Thanks Link to comment Share on other sites More sharing options...
Bert Posted July 27, 2011 Share Posted July 27, 2011 Why do you wish to do them without the UDFs? The UDF makes it easier to do for they did most of the work you are proposing to do. The Vollatran project My blog: http://www.vollysinterestingshit.com/ Link to comment Share on other sites More sharing options...
Bert Posted July 27, 2011 Share Posted July 27, 2011 If anything you can look at the UDF's code and chop out what you need if your reason is to just making the code shorter. The Vollatran project My blog: http://www.vollysinterestingshit.com/ Link to comment Share on other sites More sharing options...
bogQ Posted July 27, 2011 Share Posted July 27, 2011 well you have the UDF, edit it with scite and see how its made ... or hit forum search with SQL ... While i don't see the point of your question or you dont understand the point of not using UDF-s i hope you'll understand my answer TCP server and client - Learning about TCP servers and clients connectionAu3 oIrrlicht - Irrlicht projectAu3impact - Another 3D DLL game engine for autoit. (3impact 3Drad related) There are those that believe that the perfect heist lies in the preparation.Some say that it’s all in the timing, seizing the right opportunity. Others even say it’s the ability to leave no trace behind, be a ghost. Link to comment Share on other sites More sharing options...
blumi Posted July 27, 2011 Author Share Posted July 27, 2011 Why do you wish to do them without the UDFs? The UDF makes it easier to do for they did most of the work you are proposing to do.Sure it will be easier with the UDF, but I want to learn the syntax for SQL connect and usage. I took a look in the udf with scite but did not understand everything. :-( Link to comment Share on other sites More sharing options...
Zedna Posted July 27, 2011 Share Posted July 27, 2011 (edited) Search this forum for ADODBHere is my simple example:EDIT:ADO very good tutorialhttp://www.w3schools.com/ado/default.asp Edited July 27, 2011 by Zedna Resources UDF ResourcesEx UDF AutoIt Forum Search Link to comment Share on other sites More sharing options...
blumi Posted July 27, 2011 Author Share Posted July 27, 2011 Okay will take a look for the search etc. What about the driver I found in one UDF $driver = "{MySQL ODBC 3.51 Driver}" $port = 3306 Local $v = StringMid($driver, 2, StringLen($driver) - 2) Local $key = "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers", $val = RegRead($key, $v) Do I need this? Link to comment Share on other sites More sharing options...
Zedna Posted July 27, 2011 Share Posted July 27, 2011 (edited) What about the driver I found in one UDF Do I need this?No. You need only DSN string for connection, for MS SQL Server it' like this (as you can see in my example from my above post):"Driver={SQL Server};Server=server;Database=master;Uid=user;Pwd=password;" Edited July 27, 2011 by Zedna Resources UDF ResourcesEx UDF AutoIt Forum Search Link to comment Share on other sites More sharing options...
blumi Posted July 28, 2011 Author Share Posted July 28, 2011 This Driver={SQL Server}; I don't have to change? Link to comment Share on other sites More sharing options...
Zedna Posted July 28, 2011 Share Posted July 28, 2011 (edited) "Driver={SQL Server};Server=%server%;Database=%master%;Uid=%user%;Pwd=%password%;" Change only values inside %% EDIT: Search this forum for examples for this ... Edited July 28, 2011 by Zedna Resources UDF ResourcesEx UDF AutoIt Forum Search 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