Обсуждение: link tables with VB from Access fails with 7.3.01 Unicode Beta
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
as I haven't got any answer to this message just a note that the problems I describe are still present in the new version 7.03.0200 as well as 7.03.0201 I would greatly appreciate if anyone could give me some idea on how to workaround this Stefanos Karasavvidis wrote: > 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
Hi, In your second problem, you name CX=xxx as a solution for setting true = -1? I use this connect string for working with PostgreSQL unter Delphi 7 and Access. Provider=MSDASQL.1;Extended Properties="DRIVER={PostgreSQL};DATABASE={databasename};SERVER={servername}; PORT=5432;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONI NG=0;SHOWSYSTEMTABLES=0; CONNSETTINGS=SET CLIENT_ENCODING TO ''LATIN1''; FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE=254;TrueIsMinus1=1;Updat ableCursors=1; CACHESIZE=100;MAXLONGVARCHARSIZE=65536;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0; TEXTASLONGVARCHAR=0; UNKNOWNSASLONGVARCHAR=1;BOOLSASCHAR=0;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTAB LEPREFIXES=dd_"; LFConversion=1;DisallowPremature=0;BI=0; DEBUG=0;COMMLOG=0; where TrueIsMinus1=1 takes care of the right way of returning booleans. hope is helps you. Regards, Jean Huveneers Xillion ICT Solutions B.V. Marktplein 8 6243 BR Geulle The Netherlands tel: +31 (0)43 3659244 fax: +31 (0)43 3659249 gsm: +31 (0)6 456 44 357 www: www.xillion.nl > -----Original Message----- > From: Stefanos Karasavvidis [mailto:stefos@msc.gr] > Sent: donderdag 23 oktober 2003 14:39 > To: pgsql-odbc@postgresql.org > Subject: Re: [ODBC] link tables with VB from Access fails with 7.3.01 > Unicode > > > as I haven't got any answer to this message just a note that the > problems I describe are still present in the new version > > 7.03.0200 > as well as > 7.03.0201 > > I would greatly appreciate if anyone could give me some idea > on how to > workaround this > > > Stefanos Karasavvidis wrote: > > > 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 > > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so > that your > message can get through to the mailing list cleanly > >
Thanks Jean for the info. I'd somewhere read that there are length restrictions in the connect string and that we should not use this kind of parameters, but anyway it DID NOT WORK with this either. But you use the "normal" Postgres driver and not the unicode (beta) driver, so maybe it is related with the driver. The issue is that it did work BEFORE version 7.03.01 so something in the new versions (7.01 and 7.02) has triggered this. Regards Stefanos Jean Huveneers wrote: > Hi, > > In your second problem, you name CX=xxx as a solution for setting true = -1? > I use this connect string for working with PostgreSQL unter Delphi 7 and > Access. > > Provider=MSDASQL.1;Extended > Properties="DRIVER={PostgreSQL};DATABASE={databasename};SERVER={servername}; > PORT=5432;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONI > NG=0;SHOWSYSTEMTABLES=0; > CONNSETTINGS=SET CLIENT_ENCODING TO ''LATIN1''; > FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE=254;TrueIsMinus1=1;Updat > ableCursors=1; > CACHESIZE=100;MAXLONGVARCHARSIZE=65536;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0; > TEXTASLONGVARCHAR=0; > UNKNOWNSASLONGVARCHAR=1;BOOLSASCHAR=0;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTAB > LEPREFIXES=dd_"; > LFConversion=1;DisallowPremature=0;BI=0; > DEBUG=0;COMMLOG=0; > > where TrueIsMinus1=1 takes care of the right way of returning booleans. > > hope is helps you. > > Regards, > > Jean Huveneers > > Xillion ICT Solutions B.V. > Marktplein 8 > 6243 BR Geulle > The Netherlands > > tel: +31 (0)43 3659244 > fax: +31 (0)43 3659249 > gsm: +31 (0)6 456 44 357 > www: www.xillion.nl > > >>-----Original Message----- >>From: Stefanos Karasavvidis [mailto:stefos@msc.gr] >>Sent: donderdag 23 oktober 2003 14:39 >>To: pgsql-odbc@postgresql.org >>Subject: Re: [ODBC] link tables with VB from Access fails with 7.3.01 >>Unicode >> >> >>as I haven't got any answer to this message just a note that the >>problems I describe are still present in the new version >> >>7.03.0200 >>as well as >>7.03.0201 >> >>I would greatly appreciate if anyone could give me some idea >>on how to >>workaround this >> >> >>Stefanos Karasavvidis wrote: >> >> >>>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 >> >> >>---------------------------(end of >>broadcast)--------------------------- >>TIP 3: if posting/reading through Usenet, please send an appropriate >> subscribe-nomail command to majordomo@postgresql.org so >>that your >> message can get through to the mailing list cleanly >> >> > > > -- ====================================================================== 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
Hi, My connect string are fine, problem only is the some program's use normal string variables and they have a max lenght of 254 characters. I use the Delphi Widestring that can take 4GB (2GB in unicode). I read/was told that in the new 7.3.x ODBC Drivers the unicode driver is default, and you have to specify the legacy driver if you don't want to use unicode. That caused some troubels in my applications too, but works fine now. Regards, Jean Huveneers Xillion ICT Solutions B.V. Marktplein 8 6243 BR Geulle The Netherlands tel: +31 (0)43 3659244 fax: +31 (0)43 3659249 gsm: +31 (0)6 456 44 357 www: www.xillion.nl > -----Original Message----- > From: Stefanos Karasavvidis [mailto:stefos@msc.gr] > Sent: donderdag 23 oktober 2003 16:22 > To: j.huveneers@xillion.nl; pgsql-odbc@postgresql.org > Subject: Re: [ODBC] link tables with VB from Access fails with 7.3.01 > Unicode > > > Thanks Jean for the info. I'd somewhere read that there are length > restrictions in the connect string and that we should not use > this kind > of parameters, but anyway it DID NOT WORK with this either. > > But you use the "normal" Postgres driver and not the unicode (beta) > driver, so maybe it is related with the driver. > > The issue is that it did work BEFORE version 7.03.01 so > something in the > new versions (7.01 and 7.02) has triggered this. > > Regards > > Stefanos > > Jean Huveneers wrote: > > Hi, > > > > In your second problem, you name CX=xxx as a solution for > setting true = -1? > > I use this connect string for working with PostgreSQL unter > Delphi 7 and > > Access. > > > > Provider=MSDASQL.1;Extended > > > Properties="DRIVER={PostgreSQL};DATABASE={databasename};SERVER > ={servername}; > > > PORT=5432;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN > =0;ROWVERSIONI > > NG=0;SHOWSYSTEMTABLES=0; > > CONNSETTINGS=SET CLIENT_ENCODING TO ''LATIN1''; > > > FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE=254;TrueIs > Minus1=1;Updat > > ableCursors=1; > > > CACHESIZE=100;MAXLONGVARCHARSIZE=65536;OPTIMIZER=1;KSQO=1;USED > ECLAREFETCH=0; > > TEXTASLONGVARCHAR=0; > > > UNKNOWNSASLONGVARCHAR=1;BOOLSASCHAR=0;PARSE=0;CANCELASFREESTMT > =0;EXTRASYSTAB > > LEPREFIXES=dd_"; > > LFConversion=1;DisallowPremature=0;BI=0; > > DEBUG=0;COMMLOG=0; > > > > where TrueIsMinus1=1 takes care of the right way of > returning booleans. > > > > hope is helps you. > > > > Regards, > > > > Jean Huveneers > > > > Xillion ICT Solutions B.V. > > Marktplein 8 > > 6243 BR Geulle > > The Netherlands > > > > tel: +31 (0)43 3659244 > > fax: +31 (0)43 3659249 > > gsm: +31 (0)6 456 44 357 > > www: www.xillion.nl > > > > > >