All Forums Analytics
Sputnik 1 post Joined 01/05
21 Jan 2005
Provider Syntax

We are trying to connect to Teradata from .asp pages. We are having trouble with the provider syntax.> We are able to connect using: DSN=XXXX> We are not able to connect using:oConn.Open "Provider= Teradata ;" & _ " DBCName =MyDbcName;" & _ "Database=MyDatabaseName;" & _ "Uid=myUsername;" & _ "Pwd=myPassword" > Error reads: ADODB.Connection error '800a0e7a' Provider cannot be found. It may not be properly installed. Any suggestions? Thx.

cmarr 1 post Joined 08/06
10 Aug 2006

Does anybody have a solution for this? I had the exact same problem as Misfit and Sputnik and can't seem to resolve it. I also don't want to use SQL Server Providers. I want to user the Teradata provider. Any help would be appreciated.

jdarton 4 posts Joined 10/05
10 Aug 2006

I was able to get mine going by installing the latest TD driver for OLE/DB and using this connection string:Provider=TDOLEDB.1;Data;Persist Security Info=True;User ID=myuserid;Password=mypassword;Extended Properties=Default Database=DB_Name;Session Mode=ANSI

sparan 19 posts Joined 05/06
31 Aug 2006

try this....con.Open "Driver={Teradata};DBCNAME=" & DSN & ";uid=" & user_id & "; pwd=" & passwdlet me know if this works for you.-- Sparan

You must sign in to leave a comment.