Re: Microsoft OLE DB Provider for SQL Server in MS Access

Access doesn't support some of the data types that SQL Server does.
DSN's only work with ODBC. Access uses DAO/ADO/VBA when writing code
to access SQL Server from Access directly, and ODBC for linking tables
or using pass-through queries. You can't change any of that. HTH,

--Mary

On Wed, 5 Apr 2006 11:08:02 -0700, Cliff
<Cliff@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

If the data in a SQLServer database now contains "BigDecimal" type data MS
Access can no longer report/display the data. #Deleted# appears in the
columns. I am able to read the data in the Microsoft Development environment
with a Data Connection using the Provider=SQLOLEDB.1.

In Access I'm using a DSN with the SQLServer driver, SQLSRV32.DLL, 4/28/2004

I cannot find the OLE DB Provider listed in the ODBC Data Source
Administrator Drivers list.

Is there a way to have MS Access use SQLOLEDB instead of SQLSVR32 ?
Or another solution to read "BigDecimal" data from MS Access?

.

Relevant Pages

  • SQL Server ODBC Driver Ignores Authentication Setting
    ... set their ODBC connections with SQL Server Authentication, ... Microsoft Data Access Components 2.6 RTM, ... authentication to log into the database. ...
    (microsoft.public.sqlserver.security)
  • Re: Linking tables access - sql server 2005
    ... Another advantage of this method is that you don't need an ODBC setting on the local computer, ... Create a linked table to SQL Server without using a DSN ... Name of the table that you are linking to on the SQL Server database ... Function AttachDSNLessTable(stLocalTableName As String, stRemoteTableName As String, stServer As String, stDatabase As String, Optional stUsername As ...
    (microsoft.public.access.adp.sqlserver)
  • RE: [ODBC SQL Server Driver][Shared Memory]ConnectionWrite (send()
    ... the ODBC source using named pipe, but I don't know how to enable named pipes ... If it is not working I am going to use ado to connect to sql server. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)
  • Re: Strange Problems with ODBC connection to SQL Server
    ... When accessing Jet data, use DAO. ... This way you are not exposing connection information in clear ... >accesses an SQL Server 2000 repository via ODBC data source. ...
    (microsoft.public.data.odbc)
  • Re: [PHP] ODBC and long text fields
    ... We've a PHP app that uses ODBC to talk to a MS SQL server. ... The internal code for a query is ...
    (php.general)
Loading