Re: Bind Parameter is Too Big - Mailing list pgsql-general
From | Adrian Klaver |
---|---|
Subject | Re: Bind Parameter is Too Big |
Date | |
Msg-id | 32c5f273-65a1-09aa-b553-df5b86efda5c@aklaver.com Whole thread Raw |
In response to | Bind Parameter is Too Big ("Kluzak, Matthew C." <mckluzak@nd.gov>) |
Responses |
RE: Bind Parameter is Too Big
|
List | pgsql-general |
On 9/1/22 1:34 PM, Kluzak, Matthew C. wrote: > I support a system where staff use a PowerBuilder 2019R3 app that enters > data into a Postgres 12 database, generates SQL statements for the data > and saves them as text files. Staff uses another PB2019R3 app to > populate a Sybase ASE 15.7 database with the generated SQL statement > files. Other staff then uses a PB2019R3 app to pipe the data to a master > Sybase ASE 15.7 database. At the beginning of each week that data is > piped via PB2019R3 app to another Sybase ASE 15.7 database. The > inspectors then update their Postgres database with all inspectors' data > via another PB2019R3 app that pipes the data from Sybase to Postgres. > > * Yes, I understand how absurd the system is. I just inherited it and > am supporting it until we can replace it. The .gov domain was explanation enough. > However, when trying to pipe the data from Sybase to Postgres > I get the error "Bind Parameter for value :9 is Too Big (2000)." The > comment column is the 9th column. > > I checked the data and verified it isn't over the 1000 character limit. > I tried deleting out 13 of the 1000 characters, and the error this time > was "Bind Parameter for value :9 is Too Big (1976)." What is the actual code that pipes the data? What is the encoding/character set in Sybase vs Postgres? > > Via Appeon’s support forums I worked out getting the pipe to work in the > PowerBuilder IDE by enabling staticbind and disablebind. In this view, I > can get a connection string to use in the app’s configuration file. > However, using this connection string in the app’s configuration file > still doesn’t work when running the pipe in the app. > > Connection string is: > DBParm=ConnectString='DSN=WM_LT_User;UID=user;PWD=password',PBCatalogOwner='user',DelimitIdentifier='Yes',DisableBind=1 > > Appeon is claiming it is a Postgres issue and so I am inquiring here. I > am hoping someone can help steer me in the right direction to get this > pipe working. > > Thanks > > Matt Kluzak > > Technology Director > > North Dakota Public Service Commission > > 600 E Boulevard Ave > > Dept 408 13^th Floor > > Bismarck, ND 58505-0480 > > Phone: 701-328-4075 > > > ------------------------------------------------------------------------ > This transmission, email and any files transmitted with it, may be: (1) > subject to the Attorney-Client Privilege, (2) an attorney work product, > or (3) strictly confidential under federal or state law. If you are not > the intended recipient of this message, you may not use, disclose, > print, copy or disseminate this information. If you have received this > transmission in error, notify the sender (only) and delete the message. > This message may also be subject to disclosure under the North Dakota > Open Records Laws. > -- Adrian Klaver adrian.klaver@aklaver.com
pgsql-general by date: