VB Forum / Database Access / February 2004

I have actually ported an application from Interbase DB to MS Sql Server.
But now the SP written in it needs to have optional output parameters, any
idea how can i do this? The SP are ready and working, but need to make then
optional, other wise i need to change lot of source  ...

I have an Access XP database that links to a table in an SQL Server 2K
database.  I'm using an ADO 2.6 Command object (using VB 6 SP 5) to access
and update the linked table and I get an error message of:
[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'SQL

I have a project with three ADO recordsets defined.  I execute a recordset1.open against a stored procedure that returns three recordsets.  I then execute a
 set recordset2 = recordset1.nextrecordse
 set recordset3 = recordset1.nextrecordse
I can change data in recordset1, ...

hi,
i'm working with VB6 and Oracle and keep getting a "Multiple-step OLE
DB operation generated errors Oracle" error trying to access a field
in Oracle of type LONG, here is the loop i'm using:

I'm new to Visual BASIC & ADO (I use lots of Delphi) and I'm
converting an Access 2000 application to VB6
I was wondering if it's better to use a different connection object
for each recordset object or if it's OK to use just one connection

This is a piece of code from a VB program which has
stopped working. Unfortunatly I didn't write it, I only
have to fix it and I have not use ADO before.
ADOconnMelbourne.Execute "insert " & sTableName & " select

I have an application where occasionally I may save the entire text of  a
web page in my database.
I'm afraid if I do a lot of this, when I do something like
select * from tempdb

I am using visual basic 6.0 sp5, I have a database created on Access2000 , I
use ADO , MDAC 2.7 refresh is installed on my computer, Win 2000 OS.
When I make setup on any win2000 station , evrythinthing is fine, But on
win95 It cant handle with the database, I installed MDAC 2.7 ...

I need to display a worksheet in VB6
I know how to do it with a DataGrid (using Adodc) but this has its limitations.
There is an Excel Sheet that one could insert in a form. However you can't set a "source" property
Is there a better way to do it apart from the DataGrid?

Tools: VB6 (with every SP), ADO 2.8, Access XP.
My Db is located in a server and many clients can read'n'write on.
Db size is 23 MB and record number is 25.000, i have some indexes and i use
them.

I have a  Database in access2000 with forms , reports , querys,and code. evry think is good we are working with this program 2 years.its fin
Now i want to do (Convert) the same database with VB6.witch is the best methode tu use the 1} dataenv     2} ado code
for printing can i use ...

Our App uses an Access frontend db with tables linked to a SQL Server
backend.  When we start the app, we refresh the links in the Access db as
follows:
   Dim objCat As New ADOX.Catalog

Although my application perform nicely in wired network, the performance in wireless network (100MPS) is very slow (I have tested in 802.11b 11MPS). Would appreciate if anyone could suggest how I can improve the performance in the wireless network.  The application is developed ...

I have a database from where I want to extract some data matching the
requirement using SQL statement into an array.
To illustrate let the required field be A, B, and C.
The SQL statment be of sometype e.g.

I was just wondering if any gurus could eval this code. Is the requery and find overkill? I am useing a client side cursor and want the user to see the changes of the record ie last changed and updated
--I am useing and adodc control
   Dim x As String
   x = Me.txtFields(1)