How to connect an AWS PostgreSQL database with Database Toolbox?

4 次查看（过去 30 天）
Tim Szostakowski
Tim Szostakowski 2018-5-23
回答： Shrestha Kumar 2018-6-4
Hi everyone, I want to connect to my database located in AWS. I have a username and password, the host (something like "193.178.11.1"). If I try the line
datasource = "dev"; username = "myusername"; password = "xyz123%";
url = "193.178.11.1"; driver = "";
conn = database(datasource, username, password, driver, url)
and then type
conn.Message
I get the following message:
'No suitable driver found for 192.168.10.1dev'
Can anyone help please?

请先登录，再回答此问题。

回答（1 个）

Shrestha Kumar
Shrestha Kumar 2018-6-4
Hi,
It seems that you haven't installed the driver for the postgresql database. You can find all the drivers for different databases here - https://in.mathworks.com/help/database/ug/configuring-driver-and-data-source.html.
After installing the driver you can access the database with command -
conn = database('dbname','username','pwd', ... 'Vendor','PostgreSQL', ... 'Server','sname');

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by