ADO
Building a REAL database application using Datasnap
I have built an extensive 2-tier application in D2010, using ADO and devexpress. I want to upgrade this to using Datasnap mainly to provide HTTPS communication instead of just TCP/IP to the vulnerable[详细]
2023-04-13 02:37 分类:问答ADO Data Types (adParamInput vs adParamOutput)
Can somebody please tell me what the difference is between adParamInput and adParamOutput? I\'m using parameters in a Classic ASP/MySQL environment.[详细]
2023-04-12 21:07 分类:问答Classic ASP Array not returning values, error 500
I\'m working on executing the same code several times to produce a table. My first thoughts went out to using an array to do this.[详细]
2023-04-12 16:20 分类:问答Classic ASP Script not returning value in ELSE
First time poster and fairly new to ASP programming. I am trying to add a functionality that checks if a field is empty, if so return a set value.[详细]
2023-04-11 23:27 分类:问答Weird situation, define a file path connecting to Access .accdb database in Excel VBA using ADO, however it tells me couldn't find .mdb file
I\'m writing code in Excel VBA using ADO connection to open an Access .accdb database. I defined the file path as bellow, but when I run my code, error message tells me that \"couldn\'t find file C:\\[详细]
2023-04-11 13:16 分类:问答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 分类:问答Get the list of ODBC data source names programmatically using Delphi
I saw several examples where the list of the source names were took from registry (HKEY_LOCAL_MACHINE\\Software\\ODBC\\ODBC.INI\\ODBC Data Sources). Is there any other way to get the list of ODBC data[详细]
2023-04-11 09:23 分类:问答Object doesn't support this property or method: 'rsSQL.Execute'
开发者_如何学Cheres my ASP: sql=\"select * from empPac where empIdent=\'\" & empIdent & \"\' and catalogIdent=\" & catItem[详细]
2023-04-11 06:00 分类:问答ADO recordset fails on "memo" datatype during import into Excel
I am trying retrieve data from a SQL server, for use in some Excel 2003 macros. I would like to avoid the use of QueryTables, as I don\'t want this intermediate step of writing and reading from actual[详细]
2023-04-10 23:36 分类:问答How to check which command arrives at SQL server when send using ADO? Is there a logfile?
I have a general question about using ADO together with SQL-server 2008express (Microsoft). When sending a SQL command to the server from let\'s say an EXCEL application, is there away (eg using the[详细]
2023-04-10 17:36 分类:问答