# PostgreSQL error QueryParsingError at "/"

**URL:** <https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810>\
**Category:** uncategorized\
**Tags:** sql\
**Created:** [January 28, 2022, 1:02am UTC](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810 "2022-01-28T01:02:39Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![leroyschulz](https://clarionhub.com/user_avatar/clarionhub.com/leroyschulz/32/6200_2.png) [@leroyschulz](https://clarionhub.com/u/leroyschulz)\
**Post date:** [January 28, 2022, 1:02am UTC](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810/1 "2022-01-28T01:02:39Z")

</div>

I’m struggling trying to get a Clarion 11 app working with PostgreSQL. I’m new to PostgreSQL.

I’ve set up DSN and used the table import in the dictionary to import a table definition (a table that contains sample data). To test, I used the browse wizard to create a new procedure. The code is template generated.

But when I open the browse, I get this error.

 ![2022-01-27 Error](https://clarionhub-uploads.s3.eu-north-1.amazonaws.com/original/2X/3/350c8b0e6b7da59be2f1ff5033811ea33998efd1.jpeg)

Any ideas to troubleshoot this?

---

<div class="post-metadata">

**Author:** ![totalhip](https://clarionhub.com/user_avatar/clarionhub.com/totalhip/32/1477_2.png) [@totalhip](https://clarionhub.com/u/totalhip)\
**Post date:** [January 28, 2022, 2:39am UTC](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810/2 "2022-01-28T02:39:30Z")

</div>

What is in the name attribute for the table in your DCT?  
As the message indicates, the problem is in the FROM clause.

---

<div class="post-metadata">

**Author:** ![totalhip](https://clarionhub.com/user_avatar/clarionhub.com/totalhip/32/1477_2.png) [@totalhip](https://clarionhub.com/u/totalhip)\
**Post date:** [January 28, 2022, 2:56am UTC](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810/3 "2022-01-28T02:56:25Z")

</div>

Further considerations:  
a) all PG tables in a DCT should have a lowercase name  
b) the Clarion label can be as desired  
c) plan to us PG schemas  
d) Clarion column names in the DCT will generate as lowercase OR  
if different than PG will require a PG lowercase name attribute  
e) column names in PG should be lowercase  
f) the “cost” in PG of not using lowercase will be remembering to use quotes

For example:  
Clarion table in DCT - MyTable  
PG table name in DCT - aschema.mytable

HTH

---

<div class="post-metadata">

**Author:** ![seanh](https://clarionhub.com/letter_avatar_proxy/v4/letter/s/4af34b/32.png) [@seanh](https://clarionhub.com/u/seanh)\
**Post date:** [January 29, 2022, 11:24am UTC](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810/4 "2022-01-29T11:24:53Z")

</div>

As per Skype I think you need to put " around the schema  
so  
“scendmedia/demo\_repo”.atl\_parcel\_attr

---

<div class="post-metadata">

**Author:** ![leroyschulz](https://clarionhub.com/user_avatar/clarionhub.com/leroyschulz/32/6200_2.png) [@leroyschulz](https://clarionhub.com/u/leroyschulz)\
**Post date:** [January 29, 2022, 6:13pm UTC](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810/5 "2022-01-29T18:13:00Z")

</div>

> As per Skype I think you need to put " around the schema so “scendmedia/demo\_repo”.atl\_parcel\_attr

I just tried that. It gives me a “file not found” error.

What the dictionary imported from DSN is: _scendmedia/demo\_repo.“atl\_parcel\_attr”_.

Any other ideas?

---

<div class="post-metadata">

**Author:** ![leroyschulz](https://clarionhub.com/user_avatar/clarionhub.com/leroyschulz/32/6200_2.png) [@leroyschulz](https://clarionhub.com/u/leroyschulz)\
**Post date:** [January 29, 2022, 6:31pm UTC](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810/6 "2022-01-29T18:31:23Z")

</div>

> What is in the name attribute for the table in your DCT?

Here’s what the dictionary importer specified.

 ![2022-01-29 DCT 01](https://clarionhub-uploads.s3.eu-north-1.amazonaws.com/original/2X/2/2abff929ac10a7647b2b704a3f5f51e08c9bbe0c.png)

> a) all PG tables in a DCT should have a lowercase name

They do.

> b) the Clarion label can be as desired

Got it.

> c) plan to us PG schemas

Yep, I am.

> d) Clarion column names in the DCT will generate as lowercase OR  
> if different than PG will require a PG lowercase name attribute  
> e) column names in PG should be lowercase

