Sign in to follow this  
Followers 0
Queener

sql - error

Started by Queener,

7 posts in this topic

#1 ·  Posted 

#include <mysql.au3>
#include <Array.au3>

; Connect to the database
$SQLOBJ = _MYSQLConnect("root", "7777", "127.0.0.1", "Employees")

Switch @ERROR
    Case 0
        MsgBox(0,"","Connection successful")
    Case 1
        MsgBox(0,"","Error","Error opening connection")
    Case 2
        MsgBox(0,"","MySQL ODBC Driver not installed.")
EndSwitch


$aTables = _GetTblNames($SQLOBJ)
If NOT @ERROR Then
_ArrayDisplay($aTables, "Tables")
Else
    MsgBox(0,"Error","Something Went Wrong!")
EndIf

 

Can someone tell me what I did wrong here?

The message just display a text "ERROR". The SQL Database that I'm using is MySQL port 3306.

Msgbox(0, "Hate", "Just hate it when I post a question and find my own answer after a couple tries. But if I don't post the question, I can't seem to resolve it at all.")

Share this post

Link to post
Share on other sites



#2 ·  Posted

Where does it give you the error?

If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Share this post

Link to post
Share on other sites

#3 ·  Posted

below the console, it doesn't give any error. Just pop-up a msgbox "ERROR".

Msgbox(0, "Hate", "Just hate it when I post a question and find my own answer after a couple tries. But if I don't post the question, I can't seem to resolve it at all.")

Share this post

Link to post
Share on other sites

#4 ·  Posted

Which msgbox is displaying when  you get the error? You have 2 of them.

MsgBox(0,"","Error","Error opening connection")
MsgBox(0,"Error","Something Went Wrong!")

So it would help to know exactly which of these 2 are being displayed.

If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Share this post

Link to post
Share on other sites

#5 ·  Posted

Doesn't seem to be one of those msgbox at all... see attachment for more info.

post-76739-0-33004000-1399321845_thumb.j

Msgbox(0, "Hate", "Just hate it when I post a question and find my own answer after a couple tries. But if I don't post the question, I can't seem to resolve it at all.")

Share this post

Link to post
Share on other sites

#6 ·  Posted

I'm not sure where that error message box is coming from unless it's in the mysql.au3 file you're using.

If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Share this post

Link to post
Share on other sites

#7 ·  Posted (edited)

You're right. The messagebox is possibly coming from mysql.au3. After digging more info the au3, I saw that I formatted wrong. This is the official way to connect to the database:

;variables
$iport=3306
$sUsername = "root"
$sPassword = "7777"
$sServer = "127.0.0.1"
$sDatabase = "Employees"
$sDriver = "{MySQL ODBC 5.2 ANSI Driver}"
$sTable = "Employers"
 
; Connect to the database
$SQLOBJ = _MYSQLConnect($sUsername, $sPassword, $sDatabase, $sServer, $sDriver, $iport)
 

Switch @ERROR
    Case 0
        MsgBox(0,"","Connection successful")
    Case 1
        MsgBox(0,"","Error","Error opening connection")
    Case 2
        MsgBox(0,"","MySQL ODBC Driver not installed.")
EndSwitch
Edited by asianqueen 

Msgbox(0, "Hate", "Just hate it when I post a question and find my own answer after a couple tries. But if I don't post the question, I can't seem to resolve it at all.")

Share this post

Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0
Go To Topic Listing AutoIt General Help and Support