Contact the VFP database under DOTNET

xiaoxiao2021-03-06  52

A few days ago, I saw some netizens asked. Net how to connect with FoxPro, tested yesterday, found that the direct connection is really bad, so the DSN connection method is used.

1. First create a user DSN in the system, the driver selects Microsoft Visual FoxPro Driver, specifies the database file .dbc path, take the DSN name GBK (name as needed);

2. Open the VS.NET 2003, open the server resource manager, the leftmost retractable toolbar, click the data connection to click, click Add Connection, the driver selects "Microsoft Ole DB Provider for ODBC Drivers", then select appropriate Data source, here is GBK (the name you take), then click the Test Connection button to display the test connection success.

Obcconnection

Connection string "BackgroundFetch = YES; DSN = GBK; UID =; source = machine; source = machine; sourcedb = c: // Documents and settings // Wu Zhenjiang // my documents // Visual Studio Projects // jlgz // BIN / / DEBUG / / GBK.DBC; Exclusive = NO ";

转载请注明原文地址:https://www.9cbs.com/read-83229.html

New Post(0)