Fractional Truncation????

[scotttom]

Hello,

I am connecting to a SQL 2000 server using ODBC from an access front end. Upon insert for certain clients (not all) I get the following error.

ODBC--insert on a linked table 'tblProjects' failed.

[Microsoft][ODBC SQL Server Driver]Fractional truncation (#0) [Microsoft][ODBC SQL Server Driver]Fractional truncation (#0) [Microsoft][ODBC SQL Server Driver]Timeout expired (#0)



I'm stumped and any help would be greatly appreciated.

Thanks in advance.

Scott

 

[SQLSister]

what is you insert statement and what is the data structure including datatypes of the table involved?

"NOTHING is more important in a database than integrity." ESquared

 

[scotttom]

INSERT INTO tblProjects ( Project, Enc, [Date], CID, Product, Line, PM, PO, MID, STATUS, SalesPerson, ProjectedDollars, MaterialFrom, PORecieved, UpdBy, Upd ) SELECT '200.1319', '', '7/23/2007', '521', "Test", '553A1', 'GL', '40861', '200', 'New', 'st', '1', 'Customer', '7/23/2007 1:40:11 PM', 'st', '7/23/2007 1:40:11 PM';

Never a problem until Thursday of last week.

CRAZEE

THanks for your help.

Scott

 

[SQLDenis]

>>Timeout expired

any network problems?

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[bborissov]

I see two problems here, but maybe they are just copy and paste one, not what happens in real:
SELECT ...,"Test"...
should be:
SELECT ...,'Test'...

What type is tblProjects.Project field?

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[scotttom]

tlProjects.Projects is a varchar. "TEST" work on some, but not others.......SQLDennis you might be onto something.... the users who seem to having problems are remote users on a site to site VPN to the server......

I suppose I could just convert this to a sp, and that actually might be best, but If there is another way I'd like to know how for reference.

Thanks very much for the help.

Scott

 

[bborissov]

TEST" should work there where SET QUOTED_IDENTIFIER is OFF.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[scotttom]

Sorry, what I meant to say is that I don't think the "TEST" is the problem because it works in some (local) clients.

Thanks,

Scott

 

[scotttom]

Ok so now this has happened on the LAN and on the VPN. The exact same query works and then does not work. What could possible be the cause of that? Which suggests that it is not a connectivity issue.

Thanks in advance for your help.

Scott

 

[Rofeu]

Hi,

could it be because of settings? Maybe thousands- and decimalseperators that are switched or EU vs US dates?

Cheers,

Roel

 

[scotttom]

Hi Rofeu,

Thanks for the reply, but if it were a settings issue wouldn't it be a consistent error?

Scott

 

[Rofeu]

I read 'remote users' and '(local) clients'. Settings was the first thing that came to mind.

Cheers,

roel

 

[scotttom]

Right. Me too. But the same user running essentially the same query has variable results. This one is giving me agita!!!

thanks for any guidance.

 

[Rofeu]

The values in your SELECT as per your posted SQL are static?

 

[scotttom]

essentially.... I am just incrementing the project field.

 

[Rofeu]

How is that done? Could it be that that fails and you run into unique constraint?

 

[scotttom]

I'm doing it manually for testing. It looks like the problem might have been a router in northern NJ. I'm suspicious as it does not explain the problems on the LAN, but since our ISP said they fixed it this has not happened.

Thanks for your replies.