Development platform is Windows 7 + original concept (64 bits) in the use of ODBC connection Access (32 bit) or SQL Anywhere is always wrong,
But the same Code in XP normal! In W_main code below
//Profile NorthwindPB
The SQLCA. DBMS="ODBC"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm="ConnectString='DSN=northwind; UID=; The PWD=& lt; * * * * * * & gt; '
"
If the SQLCA. Sqlcode<> 0 then
Messagebox (" notice!" , "the connect error")
End the if
Program is running procedure defined in the error message pop-up results,
Even in the DataBase in the painter using ODBC Administrator to create a DSN also will go wrong,
See not solve in Microsoft's official 32-bit ODBC and 64 - bit ODBC compliant,
Excuse me is there a solution to a third party to circumvent this problem!

CodePudding user response:

If the SQLCA. Sqlcode<> 0 then
Messagebox (" notice!" The sqlca. Sqlerrtext)
End the if

Through the above code can know the location of the error,
If want to use ODBC Administrator in the database drawing board, try right-click to administrators run
In the DataBase using ODBC Administrator in the painter to create a DSN also will go wrong,

CodePudding user response:

Not a permissions problem, your code is helpful to me, thank you!

CodePudding user response:

What is the meaning of original concept (64 bit)? PB.Net 12.5 to support 64 - bit applications, and 64 DB connection only support ADO.Net.