rahuroy Posted February 21, 2011 Posted February 21, 2011 Hi Manadar, Small help needed to complete my scriptI am writing script for installation of application. Before starting installing i have to verify existence of database and if it exists then i have to drop it.Below is snippet of code where i am connecting to server and running query.But after querying , how to verify if database exists already? Please provide some suggestions.Thanks in advance.; $fAuthMode - Authorization mode (0 = Windows Logon, 1 = SQL) (default = 0)OnAutoItExitRegister("_Exit")Func _Exit() MsgBox(0,"@ExitCode",@exitCode) EndFuncGlobal $Ignore, $Ini, $Installer, $Pid,$GUID,$squery,$result,$fAuthMode,$xnn,$ynn,$query$Ini = @ScriptDir & "\Install.ini"Global $username = IniRead($INI, "EMSettings", "IS_NET_API_LOGON_USERNAME", "")Global $password = IniRead($INI, "EMSettings", "IS_NET_API_LOGON_PASSWORD", "")Global $sqlserver = IniRead($INI, "EMSettings", "IS_SQLSERVER_SERVER", "")Global $sqlusername = IniRead($INI, "EMSettings", "sqlloginname", "")Global $sqlpwd = IniRead($INI, "EMSettings", "sqlpassword", "")Global $emdbname = IniRead($INI, "EMSettings", "IS_SQLSERVER_DB", "")Global $fAuthMode = IniRead($INI, "EMSettings", "AuthMode", "") ; $fAuthMode - Authorization mode (0 = Windows Logon, 1 = SQL) (default = 0)Global $sQuery="select * from master.dbo.sysdatabases where name =' & $emdbname & '"If $fAuthMode=0 Then $xnn="Provider=SQLOLEDB;Data Source= " & $sqlserver & ";Trusted_Connection=Yes;" $sqlCon = ObjCreate("ADODB.Connection") $sqlCon.Open($xnn) if @error Then MsgBox(0, "ERROR", "Failed to connect to the database") Exit Else MsgBox(0, "Success!", "Connection to database successful!") EndIf $query=_SQLQuery($sqlCon,$sQuery) If $query=1 Then $sqlCon.Execute("DROP DATABASE " & $emdbname) else $ynn="Provider=sqloledb;Data Source=" & $sqlserver & ";Network Library=DBMSSOCN;User ID=" & $sqlusername &";Pwd=" & $sqlpwd & ";" $sqlCon = ObjCreate("ADODB.Connection") $sqlCon.Open($ynn) if @error Then MsgBox(0, "ERROR", "Failed to connect to the database") Exit Else MsgBox(0, "Success!", "Connection to database successful!") EndIf $query=_SQLQuery($sqlCon,$sQuery) MsgBox(0,"",$query) If $query=1 Then $sqlCon.Execute("DROP DATABASE " & $emdbname)EndIfFunc _SQLQuery($sqlCon, $sQuery) If IsObj($sqlCon) Then Return $sqlCon.Execute($sQuery) ReturnEndFunc
hannes08 Posted February 21, 2011 Posted February 21, 2011 Hello rahuroy, after the "DROP DATABASE" you could just end the connection and try reconnecing to it. If it fails then your DB is no longer existant. Regards, Hannes Regards,Hannes[spoiler]If you can't convince them, confuse them![/spoiler]
hannes08 Posted February 21, 2011 Posted February 21, 2011 Just two other hints: Use headlines that are more specific then "Help Needed" Don't address topics directly to Forum members, use PM for this. People tend to ignore when they don't feel addressed. Regards, Hannes Regards,Hannes[spoiler]If you can't convince them, confuse them![/spoiler]
guinness Posted February 21, 2011 Posted February 21, 2011 (edited) Don't address topics directly to Forum members, use PM for this.I personally wouldn't recommend PM'ing them either. As mentioned in the past, having code in the Public domain gives new users the ability to learn. Edited February 21, 2011 by guinness UDF List: _AdapterConnections() • _AlwaysRun() • _AppMon() • _AppMonEx() • _ArrayFilter/_ArrayReduce • _BinaryBin() • _CheckMsgBox() • _CmdLineRaw() • _ContextMenu() • _ConvertLHWebColor()/_ConvertSHWebColor() • _DesktopDimensions() • _DisplayPassword() • _DotNet_Load()/_DotNet_Unload() • _Fibonacci() • _FileCompare() • _FileCompareContents() • _FileNameByHandle() • _FilePrefix/SRE() • _FindInFile() • _GetBackgroundColor()/_SetBackgroundColor() • _GetConrolID() • _GetCtrlClass() • _GetDirectoryFormat() • _GetDriveMediaType() • _GetFilename()/_GetFilenameExt() • _GetHardwareID() • _GetIP() • _GetIP_Country() • _GetOSLanguage() • _GetSavedSource() • _GetStringSize() • _GetSystemPaths() • _GetURLImage() • _GIFImage() • _GoogleWeather() • _GUICtrlCreateGroup() • _GUICtrlListBox_CreateArray() • _GUICtrlListView_CreateArray() • _GUICtrlListView_SaveCSV() • _GUICtrlListView_SaveHTML() • _GUICtrlListView_SaveTxt() • _GUICtrlListView_SaveXML() • _GUICtrlMenu_Recent() • _GUICtrlMenu_SetItemImage() • _GUICtrlTreeView_CreateArray() • _GUIDisable() • _GUIImageList_SetIconFromHandle() • _GUIRegisterMsg() • _GUISetIcon() • _Icon_Clear()/_Icon_Set() • _IdleTime() • _InetGet() • _InetGetGUI() • _InetGetProgress() • _IPDetails() • _IsFileOlder() • _IsGUID() • _IsHex() • _IsPalindrome() • _IsRegKey() • _IsStringRegExp() • _IsSystemDrive() • _IsUPX() • _IsValidType() • _IsWebColor() • _Language() • _Log() • _MicrosoftInternetConnectivity() • _MSDNDataType() • _PathFull/GetRelative/Split() • _PathSplitEx() • _PrintFromArray() • _ProgressSetMarquee() • _ReDim() • _RockPaperScissors()/_RockPaperScissorsLizardSpock() • _ScrollingCredits • _SelfDelete() • _SelfRename() • _SelfUpdate() • _SendTo() • _ShellAll() • _ShellFile() • _ShellFolder() • _SingletonHWID() • _SingletonPID() • _Startup() • _StringCompact() • _StringIsValid() • _StringRegExpMetaCharacters() • _StringReplaceWholeWord() • _StringStripChars() • _Temperature() • _TrialPeriod() • _UKToUSDate()/_USToUKDate() • _WinAPI_Create_CTL_CODE() • _WinAPI_CreateGUID() • _WMIDateStringToDate()/_DateToWMIDateString() • Au3 script parsing • AutoIt Search • AutoIt3 Portable • AutoIt3WrapperToPragma • AutoItWinGetTitle()/AutoItWinSetTitle() • Coding • DirToHTML5 • FileInstallr • FileReadLastChars() • GeoIP database • GUI - Only Close Button • GUI Examples • GUICtrlDeleteImage() • GUICtrlGetBkColor() • GUICtrlGetStyle() • GUIEvents • GUIGetBkColor() • Int_Parse() & Int_TryParse() • IsISBN() • LockFile() • Mapping CtrlIDs • OOP in AutoIt • ParseHeadersToSciTE() • PasswordValid • PasteBin • Posts Per Day • PreExpand • Protect Globals • Queue() • Resource Update • ResourcesEx • SciTE Jump • Settings INI • SHELLHOOK • Shunting-Yard • Signature Creator • Stack() • Stopwatch() • StringAddLF()/StringStripLF() • StringEOLToCRLF() • VSCROLL • WM_COPYDATA • More Examples... Updated: 22/04/2018
hannes08 Posted February 21, 2011 Posted February 21, 2011 Well, what to say except... right, 100 of 100 Points. Regards,Hannes[spoiler]If you can't convince them, confuse them![/spoiler]
trancexx Posted February 21, 2011 Posted February 21, 2011 Maybe it was more like "Good morning Vietnam".Manadar. ♡♡♡ . eMyvnE
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