VB Forum / Database Access / April 2006

I created a db in ssms; I detached it and moved it into a subdirectory of a
vb app. Now sql server says the database does not exist. If I recreate the
database in smss, I can run an INSERT INTO using that db as the destination.
However, this only works if I keep it in the mssql ...

Would like some help on how to setup a treeview and listview from a access
database. I have a database that I would like to list the table with Job
Location and a table of the Job Details. The tables are linked by a
Autonumber. The first table only has one location the second ...

We have a Oracle PL/SQL stored procedure that returns 2 varchars. It
works just fine when called from a VB.NET program. However, from a VB
6.0 application using DAO, we are not able to get return values back.
Any ideas? It has to be DAO only and not ADO.

Everything was fine and all of a sudden, my ADODB control on the VB6
application starts behaving strangely. It now gives me "[ADODB] Unknown
Error". What I had done was tried to reinstall OLEDB 4.0 Jet Driver 8.0
which it did not let me install saying that the one that came with

Hello, I am having an issue with the ADO control in VB6. Currently the
application I am working on uses an ADO control connected to an Access
database. All other controls on the form are bound to the ADO control. What
I have been noticing is that after doing an update

What is the correct sysntax to use in order to INSERT a value into a Logical
data field?
Example:
A table has the following field called "SACRED" when is defined as a

Can anybody teach me how to populate a combo listbox from a sql server
database table. Thanks in advance.
WT Sit

does any body can help me Why to use MsFlexGrid to display data from Query?
Thank's for before

I am trying to connect to AS400 using OLE DB, but either using SNAOLEDB or
IBMDA400 it gave me error "Run time error 3706: Provider can not be found.
It may not be properly installed".
I can connect ODBC Data source to AS400 using "Client Access ODBC Driver (32

Here is the VFP8 query, need some help in converting to ADO and VB6.
    SELECT distinct substr(wgn,2,2) as num;
        FROM &pcoilsdbf.;
        WHERE Pcoils.kva = cfg.kva;

How can I get only the list of System DSN on the machine

what is meant with message error 3704 "Operation is not allowed when the
object is closed"
any body can help me?

Is there a simple rule for constructing the syntax in a SQL string
especially where variables are concerned. I get real stuck with my & ' "
and never get this right first time.
This doesn't seem to work

Can anyone tell me what might be wrong with the following filter statement:
Filter = (conloss <= 1680 and corloss <= 302 and (corloss + conloss <= 9999)
and (piz >= 0 and piz <= 7) and (eff >= 96.5)  and (rg08 <= 7)  and (cool <=
3232) and (totwgt < 9999) and (gradient between 2 ...

I am trying to write a Select statement to open a recordset. I keep getting
this error message:
Syntax error(missing operator) in query expression '[REEL ID] = '[REEL ID] =
'54"