Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


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

Hi

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?


Thanks,

Rory



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