[longlam]

Hello All,

I’ve had a # of issues with the new driver and would like to explore further why this is the case. Has anyone successfully connected using the new ODBC driver to their reporting applications?

Also does anyone use Java and use the driver with the ODBC/JDBC bridge to connection the database with your Java application? I also have had many issues with this.

Any support is appreciated.

Thanks!
This is a cached copy. Click here to see the original post.

[sconan]

RE: Has Anyone Gotten the New ODBC Driver to work?

I’ve been using it with some of the .Net applications that I’ve written. What kind of problems are you seeing?

[sklett]

RE: Has Anyone Gotten the New ODBC Driver to work?

If you encounter an error from WinSQL like:

—————————

ODBC Error

—————————

SQL Error State:S1000, Native Error Code: FFFFFFFF, ODBC Error: [SimbaLNA][unixODBC]NotEnoughConnInfoButDriverNoPrompt/1

—————————

OK

—————————

You need to set the Company and Role reg keys.

[longlam]

RE: Has Anyone Gotten the New ODBC Driver to work?

I’ve set the keys but,when connecting using java, the system will hang directly on the connection line (this is through debugging and stepping through the program).

Just out of curiosity, was everyone’s path to the reg values: HKEY_LOCAL_MACHINE -> SOFTWARE -> ODBC -> ODBC.INI -> NetSuite.com

Also, set keys are:

Company: World of Good

Role: Administrator

Any issues with company names with spaces?

[sklett]

RE: Has Anyone Gotten the New ODBC Driver to work?

yes, my path is the same.

Also, our cpmpany has spaces and it works fine.

[longlam]

RE: Has Anyone Gotten the New ODBC Driver to work?

Are you using java? If so did the connection lines look like this:

Code:
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”).newInstance();
Connection con = DriverManager.getConnection(“jdbc:odbc:Netsuite.com”, “long@worldofgood.com”, “****”);
I’m going to try connecting using the WinSQL tool that you talked about and see what happens.

EDIT: So when I tried the WinSQL tool, I got a buffer over run error and the program crashed. Not sure what is happening but will research further.

[longlam]

RE: Has Anyone Gotten the New ODBC Driver to work?

Follow up questions?

What Windows version are you running? I’m on Server 2003.

Are you using the System DSN to connect or a User DSN? I tried using the server DSN, Netsuite.com since that is the only one that has registry keys.

[sklett]

RE: Has Anyone Gotten the New ODBC Driver to work?

Originally posted by longlam

Are you using java? If so did the connection lines look like

I’m using .Net – although with WinSQL being a client tool this is a non-issue

[sklett]

RE: Has Anyone Gotten the New ODBC Driver to work?

Originally posted by longlam

Follow up questions?

What Windows version are you running? I’m on Server 2003.

Are you using the System DSN to connect or a User DSN? I tried using the server DSN, Netsuite.com since that is the only one that has registry keys.

WinXP Pro

I think I’m using the system DSN, although I’m not real familiar with the DSN stuff, I’m used to using connection strings. Is there a way I can tell which DSN I’m using? I will report back if you tell me how I can make the determination.

[longlam]

RE: Has Anyone Gotten the New ODBC Driver to work?

If you go to Control Panel -> Administrator Tools -> Data Sources (ODBC)

you will see a list of Data Sources you have. The data sources are sorted by types using the tabs.

Maybe it’s a Windows 2003 Server thing. I will try it on my local computer at home to see if it works….

Any 2k3 users out there?

[sklett]

RE: Has Anyone Gotten the New ODBC Driver to work?

Thanks for the instructions. I’m using a System DSN.

[Nigel West]

RE: Has Anyone Gotten the New ODBC Driver to work?

As far as I am aware the new ODBC Driver simply does not work at all, best thing to do is un-install it and revert back to the old version. This was the recommendation from NetSuite also as they know they have issues with the new driver.

[mshuman]

RE: Has Anyone Gotten the New ODBC Driver to work?

It took me 6 minutes to select the top 10 cases. Any ideas why this takes so long now?

[sklett]

RE: Has Anyone Gotten the New ODBC Driver to work?

We just renewed and didn’t order ODBC again because:so slow
totally unreliable
That doesn’t help you, I know, just thought I would comment that for me it was always painfully slow.

[mshuman]

RE: Has Anyone Gotten the New ODBC Driver to work?

I called support and they told me that they were upgrading the databases and it was impacting my ODBC? This sounds a bit off. Case 685145

[Author]

Posts