Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 SSRS 2008 with Netsuite ODBC

Author  Topic 

wmendoza87
Starting Member

1 Post

Posted - 2012-05-01 : 17:38:40
Has anyone tried to use NetSuite's ODBC connection with SSRS 2008. I was able to create the data source and can run reports in the Business Intelligence Studio, but I can't get the report to work once it is deployed to the SSRS site. I keep getting the error seen below.

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

We are having lots of issues with NetSuite's standard reporting and would like to make our own.

oleksiy
Starting Member

1 Post

Posted - 2012-06-04 : 13:49:48
Did you check these links?
http://blog.prolecto.com/2009/04/15/sql-reporting-on-netsuite-data-step-by-step/
http://blog.prolecto.com/2009/03/27/netsuite-delivers-on-odbc/
Go to Top of Page

CozyRoc
Starting Member

2 Posts

Posted - 2012-09-25 : 10:09:29
I can suggest an alternative for you to check. It is for SQL Server Integration Services. The latest version of COZYROC SSIS+ library includes NetSuite adapters. You can both read and write from/to NetSuite service. The pricing starts at $399.95/Year. Programming skills are not required.

SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Go to Top of Page

jabrunetti
Starting Member

1 Post

Posted - 2013-03-27 : 16:42:23
Did you ever figure this out? I would love to talk to you. We are experiencing the same issues.

jbrunetti@in-termserv.com


quote:
Originally posted by wmendoza87

Has anyone tried to use NetSuite's ODBC connection with SSRS 2008. I was able to create the data source and can run reports in the Business Intelligence Studio, but I can't get the report to work once it is deployed to the SSRS site. I keep getting the error seen below.

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

We are having lots of issues with NetSuite's standard reporting and would like to make our own.

Go to Top of Page
   

- Advertisement -