link tables with VB from Access fails with 7.3.01 Unicode Beta

Поиск
Список
Период
Сортировка
От Stefanos Karasavvidis
Тема link tables with VB from Access fails with 7.3.01 Unicode Beta
Дата
Msg-id 3F8E8979.1000101@msc.gr
обсуждение исходный текст
Ответы Re: link tables with VB from Access fails with 7.3.01 Unicode  (Stefanos Karasavvidis <stefos@msc.gr>)
Список 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@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


В списке pgsql-odbc по дате отправления:

Предыдущее
От: Timothy Reaves
Дата:
Сообщение: Mac OS X Driver
Следующее
От: "Marco"
Дата:
Сообщение: is possible to read Oracle table from PostgreSQL?