15. Juni 2008 08:30
16. Juni 2008 10:34
16. Juni 2008 11:41
16. Juni 2008 12:02
16. Juni 2008 14:05
16. Juni 2008 15:27
To add the extended stored procedures, follow this procedure:
From your server computer, access the Navision
Installation CD-ROM. In the folder $:\SQL_ESP, where the
$ is the CD-ROM drive, click the file xp_ndo.exe. When
prompted, enter the path to the BINN subfolder of the
SQL Server installation folder. (The unzipped xp_ndo.dll
file must be in this folder on SQL Server.)
When Navision connects to the server for
the first time, the program adds the extended stored
procedure automatically.
If the program detects that the server has already been accessed
by Navision, it does not automatically add the
extended stored procedure: you must add the extended stored
procedure manually.
To manually add the extended stored procedures, follow this procedure:
Using a Microsoft tool such as Enterprise Manager, add the
file to the extended stored procedures already installed on
SQL Server. (The name of the extended stored procedure must
be xp_ndo_enumusergroups and xp_ndo_enumusersids.)
After the extended stored procedure has been successfully added
to the server, you must grant execute permissions to the "public"
role by following this procedure:
- Open Enterprise Manager.
- Expand the server and expand the databases.
- Expand the master database and the Extended Stored Procedures.
- In the right side panel, right-click xp_ndo_enumusersids and
xp_ndo_enumusergroups and select Properties.
- Select Permissions and grant EXEC rights to "public."
To Update an Existing xp_ndo.dll File:
--------------------------------------
If you have upgraded to the SQL Server Option for Navision 4.0
you must copy the new xp_ndo.dll file to all the instances of
SQL Server in your network.
- Stop the server before you copy the dll. This ensures that the
old dll is not loaded and is overwritten by the new dll.
- Locate the xp_ndo.exe self-extracting file on the product CD.
- Extract it so that it overwrites the existing dll file which is
stored in the BINN subfolder of the SQL Server installation folder.
The new dll contains a new extended stored
procedure - xp_ndo_enumusergroups. If you are going to connect
to SQL Server with an older version of the Navision client,
the old extended stored procedure xp_ndo_enumusersids should
also be added to the server.
The installation program for Navision 4.0 installs the dll and
adds both of the stored procedures to the server.
----------------------------------------------------------------
SQL Server 2000 - 64 bit
If you are running on SQL Server 2000 - 64 bit, you must use
another compiled version of xp_ndo.dll. This can be found on
the Navision Installation CD-ROM, in the folder $:\SQL_ESP\WIN64,
where the $ is the CD-ROM drive.
To add the extended stored procedure, follow the instructions
described above.
16. Juni 2008 15:31
18. Juni 2008 12:15
18. Juni 2008 12:16