VB Forum / Database Access / January 2005

MSDE 2000A
vb6 service pack 6
Using command object to execute a stored procedure
Consider the following 2 lines in a stored procedure

hello my self avi
i m working in vb and sqlserver
in my customermaster table there is more than 400 reocrds and when i m
going to insert that all records in listbox or combobox it takes too much

I created a DTS Package using Enterprise Manager and converted it over to
.Net (I followed the tutorial that can be found at:
http://www.devguru.com/features/tutorials/DTS_VB/DTS_VB.html
My package simply copies records from a SQL table to Excel.  On tables

I have a piece of code which for some very strange reason, throws up
Overflow errors. It's nothing to do with numbers (it's a string field!), it
only happens on some PCs, and I'm tearing my hair out a bit!!!! It always
stops on the first line of code:

I have an application that has two physical tiers.
The application server runs VB6 code.
The data server runs SQLServer 2000 (standard).
Now and again, I get the following error reported:

It's a hard decision these days!
I write a lot of shareware, mostly business apps and they almost always use
some kind of relational database. Until now I've been using SQLite, but with
my recent move to .NET, the SQLite ADO.NET provider is in an unusable beta

Hi All,
Happy New year!!! Best Wishes!!!
Well, I am having a strange bug in one of my .NET for Windows  applications.
This is an application that load a list of data and when the user selects on

I'm trying to execute a stored procedure in SQL Server 2000 from a VB^
program, but getting this error:
-2147217887  [Microsoft][ODBC SQL Server Driver]Optional feature not
implemented

I'm trying to write code to search our parts list and I'm having
trouble with parts that contain a pound sign. When I execute the
following filter:
Select partnumber from parts where partnumber Like '*2TA*'

Hello Inno/VB gurus!  I'm an InnoSetup newbie and have a question.  I hope
someone can help.
I have a third party application that we currently install to hundreds of
our customers.

Currently I am having visual basic 5.0 application connection to access 97.
Now I would like to connect the same vb 5.0 application to access 2003.
My first question is  it possible ? if so is there any documentation
available.

Below is the part of code I use in my program. I have a problem with
updating the calls table. For example if I have 4 records to update, it only
update the first three and the fourth is not updated; and there is no error
message. If I have only one record to update, it doesn't ...

How do i Connect an Oracle database to VB6?
I need the code for this.

hello my self avi
i m working in vb and sqlserver
in my customermaster table there is more than 10000 reocrds and when i m
going to insert that all records in listbox or combobox it takes too much

I know this problem will be solved by use of an index. I will emphasize the
importance of using an index to the customer, however I want to at least
understand why I am getting duplicates.
I have written a program that will update the data of one application with