Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP6SP5, programatically setup ODBC to DBCs
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00715393
Message ID:
00715436
Views:
24
>Sorry didn't read you're reply properly. What is DSN-Less connection and how can I proceed with it? Any pros and cons?
>
You create connection string in your program, for example
lcConnStr = "DRIVER=Microsoft Visual FoxPro Driver;" + ;
    "SourceType=DBC;" + ;
    "SourceDB=C:\Program Files\Microsoft Visual FoxPro 7\Samples\Data\testdata.dbc"
lnConn = SQLSTRINGCONNECT(lcConnStr )
Pros: You don't have to create DSN's on user PC's.
Cons: The connection parameters are stored in your application. So it's better to store themv in some kind of configuration file.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform