jimg Posted August 9, 2007 Share Posted August 9, 2007 I'm trying to access my SQL database (NOT a Mysql database) to extract some information, and need some guidance. I tried following the thread about Mysql hoping that it would suffice, but I get a failure within Mysql.au3 (line 27) $Objconn.open(xx) $Objconn.open(xx)^ERROR Error: The requested action for this object has failed. I checked ODBCAD32.exe, and it shows the MySQL OBDC 3.51 Driver is there (as is an SQL Server driver). Should I expect my SQL 2000 server to respond properly to a Mysql access or can I change something to use the real SQL driver? I'm a hardware guy, not a programmer, so be gentle #include <mysql.au3> #include <SQLite.dll.au3> $sql = _MySQLConnect("sa","password","database","sqlserver") [values changed to protect the innocent] $var = _Query($sql,"SELECT * FROM ENTY_Person WHERE Person_LastName LIKE 'GUR%'") With $var While NOT .EOF FileWriteLine("test.txt",.Fields("Lastname").value & @CRLF) .MoveNext WEnd EndWith _MySQLEnd($sql) Link to comment Share on other sites More sharing options...
tAKTelapis Posted August 9, 2007 Share Posted August 9, 2007 No doubt, the failure is to do with you not actually connecting to a MySQL database. What flava of SQL db is it? Link to comment Share on other sites More sharing options...
jimg Posted August 9, 2007 Author Share Posted August 9, 2007 It's an SQL 2000 (SQL Version 8) database. I tried just modifying the driver name within mysql.au3 (to {SQL Driver} which shows in my list of drivers) but I got the same error.No doubt, the failure is to do with you not actually connecting to a MySQL database.What flava of SQL db is it? Link to comment Share on other sites More sharing options...
jimg Posted August 10, 2007 Author Share Posted August 10, 2007 I can open my SQL database just fine with Excel, so I know the server, database name, table name, and column names are okay.The MySQL.au3 function to open gets to the OBJCONN instruction on line 27, so I think that means the driver is there.I'm basically flailing over my head, so any hint would be much appreciated. Maybe someone can recommend a good book...It's an SQL 2000 (SQL Version 8) database. I tried just modifying the driver name within mysql.au3 (to {SQL Driver} which shows in my list of drivers) but I got the same error. Link to comment Share on other sites More sharing options...
ChrisL Posted August 28, 2007 Share Posted August 28, 2007 Any use? http://www.autoitscript.com/forum/index.php?showtopic=51952 [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