link tables with VB from Access fails with 7.3.01 Unicode Beta

From: Stefanos Karasavvidis <stefos(at)msc(dot)gr>
To: pgsql-odbc(at)postgresql(dot)org
Subject: link tables with VB from Access fails with 7.3.01 Unicode Beta
Date: 2003-10-16 12:05:13
Message-ID: 3F8E8979.1000101@msc.gr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I have 2 problems with the 7.3.01 Unicode Beta (as well as 7.1.0115 from
http://www.geocities.jp/inocchichichi/psqlodbc/)

I have
MS Access 2000 on windows 2000 with latest MDAC
Postgres 7.3.4 on Linux

I use the following VB code within MS Access to link a table without
having a DSN
Set db = CurrentDb()
strConnect = "ODBC;DRIVER={PostgreSQL Unicode (Beta)};DATABASE=" +
DB_NAME + ";SERVER=" + IP_ADDRESS + ";PORT=5433;UID=" +
LOGIN + ";PWD=" + PASSWORD +
";A6=;A7=100;A8=4096;B0=254;B1=8190;BI=0;C2=dd_;CX=188103ab"

Set tdef = db.CreateTableDef("xxxx")
tdef.Connect = strConnect
tdef.SourceTableName = "yyyyyy"
db.TableDefs.Append tdef

This worked perfectly with the previous versions of the drivers. Now I
have the following problems:

Problem 1
==========
With both drivers the above code initially fails. 7.3.01 reports a 7711
error and versions 7.1.0115 Run-time error '3151'

Iff I manually link any table with a DSN datasource and rerun the above
code, it works perfectly (except the other problem I will describe later).
When I close Access and reopen it, I have again the same problem. if I
don't link manually a table, the code does not work

Problem 2
==========
although I specify CX=188103ab in the connection parameter, I get always
CX=1b503ab in the actually linked tables. In my specific case this does
not handle -1 as true.

Does any oneone have a workaround or a solution for this problems?

Regards

Stefanos

--
======================================================================
Stefanos Karasavvidis
Electronic & Computer Engineer
e-mail : stefos(at)msc(dot)gr

Multimedia Systems Center S.A.
Kissamou 178
73100 Chania - Crete - Hellas
http://www.msc.gr

Tel : +30 2821 0 88447
Fax : +30 2821 0 88427

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Joe Conway 2003-10-16 17:41:51 Re: is possible to read Oracle table from PostgreSQL?
Previous Message Marco 2003-10-15 19:02:46 is possible to read Oracle table from PostgreSQL?