ADODB
ADODB open recordset fails / "Operation is not allowed when object is closed"
I have the following UDF in excel which uses ADO to connect to my MSSQL server. There it should execute the scalar udf \"D100601RVDATABearingAllow\".[详细]
2023-04-11 12:46 分类：问答Replace/Convert via sql while querying csv
I\'m trying to query a CSV via ADODB/SQL and the resu开发者_运维知识库lts need to be ordered by date. The challenge is that the date is in dd-mon-yy format. I tried to use CONVERT and REPLACE but Exce[详细]
2023-04-10 05:45 分类：问答VBA Recordsets: Why does the way I declare my array, in the Fieldvalue parameters of .addnew, matter?
I\'ve been trying to dynamically add to a Recordset but I am unable to do so. The .addnew function of a adodb.recordset seems to not allow just any type of array to be passed to it\'s fieldvalues, val[详细]
2023-04-08 16:01 分类：问答"Call to undefined function odbc_exec()" error connecting to Access database on Linux PHP server
I am getting the folowing error trying to run a test query on an Access Database \"Fatal error: Call to undefined function odbc_exec() in /home/ratpackc/public_html/Preview/ADOdb/drivers/adodb-odbc.in[详细]
2023-04-08 14:31 分类：问答Running a query using ADODB Connection randomly takes a long time to execute
I have come across an issue that seems to be somehow connected to a web server configuration, and resulting in queries randomly taking a long time to execute. The application is created using old plai[详细]
2023-04-07 17:14 分类：问答Order ADODB Recordset
H there, I need to merge and order3 recordset. I amable to merge the 3 开发者_如何学Gorecordset but I cannot use the sort method on the result recordset.[详细]
2023-04-05 06:49 分类：问答Why does ADODB.STREAM not work in Internet Explorer 9?
Why doesn\'t this code work in Internet Explorer 9? funct开发者_如何学JAVAion GetFile(FileName) {[详细]
2023-04-04 23:09 分类：问答Adodb Connection To Outlook Calendar Appointment
I\'m connecting to Outlook using Adodb. (ADO is a requirement) With ADOConn .Provider = \"Microsoft.JET.OLEDB.4.0\"[详细]
2023-04-03 23:37 分类：问答OLEDB query to select first and last time for id
I\'m using ADODB connection in VBA excel file with Microsoft.Jet.OLEDB.4.0 provider. The file with which I\'m establishing connection is .csv file which looks like:[详细]
2023-04-02 20:34 分类：问答How do you create an ADODB disconnected recordset in a VB.NET Windows application?
I\'m using an OLEDB connection to a Sybase database, with ADODB.dll file version 7.10.6070.0 (which comes from the Sybase 12.5 package).I need to be able to open a connection, use a command object to[详细]
2023-04-02 17:17 分类：问答
加载中,请稍侯......