From: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | <Wolfgang(dot)Fuertbauer(at)ebewe(dot)com> |
Cc: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Problem with VB-DirectODBC selecting text-fields [EBEWE: Virus checked] |
Date: | 2002-03-09 09:00:42 |
Message-ID: | EKEJJICOHDIEMGPNIFIJGEGMHBAA.Inoue@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> -----Original Message-----
> From: Wolfgang(dot)Fuertbauer(at)ebewe(dot)com
>
> Hi,
>
> i have a problem with the following SQL-Statement:
>
> Select Groessen from Weg where Bsnr = 14957 and Znr = 1 and wegkz = 1;
>
> when executing it via direct-odbc in VB it gives me the error-nr: 3146
>
> the VB-Code:
> ------------
> Set myConn = myWs.OpenConnection("", _
> dbDriverNoPrompt, _
> False,_
> "ODBC;dsn=PostgreSQL;uid=postgres;pwd=;")
> sql = "Select Groessen from Weg where Bsnr = 14957 and Znr = 1 and wegkz =
> 1"
> Set rs = myConn.OpenRecordset(Sql, _
> dbOpenSnapshot, _
> dbExecDirect, _
> dbOptimistic)
How are you creating the myWs ?
Are you setting the DefaultCursorDriver property as dbUseOdbcCursor ?
regards,
Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2002-03-09 09:00:59 | Re: Psqlodbc 7.1.11 |
Previous Message | Alan Wayne | 2002-03-08 23:14:14 | ODBC |