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:
I'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 odbcad32
I 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...