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@msc.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
