Archives of the TeradataForum

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

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

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>>