SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 SSRS 2008 with Netsuite ODBC
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

wmendoza87
Starting Member

USA
1 Posts

Posted - 05/01/2012 :  17:38:40  Show Profile  Reply with Quote
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

USA
1 Posts

Posted - 06/04/2012 :  13:49:48  Show Profile  Reply with Quote
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

USA
2 Posts

Posted - 09/25/2012 :  10:09:29  Show Profile  Reply with Quote
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

USA
1 Posts

Posted - 03/27/2013 :  16:42:23  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.17 seconds. Powered By: Snitz Forums 2000