locked
ODBC Driver for Exchange RRS feed

  • Question

  • Is there an ODBC driver to connect to Exchange?  If so where can I get it.
    I know there is an OLEDB but I was not sure if there was a way to connect via ODBC.
    I am working on a contract that requires an ODBC connection to query data from exchange.

    Wednesday, March 28, 2012 1:39 PM

All replies

  • No there isn't there used to be exoledb in Exchange 2003 and 2007 http://msdn.microsoft.com/en-us/library/aa142634(v=exchg.65).aspx but this has be removed in 2010. What are trying to do and why do you need to use OLEDB ? You maybe better looking to do something like http://msdn.microsoft.com/en-us/library/bb508823(v=exchg.80).aspx if your after DB integration etc.

    Cheers
    Glen

    Thursday, March 29, 2012 6:29 AM
  • hi gtjr92,

    There is one here: http://www.connect-gate.com/index.php/en/why-connect-gate/sql-for-communication

    It's quite fast and cover the most important SQL statements.

    Download the ODBC driver for the version of Teradata that is installed. The following site should have the appropriate driver: http://www.teradata.com/DownloadCenter/Forum90-1.aspx is only for 32-bit supportive.

    NOTE: the TTU 12.0 Windows-i-386 tdodbc.12.00.00.07 driver returns an error with the terasso library when the driver is selected in the ODBC Data Source Administrator. This driver is not supported on Windows Server 2008 R2.

    Download the TTU 13.0 Windows-i386 tdodbc.13.10.00.01 driver from the web site above. Teradata 13 ODBC driver is backward compatible with Teradata 12. The remaining instructions are for installing the Teradata 13 ODBC driver and are working on a Teradata 12 installation.

    NOTE: the following steps must be performed by a user with administrative rights to the computer on which the install is being performed.

    2. The download file is a zipped file and should be saved on the hard drive of the machine on which it is to be installed. The zipped file contains three components that must be installed in the following order: Teradata GSS Client, ICU Library and ODBC driver.
    3. Extract all from tdodbc__WINDOWS_i386.13.00.00.00. Select the directory in which the zipped file is located from the Browse window. For ease of locating the files for the components, create a subdirectory for each of two components (GSS, ICU)
    4. Extract all from TeraGSS__windows_i386.13.00.00.00 into the GSS subdirectory by selecting it in the Browse window during the install. Right click the setup.exe icon and choose “Run as Administrator” to install.
    5. Extract all from tdicu__windows_i386.13.00.00.00 into the ICU subdirectory by selecting it in the Browse window during the install. Open the DISK1 directory. Right click the setup.exe icon and choose “Run as Administrator” to install.
    6. Navigate to the directory in which the original zipped file was stored. Right click on tdodbc__windows_i386.13.00.00.00 and choose “Run as Administrator” to install the ODBC driver.
    7. Navigate to the c:\Windows\SysWOW64 directory. Click on the odbcad32 application. This will open the ODBC Data Source Administrator for 32-bit drivers on the 64-bit server. NOTE: The ODBC Data Source Administrator that is located by clicking Start and Administrative Tools will only create 64-bit ODBC connections.
    8. Click on the System DSN tab
    9. Click on Add to create a new Data Source
    10. Select Teradata then click Finish
    11. Enter the Data Source name, Description and the Name or IP address of the Teradata Server to which the connection is to be made. Click OK
    12. Your 32-bit ODBC data source is now ready for use

    Thanks.............



    Friday, March 30, 2012 4:05 PM
  • Hi George,

    That link doesn't work.

    Regards,


    Scott Quinn | C# developer & messaging specialist (for hire). Contact me at http://au.linkedin.com/in/scottquinn

    Saturday, March 31, 2012 1:52 AM
  • Yes OutlookODBC

    Gary Cawley

    Thursday, September 17, 2020 8:46 PM