stamandster Posted January 23, 2008 Share Posted January 23, 2008 (edited) I'm trying to get this working, but I can't get it. I keep getting "Variable must be of type: Object". I'm trying to adapt the scripts found here http://www.databasejournal.com/features/ms...cle.php/1548361Anyone??Dim $strComputer, $objWMIService Const $wbemFlagReturnImmediately = 0x10 Const $wbemFlagForwardOnly = 0x20 $strComputer = "." $strSQLServer = "." $strDBName = "DBName" $objWMIService = ObjGet("winmgmts:{impersonationLevel=impersonate}//" & $strComputer & "/root/MicrosoftSQLServer:MSSQL_DatabaseFile") FindDBItems() FUNC FindDBItems() Local $colInstances $colInstances = $objWMIService.Instances For $objInstance In $colInstances If $objInstance.DatabaseName = $strDBName Then $Item = $objInstance.PhysicalName MSGBOX(0,"DB","DB's: "& $ITEM) EndIf Next EndFunc Edited January 23, 2008 by kickarse Link to comment Share on other sites More sharing options...
ptrex Posted January 23, 2008 Share Posted January 23, 2008 @kickarse You can only run this script if you have that CLASS "SQLServer" installed on your machine. To test this is, you have go to START -> RUN -> WBEMTEST en Enter Check for SQLServer Namespece if it's there. Regards, ptrex Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New Link to comment Share on other sites More sharing options...
stamandster Posted January 23, 2008 Author Share Posted January 23, 2008 Thanks... it's actually running MSDE 2000. Would the class be wrong? I don't know how to use WBEMTEST Link to comment Share on other sites More sharing options...
ptrex Posted January 24, 2008 Share Posted January 24, 2008 @kickarse Open teh WBEMTEST appl. click connect -> root\default Then click Enum CLASSES en fill in the "SQLServer". If you get an ERROR you don't have the proper class installed and yo cannot run this script you posted. Regards ptrex Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New 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