InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 11:55:28 GMT20http://www.sqlservercentral.com/Forums/Topic1309881-1044-1.aspxI agree with anthony.green.Thu, 03 Jan 2013 09:19:47 GMTellahliamehttp://www.sqlservercentral.com/Forums/Topic1309881-1044-1.aspxThe problem will most likely be down to 32 vs 64.As you see the DSN in SysWOW64 that means the DSN is a 32bit DSN not a 64 bit DSN, therefore if SQL is 64bit SQL it cant pick up on that DSN, it needs to be in the 64bit DSN library (C:\Windows\System32zodbcad32.exe). So options are, install a 32 bit version of SQL, create the linked server to Netsuite, then create a linked server from 64bit SQL to 32bit SQL, create a 64 bit DSN, use SSIS running in 32 bit mode to pull data from Netsuite into the 64bit instance or go with CozyRocTue, 25 Sep 2012 08:17:38 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1309881-1044-1.aspxI can suggest an alternative for you to check. It is for SQL Server Integration Services. The latest version of [b][url=http://www.cozyroc.com/]COZYROC SSIS+[/url][/b] 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.Tue, 25 Sep 2012 08:07:40 GMTCozyRochttp://www.sqlservercentral.com/Forums/Topic1309881-1044-1.aspxHi all,I'm having an issue to create a linked server connection to netsuite on the cloud.They supplied me with an ODBC driver... They say that the odbc drive supports 32bit and 64 bit systems?!?!?With the same ODBC, I was able to connect with Excel 2010 but I can't figure out how to get the linked server working... I'm thinking, If it works for Excel it should work for MS-SQL... They're both microsoft products!!! right?My Excel data connection resembles this:DSN=NetSuite.com;UID=mylogin;SDSN=NetSuite.com;HST=odbcserver.netsuite.com;PRT=1708I'm on Windows 7, I see the odbc driver in my system DSN and user DSN in c:\windows\sysWOW64\odbcad32.exe and only see the odbc driver in the user DSN in the systems odbcad32I have a feeling that this has to do with a 32bit vs 64bit problem... but am not sure.I'm sure I'm not the first one with this problem and also sure that there must be a solution... Any help would be greatly appreciated as it's been practically a week that I'm trying to sole this problem... ThanksFri, 01 Jun 2012 11:20:33 GMTjghali