In the Clarion documentation it refers to the “ODBC Join Test” as one of the examples. I have installed the examples for C9, C10 and C11 and not found the example. See odbc_join_test.htm [Clarion Community Help] which is a copy of the relevant help entry. It refers to a folder called "\ (CLARION RO…

Same error message, but without the word “public.” :scream: Thank you to everyone who contributed. I have learnt a lot in the process. :clap: :clap: :clap: I have given up trying to do this without FM3. I have succeeded with FM3. [mptable3] I changed glo:pgconn to STRING(1024) and removed the i…

Thanks Mike, I have the correct connection string, but can’t figure out which field to put it in, in the dictionary’s table definition: Driver Options: ? Owner Name: ? Full Path Name: ? None of the examples I could find help me figure this out. The closest I could find is in FM3 documentation, b…

Donn, Set driver to ODBC. Put your driver string in a configuration ini file. Load your global variable with the driver string from the ini. Make it easy on yourself and use lowercase for PG - ie customers.

[image] DonnEdwards: Driver Options: ? Owner Name: ? Full Path Name: ? So I leave all of it blank? Don’t I need to put the global variable somewhere? I created glo:pgconn as a global variable and set its initial value to 'DRIVER=PostgreSQL Unicode; SERVER=127.0.0.1; PORT=5432; DATABASE=ni…

Put global variable in the owner name. Full path name is the PG schema.tablename. I encourage the use of schemas once you get going.

…and I assume you have indeed installed the PG ODBC driver. BTW - a final caution: Once working, you will never want to think about tps again.

[image] DonnEdwards: It refers to a folder called "\ (CLARION ROOT) \EXAMPLES\ODBCJOIN " but it is nowhere to be found. Did it change its name? I attached that example from CW20. On these old APPs you must set a Project Target (EXE) name or you’ll get error "Either the Sources list must conta…

[image] totalhip: I assume you have indeed installed the PG ODBC driver. Yes indeed, and I have tested it to ensure it works. [image] totalhip: Once working, you will never want to think about tps again. I certainly hope so :grin:

This is weird. I have removed all references to FM3 Version numbers on my table definitions in the DCT. Here is the Global definition for glo:pgconn [pgconn1] [pgconn2] Here are my two tables, as seen by pgAdmin III: [pgsql] Here are the table properties for mediapad (mp) [mptable] and fo…

[image] CarlBarnes: I attached that example from CW20 Many thanks. From the example I noticed that they define the tables slightly differently [joindct] So what part goes into the glo:DriverString and what part goes into the DataSource ?

ClarionHub

ODBC Join Test Example

questions

odbc, postgresql

Mike_Duglas May 19, 2021, 9:35am 2

connectionstrings.com

PostgreSQL ODBC Driver (psqlODBC) Connection Strings - ConnectionStrings.com

Connection Strings using psqlODBC for connections to PostgreSQL.

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled