Creating multiple connections to a database using loops- Database toolbox.
7 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Akzeptierte Antwort
Walter Roberson
am 31 Mai 2011
You probably need DB_name{i} instead of DB_name(i)
Though possibly you want DB_name(i,:)
0 Kommentare
Weitere Antworten (1)
daniel.x16
am 31 Mai 2011
1 Kommentar
Walter Roberson
am 31 Mai 2011
Please do not do that. Please read this FAQ:
http://matlab.wikia.com/wiki/FAQ#How_can_I_create_variables_A1.2C_A2.2C....2CA10_in_a_loop.3F
Siehe auch
Kategorien
Mehr zu Matrix Indexing finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!