They are.

Here’s more info:

- I have a TPS app that I want to have several tables use remotely-hosted PostgreSQL instead. (For several reasons, but mostly so that I can easily use webhooks and other APIs using Zapier, which I use extensively.)
- To keep things simple, I’m using [https://bit.io/](https://bit.io/), a hosted PostgreSQL installation.
- I’ve set up an ODBC DSN and confirmed that the connection works.
- The table I’m connecting to contains sample data (that’s a setup option with [Bit.io](http://Bit.io)).
- I’m using Clarion’s dictionary importer to import those tables.
- I’ve used the wizard to create browses for testing. (So it’s all template-generated code.)
- I’ve run into one of two errors when I open the browse. (Posting below.)
- I do use FM3 with the TPS files in this app, but I’d rather not use it for the SQL files, so I’ve set the FM3IGNORE flag.
- I’ve tried lots of owner and path options, but no luck.
- If you want to try, I can either send you the connection details or you can create a [Bit.io](http://Bit.io) account. It’s free and only takes a couple of minutes to set up.

Any ideas would be appreciated.

---

<div class="post-metadata">

**Author:** ![totalhip](https://clarionhub.com/user_avatar/clarionhub.com/totalhip/32/1477_2.png) [@totalhip](https://clarionhub.com/u/totalhip)\
**Post date:** [January 29, 2022, 7:26pm UTC](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810/7 "2022-01-29T19:26:06Z")

</div>

Have you tried using PG Admin to view the PG database?  
I am wondering about scendmedia being the database name with demo\_repo as the schema. The database does not need to be included in the name .

---

<div class="post-metadata">

**Author:** ![leroyschulz](https://clarionhub.com/user_avatar/clarionhub.com/leroyschulz/32/6200_2.png) [@leroyschulz](https://clarionhub.com/u/leroyschulz)\
**Post date:** [January 29, 2022, 8:28pm UTC](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810/8 "2022-01-29T20:28:12Z")

</div>

> Have you tried using PG Admin to view the PG database?

I use Beekeeper Studio. That connects without issue.

> I am wondering about scendmedia being the database name with demo\_repo as the schema. The database does not need to be included in the name.

The database name is different – it’s not “scendmedia”. According to [Bit.io](http://Bit.io), “scendmedia/demo\_repo” is the schema, and that’s the schema that’s working with DSN. I might be wrong, but I don’t think that’s the issue.

Is it possible that the forward slash is tripping things up?

---

<div class="post-metadata">

**Author:** ![FedericoNavarro](https://clarionhub.com/letter_avatar_proxy/v4/letter/f/2acd7d/32.png) [@FedericoNavarro](https://clarionhub.com/u/FedericoNavarro)\
**Post date:** [January 29, 2022, 8:46pm UTC](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810/9 "2022-01-29T20:46:42Z")

</div>

Leroy,

Try this way:

Owner Name: PostgreSQL35W,“scendmedia/demo\_repo”

(or demo\_rep without the last “o” as you put it on the last message, or it was a typo?)

Full Path Name: atl\_parcel\_attr

(or “atl\_parcel\_attr”)

Federico

---

<div class="post-metadata">

**Author:** ![totalhip](https://clarionhub.com/user_avatar/clarionhub.com/totalhip/32/1477_2.png) [@totalhip](https://clarionhub.com/u/totalhip)\
**Post date:** [January 29, 2022, 9:12pm UTC](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810/10 "2022-01-29T21:12:25Z")

</div>

> [@leroyschulz](#):
>
> The database name is different – it’s not “scendmedia”. According to [Bit.io](http://Bit.io), “scendmedia/demo\_rep” is the schema, and that’s the schema that’s working with DSN. I might be wrong, but I don’t think that’s the issue.  
> Is it possible that the forward slash is tripping things up?

If you’ve tried quotes as Sean suggested, I would try variations:  
“scendmedia/demo\_rep”.“atl\_parcel\_attr”  
“scendmedia/demo\_rep.alt\_parcel\_attr”

Also, you might use trace to see what exactly is passed in a successful select with DSN.

---

<div class="post-metadata">

**Author:** ![leroyschulz](https://clarionhub.com/user_avatar/clarionhub.com/leroyschulz/32/6200_2.png) [@leroyschulz](https://clarionhub.com/u/leroyschulz)\
**Post date:** [January 29, 2022, 9:19pm UTC](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810/11 "2022-01-29T21:19:49Z")

</div>

> (or demo\_rep without the last “o” as you put it on the last message, or it was a typo?)

Yes, that was a typo. I just fixed that in my message.

> Owner Name: PostgreSQL35W,“scendmedia/demo\_repo”  
> Full Path Name: atl\_parcel\_attr  
> (or “atl\_parcel\_attr”)

I just tried that. According to the docs at [https://docs.bit.io/docs/getting-started](https://docs.bit.io/docs/getting-started), the double quotes are required around both “scendmedia/demo\_repo” and “atl\_parcel\_attr”, so that’s what I’ve done.

Now I get this error.

![2022-01-29 Error 01](https://clarionhub-uploads.s3.eu-north-1.amazonaws.com/original/2X/1/15354ffa89d4c23f82b1968d91240c1db1eafdc7.png)

---

<div class="post-metadata">

**Author:** ![leroyschulz](https://clarionhub.com/user_avatar/clarionhub.com/leroyschulz/32/6200_2.png) [@leroyschulz](https://clarionhub.com/u/leroyschulz)\
**Post date:** [January 29, 2022, 9:35pm UTC](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810/12 "2022-01-29T21:35:07Z")

</div>

> If you’ve tried quotes as Sean suggested, I would try variations:  
> “scendmedia/demo\_rep”.“atl\_parcel\_attr”  
> “scendmedia/demo\_rep.alt\_parcel\_attr”

I have tried all those variations as well as using a glo:fullpathname variable and assigning the value at runtime.

> Also, you might use trace to see what exactly is passed in a successful select with DSN

Here are the trace results using _scendmedia/demo\_repo.“atl\_parcel\_attr”_:

```
06B1CH(3) 14:27:57.147 Allocating Environment Environment 0FA24AF0H Time Taken:0.00 secs
06B1CH(3) 14:27:57.147 scendmedia/demo_repo."atl_parcel_attr" FILE,DRIVER('ODBC'),OWNER( ****** ),NAME('scendmedia/demo_repo."atl_parcel_attr"'),THREAD
06B1CH(3) 14:27:57.147 ATL:PARCELID BLOB
06B1CH(3) 14:27:57.147 ATL:MAILADDR BLOB
06B1CH(3) 14:27:57.147 ATL:CITY BLOB
06B1CH(3) 14:27:57.147 RECORD
06B1CH(3) 14:27:57.147 ATL:APPRVALUE LONG
06B1CH(3) 14:27:57.147 ATL:LANDAREA SREAL
06B1CH(3) 14:27:57.147 ATL:ZIPCODE LONG
06B1CH(3) 14:27:57.147 ATL:FIPS LONG
06B1CH(3) 14:27:57.147 END
06B1CH(3) 14:27:57.147 END
06B1CH(3) 14:27:57.147 
06B1CH(3) 14:27:57.147 GET_PROPERTY(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Time Taken:0.01 secs
06B1CH(3) 14:27:57.147 GET_PROPERTY(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:57.147 GET_PROPERTY(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:57.147 GETNULLS(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Error: File Not Open Time Taken:0.00 secs
06B1CH(3) 14:27:57.147 GET_PROPERTY(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:57.147 GET_PROPERTY(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:57.148 GET_PROPERTY(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:57.148 GET_PROPERTY(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:57.148 GET_PROPERTY(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:57.148 GET_PROPERTY(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:57.148 GET_PROPERTY(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:57.148 GET_PROPERTY(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:57.148 GET_PROPERTY(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:57.148 GET_PROPERTY(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:57.148 GET_PROPERTY(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:57.148 GET_PROPERTY(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:57.148 GET_PROPERTY(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:57.148 AllocatingConnection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:57.148 Connecting to DSN=PostgreSQL35W Time Taken:1.11 secs
06B1CH(3) 14:27:58.257 Getting Functions for Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Getting Transaction capacity for Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Getting Transaction Isolation level Connection 0FA27880HIsolation level is 2 Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Setting Auto Commit ON for Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Getting Connection Information for Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Getting Correlation name support for Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Getting Connection Information for Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Getting Quote character for Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Getting Connection Information for Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Getting Qualifier Seperator for Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Getting Outer Join support for Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Getting number of statements per connection for Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Getting ODBC Version for Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Getting Connection Information for Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Getting Connection Information for Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Getting Connection Information for Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Getting Driver Name for Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Getting Connection Information for Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Allocating Statement 0FA27BC8H on Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Setting Asynchronous calling on for Statement 0FA27BC8H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Setting Asynchronous calling off for Statement 0FA27BC8H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Unknown Backend
06B1CH(3) 14:27:58.257 Maximum Statements per connection is 255
06B1CH(3) 14:27:58.257 Getting Connection Information for Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Getting list of key words Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Getting list of key words Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.257 Getting columns for scendmedia/demo_repo.atl_parcel_attr using Statement 0FA27BC8H Time Taken:0.14 secs
06B1CH(3) 14:27:58.400 Binding Column 4 to C type CHAR(129) for Statement 0FA27BC8H Time Taken:0.00 secs
06B1CH(3) 14:27:58.400 Fetching Row from Statement 0FA27BC8H Return Code: 0 Time Taken:0.00 secs
06B1CH(3) 14:27:58.400 Fetching Row from Statement 0FA27BC8H Return Code: 0 Time Taken:0.00 secs
06B1CH(3) 14:27:58.400 Fetching Row from Statement 0FA27BC8H Return Code: 0 Time Taken:0.00 secs
06B1CH(3) 14:27:58.400 Fetching Row from Statement 0FA27BC8H Return Code: 0 Time Taken:0.00 secs
06B1CH(3) 14:27:58.400 Fetching Row from Statement 0FA27BC8H Return Code: 0 Time Taken:0.00 secs
06B1CH(3) 14:27:58.400 Fetching Row from Statement 0FA27BC8H Return Code: 0 Time Taken:0.00 secs
06B1CH(3) 14:27:58.400 Fetching Row from Statement 0FA27BC8H Return Code: 0 Time Taken:0.00 secs
06B1CH(3) 14:27:58.400 Fetching Row from Statement 0FA27BC8H Return Code: 100 Time Taken:0.00 secs
06B1CH(3) 14:27:58.400 Unbinding Columns Statement 0FA27BC8H Time Taken:0.00 secs
06B1CH(3) 14:27:58.400 Closing Statement 0FA27BC8H Time Taken:0.00 secs
06B1CH(3) 14:27:58.400 OPEN(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Time Taken:1.25 secs
06B1CH(3) 14:27:58.400 GET_PROPERTY(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:58.400 SETNULLS(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Error: Invalid Field Type Descriptor Time Taken:0.00 secs
06B1CH(3) 14:27:58.400 VIEW(FILE)
  PROJECT(FIELD(1),FIELD(2),FIELD(3),FIELD(4))
END
GET_PROPERTY(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:58.400 GET_PROPERTY(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:58.455 SET_PROPERTY(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:58.455 SET_PROPERTY(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:58.456 GET_PROPERTY(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:58.456 GET_PROPERTY(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:58.456 OPEN(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:58.456 Setting Asynchronous calling off for Statement 0FA27BC8H Time Taken:0.00 secs
06B1CH(3) 14:27:58.456 BUFFER(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:58.456 BUFFER(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:58.456 SET_PROPERTY(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:58.456 SET_PROPERTY(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:58.456 SETview(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:58.456 GET_PROPERTY(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:58.456 SET_PROPERTY(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:58.456 GET_PROPERTY(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:58.456 SET_PROPERTY(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:27:58.456 Allocating Statement 0FA2DCE8H on Connection 0FA27880H Time Taken:0.00 secs
06B1CH(3) 14:27:58.456 Setting Concurrency to Read Only for Statement 0FA2DCE8H Time Taken:0.00 secs
06B1CH(3) 14:27:58.456 Setting Cursor Type to Forward Only for Statement 0FA2DCE8H Time Taken:0.00 secs
06B1CH(3) 14:27:58.456 Resetting Parameters Statement 0FA2DCE8H Time Taken:0.00 secs
06B1CH(3) 14:27:58.456 Preparing Statement 0FA2DCE8H : SELECT A.APPRVALUE, A.LANDAREA, A.ZIPCODE, A.FIPS FROM scendmedia/demo_repo."atl_parcel_attr" A Time Taken:0.00 secs
06B1CH(3) 14:27:58.456 Setting number of rows to fetch to 20 for Statement 0FA2DCE8H Time Taken:0.00 secs
06B1CH(3) 14:27:58.456 Describing Column 1 for Statement 0FA2DCE8H
06B1CH(3) 14:27:58.637 Error Occurred: S1000 LOG: QueryParsingError: Encountered exception when parsing query: <0AH>"SELECT A.APPRVALUE, A.LANDAREA, A.ZIPCODE, A.FIPS FROM scendmedia/demo_repo."atl_parcel_attr" A": syntax error at or near "/", at index 66;<0AH>No query has been executed with that handle
06B1CH(3) 14:27:58.638 Time Taken:0.19 secs
06B1CH(3) 14:27:58.638 Getting Auto-increment state for Column 1 for Statement 0FA2DCE8H Time Taken:0.06 secs
06B1CH(3) 14:27:58.703 Getting Searchable state for Column 1 for Statement 0FA2DCE8H Time Taken:0.08 secs
06B1CH(3) 14:27:58.772 Closing Statement 0FA27BC8H Time Taken:0.00 secs
06B1CH(3) 14:27:58.772 Setting Concurrency to Read Only for Statement 0FA27BC8H Time Taken:0.00 secs
06B1CH(3) 14:27:58.772 Setting Cursor Type to Forward Only for Statement 0FA27BC8H Time Taken:0.00 secs
06B1CH(3) 14:27:58.772 Resetting Parameters Statement 0FA27BC8H Time Taken:0.00 secs
06B1CH(3) 14:27:58.772 Preparing Statement 0FA27BC8H : SELECT APPRVALUE,LANDAREA,ZIPCODE,FIPS,PARCELID,MAILADDR,CITY FROM scendmedia/demo_repo."atl_parcel_attr" WHERE 0 = 1 Time Taken:0.00 secs
06B1CH(3) 14:27:58.772 Describing Column 1 for Statement 0FA27BC8H
06B1CH(3) 14:27:58.974 Error Occurred: S1000 LOG: QueryParsingError: Encountered exception when parsing query: <0AH>"SELECT APPRVALUE,LANDAREA,ZIPCODE,FIPS,PARCELID,MAILADDR,CITY FROM scendmedia/demo_repo."atl_parcel_attr" WHERE 0 = 1": syntax error at or near "/", at index 77;<0AH>No query has been executed with that handle
06B1CH(3) 14:27:58.974 Time Taken:0.20 secs
06B1CH(3) 14:27:58.974 Getting Auto-increment state for Column 1 for Statement 0FA27BC8H Time Taken:0.06 secs
06B1CH(3) 14:27:59.043 Getting Searchable state for Column 1 for Statement 0FA27BC8H Time Taken:0.06 secs
06B1CH(3) 14:27:59.109 NEXT(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) LOG: QueryParsingError: Encountered exception when parsing query: 
"SELECT APPRVALUE,LANDAREA,ZIPCODE,FIPS,PARCELID,MAILADDR,CITY FROM scendmedia/demo_repo."atl_parcel_attr" WHERE 0 = 1": syntax error at or near "/", at index 77;
No query has been execute Time Taken:0.65 secs
06B1CH(3) 14:27:59.109 ATL:APPRVALUE : 0
06B1CH(3) 14:27:59.109 ATL:LANDAREA: 0
06B1CH(3) 14:27:59.109 ATL:ZIPCODE : 0
06B1CH(3) 14:27:59.109 ATL:FIPS : 0
06B1CH(3) 14:28:07.637 SET_PROPERTY(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:28:07.637 SET_PROPERTY(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:28:07.637 SETview(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:28:07.637 CLEAR(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Time Taken:0.00 secs
06B1CH(3) 14:28:07.640 CLOSE(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:28:07.640 Freeing Statement 0FA2DCE8H Time Taken:0.00 secs
06B1CH(3) 14:28:07.640 GET_PROPERTY(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:28:07.641 GET_PROPERTY(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:28:07.641 SET_PROPERTY(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Time Taken:0.00 secs
06B1CH(3) 14:28:07.641 Freeing Statement 0FA27BC8H Time Taken:0.00 secs
06B1CH(3) 14:28:07.641 CLOSE(scendmedia/demo_repo."atl_parcel_attr":0F5805A4H) Time Taken:0.00 secs
06B1CH(3) 14:28:07.721 CLOSE(VIEW:11D01BC8:scendmedia/demo_repo."atl_parcel_attr":011D005A4H) Error: File Not Open Time Taken:0.00 secs
06B1CH(1) 14:28:12.334 Disconnecting Connection 0FA27880H Time Taken:0.00 secs
06B1CH(1) 14:28:12.334 Freeing Connection 0FA27880H Time Taken:0.00 secs
06B1CH(1) 14:28:12.335 Freeing Environment 0FA24AF0H Time Taken:0.00 secs

```

According to the [Bit.io](http://Bit.io) docs (linked above) it needs to be _“scendmedia/demo\_repo”.“atl\_parcel\_attr”_ but when I specify that full pathname it results in a “file not found”. When I don’t enclose _scendmedia/demo\_repo_ in quotes, the QueryParsingError appears.

Any clever insight into this?

---

<div class="post-metadata">

**Author:** ![FedericoNavarro](https://clarionhub.com/letter_avatar_proxy/v4/letter/f/2acd7d/32.png) [@FedericoNavarro](https://clarionhub.com/u/FedericoNavarro)\
**Post date:** [January 29, 2022, 10:26pm UTC](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810/13 "2022-01-29T22:26:03Z")

</div>

I’ve set up a test db at [bit.io](http://bit.io) and worked in that way

You can use it dsnless if you want.

And you could use a variable on Owner ID, like: !Glo:ConnectionString

Then set:

Glo:ConnectionString = ‘Driver={{PostgreSQL Unicode};[Server=db.bit.io](http://Server=db.bit.io);Port=5432;Database=“scendmedia/demo\_repo”;Uid=yourConnectionUser;Pwd=yourPassWord;’

---

<div class="post-metadata">

**Author:** ![seanh](https://clarionhub.com/letter_avatar_proxy/v4/letter/s/4af34b/32.png) [@seanh](https://clarionhub.com/u/seanh)\
**Post date:** [January 29, 2022, 11:40pm UTC](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810/14 "2022-01-29T23:40:21Z")

</div>

What version of the ODBC driver are you using? You might try updating that.  
The original message seemed to say it didn’t like the “/” in the schema, but that may be ODBC driver related.  
If possible try changing the schema to not have a slash

---

<div class="post-metadata">

**Author:** ![leroyschulz](https://clarionhub.com/user_avatar/clarionhub.com/leroyschulz/32/6200_2.png) [@leroyschulz](https://clarionhub.com/u/leroyschulz)\
**Post date:** [January 30, 2022, 2:31am UTC](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810/15 "2022-01-30T02:31:07Z")

</div>

> I’ve set up a test db at [bit.io](http://bit.io/) and worked in that way  
> You can use it dsnless if you want.

Did you get it working with or without DSN?

> And you could use a variable on Owner ID, like: !Glo:ConnectionString  
> Glo:ConnectionString = ‘Driver={{PostgreSQL Unicode};[Server=db.bit.io](http://server%3Ddb.bit.io/);Port=5432;Database=“scendmedia/demo\_repo”;Uid=yourConnectionUser;Pwd=yourPassWord;’

I did try that method before posting here. I’ll try again.

---

<div class="post-metadata">

**Author:** ![leroyschulz](https://clarionhub.com/user_avatar/clarionhub.com/leroyschulz/32/6200_2.png) [@leroyschulz](https://clarionhub.com/u/leroyschulz)\
**Post date:** [January 30, 2022, 2:34am UTC](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810/16 "2022-01-30T02:34:37Z")

</div>

> What version of the ODBC driver are you using? You might try updating that.

12.01.00.00

> The original message seemed to say it didn’t like the “/” in the schema, but that may be ODBC driver related.

I’ll try a newer version.

> If possible try changing the schema to not have a slash

[Bit.io](http://Bit.io) doesn’t appear to allow for that.

---

<div class="post-metadata">

**Author:** ![leroyschulz](https://clarionhub.com/user_avatar/clarionhub.com/leroyschulz/32/6200_2.png) [@leroyschulz](https://clarionhub.com/u/leroyschulz)\
**Post date:** [January 30, 2022, 2:59am UTC](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810/17 "2022-01-30T02:59:50Z")

</div>

> [@FedericoNavarro](#):
>
> Glo:ConnectionString = ‘Driver={{PostgreSQL Unicode};[Server=db.bit.io](http://Server=db.bit.io);Port=5432;Database=“scendmedia/demo\_repo”;Uid=yourConnectionUser;Pwd=yourPassWord;’

Two questions:

1. _scendmedia/demo\_repo_ is the schema, not the database. As shown in [Bit.io](http://Bit.io)’s connection info, the database is _bitdotio_. How would I specify the schema if I’m using a connection string?

2. Should the database parameter really be in double quotes like in your example above? For that matter, should the UID and password?

I’ve tried it both ways but I’m still not getting it to work.

---

<div class="post-metadata">

**Author:** ![leroyschulz](https://clarionhub.com/user_avatar/clarionhub.com/leroyschulz/32/6200_2.png) [@leroyschulz](https://clarionhub.com/u/leroyschulz)\
**Post date:** [January 30, 2022, 4:23am UTC](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810/18 "2022-01-30T04:23:18Z")

</div>

> [@seanh](#):
>
> What version of the ODBC driver are you using? You might try updating that.

I just updated to 12.02.00.00, using the installer that [Bit.io](http://Bit.io) links to. That didn’t make a difference. Same errors as with the older version.

So here’s where I’m at:

- _scendmedia/demo\_repo.“atl\_parcel\_attr”_ connects but the query doesn’t work.
- _“scendmedia/demo\_repo”.“atl\_parcel\_attr”_ is what should be used for the query to work, but when that’s the path name is specified the connection fails with a “file not found” error.

Any other ideas?

---

<div class="post-metadata">

**Author:** ![seanh](https://clarionhub.com/letter_avatar_proxy/v4/letter/s/4af34b/32.png) [@seanh](https://clarionhub.com/u/seanh)\
**Post date:** [January 30, 2022, 9:00am UTC](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810/19 "2022-01-30T09:00:03Z")

</div>

How about “scendmedia/demo\_repo.atl\_parcel\_attr” ?

---

<div class="post-metadata">

**Author:** ![seanh](https://clarionhub.com/letter_avatar_proxy/v4/letter/s/4af34b/32.png) [@seanh](https://clarionhub.com/u/seanh)\
**Post date:** [January 30, 2022, 9:02am UTC](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810/20 "2022-01-30T09:02:34Z")

</div>

Find way more up to date versions here:  
[https://www.postgresql.org/ftp/odbc/versions/msi/](https://www.postgresql.org/ftp/odbc/versions/msi/)  
Latest they have is 13.02

[Next page](https://clarionhub.com/t/postgresql-error-queryparsingerror-at/4810.md?page=2)