Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connection String DBC Question
Message
From
26/11/2008 13:13:38
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Connection String DBC Question
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows NT
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01364238
Message ID:
01364238
Views:
78
In the past, I've created DSN connections and created a reference to the DSN in the "connections" section of the Project/Database. However, I have recently started using "connection strings" instead of a DSN stored on the local computer. I have figured out that the connection string info gets saved in the DBC. I have been able to locate the string info in the "Property" memo field, if I USE the DBC. However, I see that the data is compiled in some way and is not just plain text.

I would like to put the connection string info in a table and have the application check for changes in the .DBF to see if anything has changed from what is stored in the "Property" memo field and, if it has, update the "propery" field. My question is this: Am I going to run into problems if I try change (udate) this compliled data programically in the DBC. Any "hints" or "gotchas" on how to do this?

Thanks,
Robert Wright
Next
Reply
Map
View

Click here to load this message in the networking platform