on 08-04-2007 2:18 AM
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
Thanks
I got it working when I added the driver .jar file to aii_af_jmsproviderlib.sda and deployed the sda.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
check if the drivers are installed.
http://help.sap.com/saphelp_nw04/helpdata/en/80/4f34c587f05048adee640f4c346417/content.htm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.