General information
Category:
Coding, syntax & commands
Title:
Sharing Connection from TWO DBC
We are using an old MS SQL database (ver. 6.5) that is sensitive to resource taken up by "connections." Recently, I created a VFP9 application that contains two different DBC's. One DBC contains queries that are unique to the application and the other DBC contains queries that are general to many applications. Although I have each query set to "Share" in both DBC's, I just noticed that each DBC requires a connection to the SQL server. Is there anyway to get two DBC's to share the same connection? Also, I just noticed that the "name" of the connection in the two DBC's are slightly different. Would it make any difference if I renamed them the same name or is this an issue because each DBC establishes its own connection.
I realize I can copy the queries from one DBC into the other DBC and then I would have all queries in just one DBC and thus get down to just one "shared connection." But, that would defeat the reason they were separted into two DBC's in the first place which was to keep a master DBC of common queries for multiple applications.
Thanks,
Robert
Next
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