I wrote a program, using pb9 is SQL server2000 database through the odbc connection, compiled into. Exe can be run normally, then I have to some of the DLL file copy to this folder, other modules in the program running normally, but there is a window of data retrieval results appear garbled (shows a lot of blade passages for etrive, etsqlselect record), but it is not an error,

The analysis process is as follows:
1, the data retrieval and elsewhere are used to settrans, setsqlselect, retrieve, by setting different SQL statements to implement retrieval in different conditions, the only difference is there in the union connections two SQL statements, however, is not the problem in the development environment runtime, the SQL statement should be no problem, take the SQL statements to the SQL server running results also right,

2, I tried it on all the DLL file folder, as long as the folder pbodb90. DLL, delete programs you can run normal (of course, the machine has a pb environment, program under the installation directory of pb can still find pbodb90. DLL),

Through the above analysis, I baffled, hope expert advice,

CodePudding user response:

Pbodb90. DLL is used for data exchange odbc interface, should be must,
You try, the DLL or exe files related copy to another without pb under the environment of running, see the effect, pay attention to take pbodb90. DLL this file,
I once met one problem is that in the development environment of the machine, compiled into an executable file, directory have pbvm90. DLL this file, opened the illegal operation, is normal after deletion,
Estimation is a search path for executable files,

CodePudding user response:

Upstairs, I tried to put the DLL or EXE file copy to PB environment, the problem is still, still showed garbled, of course, if delete PBODB90 DLL, runtime error,

CodePudding user response:

Pb9 SQL Server2000, why want to use the ODBC connection with direct or OLE DB is not better

CodePudding user response:

Upstairs, because some client is not installed on the SQL SERVER database connection driver,
PB9 how to use the OLEDB connection SQL SERVER2000 to have excuse me?

CodePudding user response:

Are all very good advice! Worth learning