How to connect an AWS PostgreSQL database with Database Toolbox?
조회 수: 7 (최근 30일)
이전 댓글 표시
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?
댓글 수: 0
답변 (1개)
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');
댓글 수: 0
참고 항목
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!