Home > Archive > MS SQL Server ODBC > March 2006 > Access / SQL Server currency datatypes









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Access / SQL Server currency datatypes
Simon Lampert

2006-03-14, 7:23 am

When linking a SQL server 2000 table to Access 2003 using the standard MS
ODBC driver (2000.85.1117.00) fields with a datatype money and smallmoney
are blank in Access.

If I use a DataDirect ODBC driver the money fields are displayed correctly.

Any Idea if there is a MS ODBC driver that displays money correctly?
Mary Chipman [MSFT]

2006-03-16, 11:23 am

You might want to ask this question in one of the Access newsgroups
since it isn't an ODBC or a SQL Server issue. Someone there may have
the answer you seek.

--Mary

On Tue, 14 Mar 2006 06:02:26 -0600, "Simon
Lampert"<ureader@byteaccess.com> wrote:

>When linking a SQL server 2000 table to Access 2003 using the standard MS
>ODBC driver (2000.85.1117.00) fields with a datatype money and smallmoney
>are blank in Access.
>
>If I use a DataDirect ODBC driver the money fields are displayed correctly.
>
>Any Idea if there is a MS ODBC driver that displays money correctly?
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com