Error using database.j​dbc.connec​tion/selec​t (line 74) Invalid connection.

5 次查看（过去 30 天）
Oleh Chaharyn
Oleh Chaharyn 2019-5-2
回答： Bob Hickish 2020-5-18
I can't connect to database using jdbc driver:
Error using database.jdbc.connection/select (line 74)
Invalid connection.
I tried to reinstall driver, updated javaclasspath but it doesn't work.
Is there any solution?

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

回答（1 个）

Bob Hickish
Bob Hickish 2020-5-18
I'm not sure if we had the same issue, but I managed to resolve mine by using these three functions in this order:
opts = configureJDBCDataSource('Vendor','PostgreSQL')
opts = setConnectionOptions(opts,"DataSourceName","PostgreSQL",..)
conn = database(databasename,username,password,driver,url)
I then checked I was connected to the database with: isopen(conn)

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by