VB Forum / Database Access / June 2005

I have a VB6 program that I'm writing that uses SQL Server to maintain
version numbers for various applications and servers within my shop.  The
general layout of the database and tables is this (not very many fields):
tblPograms - contains a row for each possible program we have. ...

Where can i find some tutorial,link or documentation that explain
exaustively the interoperation between ado and active directory?
I don't know too much of active directory.
Thanks

I have a VB6 project that I would like to us an MSFlexGrid control.
I am reading a SQL Server database using ADO.
Does anyone have any readable code in the best way to populate the data
grid?

I usually use the following code to execute a SP within my VB6 code:
...
Set objCmd = New ADODB.Command
Set objRS = New ADODB.Recordset

I use vb6 and mssql2000. In the database i have a table with 32 fields.
For inserting to the table i use a dll where i have written the function
which takes all 32 param, creates the command params and passes
to sql stored procedure. connecting to the database is also done in

Can anybody help me to overcome this problem?
ADODB is not allowing me to copy more than 255 characters into an excel
cell. I must truncate the string to 255 characters before updating.
otherwise it is throwing exception and fails. Please check the code

I want to delete all rows in a SQL Server table at the start of a procedure.
I have a SqlDataAdapter with a DataSet that has two tables. I have the
following code to delete all records in both tables. These tables are
populated from the last execution of the procedure. I fail ...

Hi ng!
I want to update a value which is in a primary key column. I am using ADO
2.7 on SQLServer 2000.
My code is something like this (VB.NET):

When I have to set "CursorLocation" with "Client" or "Server"?

When you set up an OLEDB connection string for SQL server, on the advanced
tab, there is a property called "General Timeout".
Is this equivalent to ADO CommandTimeout?
Jiho

I am upgrading from VB6 to VB.NET.
I have to read a large amount of rows in the database (CodeBase)
What is the best way to read the data through a datagrid ?
I used the Spread control from Farpoint in virtual mode. But now i can't

How can i do to read/write a clob field from db2?
thanks
Pablo

[newbie when it comes to ADO]
I'm creating and populating an ADO recordset 'by hand' (programmatically)
primarily for using it's sorting capability, so there is no underlying
table. I'm wondering though if I could now use it to select the top 10

I have an Employee object.  One method of the employee object is to return
the total number of Transactions for a user defined period of days.  The
pseudo code is as follows.  (This is a simplified example as the criteria
and definition is more complicated than this simple ...

i need to open, read, edit  a Visual foxpro DBF file but i do not find
information about it.
Any exapmple?
thankssssssssssssssssssssssssssss