Ray67 Posted June 21, 2017 Share Posted June 21, 2017 Hello, I'm very new to autoit. Still trying to learn it. I'm get undeclared global variable in the following script ;Declare error handler Local $oErrorHandler = ObjEvent("AutoIt.Error", "_ErrFunc") ;Declaration variables for SQL Connection Local $ServerAddress = "" Local $ServerUserName = "" Local $ServerPassword = "" Local $DatabaseName = "" $constrim="DRIVER={SQL Server};SERVER="&$ServerAddress&";DATABASE="&$DatabaseName&";uid="&$ServerUserName&";pwd="&$ServerPassword&";" $adCN = ObjCreate ("ADODB.Connection") ;<==Create SQL connection ;MsgBox(0,"",$constrim ) if @error Then MsgBox(0, "ERROR", "Failed to connect to the database") Exit Else MsgBox(0, "Success!", "Connection to database successful!") EndIf $sQuery= "Select * from EftProv, Amt WHERE LName = 'A'" $result= $dbCon.Execute($sQuery) (undeclared global variable error) MsgBox(0,"MD Found:",$result.Fields( "ID" ).Value ) $adCN.Close ;==>Close the database Thank you Link to comment Share on other sites More sharing options...
benners Posted June 21, 2017 Share Posted June 21, 2017 It's most likely related to $dbCon, I don't see it initialized anywhere in the snippet you posted Link to comment Share on other sites More sharing options...
BrewManNH Posted June 21, 2017 Share Posted June 21, 2017 $dbCon isn't declared anywhere in your script. 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 GudeHow 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 Link to comment Share on other sites More sharing options...
Ray67 Posted June 22, 2017 Author Share Posted June 22, 2017 18 hours ago, BrewManNH said: $dbCon isn't declared anywhere in your script. Thanks for your help. I think I fixed variable issues. Now I have another issues. It's connecting to the sql sever but it's not returning any value. ;Declare error handler Local $oErrorHandler = ObjEvent("AutoIt.Error", "_ErrFunc") ;Declaration variables for SQL Connection Local $ServerAddress = "" Local $ServerUserName = "" Local $ServerPassword = "" Local $DatabaseName = "" $constrim="DRIVER={SQL Server};SERVER="&$ServerAddress&";DATABASE="&$DatabaseName&";uid="&$ServerUserName&";pwd="&$ServerPassword&";" $adCN = ObjCreate ("ADODB.Connection") ;<==Create SQL connection ;MsgBox(0,"",$constrim ) if @error Then MsgBox(0, "ERROR", "Failed to connect to the database") Exit Else MsgBox(0, "Success!", "Connection to database successful!") EndIf $sQuery= "Select * from EftPr, Amt WHERE LName = 'AD'" $result= $adCN.Execute($sQuery) MsgBox(0,"MD Found:",$result.Fields( "LName" ).Value ) $adCN.Close ;==>Close the database 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