Creating multiple connections to a database using loops- Database toolbox.

Question

daniel.x16 2011-5-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/8538-creating-multiple-connections-to-a-database-using-loops-database-toolbox

Hi,

I am trying to create multiple connections to a database for a program I am writing to graph data from different databases next to eachother.

The basic command to connect to a database is:

conn=database(database_name,'IP Address','Password')  
datbase_name is the name of the database
and IP Address and Password must be enclosed in single quotes.

What I am trying to do is basically (for a variable number n...a user can input how many databases he wants to connect to. I have all the database names in a matrix called DB_name...so I want DB_name(i) to call the i-th entry)

 for i=1:n
conn(i)=database(DB_name(i),'192.168.94.94','password')
end

However, this does not work. I am not entirely sure why it doesn't. I have been looking all through the forums, and have been unable to get any of the solutions to work with my problem.

I can do it with a ton of 'for' statements, this is impractical, and I want to do it with a loop to make sure I can support any number of database name entries.

Any help would be greatly appreciated!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2011-5-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/8538-creating-multiple-connections-to-a-database-using-loops-database-toolbox#answer_11752

You probably need DB_name{i} instead of DB_name(i)

Though possibly you want DB_name(i,:)

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

daniel.x16 2011-5-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/8538-creating-multiple-connections-to-a-database-using-loops-database-toolbox#answer_11759

在 MATLAB Online 中打开

This sort of works...now I have:

for i=1:n
    conn{i}=database(DB_names{i},'localhost','')
end

But instead of making conn1,conn2,conn3....connn, it just makes 'conn', as a 1 by n cell. (Basically it puts each connection in ONE matrix, I want it in n matrices.) How can I make conn1, conn2,...connn?