Re: Connection Problem

From: "Joseph Watson" <jtwatson(at)datakota(dot)com>
To: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>, "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
Cc: "'pgsql-ODBC \(E-mail\)'" <pgsql-ODBC(at)postgresql(dot)org>
Subject: Re: Connection Problem
Date: 2002-01-28 22:53:20
Message-ID: 000b01c1a84e$96eb4100$0a01a8c0@bay.chartermi.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Thanks so much for all the help

I moved the DAO 3.6 up the reference list and this fixed the problem and it
works.

Thanks so much.

Joseph

----- Original Message -----
From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
Cc: "'Joseph Watson'" <jtwatson(at)datakota(dot)com>; "'pgsql-ODBC (E-mail)'"
<pgsql-ODBC(at)postgresql(dot)org>
Sent: Monday, January 28, 2002 4:55 AM
Subject: Re: [ODBC] Connection Problem

> Dave Page wrote:
> >
> > > -----Original Message-----
> > > From: Hiroshi Inoue [mailto:Inoue(at)tpf(dot)co(dot)jp]
> > >
> > > Joseph Watson wrote:
> > > >
> > > > Here is my VB code:
> > > >
> > > > Private Sub Command5_Click()
> > > >
> > > > Dim FSEInfo As Workspace
> > > > Dim conn As Connection
> > >
> > > If I remove the above line(Connection), the following
> > > seems to work though I don't understand the reason.
> >
> > If it were VB I'd say in a flash that ADO is referenced in the project
> > before RDO/DAO and conn was defaulting to ADODB.Connection. Is this
possible
> > in Access?
>
> Oh I see.
> Joseph, please change the line like
> Dim conn As DAO.Connection
> and try.
>
> regards,
> Hiroshi Inoue
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Kuo, Keleen 2002-01-29 06:45:19 ISA Server -> ODBC -> PostgreSQL Problem
Previous Message Ludek Finstrle 2002-01-28 13:50:10 Re: SQLExecute get result to client?