cancel
Showing results for 
Search instead for 
Did you mean: 

How to connect jdbc Adapter to Teradata

Former Member
0 Kudos

Hi gurus

Could any one let me know what the connection string would be to connect JDBC Adapter to Teradata Database.

I am currently using JDBC:OBDC Driver (sun.jdbc.odbc.JdbcOdbcDriver) and my connection string is : jdbc:odbc:teradata://<host>;DatabaseName=xxx

I get the error

Cannot establish connection to URL ......

SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified'

Thanks in Advance

Jai

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks

I got it working when I added the driver .jar file to aii_af_jmsproviderlib.sda and deployed the sda.

prabhu_s2
Active Contributor
0 Kudos

JDBC Driver : sun.jdbc.odbc.JdbcOdbcDriver

Connection : jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ= D:\USERS\OPS\OPS.mdb ;

also check if this is useful

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

prabhu_s2
Active Contributor
0 Kudos
Former Member
0 Kudos

hello Prabhu,

How r u!!

Pls response to my question --- to which Middleware to use Orace fusiion or SAP XI . It is is 1st page.

Regards