Multiple .NET ODBC Commands

[cosmoh2o]

Please help,

I am building a program that connects to a separate server for a database through .NET ODBC. Is it possible to use a single OdbcConnection object with different OdbcCommand objects on the same database? For example: I connect to the database using OdbcConnection1 and execute a reader object through OdbcCommand1. Next, I create OdbcCommand2 using the same OdbcConnection1 (I didn't "close" the ODBC Connection after the previous command object was executed)and execute another reader object. Finally, I close the connection to OdbcConnection1.

I would like to use an inner join but don't believe this is possible since the database I am pulling from is not properly normalized.

Thanks to anyone who knows this answer, and I appologize if it is overly simple but I am new to .NET ODBC.

 

[chiph]

Yes, you can run multiple command objects against a single connection object.

I'm not sure if I can help with your inner-join question -- that's more of an application design question, which will depend on your table design.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[cosmoh2o]

Thank you ChipH.