Navision Financials V2.01.A. C/ODBC

Business Central/NAV Technical Forum
1

We use Navision Financials V2.01.A.

On Windows server 2003 terminal server I have installed the Nav client and C/ODBC driver V2.11.00.924 from the original installation CD

Logged on as administrator it’s working just fine when importing data to Excel, but when ordinary users are logged in they got this error when importing data to Excel

The operation system cannot gain access to the file ??? ???
Please check that the file type and attributes are correct.

If users are member of local administrator group it’s also work fine for them but that is not a solution I want to use. [:(]

I found a link to a solution of the problem, but as you know this site is down

http://www.navision.net/forum/topic.asp?TOPIC_ID=4929

Does any body know where I can reach this link or have a solution off my problem it would be appreciated

Regards Jesper

2

you can try:

http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=4929

br
Josef Metz

3

Tanks for answer Josef

I have no access to the topic have to be logged in but have no user account on that site

If topic actual does exist and you or any one else for that matter have access pleas copy and pasta the topic answer here

Thanks in advanced

Jesper

4

Original question:
Hello,

I have the following problem:

I install Navision Financials V2.01.A. Then I install C/ODBC from the same CDROM (CODBC.DLL V2.11.00.924). The operating sytem is MS-Windows 2000 SP2 (german). I install this as administrator. Then I logoff and login as user. Now, when I try to make a C/ODBC request (with MS Query for example) I get the following error message:

The operation system cannot gain access to the file ??? ???
Please check that the file type and attributes are correct.

Then I press the button and the following message comes up:

S0000 [Navision Software a/s][Navision Financials ODBC Driver]Base initialization failed

I only can press and the request cames back with no data.
(The six question marks in the first error box come in the same manner as I have posted it.)

I’ve tried a newer codbc.dll (2.11.02.1507 from 28.07.1999) but it doesn’t work too.

Rolf

First answer:
Make sure that the SYSTEM user has full access to C:\ folder. By default W2K/XP has SYSTEM access as part of the default EVERYONE access. When you modify EVERYONE permissions, you also modify the SYSTEM permissions, without knowing it. See “MORE INFORMATION” in the following MS KB article:

Excerpt:

“By default, the Everyone group has Full Control permissions on an NTFS volume. This permission might have been removed to provide additional security. Individual accounts, such as the Administrator account, may have been added. However, the Everyone group includes the System account. Removing the Everyone group without adding the System account as an individual account renders the paging file unusable.”
Naji Shaman

Reply to 1st answer:
Hi Naji,

thanks for your hint. I’ve verified the permissions and SYSTEM user has Full Control to C:\ and C:\WINNT.
I haven’t modified any permissions nor deleted or moved any group. May be this is the problem?

Greetings
Rolf

2nd answer:
Try allowing write access for the User to the folder
c:\winnt\system32\ias

This corrected my problem I had.

Tim

3rd answer:
Hi Rolf

We have had the same problem and the following helped:

Overwriting the existing odbc.dll file in your windows folder with a newer one (as far as I can see it is not the same odbc.dll I have that you have tried ).

You can mail me if you want the file

Mads Morre

Reply to 2nd answer:
Hi Tim,

this was the solution to my problem, too.

Thanks much
Rolf

5

Thanks a lot for the help

On my terminal server I only had to give ”Remote Desktop Users” ”Full Control” on folder %systemroot%\system32\ias to make the ODBC driver work.

Why or what the ODBC driver use IAS folder to don’t ask me [:O]

I 'am just happy it’s working [:D]

br

Jesper

6

Maybe you may now mark the thread as Solved?

7

Hi Jesper,

navision.net was stopped a few years back now, and moved to www.mbsonline.org , so your link is at

http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=4929

just replace navision.net with mbsonline.org

by the way, where did you find that link? It seems quite old.