Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 11 Jan 2007 @ 11:34:28 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Problem connecting to TeraData via ADO from Windows 2003 machine
From:   Adurthy, Sri Krishna K


I have the following snippet of code in an ASP page running on IIS 6.0 on my production webserver:

        Dim cnnDB
        Dim ConnectionString

        ConnectionString = "Provider=MSDASQL;DSN=ODSS;UID=xxxxx;PWD=xxxxx"
        Set cnnDB = Server.CreateObject("ADODB.Connection")
        cnnDB.Open  ConnectionString


When the "cnnDB.Open ConnectionString" portion is reached, the connection hangs indefinitely. I am able to connect instantly to the server using Teradata SQL Assistant version 7.1. My version of ADO is 2.8 RTM 2. I am able to connect from my production server, also a Windows 2003 server, running the same version of ADO and the same version of the TeraData ODBC driver.

Any information as to the differences between the way ADO connects to the ODBC driver vs. the way Teradata SQL Assistant connects?



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023