ADO
VB6 syntax problem, "no current record" error
I am writing an app in vb6 using sql server 2005. here is my current code. 开发者_运维百科Dim Sqlstring As String[详细]
2023-03-20 00:45 分类：问答Issues opening a recordset in VB Script when connecting to DB2 via ADO
I am trying to use vbscript to connect to an iSeries DB2 database via ADO to do some very simple data retrieval, but am hitting a couple of oddities.[详细]
2023-03-19 13:58 分类：问答How to use visusal c++ 2010 to access access database?
I am facing the problem to access database,how can i use ado to access access database? i am using visusal c++ 2010 and access 2003[详细]
2023-03-19 11:08 分类：问答SQL Server 2008 USE database with [] Delphi ADO
In SQL server 2008 Management studio I can do this Use [C:\\test\\somedb...] When I use Delphi 2009 with the same command, using ADO, the [] seems to be interpreted as a parameter and the command fa[详细]
2023-03-19 02:58 分类：问答Exporting Access Tables Programmatically
alright, after a few hours of searching and reading all over the net, I have broken down and decided to ask for help. I am working to automate many of the more medial and repetitive tasks as work, and[详细]
2023-03-18 11:53 分类：问答MySQL TAdoConnnection connection "connected" property incorrectly set True
I have an application which connects to a MySql database using Delphi\'s TAdoConnection object.This 开发者_开发百科is a very query intensive application.So I create the connection and keep it open to[详细]
2023-03-18 09:33 分类：问答ADO Connection to SQL Server drop down does not always show servers
When using the ADO Connection dialog to build a c开发者_运维技巧onnection string, the database server does not always show in the drop down of available servers. On some machines it does - on others i[详细]
2023-03-18 05:26 分类：问答Calculated column in wrong position when using `SELECT *`
Consider this query that uses SELECT * and \'appends\' a calculated column: SELECT *, IIF(TRUE, 1, 0) AS calculated_col[详细]
2023-03-18 01:04 分类：问答Calling MySql stored function rather than a stored procedure with ADO Command object
I\'m trying to call a stored function like this from vba in access: SELECT my_function(); If it were a stored procedure it would be like this:[详细]
2023-03-17 04:49 分类：问答Notifying Excel 2007 about changes in a database in SQL Server 2008 R2
I have a lot of trouble using Excel 2007 together with SQL server 2008 R2. I need to share data between two or more workbooks, and I want to do this through a SQL database (placed in SQL Server 2008[详细]
2023-03-16 21:10 分类：问答
加载中,请稍侯......