Sybas IQ Database Connection
显示 更早的评论
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
2021-4-23
Hi,
What is you MATLAB version ?
databaseConnectionOptions has been introduced in 2020b.
回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息
2021-1-28
2021-4-23
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
