JWoodruff Posted September 17, 2007 Share Posted September 17, 2007 Hello everyone, I am attempting to connect to an oracle database and am unable to do so. I have created an odbc datasource to my database and am attempting the following code: $ado = ObjCreate("ADODB.Connection") With $ado .ConnectionString =("Provider='OraOLEDB.Oracle';Data Source='[DB]';User Id='[USER]';Password='[PASSWORD]';") .Open EndWith $adors = ObjCreate( "ADODB.RecordSet" ) With $adors .ActiveConnection = $ado .CursorLocation = "adUseClient" .LockType = "adLockReadOnly"; Set ODBC connection read only .Source = "select [VALUE] from [TABLE] where [VALUE] ='[VALUE]'" .Open EndWith - Woody Link to comment Share on other sites More sharing options...
ptrex Posted September 17, 2007 Share Posted September 17, 2007 Maybe this can get you started :Oracleregards,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...
JWoodruff Posted September 17, 2007 Author Share Posted September 17, 2007 Maybe this can get you started :Oracleregards,ptrexTrying it out now with the error management code. It is returning "provider cannot be found" - Woody 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