VB Forum / Database Access / January 2004

In this VB function, how am I going to input VB code who is going to connect
via ODBC with oracle database. Error shows at the --->>>
Public Function get_cjena_imp(p_vccid As Integer, p_datum As Date)
   Dim RST As DAO.Recordset

Because of reasons I don't know between the two
departemnts, we are not allowed to write stored procedures
to access the DB2 mainframe. So we use the Hummingbird
Bi/Query toolset. Recently, Hummingbird released a new

Group,
I've got a VB6 frontend to an Access 2000 database.  I'm using DAO
recordsets to populate 2 DBgrid's.  The DBgrid's are populated
correctly on my Windows XP production machine and 2 windows 2000

Has anyone come across a situation where you have an SP that runs just find
in iSQL but not via ADO?
BV.
www.iheartmypond.com

Can anyone help with this problem I am having?
I am using VB6 to connect to MySql running on Linux.  I can make a
connection fine and all works OK.  However, if i close the DB and then
re-open it later, I get the error "Error Number -2147467259

I used VB6 to connect an Access 2002 database, everything is fine except
when I set a database password in Access.  Is it possible to do so?
Thanks in advance of your help.
Regards,

I need your help for this thing.  I am using VB6, should I use
DataEnvironment or ADODB to connect to a Access database.  Which one is
the best for a client-server application?
Do you have any link where I could read about it?

I am using ADO on an ASP page written in VBscript (duh). I am using the ADO
to pull information from an Access 2000 database. About 75% of the time, the
SQL Query I use works find. But, the other 25% of the time, it will fail
saying "Type mismatch". This really puzzles me, because ...

I neet to build an error handler that takes care of ado error:
1. If i pressed AddNew and an error occured i need to cancel the addNew
action for closing the recordset.
How can i know when the adodb.recordset is on AddNew mode and how can i

By using Microsoft Data Provider for Oracle, posting
records in master and detail table. If an error occurs
while posting in detail table. I want rollback whole
transaction both in master/detail tables. Here is code

I have datagrid that bound to table
On runtim i've changed the data on the database
How can i update on runtime the dataGrid?

Hi all..
I've 2 questions here
is there any code out there which allows me to populate a combo box with the
countries in the world, as well as the states related to it.

I am getting close to a solution I think, thanks to the
newsgroups.  If any VB person can confirm Wayne's answer
as to libraries needed, or has further info, please let
me know.  The question is basically this: what must

I have created a test project and it includes a  master /
detail form created using the 'Data Form Wizard'  i am
having trouble getting the  FIND  function to work
Code :

I am using VB.NET to connect to a Access Database. When I
try
to add a record to the customer table. It gives me this
error.