MATLAB: Am I unable to connect to PostgreSQL database when using the DATABASE command in Database Toolbox 3.5.1 (R2009a)

Database Toolboxpg

When I try to use the DATABASE command in Database Toolbox 3.5.1 (R2009a), to connect to my PostgreSQL database, I get the following error:

 Fatal error: Missing or erroneous PG_HBA.CONF file, see server log for details.

Best Answer

There is a possiblilty that the above mentioned configuration file is corrupt. Verify that you are able to connect to the database using PSQL.

You may need to consult the PG SQL manual to verify that your pg_hba.conf file contains appropriate entries. Here is the documentation for PostgreSQL 8.1.17:

http://www.postgresql.org/docs/8.1/interactive/client-authentication.html

Related Solutions

MATLAB: Am I unable to create an SSL connection to a database using Database Toolbox 3.0 (R14)

This enhancement has been incorporated in Release 14 Service Pack 3 (R14SP3). For previous product releases, read below for any possible workarounds:

This error may be caused by incorrect syntax. When using the DATABASE command with additional variables in the URL, be sure to append an ampersand (&) to the end of the URL as shown in this example:

conn = database('dbname','username','password','org.postgresql.Driver','jdbc:postgresql:servername:dbname:ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory&');

MATLAB: Do I receive an error regarding “Too Few Parameters” when using the Database Toolbox 3.5.1 (R2009a) to work with an MS Access database

This error message is returned by the ODBC driver for the MS Access database. It indicates that the column you are trying to access in the table does not exist. Additional information regarding this error message may be found at the following location:

https://support.microsoft.com/en-us/help/867225/-microsoft-odbc-text-driver-too-few-parameters--expected-1

You may also receive this error message when using double quotes instead of single quotes in a WHERE clause. For example:

Incorrect SQL statement:

SELECT * FROM myTable WHERE myField="Hello World"

Correct SQL statement:

SELECT * FROM myTable WHERE myField='Hello World'

Best Answer

Related Solutions

MATLAB: Am I unable to create an SSL connection to a database using Database Toolbox 3.0 (R14)

MATLAB: Do I receive an error regarding “Too Few Parameters” when using the Database Toolbox 3.5.1 (R2009a) to work with an MS Access database

Related Question