Archives of the TeradataForum
Message Posted: Thu, 11 Jan 2007 @ 11:34:28 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|