Home > database >  Pb foxpro via the odbc connection problem
Pb foxpro via the odbc connection problem

Time:09-30

The odbc data source: bw3000
Connection configuration:
//Profile bw3000
The SQLCA. DBMS="ODBC"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm="ConnectString='DSN=bw3000; UID=dba; The PWD=SQL ', CommitOnDisconnect='No' "

In the pb database profiles in connection tip: the catalog tables could not be created are not available for use
(hint the connection is successful, table can be queried, can't modify/delete)

At runtime the sqlca. Sqlcode=1
The sqlca. Sqlerrtext=DBMS ODBC is not supported in your current installation

Development environment: pb9.0 \ foxpro6.0

Do you have any questions consult everybody greatly, the connection Settings? Why will prompt error above? How to operate?

CodePudding user response:

If the odbc configuration is wrong, choose wrong driver

CodePudding user response:

Reply to the second floor, should not, I all machines on foxpro data sources are tried, the same, the data source is as follows:
Microsoft Visual FoxPro Driver pare said o
Microsoft FoxPro VFP Driver (*. DBF)
Microsoft Visual FoxPro Driver
Microsoft Visual FoxPro - Treiber
All four above experiments, the prompt information

CodePudding user response:

Want to know what the problem is the friend help me reply, thank you!
  • Related