From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Ni Kun <tianni(at)bsc(dot)fujitsu(dot)com> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Access 2000 ODBC table links |
Date: | 2001-11-16 00:08:50 |
Message-ID: | 3BF45912.2396CC80@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
What version of psqlodbc driver are you using ?
regards,
Hiroshi Inoue
Ni Kun wrote:
>
> Private Sub Link_ODBCTbl(rstrTblSrc As String, rstrTblDest As String,
> dbsCurrent As Database)
>
> Dim tdf As TableDef
>
> On Error Resume Next
>
> Set tdf = dbsCurrent.CreateTableDef(rstrTblDest)
> dbsCurrent.TableDefs.Delete rstrTblDest
>
> tdf.Connect = "ODBC;DRIVER={PostgreSQL};" _
> & "DATABASE=soldb;SERVER=10.73.233.137;" _
> & "PORT=5432;" _
> & "UID=soluser;" _
> & "PWD=soluser;READONLY=0;PROTOCOL=6.4;" _
> & "FAKEOIDINDEX=1;SHOWOIDCOLUMN=1;" _
> & "ROWVERSIONING=1;SHOWSYSTEMTABLES=0;" _
> & "CONNSETTINGS="
> tdf.SourceTableName = rstrTblSrc
>
> dbsCurrent.TableDefs.Append tdf
> dbsCurrent.TableDefs.Refresh
>
> End Sub
>
> Windows2000: Postgre7.1.3+Access2000
> "dbsCurrent.TableDefs.Append tdf" executing、why Access2000 Program
> closed?Momory Error?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2001-11-16 00:43:21 | Re: SQLDescribeCol and column alias |
Previous Message | Gilles DAROLD | 2001-11-15 20:23:58 | SQLDescribeCol and column alias |