Sybas IQ Database Connection
    3 views (last 30 days)
  
       Show older comments
    
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 Comment
  Amrtanshu Raj
    
 on 23 Apr 2021
				Hi,
What is you MATLAB version ?
databaseConnectionOptions has been introduced in 2020b.
Answers (0)
See Also
Categories
				Find more on Database Toolbox in Help Center and File Exchange
			
	Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
