I am writing an app in vb6 using sql server 2005. here is my current code. 开发者_运维百科Dim Sqlstring As String
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.
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
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
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
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
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
Consider this query that uses SELECT * and \'appends\' a calculated column: SELECT *, IIF(TRUE, 1, 0) AS calculated_col
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:
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
加载中,请稍侯......