VB Forum / Database Access / October 2005

i have got a client server application made in VB6 using an oracle91
databse .It was working fine earlier but now we have deployed server
application in another computer.Doing which it throws the error.
"DATA SOURCE NOT FOUND NO DEFAULT DRIVER SPECIFIED"

I am using adodc control in my VB6 program connected to access DB.(with
connection string)
When I use the following line to update a record :
form1.adodc1.Update

We've developed an Outlook Add-in with Visual Basic 6.  The add-in displays
a dialog containing ADO databound controls.  Some of the controls use a
DataEnvironment control as a row source.  We're using the JET OLE DB
provider to connect to an Access database.  The controls have ...

My vb6 code was this...
Public Sub KillAllRecordsInDB(ByVal SQLServer$, ByVal Catalogue$, ByVal
TableName$)
Dim loConnection As ADODB.Connection

I found ADO connection timeout property did not
work properly. For example, in adotest2() :
    cn.ConnectionTimeout = 1
With this setting, I found about 40 seconds of

Hi, could you please help me to change query in my access *.mdb file from
Excel.
I have to update queries ( change filterin criterias) in my *.mdb files
usiing VBA macro in Excel.

A small program that only reads fpxpro7 database (dbf file) from a directory
using ADO connection string cannot be run if compiled on a machine without
foxpro installed. In order to run, the exe needs to be compiled in VB6 WITH
foxpro7 installed.

I have a client /server architecture in vb6 with oracle 9i as the
database server.
everything else is working fine, client can connect to the server
server to the database etc....but the thing is that client is not able

This might seem like a simple question, but without using blobs, how do I
get the contents from a stream object into an image or picture object? No
problem reading or writing to or from a file with stream. (I've read the
article that Paul Clement recommends, but it doesn't ...

I am trying to convert my DAO appliction to
ADO. For example, daotest() should be
converted to adotest().
In adotest(), I find record set insert and

I have SQL Server 2000 stored procedure which inserts/update records in
several tables. Now I need to add Image type parameter to that procedure.
It's not a problem.
I have a problem with parameter in VB6 program which uses that SP. All

How can I read table data from Access 2003 into variables within
VisualBasic.net so that I can work with these data variables using
VisualBasic.net?
I was able to use VisualBasic.net to connect to Access tables by creating a

Hi bill :
I have one question to ask :
in vb6 while I use ado object .
I can use find method that allow me

    ericzaj      10/8/2005 11:02 AM PST     
     Question
     I am creating a simple two form data access application. The first form
displays my main table that shows orders in an orders table. I have a command