Creating multiple connections to a database using loops- Database toolbox.
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposta accettata
Walter Roberson
il 31 Mag 2011
You probably need DB_name{i} instead of DB_name(i)
Though possibly you want DB_name(i,:)
0 Commenti
Più risposte (1)
daniel.x16
il 31 Mag 2011
1 Commento
Walter Roberson
il 31 Mag 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
Vedere anche
Categorie
Scopri di più su Matrix Indexing in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!