PostgreSQL error QueryParsingError at "/"

leroyschulz · January 28, 2022, 1:02am

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.

Any ideas to troubleshoot this?

totalhip · January 28, 2022, 2:39am

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

totalhip · January 28, 2022, 2:56am

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

seanh · January 29, 2022, 11:24am

As per Skype I think you need to put " around the schema
so
“scendmedia/demo_repo”.atl_parcel_attr

leroyschulz · January 29, 2022, 6:13pm

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?

leroyschulz · January 29, 2022, 6:31pm

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

Here’s what the dictionary importer specified.

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/, 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).
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 account. It’s free and only takes a couple of minutes to set up.

Any ideas would be appreciated.

totalhip · January 29, 2022, 7:26pm

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 .

leroyschulz · January 29, 2022, 8:28pm

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, “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?

FedericoNavarro · January 29, 2022, 8:46pm

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

totalhip · January 29, 2022, 9:12pm

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.

leroyschulz · January 29, 2022, 9:19pm

(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, 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.

leroyschulz · January 29, 2022, 9:35pm

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 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?

FedericoNavarro · January 29, 2022, 10:26pm

I’ve set up a test db at 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;Port=5432;Database=“scendmedia/demo_repo”;Uid=yourConnectionUser;Pwd=yourPassWord;’

seanh · January 29, 2022, 11:40pm

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

leroyschulz · January 30, 2022, 2:31am

I’ve set up a test db at 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;Port=5432;Database=“scendmedia/demo_repo”;Uid=yourConnectionUser;Pwd=yourPassWord;’

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

leroyschulz · January 30, 2022, 2:34am

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 doesn’t appear to allow for that.

leroyschulz · January 30, 2022, 2:59am

Two questions:

scendmedia/demo_repo is the schema, not the database. As shown in Bit.io’s connection info, the database is bitdotio. How would I specify the schema if I’m using a connection string?
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.

leroyschulz · January 30, 2022, 4:23am

I just updated to 12.02.00.00, using the installer that 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?

seanh · January 30, 2022, 9:00am

How about “scendmedia/demo_repo.atl_parcel_attr” ?

seanh · January 30, 2022, 9:02am

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