[Alexander.Sante]

What am I doing?

Trying to use ODBC & Coldfusion to retrieve data from Netsuite.

I am able to view the ITEMS and INVENTORY_ITEMS table with no problem. However when I try to view the “_CATEGORIES” table and most of the other tables, I get an error:

[Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: Driver does not support this function.

I used to think that error meant a Syntax Error, but i’ve made sure that this is correct. I am able to run that same query in EXCEL, and it works fine. I get the data that i’m looking for.

So why would some queries work fine in excel and not in Coldfusion? And why do some queries work in ColdFusion, but not others? I have advanced analytics on my account, and even setup a seperate Administrator account to test this out… Anybody ever get this error?
This is a cached copy. Click here to see the original post.

[Alexander.Sante]

RE: ODBC: Internal error…

Quick update..

The “_CATEGORIES” table is custom record. But i’ve also tried “ACCOUNT_ACTIVITY”, “ACCOUNTS”, and “ACTIVITIES” … same error.

[Alexander.Sante]

RE: ODBC: Internal error…

In case anyone else runs into this same problem and happens to find this topic. Coldfusions JDBC-ODBC bridge driver does not work correctly with Netsuites driver. The problem seems to be with the type of data being returned by Netsuite, it cannot be converted correctly by the JDBC driver and causes that extremely helpful error.

[Author]

Posts