Database Search
If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.
TechHome
OLE COM ADO CDO ADSI LDAP
 | |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|
- !! A List of Links to various OLE docs !!
- !! Understanding COM !!
- 1129 ObjectCreate
- 1129 OleInitiate Failed UAC
- 1129 OleInitiate Failed
- 1251 Ole - WIL Ole interface Dll not found
- Access to Excel Converter
- Access2000 Transaction Processing Demo
- Add Application to the Windows Firewall Exceptions List
- ADO vs ODBC
- ADO vs OLEDB vs ODBC
- Automatic Update from MicroSoft
- Bring up the RUN Dialog
- BYREF return parameters
- Close All Open OLE COM Objects
- Close an Object
- Closing Objects Explained
- Code to Create a Temporary DB
- Collaboration Data Objects Roadmap
- COM Constants for MS Office Applications
- COM Interfaces Explained
- COM Widestring Value Issue
- CommandTimeOut - lesson learned
- Connection String
- Convert Data Returned OLE
- Converting Pre 2004B OLE Scripts
- Copy Table Structure With SQL
- Create Object
- Create Recordset in Memory
- CreateObject Remote Computer
- Database ISAM Example
- dBase IV Creation
- Delete Mailbox in Exchange
- Determining if a Particular Update has Been Installed
- Determining Whether Automatic Updates is Enabled
- Display the Windows Run Dialog Box
- Does WinBatch Support 3rd party COM objects
- DSO Tabular Paging Demo
- Enumerate Citrix Applications
- Find Object Name and Properties
- Find User on Workstation
- ForEach Problem
- Generate GUIDs using ObjectType
- Get Audio File Information
- Get Information for IOMega Zip Drive
- Get Number of Records in Each Table
- Getting Multivalued Properties and Arrays
- GUID Create
- Handle Reassignment
- How to include an Office Assistant
- Insert Data into an SQL Server 2000
- Install CAPICOM on Win7
- Intcontrol 71 and Number of OLE Channels
- Interacting with Citrix
- IPCONFIG Results From STDOUT
- IsObject UDF
- List Components in Com Catalog
- List Databases on a Server
- List OLE DB Providers
- Load Data from ASCII File to a Java Applet Window
- MatLab COM Automation
- Method with Variant Parameters Explained
- Multi-Dimensional SafeArrays are NOT supported
- Named Parameters
- Object 101
- ObjectCreate Cannot Access Remote Server
- ObjectEventAdd Issue
- Office 2007 Driver Tips
- OLE COM Default Member Discussion
- OLE Explanation
- OLE Failing unless IE4 Installed - DCOM98
- OLE Property and Method Name Limit
- OLE Shell functions
- OLE2 Automation Tips
- Open DB and Permit Working with Tables
- Oracle Objects
- Pass ByRef Type Parameter
- Passing an Array as a Parameter to an OLE Method
- Passing Parameters
- Primer - Fabricated Hierarchical Recordsets
- Problems Writting a VB to WinBatch OLE Code Converter
- Read and Write to a Parallel Port
- RecordSets to HTML - with some Javascript
- Regular Expressions with WB
- Remotely Stop or Start COM Components
- Sample Code to Query a MIMSXServer
- Save Binary Streams to DB
- Set Proxy Server and Port
- Setting Group Policy Objects
- Shell ExtendedProperty
- Shell Helper Object
- SQL Server Update Stored Procedure
- Textract Problem
- textract test
- TextStream and Scripting.FileSystemObject
- Translate VB Default Member Name
- Trapping COM OLE Errors
- UDF to Return an Array of DB Table Types
- Un supported Variant Type Error With Concatenation
- Unicode Conversions with FileSystemObject
- Using the Object Browser
- Using the Visual Basic Object Browser
- Vbscript Array in WIL
- Virtual Server COM CoInitializeSecurity
- VT_DECIMAL Versus FLOAT
- WinBatch and Dot NET
- WinBatch Equivalent To VB Nothing
- WinBatch OnError
- Windows Firewall
- Windows Image Acquisition
- Working with Office Applications
- Write-Read DBF
Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
SQL Server Update Stored Procedure
Keywords: SQL Server Update Stored procedure
Question:
I have a scripe that works well (all but the Update). I'm not getting an error message, the no data is added in the update.Using :
oConn = "Provider=SQLOLEDB;Data Source=Server1;Initial Catalog=AutoInqS;Integrated Security=SSPI;"It runs select statements OK.
[ sqlB1 = "SELECT * FROM InqSrc WHERE (((SesVar)<>'0'))" ] rsB1 = RoConn.Execute(sqlB1)It runs Insert Stored Procedures OK.
[ cSQL = "insert_BasicInquiryReturn_1 @SesVar_1 = '%th1w%', @TagNo_2 = '%th2w%', @Uid = '%th4w%'" RoConn.Execute(cSQL)]But I can not get it to run an Update Stored Procedure.
svM = strcat("update_BasicInquiryReturn_ZZ @SV = '%th1w%',", ", " , " @St = '%Rs%'", ", " , " @In = '%Inv%'", ", " , " @TLP = '%TLP%'", ", " , " @DT = '%Dtp%'", ", " , " @DN = '%Dec%'")
RoConn.Execute(svM)
Using Message, it is filling the variables correctly.
I tried an ADODB Command object also with the same Non Results.
I am obviously overlooking something.
Answer:
There are 2 possibilities:- You need to put in code to check the 'state' of the Connection if you are immediately following the INSERT with UPDATE. If the INSERT is still 'executing' Winbatch will issue the UPDATE but it will go to dead air.
- The UPDATE takes longer than the CommandTimeOut for the Connection - big 'gotcha' here, if you set the CommandTimeOut to 0 ( supposedly never times out ) for a Connection, you are hosed- its a well known but little advertised ADO bug.
Article ID: W15589
File Created: 2003:05:13:11:29:08
Last Updated: 2003:05:13:11:29:08