Data Access Worldwide Knowledge Base
Article ID 2132 Article Title INFO: What determines the "default" database for a workspace in VDF? Article URL http://www.dataaccess.com/kbasepublic/KBPrint.asp?ArticleID=2132 KBase Category VDF11 Date Created 06/12/2005 Last Edit Date 06/20/2005
Article Text
QUESTION:
As of Visual DataFlex 11.0, a workspace can have a "default" database, and some of Database Builder's menus and dialogs change depending on the "default" database, to make it easier and more intuitive to work with. How does VDF determine what the default database for a workspace is?
ANSWER:
If you created the workspace using VDF 11.0 or higher, the DDSrc folder of the workspace will contain a file named connection.ini. This file contains numerous tags in square brackets [for example]. The top most tag is [Connection] and it contains a DriverName= line.
For example, a connection.ini file in a workspace that has MS SQL as its default database starts with this information:
[Connection]
DriverName=MSSQLDRV
To use ODBC as default driver, use:
[Connection]
DriverName=ODBC_DRV
To use the embedded database as default driver, use:
[Connection]
DriverName=DATAFLEX
If the file does not exist, because the workspace is from an older VDF revision than 11.0, you can copy this file from one of the sample workspaces or simply create a new one.
Email this Article
Email this Article to a Colleague
Send Feedback on this Article to Data Access Worldwide
Copyright ©2010 Data Access Corporation. All rights reserved.
The information provided in the Data Access Technical Knowledge Base is provided "as is" without warranty of any kind. Data Access Corporation disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. In no event shall Data Access Corporation or its suppliers be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages, even if Data Access Corporation or its suppliers have been advised of the possibility of such damages. Some states do not allow the exclusion or limitation of liability for consequential or incidental damages so the foregoing limitation may not apply.