VB Forum / Database Access / April 2005

hello everybody:
I am not really sure if this is the right place to make this question, but let me try
this is my case
i want to call a strore procedure from visual basic (excel) with output parameter, is it possible ??

I'm using a List Box on my form for display of a recordset from my database.
I'm using code as follows to create a string for a list box, works fine.
lstBox.AddItem rsLog.Fields("EmpNo") & "   " & rsLog.Fields("LName") & "  "
_

insert into tbl_roba (intsif) values('ccc' || char(92))
insert into tbl_roba (intsif) values('ccc' & char(92))
insert into tbl_roba (intsif) values('ccc' and char(92))
insert into tbl_roba (intsif) values('ccc' + char(92))

I have a problem regarding passing parameter from excel spreadsheet to a
backend sql
database to refresh data.
For example, I already add a text box in an excel spreadsheet to let me

I want to use ADO Connection transactions from a VB 6 Middle-Tier to SQL
Server 2000, but I don't understand how transactions are managed relative to
connection pooling.
I have 4 Web server boxes hitting the VB Middle-tier via COM+/DCOM on a

VB6/DAO 3.6/Access 2000.
I'm using the data control from common controls which takes a dao
recordsource.  In this case I'm assigning a dao recordset as the data
control's recordsource.

I am creating an VB application which connect to SQL Server.
I find that the find method in the ADO recordset object does not work when
the field property in SQL Server is set to not allow null.
Here is my VB code

I have a question... because I've heard several people say that using
the "data-bound controls" is a BAD idea, that hard coding is far
better.
Being a newbie... I have no idea why the methods would be "BAD".

i know this isn' the place but thought i'd get a response.
i'm trying to open an .xls file and save it to .cvs in VB 6.0
my code is as follows:
Dim xlApp As Object

I set up an OLEDB connection, adapter, and dataset on my opening form.
I want to input the Data Source and replace the DS supplied at design time
with a string variable (I will probably use an OpenFileDialog).  Where do I
put the file dialog ?  Another question, how do I make this ...

I'm using an Access Database and ADO to call a SQL Stored Procedure to
update about 2 to 4 records in a SQL table. When I call the .execute
method of the ADO Command object, the app hangs until the timeout
period expires. The SQL Server is also unresponsive to ALL subsequent

I seem to be running in circles here.  I decided to use a datetime field in
a VFP DBF table (8 bytes, type DATE) to handle concurrency conflicts.  So I
altered the existing table to add a LASTUPDT  field of type DATE.  Initially
all values in this column are NULL (as displayed in ...

       I have some VB code that uses an ADO connection to the current
project to delete a record.  Fight after that call is some code that needs
that record gone before it executes, or I get an error.  Is there a simple
way to have VB wait until the ADO execution is done before ...

Hi.  My application is opening a DSN which uses the Visual Foxpro driver
(vfpodbc.dll ver 6.01.8629.01).  I can read, write, update and delete all
normally using a VB.NET dataset.  Now, I want to be able to add a column to
the table programmatically.  When I issue this command:

Hello - I have an application that uses a DSNless ODBC driver to connect to
a SQL Server database.  I recently learned that the old System DSN that we
had created was using the "use regional settings when outputting currency,
numbers, dates, and times" checkbox.