Set the Product Name to Teradata Database.
#Odbc driver for sql server 2008 drivers#
Select Microsoft OLE DB Provider for ODBC Drivers.Assign a name to the Linked Server I suggest a single word name like TD.Make Sure MSDASQL (Microsoft OLE DB Provider for ODBC Drivers) is installed on the server.Select the Data Source created in the previous sectionĤ.Select Use data source name radio button.Select the Microsoft OLE DB Provider for ODBC Drivers.Double-Click the file to display the Data Link Properties dialog box.Change the file extension to UDL (for example Foo.UDL).Right-Click and select " New" - > " Text Document".Fill in the required fields in the ODBC Driver Setup for Teradata Database dialog box.User DSN will not work because SQL Server service will not have access to the User DSNs. Start the ODBC Data Source Administrator.You can use the steps in the "Test the ODBC Data Source" section to see a list of OLE DB Providers currently installed on your server. The OLE DB Provider for ODBC 64-bit if it is not included in your OS.:Īt .(Database.java:374)Īt .(Database.java:323)Īt .(Database.java:285)Īt .(Database.java:275)Īt .(DatabaseFactory.java:76)Īt .(DatabaseMeta.java:2455)Īt .(DataHandler.java:511)Īt (Unknown Source)Īt (Unknown Source)Īt .invoke(Unknown Source)Īt .(AbstractXulDomContainer.java:329)Īt .$n(SwingButton.java:58)Īt .dispatch(Unknown Source)Īt (Unknown Source)Īt $000(Unknown Source)Īt $1.run(Unknown Source)Īt (Native Method)Īt $1.doIntersectionPrivilege(Unknown Source)Īt (Unknown Source)Īt (Unknown Source)Īt (Unknown Source)Īt (Unknown Source)Īt (Unknown Source)Īt (Unknown Source)Īt (Unknown Source)Īt .show(SwingDialog.java:234)Īt .XulDatabaseDialog.open(XulDatabaseDialog.java:256)Īt .ConnectionPanel$AddDataSourceAction.actionPerformed(ConnectionPanel.java:255)Īt (Unknown Source)Īt $Handler.actionPerformed(Unknown Source)Īt (Unknown Source)Īt (Unknown Source)Īt .BasicButtonListener.mouseReleased(Unknown Source)Īt (Unknown Source)Īt (Unknown Source)Īt (Unknown Source)Īt (Unknown Source)Īt (Unknown Source)Īt (Unknown Source)Īt (Unknown Source)Īt (Unknown Source)Īt (Unknown Source)Īt (Unknown Source)Īt (Unknown Source)Īt (Unknown Source)Īt $2.run(Unknown Source)Īt .SimpleJdbcDataSourceDialog.performConfiguration(SimpleJdbcDataSourceDialog.java:152)Īt .(SimpleJdbcDataSourcePlugin.java:70)Īt .actionPerformed(AddDataFactoryAction.java:79)Īt (Unknown Source)Īt .BasicMenuItemUI.doClick(Unknown Source)Īt .BasicMenuItemUI$Handler.mouseReleased(Unknown Source)Īt (Unknown Source)Īt (Unknown Source)Īt (Unknown Source)Ĭaused by: .:Īt .(Database.java:510)Īt .(Database.java:358)Ĭaused by: : The specified DSN contains an architecture mismatch between the Driver and ApplicationĪt .createSQLException(Unknown Source)Īt .standardError(Unknown Source)Īt .SQLDriverConnect(Unknown Source)Īt .initialize(Unknown Source)Īt .connect(Unknown Source)Īt (Unknown Source)Īt .(Database.This blog outlines the steps to create a SQL Server 2008 (64-bit) R2 Linked Server to the Teradata Database. The specified DSN contains an architecture mismatch between the Driver and Application but When I test it in the pentaho report design 3.8.2 and got below error:Įrror connecting to database : .:Įrror occured while trying to connect to the databaseĮrror connecting to database: (using class ) I test the connectivity from Kettle Spoon Database Connection screen and found it working well. I tried to connect sql server 2008 via ODBC to design report.
0 kommentar(er)
