sunny Posted April 24, 2009 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
Mat Posted April 24, 2009 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
ericksoncl23 Posted April 24, 2009 Posted April 24, 2009 mdiesel That doesnt work for connecting to a database. It just makes a temp database in memory. meh
sunny Posted April 24, 2009 Author 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
WideBoyDixon Posted April 24, 2009 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]
Mat Posted April 24, 2009 Posted April 24, 2009 sorry then... But you can do it in autoit right? as said, never used sql. AutoIt Project Listing
ChrisL Posted April 24, 2009 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
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