ADO connection

[jluet]

I'm accessing a SQL server database with a ADO connection.

I can open the first table, but when I try to connect to a second table, I get a timeout error, even increasing it to 60 seconds.

Any suggestions, or is there another connection component I can use w/Delphi 2006?

Thanks
John

 

[roo0047]

The 1st thing I'd look at is the table name spelling and case.

Roo
Delphi Rules!

 

[Opieo]

I would also like to suggest looking at the KeepConnected property. Was the connection to the first table left open while trying to open the second?

~
“Your request is not unlike your lower intestine: stinky, and loaded with danger.” — Ace Ventura.