Sybas IQ Database Connection

3 visualizzazioni (ultimi 30 giorni)
Tareq Rahmani
Tareq Rahmani il 28 Gen 2021
Commentato: Amrtanshu Raj il 23 Apr 2021
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 Commento
Amrtanshu Raj
Amrtanshu Raj il 23 Apr 2021
Hi,
What is you MATLAB version ?
databaseConnectionOptions has been introduced in 2020b.

Accedi per commentare.

Risposte (0)

Community Treasure Hunt

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

Start Hunting!

Translated by