ADO
Problem with Indy, ADO and Delphi 2009
I\'ve a problem using ADO and indy in Delphi 2009. My project always crashes on exit when running i开发者_Go百科n delphi 2009.[详细]
2023-04-06 07:28 分类:问答Why is calling a stored procedure always preceded by a call to sp_sproc_columns?
I\'ve inherited a classic asp site, which uses ADO Db Command objects for stored procedures. One of the things I\'ve noticed, in the sql profiler, is that for every call to a stored procedure there i[详细]
2023-04-05 02:37 分类:问答convert boolean value to SortOrder enum value
i am reading boolean value (value would either 1 or 0) using data reader in ADO.NET from a table and want to type cast value to SortOrder (http://msdn.microsoft.com/en-us/library/dscy145f.aspx).[详细]
2023-04-03 13:37 分类:问答SQL Server 2005 running stored procedure from Excel (VBA)
I am trying to run a stored procedure on my SQL server. I think the connection type is \'ODBC\', but I am unsure, I am trying the below:[详细]
2023-04-01 22:07 分类:问答How do I select a variable with a space in the name using VBA from a CSV file via ADO?
Sub GetTextFileData(strSQL As String, strFolder As String, rngTargetCell As Range) \' example: GetTextFileData \"SELECT * FROM filename.txt\", _[详细]
2023-04-01 17:35 分类:问答Returning SCOPE_IDENTITY() using Adodb.Command
I have an Insert statement (Stored Procedure) that returns the SCOPE_IDENTITY() after insert, however, I am trying to figure out how to return it after I use an ADODB.Command request in Classic ASP.[详细]
2023-04-01 10:50 分类:问答How can I make ADO database connections in 'TISAPIApplication` before processing incoming requests?
TADOConnection is failing to connect 开发者_运维知识库in the application initialization section of Delphi ISAPI App (TISAPIApplication):[详细]
2023-04-01 08:44 分类:问答error '800a01b6': Object doesn't support this property or method: Object.Parameters.Add'
This is an extension to: Returning SCOPE_IDENTITY() using Adodb.Command Trying to get SCOPE_IDENTITY() using ADO.Command from a SP but get an error when I run the Ado.Command.. Here is the code examp[详细]
2023-03-31 22:32 分类:问答Refactoring LDAP/AD script from VBS to C#
I need to refactor a VBS dealing with LDAP, ADODB and ActiveDirectory from VBS to C#. The part I\'m stuck is connecting (just starting and already stuck... great). This is the original source[详细]
2023-03-30 04:33 分类:问答VBA Deleting records by iterating through ADODB Result Set
I am trying to loop through an ADODB resultset and delete the record if a condition is true. However, when I do this only the first field of the record is deleted the rest of the record remains.[详细]
2023-03-29 08:44 分类:问答