General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Jon -
I wound up creating four different DSN's, each pointing to a different DBC, and the problems went away.
I was just trying to simplify things by pointing to the tables as files in a "Free Table Directory". I did not realize that the ODBC driver would hang onto the .DBC's if I did that.
Thanks for your help.
- George
>>These are tables in .DBC's. They aren't Free Tables. The DSN points to a "Free Table directory".
>>
>>Maybe I'll try setting up several DSN's. It's just that I have tables in 4 different .DBC's being used, and having 4 different DB objects in my script is harder to maintain.
>
>George,
>
>Maybe I'm missing something here, but I don't understand why you have the DSN pointing to a Free Table directory if the tables are part of a database container..? If you are referencing different DBCs at the same time, then I'm pretty sure you will need an ODBC DSN for each one since the DSN can only point to one database container at a time.
>
>Laterness,
>Jon
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only