NAV ODBC Driver

Developer101

Has any body used ODBC driver for NAV 2009. I am trying to set it up first in ODBC Data Source Administrator in Windows. I got the ODBC driver installed but when I am trying to setup the 'database name' box is greyed out no matter what I do.
After setting it up , how many ways I can use this?

kylehardin

Does it let you enter the server name?

Developer101

Yes it does let me enter the server name but the 'Database Name' stays greyed out, I don't get that.

Developer101

Any one used ODBC for NAV ever?

Jan_Veenendaal

Isn't this depending on the type of server? As I recall the 'classic' C/SIDE server can only serve one database - so it would not make sense to select both server name and database name.

I used NAV ODBC once with little success.... we had two columns in a table with different names but with exactly the same caption ; ODBC crashed on that. Never used it again.
I did on 1 or 2 occasions use SQL ODBC to read info from a NAV database. It was very slow on large databases.

Developer101

Hi Jan
So you are saying its better not to use the ODBC? My problem is when I setup an ODBC connection for NAV in the User DSN setup available in the ODBC Data Source Administrator 32bit (accessed from Control Panel). I see a box for entering server name, database name and a company name. Database name box always stays disabled when I enter server name , but company name box stay open.

Why I don't have all the boxes open?

What I want to do is to give my boss a solution to use excel and get the flowfields in the excel query and I thought only way possible was to user ODBC connection for NAV.

kylehardin

Excellent point Jan brings up - is your NAV database on SQL, or is it a native NAV database service?

Developer101

That Database is on SQL Server

vaprog

The user must have a login to SQL Server which is connected to an SQL user on the NAV Database. Also with Enhanced Security, SQL permissions on tables might be an issue.

Try SQL Server Management Studio or another SQL query tool with the credentials you use for the ODBC connection first.

Developer101

I have sysadmin (windows logon) to SQL. I dont see any issue with logon.

archer89

best you reinstall nodbc driver using windows admin account.

Developer101

OK I will try doing that, thanks