Skip site navigation (1) Skip section navigation (2)

Re: Problems with Visual Basic

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: Wolfgang F·tbauer <w(dot)fuertbauer(at)eunet(dot)at>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Problems with Visual Basic
Date: 2002-01-18 22:37:46
Message-ID: EKEJJICOHDIEMGPNIFIJKEFJGIAA.Inoue@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
> -----Original Message-----
> From: Wolfgang FEtbauer
>
> Hi,
>
> found a Problem with the following configuration; can you help please?
>
> ODBC-Driver-Version:
>          7.1.007
> Database-Version:
>          7.1.3 on Linux 2.4.4-4GB (root(at)Pentium(dot)suse(dot)de) (gcc version
> 2.95.3 20010315 (SuSE))
> Visual Basic:
>          6 SP 5
> Data Access Method:
>          DAO (.. i know; but I have/want to convert a *large* project)
> The Code:

M$ ODBC cursor library support is needed.

>          Set myWs = CreateWorkspace("FAKTODBC", "Admin", "", dbUseODBC)
>          Workspaces.Append myWs
>

Please insert the following code here.

	myWS.defaultCursorDriver = dbUseODBCCursor

>          Set myDB = myWs.OpenDatabase("fakt32", dbDriverNoPrompt, False,
> "ODBC;dsn=PostgreSQL;uid=postgres;pwd=;")
>          Set gRsK = OpenRs(DYN, "Select * from " & TB_KENN)

Please open the recordset gRsK with dbExecDirect, dbOptimistic option.

regards,
Hiroshi Inoue


In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-01-18 22:37:52
Subject: Re: ODBC problem
Previous:From: Hiroshi InoueDate: 2002-01-18 22:37:40
Subject: Re: odbc error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group