-
Linked Object to SQL-View to Oracle Table through MSDAORA
Following situation: SQL-Server 2000 Linked Server to Oracle through MS OLE DB Provider for Oracle SQL-Server throws an Error when trying to show records in SQL Enterprise Manager: 'IRowset::GetNextRows' returned 0x80004005... The sql view looked like: SELECT Fieldname, Fieldname2 FROM ORACLESERVER..NAVISION.SOMETABLE…
-
Backing up to a mapped drive
Hi all, Is it possible to make an SQL back-up to a mapped drive?
-
NT AUTHORITY\NETWORK SERVICE sessions on master DB from NAS
Yesterday we moved the SQL-NAV database to a new windows 2008 64 bit server with SQL 2005 sp2. Now when I look at the sessions I see a new session for NT AUTHORITY\NETWORK SERVICE to the master database appear almost every minute. I stopped the Navision Application Server and all the sessions disappeared. But when I…
-
License issue
Hi How to license SQL Server correctly for Navision concerning users? Is the number of SQL Cals the number of licensed concurrent Navision users or is it the number of installed Navision clients? Thanks in advance Thomas
-
Backup/dump of a selected tables.
We have seen an issue where an index in a table was destroyed. We were able to use Navision anyway, but we were having real problems rebuilding the indexes. I have previously worked some with MYSQL and there is this brilliant feature MYSQLDUMP. What is does is basically dump a database or a collection of databases for…
-
Problem in Window AUthentication
We have a NAV5.0 (window authentication) running with SQL server 2005. We are facing probelm in some transactions e.g. Posting of PO, modify in item card. Error message appear "Combination of USer ID and paswword is incorrect". If i give a sysadmin role (sqlserver role) to that user then all the transaction is working fine…
-
"Server Not Found" Error while connecting to sql server
Hi all, I have installed sql server in the server system.I am able to connect SQL server database by using the SQL fin from the server system.But i am not able to connect from the client system's thorugh SQL fin which is giving me the error "Server not found" at the time of choosing the database. I tried out to ping the…
-
Difference between backup from NAV and SQLserver
What is differnece in backup taken from NAV front end and MSSQL back end. I had restore a backup taken from both (SQL & NAV), i found the same. but i heard there is some difference, need to know what? please help Regards, Jai :?:
-
Minimum permission in SQL for NAV users?
What is the minimum permission required on SQL server to nav user to their normal work without backup/restore/user creation permission??. Regards, Jai :?:
-
Navision disconnects from SQL when my internet dies.
I have a weird issue. I am have been having internet issues over past few weeks (DSL). The issue here is that when the internet disconnects, Navision disconnects from the SQL server. I have SQL (2008) and Navision (5.00sp1) on the same Vista laptop (DELL-01). I connect to SQL using the computer Name, I didn't try IP…
-
how to delete a virtual table record from sql server
hi all, i write a code for deleting a virtual table record as shown below. delete from [Sample DB].[dbo].Session where [Sample DB].[dbo].Session.[User ID] ='xxxx' it shows an error like "View or function 'Sample DB.dbo.Session' is not updatable because the modification affects multiple base tables." is it possible to…
-
mdf vs ndf ina a SqlServer Database
Hi, When I create a SqlServer Database in Navision, It creates an mdf, ndf and ldf file. Ok, ldf is the Log file an I see that all my tables are in ndf file. What is the purpose of mdf file?? What does mdf file contain?? Thanks Asier
-
Create a variable cursor
Hi, I want to create a cursor dynamically to a non determined company\table in NAV. like this: DECLARE @Company varchar( 50);DECLARE @Table varchar( 50);DECLARE @EndPoint int;SET @Company = 'Company';SET @Table = 'TableName';DECLARE curData CURSOR LOCAL FAST_FORWARD FOR Select DISTINCT EndPoint from…
-
SQL Reporting question concerning G/L Total-Balance
Hi, I was asked to recreate the default Navision Report G/L Total-Balance (in NAV 2009 Report 11002) using SQL Reporting Services. The first steps were quite easy, but somehow the totaling will not work. The problem is, that the information what accounts should be summed is in the table "G/L Account", whereas the…
-
SQL reporting
Does anyone use SQL report builder with Navision. We have had a demo and it looks a lot more user friendly than Jet reports which we currently have. Alan
-
Error SQL Server 17750
When I have to try open NAV with windows authentication... The following SQL Server error(s) ocucrred: 17750, "42000",[Microsoft][ODBC SQL Server Driver][SQL Server] Could not load the DLL C:\Program Files\Microsoft SQL Server\MSSQL.1\Binn\xp_ndo.dll, or one of the DLLs it references. Reason: 126(It cant find the specified…
-
Transaction Log deleted !
Hi everyone, I have some questions about recovering a database with the transaction log file deleted. One of the "IT" guys thought that it was too big and deleted it. And the database was detached from the master db. So, after a few hours of reading/searching i'v made a backup of the ndf and mdf file and renamed them on…
-
Problem checking for 0 values in decimal field in SQL
Hi there, I've made a change for a customer running on NAV 2009 on SQL Server 2008, to check if any lines on a Purchase Order have a unit cost of 0. If so do not allow the PO to be released. For lines with Unit Cost of 0.21919 say, the check if unit cost = 0 is returning TRUE?? It does not happen on Native client. Has…
-
customer discount
Does anyone know how we can easily see a customer net price of an item. eg. A customer calls us and asks how much will it cost him for an xyz part. We have customer discounts set up but as far as I know you only see the net price when you enter the sales order and the discount is added to the line. This seems a long way…
-
BA configurator error
When I run the BA configurator, I am getting an error message when it tries to create SSIS Package (Part 1): SsisError1 Exception from HRESULT:0xC0048021 I have a Vista PC with SQL Seerver 2005 SP2 and SQL Server 2008 SP1 as an instance. My research indicated that a bad SQL Server 2008 install could cause the problem - I…
-
Migration from SQL Server from 2000 to 2005 2008 (Nav 3.70B)
Hello, i am supervising a customer who uses Navision 3.70B but without product support. Currently SQL 2000 with the latest SP's is running under Windows Server 2003. They plan to upgrade the hardware, think about upgrading the SQL Server too. Are there any problems to expect? Ok, i know, the best would be to sell a…
-
Windows Authentication Problems
Having problems trying to implement windows authentication. Setup is NAV 5.0 SP1, Windows 2003 64bit, SQL2005, Security model standard. Added myself as a windows logon in NAV with appropriate permissions. Initially was getting "invalid username and password". Subsequently have added the extended stored procedures…
-
Navision from SCSI/CSice to SAN/SQL
Hello we are planing to change our database from C/Side to SQL and to change from a SCSI HD shelf to a Fibre Channel SAN. Is there anyone who has already done this? Now we have aHP Proliant DL380 G5 with Windows 2003 R2, 4 GB Ram, Xeon Quadcore 2,8Ghz and 12 (15K Disks 24 HD as Raid1). The System is okay and the user locks…
-
Prevent user access through Query Analyzer etc.
Hi All ! I want to forbid users login to SQL Server with anything accept Navision Client. I try to experimented with sp_$ndo$loginproc and database role but with no succcess. Any help? Wojtek
-
SQL 2008 Compressed Backup is amazing!!!
We are moving from SQL 2005 Enterprise x64 to SQL 2008 Enterprise X64 next week. Our Navision version is NAV 2009 executables & NAV 5.0 codebase. I have done some testing in regards to back ups and restores and feel I must share the results. We have a 111 gb database. A normal backup takes 25 minutes (and the size is 111…
-
Critical Rename Error in v4.03 SQL
Has anybody else noticed that it is possible to rename a customer record in v4.03 on SQL to <BLANK>? The same is true for vendors and all other tables with a single field as primary key, but only if the NotBlank property on the field is No. The same is not possible in the native client - it fails with the error "You cannot…
-
Cannot Post Item Reclass. Journal
Hi Experts, Please find the attached Error screen shot. I am making a Purchase Order and assigning a Lot No to the Item(s) in it. Later, I am calling the same item in an Item Reclass. Journal and assigning a New Lot No. Till Lot No assignment it is fine. But when I try to post the entry, I am receiving the error mentioned…
-
Item Reclassification Journal Error
Hi Experts, Please find attached the error message I received while trying to Post an Item Reclass. Journal. I 've filled the fields and selected the existing Lot No and assigned the New Lot No against it. But when I try to post the entry, I am receiving the following error. Thanks in Advance.
-
UTC troubles
I have a problem fetching datetimes from a SQL table on a server separate to the one used by NAV. Through a series of views I've managed to create a table in NAV which looks directly into the desired table on the separate SQL Server. Testing my views step by step I can validate that the datetime fields are passed along…
-
Time-out error during restoration
Hello. Saw this error today. I was wondering if anybody else has seen it. Restoring a fbk into sql 2005 with 5.0 sp1 exe. Getting the following time out error.---------------------------Microsoft Dynamics NAV---------------------------The following SQL Server error(s) occurred while accessing the Value Entry…