Provider Syntax

Analytics

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.
3 REPLIES
N/A

Re: Provider Syntax

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.

Re: Provider Syntax

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 Source=server.com;
Persist Security Info=True;
User ID=myuserid;
Password=mypassword;
Extended Properties=Default Database=DB_Name;
Session Mode=ANSI
Enthusiast

Re: Provider Syntax

try this....

con.Open "Driver={Teradata};DBCNAME=" & DSN & ";uid=" & user_id & "; pwd=" & passwd

let me know if this works for you.

-- Sparan