Page 322 of 724« First...102030...320321322323324...330340350...Last »

MS10-056: Description of the security update for the 2007 Office system and for the Compatibility Pack for the 2007 Office system: August 10, 2010

Microsoft has released security bulletin MS10-056. To view the complete security bulletin, visit one of the following Microsoft websites:

How to obtain help and support for this security update

Help installing updates:
Support for Microsoft Update

(http://support.microsoft.com/ph/6527)

Security solutions for IT professionals:
TechNet Security Troubleshooting and Support

(http://technet.microsoft.com/security/bb980617.aspx)

Help protect your computer that is running Windows from viruses and malware:
Virus Solution and Security Center

(http://support.microsoft.com/contactus/cu_sc_virsec_master)

Local support according to your country:
International Support

(http://support.microsoft.com/common/international.aspx)

 

Known issues

After you install this update on a computer that is running Microsoft Office 2003 and the Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats, you may receive an error message that resembles the following when you try to when open a file that was saved by using Information Rights Management (IRM):

Unable to open file. Password is incorrect

To resolve this problem, install hotfix 983309. For more information, visit the following Microsoft Web page:

983309

(http://support.microsoft.com/kb/983309/
)

Description of the Office Excel 2007 hotfix package (Mso-x-none.msp): June 29, 2010

Prerequisites to apply this security update

There are no prerequisites for installing this security update.

Restart information

You may have to restart the computer after you apply this security update.

Security update replacement information

This security update replaces the following security update:

969613

(http://support.microsoft.com/kb/969613/
)

MS09-027: Description of the security update for the 2007 Office system and for the Compatibility Pack for the 2007 Office system: June 9, 2009

Removal information

To remove this security update, use the Add or Remove Programs item or use the Programs and Features item in Control Panel.

Note When you remove this security update, you may be prompted to insert the disc that contains 2007 Microsoft Office in the CD drive. Additionally, you may not have the option to uninstall this security update from the Add or Remove Programs item or the Programs and Features item in Control Panel. There are several possible causes for this issue.

For more information about the removal, click the following article number to view the article in the Microsoft Knowledge Base:

903771

(http://support.microsoft.com/kb/903771/
)

Information about the ability to uninstall Office updates

File information

The English (United States) version of this security update has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

The 2007 Microsoft Office system and the Microsoft Office Compatibility Pack

Collapse this tableExpand this table

File name File version File size Date Time
Wordcnv.dll 12.0.6539.5000 4,675,432 11-Jun-2010 21:51
Wordconv.exe 12.0.6500.5000 20,808 27-Feb-2009 00:45
Wordcnvpxy.cnv 12.0.6500.5000 24,912 27-Feb-2009 00:45

Article ID: 2277947 – Last Review: July 18, 2012 – Revision: 4.0


Applies to
  • Microsoft Office Basic 2007
  • Microsoft Office Enterprise 2007
  • Microsoft Office Home and Student 2007
  • Microsoft Office Professional 2007
  • Microsoft Office Professional Plus 2007
  • Microsoft Office Small Business 2007
  • Microsoft Office Standard 2007
  • Microsoft Office Ultimate 2007
  • Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats
  • Microsoft Office Access 2007
  • Microsoft Office Excel 2007
  • Microsoft Office OneNote 2007
  • Microsoft Office Outlook 2007
  • Microsoft Office PowerPoint 2007
  • Microsoft Office Publisher 2007
  • Microsoft Office SharePoint Designer 2007
  • Microsoft Office Word 2007
kbsecvulnerability kbsecurity kbsecbulletin kbfix kbexpertiseinter kbbug atdownload KB2277947

Read the article:
MS10-056: Description of the security update for the 2007 Office system and for the Compatibility Pack for the 2007 Office system: August 10, 2010

How To Retrieve a Recordset from an Oracle Stored Procedure Using ADO on ASP

This article demonstrates how to call an Oracle package to retrieve a recordset using ADO on Active Server Pages (ASP).

This article assumes that:

  • You are proficient with Visual Basic Scripting Edition (VBScript), ActiveX Data Objects (ADO), and Active Server Pages (ASP).
  • You understand Oracle’s Procedural Language/Structured Query Language, if you will also be creating Oracle packages.
  • Your Internet Information Server (IIS) is configured properly to the Oracle database.
To call an Oracle stored procedure, the stored procedure must be encapsulated within a package. The following sample uses an Oracle package that was assembled as an example in the Microsoft Knowledge Base article below:

174981

(http://support.microsoft.com/kb/174981/EN-US/
)

How To Retrieve Typical Resultsets from Oracle Stored Procedures

The script sample below does not use a Data Source Name (DSN) to connect to Oracle. It uses a DSN-less connection. (You can use a system DSN by commenting out the appropriate lines.) The sample uses ODBC to connect to Oracle.

Note that you could also use the Microsoft OLE DB Provider for Oracle in this sample. To do so, comment out the appropriate lines.

<%@ LANGUAGE="VBSCRIPT" %>

<%
	'Constants
	adCmdUnknown = 0
	adCmdText = 1
	adCmdTable = 2
	adCmdText = 1
	adParamInput = 1
	adParamOutput = 2
	adInteger = 3
	adUseClient = 3
	adOpenStatic = 3

	Dim cnnOracle
	Dim cmdStoredProc
	Dim rsEmp

	'This code creates a connection object.
	Set cnnOracle = Server.CreateObject("ADODB.Connection")
	cnnOracle.CursorLocation = adUseClient

	'System DSN connection
	'strConn = "DSN=OracleDSN; UID=UserID; PWD=Password"

	'DSN-less connection
	strConn = "DRIVER=Microsoft ODBC for Oracle; SERVER=DatabaseAlias; UID=UserID; PWD=Password"

	'OLE DB connection
	'strConn = "Provider=MSDAORA.1; Data Source=DatabaseAlias; User ID=UserID; Password=Password"

'Note:  The DatabaseAlias is the name that was created in SQL*Net Easy Configuration or in Net8.

	cnnOracle.Open strConn

	'This code creates a command object.
	Set cmdStoredProc = Server.CreateObject("ADODB.Command")
	Set cmdStoredProc.ActiveConnection = cnnOracle

	'Retrieve only one record
	'cmdStoredProc.CommandText = "call packperson.oneperson(?,resultset 2, ssn, fname, lname)}"
	'cmdStoredProc.CommandType = adCmdText
	'cmdStoredProc.Parameters.Append cmdStoredProc.CreateParameter("wildcard",adInteger,adParamInput)

	'Retrieve all records.
	cmdStoredProc.CommandText = "call packperson.allperson(resultset 9, ssn, fname, lname)}"
	cmdStoredProc.CommandType = adCmdText

	'This code creates a recordset object.
	Set rsEmp = Server.CreateObject("ADODB.Recordset")
	rsEmp.CursorType = adOpenStatic

	Set rsEmp.Source = cmdStoredProc

	'Set the parameter for to get only one record
	'cmdStoredProc(0) = 555662222

	rsEmp.Open
%>





Retrieving a Recordset from an Oracle Stored Procedure using ADO on ASP



<%
        'Traverse through the recordset and display the data
	While Not rsEmp.EOF
		Response.Write(rsEmp(0) & " " & rsEmp(1) & " " & rsEmp(2) & "
") rsEmp.MoveNext Wend ' Close the Recordset and the Connection rsEmp.Close cnnOracle.Close ' Dereference the ADO Objects Set cmdStoredProc = nothing Set rsEmp = nothing Set cnnOracle = nothing %>

For additional information, click the article number below to view it in the Microsoft Knowledge Base:

176086

(http://support.microsoft.com/kb/176086/EN-US/
)

How To Retrieve Recordsets from Oracle Stored Procs Using ADO

For information on why you must use an Oracle Package instead of an Oracle stored procedure, click the article number below to view it in the Microsoft Knowledge Base:

167225

(http://support.microsoft.com/kb/167225/EN-US/
)

How To Access an Oracle Database Using RDO

For additional information on ADO and to download the latest version of the Microsoft Data Access Components (MDAC), please see the following Microsoft Web site:

Article ID: 229919 – Last Review: July 18, 2012 – Revision: 6.0


Applies to
  • Microsoft Internet Information Services 5.0
  • Microsoft Data Access Components 2.1
  • Microsoft Data Access Components 2.5
  • Microsoft Data Access Components 2.6
  • Microsoft Data Access Components 2.7
kb3rdparty kbaspobj kbcodesnippet kbdatabase kbhowto kboem kboracle KB229919

View article:
How To Retrieve a Recordset from an Oracle Stored Procedure Using ADO on ASP

ACC97: #Deleted Entries Appear in Alternate Rows in Linked SQL Server Tables

In a linked table from Microsoft SQL Server 6.5, Microsoft
SQL Server 7.0, or Microsoft Data Engine (MSDE) you see #Deleted in alternate
rows. One row has the typical data, the next contains #Deleted entries, the
next typical data, and so on.
This behavior can occur under the following conditions:

  • The table has numeric or text field columns.
  • The SQL Server database has been created on a server with
    non-default code pages and sort order.
  • The version of the Microsoft ODBC SQL Server driver
    accessing the table is 3.70.0623.

NOTE: This problem does not occur with earlier or later versions of the
Microsoft ODBC SQL Server driver.

To resolve this problem, do one of the following:
Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
at the beginning of this article.
For additional information, click the article number below to
view the article in the Microsoft Knowledge Base:
236825

(http://support.microsoft.com/kb/236825/EN-US/
)

PRB: #deleted Seen When SQL Server 7.0 Tables Containing Numeric and Text fields Are Opened

Article ID: 269580 – Last Review: July 18, 2012 – Revision: 5.0


Applies to
  • Microsoft Access 97 Standard Edition
Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered “as is” and will no longer be updated.

Read More:
ACC97: #Deleted Entries Appear in Alternate Rows in Linked SQL Server Tables

ACC97: "ORDER BY Clause Is Not Valid…" Error with Linked Table

When you run a query that uses an ORDER BY statement on a
linked table, you may receive the following error message:

The ORDER BY clause is not valid because column, “col
name,” is not part of the result table.

You are unable to use the ORDER BY statement on a
non-Primary Key field. Microsoft Jet does not make the necessary ODBC call, SQLGetInfo(SQL_ORDER_BY_COLUMNS_IN_SELECT), to retrieve the information necessary to include ORDER BY
columns in the SELECT statement.

When you run a query using Jet 3.5x,
Jet obtains table indexes and issues a “pre-query” that selects all the indexed
columns and retains the remaining part of the query issued by Access. For
example, if the following query is issued from Access against a table called
Test1 with fields A, B, C, D, E, and F, having a unique index on A, B, and C

Select D,E,F from Test1 order by D,E,F

the “pre query” would be:

Select A,B,C from Test1 order by D,E,F

This “pre-query” extends beyond the ANSI-92 standards and is
rejected by some of the relational database management systems, such as DB2.
Other relational database management systems, such as Microsoft SQL Server,
ORACLE, and others, allow this “pre-query” to succeed. (Strict ANSI-92
compliance dictates that ORDER BY columns must also be in the SELECT list.)

First, install the latest release of Microsoft Data Access
Components MDAC 2.1.2.4202.3 (GA). You can download MDAC 2.1.2.4202.3 (GA) from
the following Microsoft Web site: Then, if you are running Microsoft Windows 95, Microsoft Windows
98, or and Microsoft Windows NT, install the Microsoft Jet 3.5 SP3 update. This
is not necessary if you are running Microsoft Windows 2000. For additional
information about how to obtain the Microsoft Jet 3.5 SP3 update, please click
the article number below to view the article in the Microsoft Knowledge Base:
172733

(http://support.microsoft.com/kb/172733/EN-US/
)

ACC97: Updated Version of Microsoft Jet 3.5 Available for Download

Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
at the beginning of this article.
In addition to obtaining the Jet update listed in the
“Resolution” section, if you are using the IBM DB2 OS/390 ODBC driver, you must
also install an IBM Driver Patch (Fixpack 9). The IBM DB2 OS/390 ODBC driver
version v5.1.2 incorrectly returns “N” instead of “Y” when responding to a call
to SQLGetInfo(SQL_ORDER_BY_COLUMNS_IN_SELECT).

Steps to Reproduce Problem

  1. Click Start, point to Settings, and then click Control Panel.
  2. In Control Panel, double-click the ODBC Data Sources (32-bit) icon.
  3. In the ODBC Data Source Administrator dialog box, click the Tracing tab, and then click Start Tracing Now.
  4. Open Query Manager in SQL Server 7.0 or ISQL/w in SQL
    Server 6.x.
  5. To create a new table, run the following code:
    CREATE TABLE test1
    
        ( 
    
         Field1 char(4),
    
         Field2 char(4),
    
         Field3 char(4),
    
         Field4 char(4),
    
         Field5 char(4),
    
         Field6 char(4)
    
        )
    
    GO
    
    CREATE UNIQUE INDEX testCompIdx
    
        ON Test1 (Field1,Field2,Field3)
    
    GO
    
    INSERT INTO Test1 (Field1,Field2,Field3,Field4,Field5,Field6)
    
           VALUES ('A','B','C','D','E','F')
    					

  6. Open an Access 97 database and link a table to the SQL
    Server table that you created in step 4.
  7. Create a new query called Query1 in Design view without
    adding any tables.
  8. In the Query1 query, on the View menu, select SQL, and type the following:

    SELECT Field4,Field5,Field6
    FROM dbo_Test1
    ORDER BY Field4,Field5,Field6

  9. Save and run Query1.
  10. Open the ODBC trace file in Notepad to review the query.
    You see the following text:

    SELECT “dbo”.”Test1″.”Field1″,”dbo”.”Test1″.”Field2″,”dbo”.”Test1″.”Field3″ FROM “dbo”.”Test1″ ORDER BY “Field4″ ,”Field5″ ,”Field6″

  11. Close the database and delete the ODBC trace log.

Article ID: 235960 – Last Review: July 18, 2012 – Revision: 6.0


Applies to
  • Microsoft Access 97 Standard Edition
Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered “as is” and will no longer be updated.

View article:
ACC97: "ORDER BY Clause Is Not Valid…" Error with Linked Table

ACC97: SQL Memo Fields Truncated to 255 in Update Query

When you run an update query from Microsoft Access to copy
the contents of one SQL Server Memo field into another SQL Server Memo field,
the data in the new field will be truncated at 255 characters.
This behavior will occur when you add criteria to one of
the SQL Server fields, that field is part of an index, and you are using any of
the following 32-bit ODBC drivers:
   Driver        Version    Source
   ------------  ---------  ---------------------------------------------
   SQLSRV32.DLL  2.50.0126  Microsoft Access 7.0
                 2.65.0201  ODBC Desktop Driver Pack 3.0 (Q139487)
                 2.65.0213  Microsoft Access 97 (Q159674)
                 2.65.0240  SQL Server 6.5
				

To obtain the latest drivers, install the Microsoft Data Access
Components (MDAC) 2.0 from the following Microsoft Web site:

Remove the criteria you have set on the indexed field.
Microsoft has confirmed this to be a problem in Microsoft
Access 97.

Article ID: 170218 – Last Review: July 18, 2012 – Revision: 5.0


Applies to
  • Microsoft Access 97 Standard Edition
kbbug kbinterop kbnofix KB170218
Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered “as is” and will no longer be updated.

Read the article:
ACC97: SQL Memo Fields Truncated to 255 in Update Query

List of ODBC Drivers Installed by Product

This article was previously published under Q140548

Moderate: Requires basic macro, coding, and interoperability
skills.
This article contains a listing of all the Open Database
Connectivity (ODBC) drivers installed by Microsoft Access versions 1.0, 1.1,
2.0, 7.0, 97, the Microsoft Data Access Components versions 1.5c and 2.1, the
Microsoft ODBC 3.0 drivers for Windows 95 and Windows NT, the Microsoft ODBC
Fulfillment Kit, the Microsoft Windows NT Desktop Driver Pack, the Microsoft
Upsizing Tools, and the Microsoft Data Access Pack, Dataacc.exe, included with
the Microsoft Access 97 ValuPack.

For the latest drivers, you can
download the Microsoft Data Access Components (MDAC) from the following
Microsoft Web site:

This article is in two parts. First are diagrams of how ODBC
interacts with other software in a networked PC environment. Second is a
listing of all the ODBC drivers installed by the following products:

  • Microsoft Access versions 1.0, 1.1, 2.0, 7.0, and
    97
  • Microsoft Data Access Components version 1.5c
  • Data Access Pack (Dataacc.exe)
  • Microsoft ODBC 3.0 drivers for Windows 95 and Windows NT
    (installed by GE1263.exe)
  • Microsoft ODBC Fulfillment Kit (Desktop Driver Pack
    2.0)
  • Microsoft Windows NT 3.51 Desktop Driver Pack
  • Microsoft Upsizing Tools.

Installing support for ODBC installs the following DLLs into
the WINDOWS/SYSTEM folder.

Diagrams
--------
              ORACLE CONNECTION 6 AND 7 CONNECTION PATHS
              ------------------------------------------

                               Application
                                    |
                      ODBC Driver Manager(ODBC.DLL)
                                    |
                 ORACLE Driver(SQORA.DLL or SQORA7.DLL)
                                    |
                        OCI Layer(ORA7WIN.DLL)
                                    |
                 SQL*Net Driver(like SQLTCP.DLL, SQLTCP1.DLL,
             SQLTNS.DLL, SQLTNS1.DLL, SQLSPX.DLL, or SQLSPX1.DLL)
                                    |
          Network Software(like Microsoft NT Server Client Software, WFW
             Client, Win95 Client, or Novell NetWare Client Software)
                                    |
                             SQL*Net Listener
                                    |
                              ORACLE RDBMS

                 MICROSOFT SQL SERVER VER 4.2x 16-BIT ENVIRONMENT
                 ------------------------------------------------

       Application (32-bit)                        Application (16-bit)
              |                                            |
         32-Bit Thunking Driver Manager (ODBC16GT.DLL      |
              |                       and/or ODBC32GT.DLL) |
              |                                            |
         ODBC Universal Thunking DLL(ODBC16UT.DLL)         |
               -------------------> | <--------------------
                                    |
                      ODBC Driver Manager(ODBC.DLL)
                                    |
                   ODBC Cursor Library (ODBCCURS.DLL)
                                    |
                     SQL Server Driver(SQLSRVR.DLL)
                                    |
                Network Library(like DBNMP3.DLL or DBMSSPX3.DLL)
                                    |
      Network Software(like Microsoft NT Server Client Software, WFW
         Client, Win95 Client, or Novell NetWare Client Software)
                                    |
                            SQL Server DBMS

                MICROSOFT SQL SERVER VER 6.0 32-BIT ENVIRONMENT
                -----------------------------------------------

       Application (16-bit)                        Application (32-bit)
              |                                            |
         ODBC Driver Manager(ODBC32.DLL)                   |
              |                                            |
         ODBC Cursor Library(ODBCCUR.DLL)                  |
              |                                            |
         16-Bit ODBC Generic Thunking DLL(ODBC16GT.DLL)    |
              |                                            |
         32-Bit ODBC Generic Thunking DLL (ODBC32GT.DLL)   |
               -------------------> | <--------------------
                                    |
                     ODBC Driver Manager(ODBC32.DLL)
                                    |
                    ODBC Cursor Library(ODBCCR32.DLL)
                                    |
                SQL Server Driver (32-bit) (SQLSRV32.DLL)
                                    |
             Network Library(like DBNMPTW.DLL or DBMSSPXN.DLL)
                                    |
      Network Software(like Microsoft NT Server Client Software, WFW
         Client, Win95 Client, or Novell NetWare Client Software)
                                    |
                            SQL Server DBMS
				

Files Installed by Specific Products

The following is a listing of all the Open Database Connectivity
(ODBC) drivers installed by product.

Microsoft Data Access Components 2.1

Filenames                Version                     Component
cliconfg.DLL             1998.11.13.0                SQL Server ODBC
cliconfg.exe             1998.11.13.0                SQL Server ODBC
dbmsadsn.dll             1998.11.13.0                SQL Server OLEDB
dbmsrpcn.dll             1998.11.13.0                SQL Server OLEDB
dbmsshrn.dll             1998.11.13.0                SQL Server OLEDB
dbmssocn.dll             1998.11.13.0                SQL Server OLEDB
dbmsspxn.dll             1998.11.13.0                SQL Server OLEDB
dbmsvinn.dll             1998.11.13.0                SQL Server OLEDB
dbnmpntw.dll             1998.11.13.0                SQL Server OLEDB
ds16gt.dll               3.510.3513.0                ODBC
ds32gt.dll               3.510.3513.0                ODBC
expsrv.dll               6.0.0.8246                  Jet98
msadce.dll               2.10.3513.2                 RDS
msadcer.dll              2.10.3513.2                 RDS
msadcf.dll               2.10.3513.2                 RDS
msadcfr.dll              2.10.3513.2                 RDS
msadco.dll               2.10.3513.2                 RDS
msadcor.dll              2.10.3513.2                 RDS
msadcs.dll               2.10.3513.2                 RDS
msadds.dll               2.10.3513.2                 RDS
msaddsr.dll              2.10.3513.2                 RDS
msader15.dll             2.10.3513.2                 ADO
msado15.dll              2.10.3513.2                 ADO
msadomd.dll              2.10.3513.0                 ADOMD
msador15.dll             2.10.3513.2                 ADO
msadox.dll               2.10.3513.0                 ADOX
msadrh15.dll             2.10.3513.2                 ADO
mscpxl32.dll             3.60.3.20                   Oracle ODBC
msdadc.dll               2.10.3513.0                 OLEDB
msdaenum.dll             2.10.3513.0                 OLEDB
msdaer.dll               2.10.3513.0                 OLEDB
msdaora.dll              2.10.3513.0                 Oracle OLEDB
msdaosp.dll              2.10.3513.0                 OLEDB
msdaprsr.dll             2.10.3513.2                 RDS
msdaprst.dll             2.10.3513.2                 RDS
msdaps.dll               2.10.3513.0                 OLEDB
msdarem.dll              2.10.3513.2                 RDS
msdaremr.dll             2.10.3513.2                 RDS
msdasc.dll               2.10.3513.0                 OLEDB
msdasql.dll              2.10.3513.0                 OLEDB
msdasqlr.dll             2.10.3513.0                 OLEDB
msdatl2.dll              2.10.3513.0                 OLEDB
msdatt.dll               2.10.3513.0                 OLEDB
msdfmap.dll              2.10.3513.2                 RDS
msexch40.dll             4.0.2115.25                 Jet98
msexcl40.dll             4.0.2115.25                 Jet98
msjet40.dll              4.0.2115.25                 Jet98
msjetoledb40.dll or
MSJETO~1.DLL             4.0.2115.25                 Jet98
msjint40.dll             4.0.2115.25                 Jet98
msjro.dll                2.10.3513.0                 JRO
msjter40.dll             4.0.2115.25                 Jet98
msjtes40.dll             4.0.2115.25                 Jet98
msltus40.dll             4.0.2115.25                 Jet98
msorcl32.dll             2.573.3513.0                Oracle ODBC
mspbde40.dll             4.0.2115.25                 Jet98
msrclr40.dll             4.0.2115.25                 Jet98
msrd2x40.dll             4.0.2115.25                 Jet98
msrd3x40.dll             4.0.2115.25                 Jet98
msrecr40.dll             4.0.2115.25                 Jet98
msrepl40.dll             4.0.2115.25                 Jet98
mstext40.dll             4.0.2115.25                 Jet98
mswdat10.dll             4.0.2115.30                 Jet98
mswstr10.dll             4.0.2115.30                 Jet98
msxactps.dll             2.10.3513.0                 OLEDB
msxbde40.dll             4.0.2115.25                 Jet98
mtxdm.dll                1997.11.532.0               ODBC
mtxoci.dll               1998.2.715.0                MTxOCI
odbc16gt.dll             3.510.3513.0                ODBC
odbc32.dll               3.510.3513.0                ODBC
odbc32gt.dll             3.510.3513.0                ODBC
odbcad32.exe             3.510.3513.0                ODBC
odbcbcp.dll              3.70.6.23                   SQL Server ODBC
odbccp32.cpl             3.510.3513.0                ODBC
odbccp32.dll             3.510.3513.0                ODBC
odbccr32.dll             3.510.3513.0                ODBC
odbccu32.dll             3.510.3513.0                ODBC
odbcint.dll              3.510.3513.0                ODBC
odbcji32.dll             4.0.3513.0                  JetODBC
odbcjt32.dll             4.0.3513.0                  JetODBC
odbctrac.dll             3.510.3513.0                ODBC
oddbse32.dll             4.0.3513.0                  JetODBC
odexl32.dll              4.0.3513.0                  JetODBC
odfox32.dll              4.0.3513.0                  JetODBC
odpdx32.dll              4.0.3513.0                  JetODBC
odtext32.dll             4.0.3513.0                  JetODBC
oledb32.dll              2.10.3513.0                 OLEDB
oledb32r.dll             2.10.3513.0                 OLEDB
oledb32x.dll             2.10.3513.0                 OLEDB
sqloledb.dll             7.1.6.23                    SQL Server OLEDB
sqlsrv32.dll             3.70.6.23                   SQL Server ODBC
sqlstr.dll               1998.11.13.0                SQL Server ODBC
sqlwid.dll               1998.11.13.0                SQL Server ODBC
sqlwoa.dll               1998.11.13.0                SQL Server ODBC
vbajet32.dll             6.0.1.8246                  Jet98
vfpodbc.dll              6.0.8281.0                  Visual FoxPro
asycfilt.dll             2.30.4265.1                 System
common98.dll             6.0.0.8076                  Setup
odbcstf.dll              3.510.3419.8                Setup
				

Microsoft Access 97

File Name        File Size     Date       Version Number

odbccp32.dll       93,968      11/17/96     03.00.2301
odbccp32.cpl        8,464      11/17/96     03.00.2301
odbcad32.exe       10,240      11/17/96     03.00.2301
odbccr32.dll      179,200      11/17/96     03.00.2301
odbc32.dll        246,554      11/17/96     03.00.2301
odbcint.dll        63,488      11/17/96     03.00.2301
sqlsrv32.dll      244,224      11/17/96      2.65.0213
odbcjt32.dll      241,664      11/17/96   3.50.3428.00
odbcji32.dll       37,888      11/17/96   3.50.3428.00
odbcstf.dll        22,016      11/17/96     03.00.2301
odbctl32.dll       77,824      11/17/96   3.50.3428.00
odbc16gt.dll       26,224      11/17/96     03.00.2301
odbc32gt.dll        8,192      11/17/96     03.00.2301
odbctrac.dll      142,336      11/17/96     03.00.2301
				

Microsoft Data Access Components version 1.5c

File Name        File Size      Date       Version Number

Dbmssocn.dll       10,752       8/11/97     1997.08.11
Dbnmpntw.dll       22,016       8/11/97     1997.08.11
Ds32gt.dll          8,704       12/8/97     3.50.3609
Mscpxl32.dll       17,408       8/11/97     3.50.0300
Msexch35.dll      330,000       6/23/97     3.51.0623.0
Msexcl35.dll      250,128        7/1/97     3.51.0623.2
Msjet35.dll     1,045,776       7/21/97     3.51.0623.4
Msjint35.dll      123,664       6/23/97     3.51.0623.0
Msjter35.dll       24,848       6/23/97     3.51.0623.0
Msltus35.dll      166,160       6/23/97     3.51.0623.0
Msorcl32.dll      129,808      11/13/97     2.73.7283.3
Mspdox35.dll      250,128       6/23/97     3.51.0623.0
Msrd2x35.dll      252,176       6/23/97     3.51.0623.0
Msrepl35.dll      407,312       6/23/97     3.51.0623.0
Mstext35.dll      165,648       6/23/97     3.51.0623.0
Msxbse35.dll      287,504       6/23/97     3.51.0623.0
Mtxdm.dll          29,456      11/14/97     1997.11.532.0
Odbc16gt.dll       26,224       12/9/97     3.50.3609
Odbc32.dll        171,792      12/10/97     3.50.3609
Odbc32gt.dll        9,728       12/8/97     3.50.3609
Odbcad32.exe       10,752       12/8/97     3.50.3609
Odbcbcp.dll        12,800      10/24/97     3.50.0304
Odbccp32.cpl       11,056      12/10/97     3.50.3609
Odbccp32.dll       83,072      12/10/97     3.50.3609
Odbccr32.dll      198,656      12/10/97     3.50.3609
Odbccu32.dll      199,264      12/10/97     3.50.3609
Odbcint.dll        69,120       12/8/97     3.50.3609
Odbcji32.dll       37,888      10/30/97     3.51.1029.00
Odbcjt32.dll      246,784      10/30/97     3.51.1029.01
Odbctl32.dll       73,216      10/30/97     3.51.1029.02
Odbctrac.dll      137,424      12/10/97     3.50.3609
Oddbse32.dll        5,120      10/30/97     3.51.1029.03
Odexl32.dll         5,120      10/30/97     3.51.1029.04
Odfox32.dll         5,120      10/30/97     3.51.1029.05
Odpdx32.dll         5,120      10/30/97     3.51.1029.06
Odtext32.dll        5,120      10/30/97     3.51.1029.07
Sqlsrv32.dll      417,792       11/7/97     3.50.0305
Vbajet32.dll       18,192       6/13/97     3.0.6908
Vbar332.dll       368,912       6/13/97     3.0.6908
Windbver.exe       30,720       8/11/97     1997.08.11
				

Data Access Pack (Dataacc.exe)

File Name        File Size      Date       Version Number

odbccp32.dll       93,968       11/17/96     03.00.2301
odbccp32.cpl        8,464       11/17/96     03.00.2301
odbcad32.exe       10,240       11/17/96     03.00.2301
odbccr32.dll      179,200       11/17/96     03.00.2301
odbc32.dll        246,554       11/17/96     03.00.2301
odbcint.dll        63,488       11/17/96     03.00.2301
sqlsrv32.dll      244,224       11/17/96      2.65.0213
odbcjt32.dll      241,664       11/17/96      3.50.3428.00
odbcji32.dll       37,888       11/17/96      3.50.3428.00
odbcstf.dll        22,016       11/17/96     03.00.2301
odbctl32.dll       77,824       11/17/96      3.50.3428.00
odbc16gt.dll       26,224       11/17/96     03.00.2301
odbc32gt.dll        8,192       11/17/96     03.00.2301
odbctrac.dll      142,336       11/17/96     03.00.2301
Oddbse32.dll        5,120       11/17/96      3.50.3428
Odexl32.dll         5,120       11/17/96      3.50.3428
Odfox32.dll         5,120       11/17/96      3.50.3428
Odtext32.dll        5,120       11/17/96      3.50.3428
Odpdx32.dll         5,120       11/17/96      3.50.3428
ctl3d32.dll        27,136       07/12/95      2.30
ctl3ds.dll         26,624       06/26/95      2.30
dbnmpntw.dll       23,552       07/29/96      1996.07.15
ds16gt.dll          4,656       11/17/96      03.00.2301
ds32gt.dll          5,632       11/17/96      03.00.2301
instcat.sql       132,644       04/03/96      Not Marked
Mscpxl32.dll       14,848       11/17/96      3.50.3428
Msexcl35.dll      254,976       11/17/96      3.50.3428
Msexch35.dll      517,904       11/17/96      3.50.3428
Msltus35.dll      169,984       11/17/96      3.50.3428
Msjet35.dll     1,038,848       11/17/96      3.50.3428
Msjint35.dll       36,624       11/17/96      3.50.3428
Mstext35.dll      166,912       11/17/96      3.50.3428
Msxbse35.dll      290,816       11/17/96      3.50.3428
Odbctrac.dll      142,336       11/17/96     03.00.2301
Vbajet32.dll       18,192       11/17/96      3.0.6908
VfpOdbc.dll       876,816       10/23/96      5.0.0.348
				

Microsoft ODBC 3.0 (32-Bit) drivers for Windows 95 and Windows NT

File Name        File Size       Date        Version Number

CTL3D32.DLL      27136         07/12/95       2.30.00
CTL3DS.DLL       26624         06/26/95       2.30.00
DBNMPNTW.DLL     26624         08/30/95       1995.08.18
DS16GT.DLL        5024         03/03/95       2.10.2323
DS32GT.DLL        6144         06/06/95       2.50.3006
INSTCAT.SQL     137788         08/07/95       Not Marked
ODBC16GT.DLL     24272         06/06/95       2.50.3006
ODBC32.DLL       64512         06/06/95       2.50.3006
ODBC32GT.DLL      8704         06/06/95       2.50.3006
ODBCAD32.EXE      7168         06/06/95       2.50.3006
ODBCCP32.CPL      6656         06/06/95       2.50.3006
ODBCCP32.DLL     91136         06/06/95       2.50.3006
ODBCCR32.DLL    167936         06/06/95       2.50.3006
ODBCINT.DLL      32765         06/06/95       2.50.3006
ODBCJI32.DLL     37888         06/06/95       3.40.22.04
ODBCJT32.DLL    226304         10/04/95       3.40.22.04
ODBCSTF.DLL      18432         10/04/95       3.40.22.04
ODBCTL32.DLL     73288         10/04/95       3.40.22.04
ODDBSE32.DLL      5120         10/04/95       3.40.22.04
ODEXL32.DLL       5120         10/04/95       3.40.22.04
ODFOX32.DLL       5120         10/04/95       3.40.22.04
ODPDX32.DLL       5120         10/04/95       3.40.22.04
ODTEXT32.DLL      5120         10/04/95       3.40.22.04
ORSTUB32.DLL      6144         10/04/95       3.40.22.04
SQLSRV32.DLL    240640         08/15/96       2.65.02.01
VSORAC32.DLL    136192         07/14/95       1.3.0.9
				

For more information about Microsoft ODBC Drivers for 32-Bit
programs, please see the following article here in the Microsoft Knowledge
Base:

140255

(http://support.microsoft.com/kb/140255/EN-US/
)

: GE1263: Microsoft ODBC Drivers for 32-Bit Programs

Microsoft Access for Windows 95 version 7.0

File Name        File Size       Date        Version Number

ODBCJT32.DLL     221000     09/12-95 12:00a    03.00.21.11
ODBCTL32.DLL      75000     09/12-95 12:00a    03.00.33.11
ODDBSE32.DLL       5000     09/28-95 12:00a    03.00.21.11
ODEXL32.DLL        5000     09/28-95 12:00a    03.00.21.11
ODFOX32.DLL        5000     09-28-95 12:00a    03.00.21.11
ODPDX32.DLL        5000     09-28-95 12:00a    03.00.21.11
ODTEXT32.DLL       5000     09-28-95 12:00a    03.00.21.11
ODBC32.DLL        63000     09-28-95 12:00a     2.50.3006
ODBDCAD.DLL        7000     09-28-95 12:00a     2.50.3006
ODBCCP32.CPL       7000     09-28-95 12:00a     2.50.3006
ODBCCP32.DLL      89000     09-28-95 12:00a     2.50.3006
ODBCCR32.DLL     164000     09-28-95 12:00a     2.50.3006
ODBCINT.DLL       32000     09-28-95 12:00a     2.10.2323
DS16GT.DLL         5000     09-28-95 12:00a     2.50.3006
ODBC32GT.DLL       9000     09-28-95 12:00a     2.50.3006
DBNMPNTW.DLL      17000     09-28-95 12:00a     1995.08.18
SQLSRV32.DLL     207000     09-28-95 12:00a     2.50.0126
				

Microsoft ODBC 2.5 Driver Components

File Name        File Size       Date        Version Number

DS16GT.DLL         5024     05-23-95 7:00a      2.10.2323
DS32GT.DLL         6144     06-07-95 5:25a      2.5.3006
ODBC16GT.DLL      24272     06-07-95 5:25a      2.5.3006
ODBC32.DLL        64512     06-07-95 5:25a      2.5.3006
ODBC32GT.DLL       8704     06-07-95 5:25a      2.5.3006
ODBCAD32.EXE       7168     06-07-95 5:25a      2.5.3006
ODBCCP32.CPL       6656     06-07-95 5:25a      2.5.3006
ODBCCP32.DLL      91136     06-07-95 5:25a      2.5.3006
ODBCCR32.DLL     167936     06-07-95 5:25a      2.5.3006
ODBCINT.DLL       32768     06-07-95 5:25a      2.5.3006
				

Microsoft Windows NT 3.51 Desktop Driver Pack

File Name        File Size       Date        Version Number

CTL3D32.DLL       27648     11-17-94  5:00p
DS16GT.DLL         5024     11-17-94  5:00p     2.00.1510
DS32GT.DLL         7168     11-17-94  5:00p
DBNMPNTW.DLL      19456     11-17-94  5:00p
INST32.DLL        98816     11-17-94  5:00p
ODBC16GT.DLL      21872     11-17-94  5:00p     2.00.1510
ODBC32.DLL        67584     11-17-94  5:00p
ODBC32GT.DLL       9216     11-17-94  5:00p
ODBCAD32.EXE      12800     11-17-94  5:00p
ODBCCP32.DLL      90112     11-17-94  5:00p
ODBCCR32.DLL     105472     11-17-94  5:00p
ODBCSTP.EXE       84480     11-17-94  5:00p
ODEXL32.DLL        5632     11-17-94  5:00p
ODFOX32.DLL        5632     11-17-94  5:00p
ODPDX32.DLL        5632     11-17-94  5:00p
ODTEXT32.DLL       5632     11-17-94  5:00p
SQLSRV32.DLL     221696     11-17-94  5:00p
ODBCJT32.DLL     249856     11-17-94  5:00p
ODBCTL32.DLL      78336     11-17-94  5:00p
ODDBSE32.DLL       5632     11-17-94  5:00p
				

Microsoft ODBC FULFILLMENT KIT (Desktop Driver Pack 2.0)

File Name        File Size       Date        Version Number

COMPOBJ.DLL      108544     11-17-94  5:00p     2.02
INSTCAT.SQL       91480     11-17-94  5:00p
ODBCINST.DLL      86800     11-17-94  5:00p     2.00.1510
ODBCSTP.EXE       72896     11-17-94  5:00p     2.00.2016
CCP3216.DLL        5632     11-17-94  5:00p
CPN16UT.DLL        3264     11-17-94  5:00p
INST16.DLL        86912     11-17-94  5:00p
ODBCJT16.DLL     248928     11-17-94  5:00p    02.00.23.17
ODBCTL16.DLL      64080     11-17-94  5:00p    01.00.23.9
DBNMP3.DLL        10944     05-10-94  5:00p     1994.01.26
MSAJT200.DLL     995056     11-17-94  5:00p     2.50.1117
MSCPXLT.DLL       10304     07-11-94  5:00p     2.00.1912
MSJETERR.DLL      11232     11-17-94  5:00p     2.50.1111
MSJETINT.DLL      15936     11-17-94  5:00p     2.50.1111
MSTX2016.DLL     102080     11-17-94  5:00p     2.50.1117
MSXL2016.DLL     149344     11-17-94  5:00p     2.50.1117
ODBC.DLL          55792     11-17-94  5:00p     2.00.1510
ODBC16UT.DLL       5792     11-17-94  5:00p
ODBC3216.DLL      12288     11-17-94  5:00p
CTL3D.DLL         20976     08-26-93  5:00p     2.04
CTL3DV2.DLL       21648     11-17-94  5:00p     2.05
ODBCADM.EXE        6496     11-17-94  5:00p     2.00.1510
ODBCCURS.DLL      88896     11-17-94  5:00p     2.00.2011
ODBTRV16.DLL       4096     11-17-94  5:00p    02.00.23.01
ODDBSE16.DLL       4080     11-17-94  5:00p    02.00.23.01
ODEXL16.DLL        4080     11-17-94  5:00p    02.00.23.01
ODPDX16.DLL        4096     11-17-94  5:00p    02.00.23.01
ODFOX16.DLL        4096     11-17-94  5:00p    02.00.23.01
ODTEXT16.DLL       4096     11-17-94  5:00p    02.00.23.01
ORA6WIN.DLL      285573     11-17-94  5:00p
SQLSRVR.DLL      161392     07-12-94  2:13p     2.00.1912
SQORA.DLL        144096     07-11-93  5:00p     1.00.3112
SQORA7.DLL       181520     10-17-94  5:00p     1.11.0000
SQORAST7.DLL       9552     10-17-94  5:00p     1.11.0000
SQORASTP.DLL      96320     07-05-93  5:00p     1.00.3106
				

Microsoft UPSIZING Tools

File Name        File Size       Date        Version Number

DBNMP3.DLL        10944     05-11-94 11:00a     1994.01.26
CTL3DV2.DLL       21648     03-16-94  4:34p     2.05
CPN16UT.DLL        3264     03-16-94  4:34p
INSTCAT.SQL       91480     07-12-94  2:13p
MSCPXLT.DLL       10304     07-12-94  4:22p     2.00.1912
ODBC.DLL          55792     03-16-94  4:34p     2.00.1510
ODBC16UT.DLL       5792     03-16-94  4:34p
ODBC32.DLL        12288     03-16-94  4:34p
ODBCADM.EXE        6496     06-13-94 12:00a     2.00.1510
ODBCCP32.DLL       5632     03-16-94  4:34p
ODBCCURS.DLL      88640     03-28-94  2:05p     2.00.1510
ODBCINST.DLL      86800     03-23-94  1:28p     2.00.1510
ODBCSTP.EXE       72720     03-16-94  4:34p     2.00.1510
SQLSRVR.DLL      161392     07-12-94  2:13p     2.00.1912
				

Microsoft Access 2.0

File Name        File Size       Date        Version Number

BTRV200.DLL      110592     04-05-94  3:00a     2.0
DBNMP3.DLL        10704     04-05-94  3:00a     1993.08.24
INSTCAT.SQL       91480     04-05-94  3:00a
ODBC.DLL          49584     04-05-94  3:00a     1.05.0916
ODBCADM.EXE        6496     04-05-94  3:00a     1.05.0916
ODBCINST.DLL      82704     04-05-94  3:00a     1.05.0923
CTL3D.DLL         20976     04-05-94  3:00a     2.04
CTL3DV2.DLL       21648     04-05-94  3:00a     2.04
COMPOBJ.DLL      102400     04-05-94  3:00a     2.01
ODBCJT16.DLL     138480     04-05-94  3:00a     1.01.15.21
ODBCCL16.DLL      67056     04-05-94  3:00a     1.01.1530
PDX200.DLL       231888     04-05-94  3:00a     2.0
XBS200.DLL       295712     04-05-94  3:00a     2.0
DAO2016.DLL      437408     04-05-94  3:00a     2.0
ODBCCTL16.DLL     67056     04-05-94  3:00a     1.01.1530
SQLSRVR.DLL      155776     04-05-94  3:00a     1.02.3231
				

Microsoft Access 1.1

File Name        File Size       Date        Version Number

COMMDLG.DLL       82248     05-26-93 12:00a     3.10
DBNMP3.DLL         9941     05-26-93 12:00a
INSTCAT.SQL       98834     05-26-93 12:00a
ODBC.DLL          44736     05-26-93 12:00a     1.00.2709
ODBCADM.EXE        6496     05-26-93 12:00a     1.01.2920
ODBCINST.DLL      63088     05-26-93 12:00a     1.01.2920
ODBCSTP.EXE       55904     05-26-93 12:00a     1.01.2920
ORA6WIN.DLL      285573     05-26-93 12:00a
SQLSRVR.DLL      151856     05-26-93 12:00a     1.01.2920
SQORA.DLL        143600     05-26-93 12:00a     1.00.2816
SQORASTP.DLL       9328     05-26-93 12:00a     1.00.2403
CTL3D.DLL         14480     05-26-93 12:00a     1.13
				

Microsoft Access 1.0 (3.5 in floppy release dated 1-4-93)

File Name        File Size       Date        Version Number

DBNMP3.DLL         8241     10-22-92  3:06p
INSTCAT.SQL       93796     01-04-93 12:00a
MSCOMSTF.DLL      74528     01-04-93 12:00a     2.0
MSDETSTF.DLL      24544     01-04-93 12:00a     2.0
MSINSSTF.DLL      65440     01-04-93 12:00a     2.0
MSSHLSTF.DLL      14928     01-04-93 12:00a     2.0
MSUILSTF.DLL       6144     01-04-93 12:00a     2.0
ODBC.DLL          44736     01-04-93 12:00a     1.00.2101
ODBCADM.EXE        9136     01-04-93 12:00a     1.00.2101
ODBCINST.DLL       6016     01-04-93 12:00a     1.00.2101
SQLSETUP.DLL      11024     01-04-93 12:00a     1.00.2101
SQLSRVR.DLL      135792     01-04-93 12:00a     1.00.2216
VER.DLL            9008     10-22-92  3:06p     3.10
				

Microsoft Access 1.0

File Name        File Size       Date        Version Number

DBNMP3.DLL         8241     10-22-92  3:06p
INSTCAT.SQL        3796     10-25-92 12:00a
MSCOMSTF.DLL       4528     10-25-92 12:00a     2.0
MSDETSTF.DLL      24544     10-25-92 12:00a     2.0
MSINSSTF.DLL      65440     10-25-92 12:00a     2.0
MSSHLSTF.DLL      14928     10-25-92 12:00a     2.0
MSUILSTF.DLL       6144     10-25-92 12:00a     2.0
ODBC.DLL          44736     10-25-92 12:00a     1.00.2101
ODBCADM.EXE        9136     10-25-92 12:00a     1.00.2101
ODBCINST.DLL       6016     10-25-92 12:00a     1.00.2101
SQLSETUP.DLL      11024     10-25-92 12:00a     1.00.2101
SQLSRVR.DLL      135792     10-25-92 12:00a     1.00.2216
VER.DLL            9008     10-22-92  3:06p     3.10
				

Article ID: 140548 - Last Review: July 18, 2012 - Revision: 4.0


Applies to
  • Microsoft Access 1.0 Standard Edition
  • Microsoft Access 1.1 Standard Edition
  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 97 Standard Edition
Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Other Support Sites

Community

Get Help Now

Article Translations

See original article:
List of ODBC Drivers Installed by Product

ACC97: How to Use Visual FoxPro DBC Files in Microsoft Access

You can use data from a Microsoft Visual FoxPro database in
Microsoft Access 97 if you have added a Visual FoxPro ODBC data source as a
User Data Source in the ODBC Data Source Administrator. This article describes
how to do so.

The latest Microsoft Visual FoxPro ODBC driver is in
the Microsoft Data Access Components (MDAC), which can be downloaded from the
following Web address:

Microsoft Universal Data Access (MDAC) Web page

(http://msdn.microsoft.com/en-us/data/aa937730.aspx)

The article is divided into two parts: the first part explains how to set up
the data source for Visual FoxPro, and the second part explains how to link
tables in Visual FoxPro.

NOTE: If you use the ISAM driver for
Microsoft FoxPro, you are only able to import the data from a DBC or DBF file;
you are not able to link the DBC or DBF files. This ISAM driver was designed
for Microsoft FoxPro for Windows version 2.6.

Creating the Data Source in Control Panel

  1. On the Start menu, point to Settings, and then click
    Control Panel.
  2. In Control Panel, double-click the 32-Bit ODBC icon.
  3. In the ODBC Data Source Administrator box, click the User
    DSN tab, and then click Add.
  4. In the Create New Data Source dialog box, select the Visual
    FoxPro driver, and then click Finish.
  5. In the ODBC Visual FoxPro Setup dialog box, in the Data
    Source Name box, type a name for your data source.
  6. In the Description box, type a description. For the
    Database type option, select Visual FoxPro database (DBC). In the Path box,
    type the path to your Visual FoxPro database or click Browse to locate the
    file. Click OK.

    The data source is created.

Linking a Visual FoxPro table in Microsoft Access 97

To link a Visual FoxPro table from a Microsoft Access database,
follow these steps:

  1. Open the sample database Northwind.mdb in Microsoft Access
    97.
  2. On the File menu, point to Get External Data, and then
    click Link Tables.
  3. In the Link box, in the Files Of Type list box, select ODBC
    Databases().
  4. In the Select Data Source box, on the File Data Source tab,
    select Visual FoxPro.
  5. In the Configure Connection box, select Visual FoxPro
    database (.DBC), type or select the path to the file, and then click OK.

    The link to the table is now created.

Article ID: 176568 – Last Review: July 18, 2012 – Revision: 5.0


Applies to
  • Microsoft Access 97 Standard Edition
Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered “as is” and will no longer be updated.

Continued here:
ACC97: How to Use Visual FoxPro DBC Files in Microsoft Access

INFO: Using ActiveX Data Objects (ADO) Through Microsoft Access 97

This article discusses what is necessary to take advantage of ActiveX Data
Objects (ADO) with Microsoft Access 95 and 97.

NOTE: Microsoft Technical Support does not provide support for ADO used in conjunction with Microsoft Access 95 and 97. This article is provided for informational purposes.

This article assumes that you are familiar with Visual Basic for
Applications and with creating Microsoft Access applications using the
programming tools provided with Microsoft Access. For more information
about Visual Basic for Applications, please refer to the “Building
Applications with Microsoft Access 97″ manual.

ADO and Microsoft Access 95/97

Both Microsoft Access 95 and 97 are built around the Jet database engine,
whose functionality is exposed through Data Access Objects (DAO).

While it is possible to use ADO within Microsoft Access 95 and 97 just
as you would any other OLE Automation Server, Microsoft Access itself is
optimized for Data Access through DAO.

The only advantage of using ADO in lieu of DAO is when you request data
through an OLE DB provider that does not have a corresponding ODBC Driver.

Using ADO also allows you to access a greater variety of datastores than
DAO since ODBC accesses relational data only. OLE DB exposes non-relational
data to ADO, allowing you to access and manipulate more data sources using
ADO/OLE DB than possible with DAO/ODBC.

For example, the OLE DB Provider for Microsoft Index Server or the OLE DB
Provider for Microsoft Active Directory allows you to access data through
ADO. As ADO imposes no assumptions or restrictions on SQL Syntax, it offers
an ideal object model for exposing data that otherwise would not be
available to ODBC, and via ODBCDirect, Jet/DAO.

Installing and Redistributing ADO with Microsoft Access

The ActiveX Data Objects Library is available as part of the Microsoft
Data Access Components (MDAC). MDAC includes ODBC, the OLE DB Provider for
ODBC Drivers, ADO, the Remote Data Service, and various other ODBC Drivers.
For more information on the MDAC Redistribution, please see the REFERENCES
section.

You can use the Setup Wizard included in the Microsoft Office 97 Developer
Edition (ODE) to include and run the MDAC redistribution setup program.
Running the MDAC redistribution program installs MDAC components to other
computers.

You must add the MDAC redistribution file to your application and then you
may run it automatically using the options provided in the ODE Setup
Wizard.

Referencing the ADO Type Library

  1. Create a new Microsoft Access database.
  2. In the Module window, click New.
  3. From the Tools menu, click References.
  4. In the References dialog box, select the Microsoft ActiveX Data
    Objects Library from the Available References list.

NOTE: If the Microsoft ActiveX Data Object Library does not appear in the Available References list, make sure you have installed the Microsoft Data Access Components (MDAC) available at the following World Wide Web URL:

Single Versus Double Quotation Marks with ADO

ADO imposes no restrictions on the syntax used to generate a recordset or
execute a statement. These restrictions come from the underlying native OLE
DB provider, such as the OLE DB Provider for Index Server or the OLE DB
Provider for ODBC Drivers.

When you use the OLE DB Provider for ODBC Drivers, the ODBC driver itself
defines valid SQL syntax for use with ADO. You must keep this in mind when
migrating SQL syntax to ADO.

The SQL statement below runs successfully when DAO is used to issue
commands to the Jet database engine:

   INSERT INTO Authors ( Au_ID, Author ) VALUES (  54, "Record # 54" )
				

With ADO however, this syntax generates one of the following three errors:

-or-

-or-

Too few parameters. Expected 1.

Instead, use this syntax:

   INSERT INTO Authors ( Au_ID, Author ) VALUES (  54, 'Record # 54' )
				

Note that this is only one example and is specific to DAO/Jet. Depending upon
the underlying provider that ADO uses and the datastore it exposes, the
syntax used to query and return data can vary.

Consider this example used to return data from the OLE DB Provider for
Microsoft Index Server (that runs on a computer that has both Microsoft
Index Server and Microsoft Internet Information Server installed):

   SELECT Filename, Path, Size, Write FROM Scope('"/"') WHERE
   CONTAINS('"32MB RAM"') > 0
				

The preceding statement retrieves the names of documents exposed by the Web
server that contain the phrase “32MB RAM.”

For additional information on MDAC versions 2.0 and earlier, please refer to:

You may also download the MDAC components from the following World Wide Web
URL:

Article ID: 184233 – Last Review: July 18, 2012 – Revision: 4.0


Applies to
  • Microsoft ActiveX Data Objects 2.7
  • Microsoft Access 97 Standard Edition
kbarttypeinf kbdatabase kbinfo KB184233
Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered “as is” and will no longer be updated.

More:
INFO: Using ActiveX Data Objects (ADO) Through Microsoft Access 97

How to modify the Web.config file to show more detailed error messages in Microsoft CRM

This article describes how to modify the web.config file to show more detailed error messages in Microsoft Dynamics CRM 4.0, in Microsoft Dynamics CRM 3.0, in Microsoft CRM 1.2, and in Microsoft Business Solutions CRM 1.0.

You can receive more detailed (debug) error messages in one or more of the following products:
  • The Microsoft Dynamics CRM Web client
  • The Microsoft CRM 1.2 Sales for Outlook client (the Outlook client)
  • The Microsoft Dynamics CRM client for Microsoft Office Outlook

You can modify either or both of the Web.config files that are in the Microsoft CRM deployment. We do not recommend that you use debug error messages in production environments. However, you may find these messages useful when you try to debug a problem that occurs in Microsoft CRM.

To modify the Web.config file, follow these steps:

  1. In Windows Explorer, locate the Web.config file.
    • If you are receiving errors in the Microsoft Dynamics CRM Web client, modify the Web.config file that is located on the Microsoft Dynamics CRM server. By default, this file is located in one of the following folders:
      :inetpubwwwroot

      :P rogram FilesMicrosoft Dynamics CRMCRMWeb

    • If you are receiving errors in the Microsoft CRM 1.2 Sales for Outlook client, modify the Web.config file that is located on the client computer. By default, this file is located in the following folder:

      :P rogram FilesMicrosoft CRMClientresWeb

      Note This option is unavailable in the Microsoft CRM 1.0 Sales for Outlook client.

    • If you are receiving errors in the Microsoft CRM desktop client for Microsoft Office Outlook or in the Microsoft Dynamics CRM online client for Microsoft Office Outlook, modify the Web.config file that is located on the Microsoft CRM server. By default, this file is located in one of the following folders:

      :inetpubwwwroot
      :P rogram FilesMicrosoft Dynamics CRMCRMWeb

    • If you are receiving errors in the Microsoft CRM laptop client for Microsoft Office Outlook or in the Microsoft Dynamics CRM offline client for Microsoft Office Outlook, modify the Web.config file that is located on the client computer. By default, this file is located in the following folder:

      :P rogram FilesMicrosoft CRM ClientresWeb

  2. Open the file by using Notepad or another text editing program.
  3. In the file, scroll down the text toward the end of the file to find the following statement:

    By default, this value is set to Off. Modify this line to read as follows:

    Then, save the file.

  4. After you modify the Web.config file on the Microsoft Dynamics CRM server, close the error window, and then retry the same action that resulted in the previous error message. You should receive a more detailed (debug) error message.
  5. After you use the detailed (debug) error message to troubleshoot, repeat steps 1 through 4 to change the value of the statement back to the default setting of Off. The statement now reads as follows:

  6. Save the file.

This article was TechKnowledge Document ID: 27228

Article ID: 857192 – Last Review: July 16, 2012 – Revision: 8.0


Applies to
  • Microsoft Dynamics CRM 4.0
  • Microsoft CRM client for Microsoft Office Outlook
  • Microsoft CRM 1.2
  • Microsoft Business Solutions CRM 1.0
  • Microsoft Business Solutions CRM Sales for Outlook
kbmbscrm40 kbcrmv3c kbinfo kbmbsmigrate KB857192

Read the article:
How to modify the Web.config file to show more detailed error messages in Microsoft CRM

OFFXP: Warning 2893 When You Specify Long Company Name

oneMscomBlade,oneMsomNav,oneMscomFooter,

Read the original post:
OFFXP: Warning 2893 When You Specify Long Company Name

Page 322 of 724« First...102030...320321322323324...330340350...Last »

Recent Comments

    Archives

    Categories