Hey everyone, I have run into some issues while connecting to Teradata through .NET
It's my understanding that .NET doesn't maintain a single connection to Teradata, it might open several connections when querying the database. This isn't a problem until I start using volatile or global temp tables. If I don't execute all the commands within the same sql statement, then it will not recognize the volatile table.
Is there any way to force .NET to only open one connection, and maintain that connection throughout the life of the connection? I've tried messing with the connection pooling properties, but still haven't been sucessful. Has anyone had any luck with this?