sunny Posted April 24, 2009 Share Posted April 24, 2009 Hi Friends, I started the database connection and database operations for MS SQL Server Can you help me on how to connect to SQL Server with auto it and how to retrive the data from the table with the queries? It would be great if i can get an example on how to write queries with autoit Link to comment Share on other sites More sharing options...
Mat Posted April 24, 2009 Share Posted April 24, 2009 ?? have you actually tried the helpfile? it didn't take you long... _SQLite_Query _SQLite_FetchData good luck with your researching! MDiesel AutoIt Project Listing Link to comment Share on other sites More sharing options...
ericksoncl23 Posted April 24, 2009 Share Posted April 24, 2009 mdiesel That doesnt work for connecting to a database. It just makes a temp database in memory. meh Link to comment Share on other sites More sharing options...
sunny Posted April 24, 2009 Author Share Posted April 24, 2009 mdiesel That doesnt work for connecting to a database. It just makes a temp database in memory.Yes,Its jst creates a database in memory rather connecting to the existing database.PLS HELP friends Link to comment Share on other sites More sharing options...
WideBoyDixon Posted April 24, 2009 Share Posted April 24, 2009 I guess you'll need to find a COM object that lets you connect to SQL Server. Have you tried ActiveX Data Objects (ADO)? WBD [center]Wide by name, Wide by nature and Wide by girth[u]Scripts[/u]{Hot Folders} {Screen Calipers} {Screen Crosshairs} {Cross-Process Subclassing} {GDI+ Clock} {ASCII Art Signatures}{Another GDI+ Clock} {Desktop Goldfish} {Game of Life} {3D Pie Chart} {Stock Tracker}[u]UDFs[/u]{_FileReplaceText} {_ArrayCompare} {_ToBase}~ My Scripts On Google Code ~[/center] Link to comment Share on other sites More sharing options...
Mat Posted April 24, 2009 Share Posted April 24, 2009 sorry then... But you can do it in autoit right? as said, never used sql. AutoIt Project Listing Link to comment Share on other sites More sharing options...
ChrisL Posted April 24, 2009 Share Posted April 24, 2009 sorry then... But you can do it in autoit right?as said, never used sql.There is an _SQL.au3 file with an example that I made here http://www.autoitscript.com/forum/index.php?showtopic=51952You would need to know SQL syntax though [u]Scripts[/u]Minimize gui to systray _ Fail safe source recoveryMsgbox UDF _ _procwatch() Stop your app from being closedLicensed/Trial software system _ Buffering Hotkeys_SQL.au3 ADODB.Connection _ Search 2d Arrays_SplashTextWithGraphicOn() _ Adjust Screen GammaTransparent Controls _ Eventlogs without the crap_GuiCtrlCreateFlash() _ Simple Interscript communication[u]Websites[/u]Curious Campers VW Hightops Lambert Plant Hire 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