Hi Everyone, please assist me here
I have a database table Liverpool in Postgresql which contains names,number, surname and it is populated.
I then downloaded the ODBC File from CData for postgreSQL
I added the activity connect to database and in configure connection under Data Source I selected “Microsoft ODBC Data Source” and in details under Data Source Specification I entered “CData PostgreSQL Source” I then entered uer name and password fields.
When I tested the connection Test was successful.
I added Run query, Output Data Table, Write Line
under run query i inputed “Select * from Liverpool”
Now when I run this I get the error:
Run query: ERROR [HY000] Server error [SQL state: 42P01]: relation “liverpool” does not exist (Character 15)