Sybas IQ Database Connection

2 次查看（过去 30 天）
Tareq Rahmani
Tareq Rahmani 2021-1-28
评论： Amrtanshu Raj 2021-4-23
Hi all
How can I connect to Sybase IQ DB from Matlab script: i did the below :
vendor = "Sybase IQ";
opts = databaseConnectionOptions("jdbc",vendor);
opts = setoptions(opts,"DataSourceName","TeDIKWESE", "JDBCDriverLocation", "F:\jtds.jar", "DatabaseName","netview2_w19", "Server","172.29.44.4","PortNumber",29887 ) ; %%"AuthenticationType","Windows","loginTimeout","20","encrypt","false"
username = "";
password = "";
status = testConnection(opts,username,password);
saveAsDataSource(opts)
datasource = "TeDIKWESE";
username = "nethouse";
password = "AdsCommon__2016";
conn = database(datasource,username,password); %% *conn = database(databasename,username,password,driver,url)
selectquery = sprintf('tatata');
M2 = select(conn,selectquery); %%% M2 is a table
close(conn);
i got the below error :
Undefined function 'databaseConnectionOptions' for input arguments of type 'string'.
  1 个评论
Amrtanshu Raj
Amrtanshu Raj 2021-4-23
Hi,
What is you MATLAB version ?
databaseConnectionOptions has been introduced in 2020b.

请先登录，再进行评论。

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

回答（0 个）

类别

在 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