The first figure query results right



The second picture the query results all disorderly fall


The same client, same operating system is winxp (), the server database is SQL server 2008 R2
Find a lot of information all have no result, want to a number of ways, may have, please the great god glad,

CodePudding user response:

This is a standard DBGrid GRID control or other?
If a code in the field ongettext events, check out the

In addition, the operating system SQLCLI linker will update to can connect SQL2008R2 SQLCLI version of the database,

CodePudding user response:

added: two tables are using select * from table name, but the second one is missing in the table "proportion of annual fee" field

CodePudding user response:

reference 1st floor doloopcn response:

this is a standard DBGrid GRID control or other?
If a code in the field ongettext events, check out the

In addition, the operating system SQLCLI linker will update to can connect SQL2008R2 SQLCLI version of the database,

Is the Delphi dbgrid, no code, the determining ongettext SQLCLI is that version, after all, most of the clients are good, just 2 sets have this problem, two (2) in the same room, use the same version of the operating system, that is to say, the network structure and the operating system version number is the same,

CodePudding user response:

Try my resources SQLCLI and VC patches, look can fix your problem

CodePudding user response:

reference 4 floor doloopcn response:

try my resources SQLCLI and VC patches, look can fix your problem

What is the relationship between this VC patch?

CodePudding user response:

Very sympathetic to your situation, but not much, no good advice,

Image from the previous year, the field appears disorder, a bit like a transmission error, the possible reasons:
1, the operating system;
2, the problem of MSSQL server drive; (most likely)
3, Delphi procedure problem,
4, Midas Socket transmission problem,

Suggest you can change the machine a try,

CodePudding user response:

reference 4 floor doloopcn response:

try my resources SQLCLI and VC patches, look can fix your problem

Hit you gave me the patches, also still won't do, I feel good,,

CodePudding user response:

refer to 6th floor lyhoo163 response:

very sympathetic to your situation, but is not much, no good advice,

Image from the previous year, the field appears disorder, a bit like a transmission error, the possible reasons:
1, the operating system;
2, the problem of MSSQL server drive; (most likely)
3, Delphi procedure problem,
4, Midas Socket transmission problem,

Suggest you can change the machine a try,

I think is also unlikely to be a driver MSSQL server problem, because other clients are good, there is two problems,

CodePudding user response:

2. The problem of MSSQL server driven; (most likely)

I think because use datasnap possibility is almost zero

CodePudding user response:

There are problems of computer try reinstall the operating system

CodePudding user response:

You can show come out to see the data before and dbgrid binding,
I think it's about code issues.

CodePudding user response:

Just think:
Midas. DLL
If this thing at work,
The compilation of computer Midas. Copy the DLL to run the client directory or Windows corresponding directory, and have a look

CodePudding user response:

No Midas. DLL, can't transfer data, it should not be its problem,

CodePudding user response:

Don't use datasnap, remote direct and see if it is garbled,

CodePudding user response:

Refer to the
http://stackoverflow.com/questions/1145689/delphi-6-with-ado-oracle-returns-number-with-different-precision-generating-b

CodePudding user response:

Should be operating system interface and MSSQL characters on the proposal, and MSSQL try reinstall the system,

CodePudding user response:

Middle layer to data, to save to a file, import the document on the client, see if there are any problems, I think the possibility of operating system is large, Midas. DLL this file version problem is bigger,