-
Problem with Requery/Update
Hello everyone, working with a Navision 2009 R2 DB (Classic Client) changing data with a SQL-DB via ADO I'm now facing a Problem: I put data from a NAV-Table into the SQL DB with AddNew and Update, so far it works. After having written data to the SQL-DB, I have to put a value of 1 to a Status field there. This is the code…
-
Where do I find my pages and forms in sql?
Hi folks, I searched a while maybe I not long enough. I would like to find in the sql database (nav2015), the whereabouts of my pages. I am really new to sql, so I have no idea how to do that. I want to search for a trigger in pages in the c/al code. A programmer told me it would be possible to access it on the…
-
SQL Server 2014 web version is not working with Nav 2015?
Does SQL Server 2014 web edition work with Microsoft Dynamics Nav 2015? I read the Microsoft Dynamics NAV 2015 requirements but not sure. Thanks
-
Different Collation on SQL Server and NAV 2015 DB
Hello. We have a SQL 2014 Standard Server installed with a NAV 2015 database installed on that. The SQL 2014 Standard Server has the following SQL collation: SQL_Latin1_General_CP1_CI_AS The NAV 2015 database has the collation: Latin1_General_100_CS_AS To set the SQL 2014 Server to the same collation as the NAV database,…
-
How to change records in MS Dynamics customer table?
Hi, how can I change all records in column "City" / Name1 with Name 2 in table 18 Customer in Navision 4.3?
-
ADO jumps back to default
Can someone please tell me how to force the ADO connection to stay on the instance? Setup: Server S004 is running 2 SQL servers. Vanilla SQL 2008, and SQL 2012 as instance SQL2012. When connecting to the databases you point to s004 if you want bases on SQL2008, and s004\SQL2012 if you want bases on the SQL2012 instance.…
-
Modify a boolean field in NAV database by TSQL
Hi guys, If i change a Boolean field that i have added to the "Sales Invoice Header" with a SQL Script, can something wrong happen ?? Thanks
-
Lock request time out period exceeded error
Hi, I'm trying to create NAV tenant (NAV 2015) using PowerShell in Windows Server 2012 environment. When I execute HowTo-MoveCompanyToTenant script it gives following error; Invoke-Sqlcmd : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. At D: \Sana Remote…
-
AlwaysOn function in SQL 2014 (an 2012)
Hi folk, do you know the "always on" functionality in SQL Server using a Dynamics Nav installation? This would be usefull for the same company with multiples instances of SQL Server, having all databases accessible together. Is there a recommendation or any white sheet about Alwayson? If not, have any of you did a setup…
-
using ADO and SQL queries longer than 1024 char.
Hello, Has anyone got an idea how to execute sql queries longer than 1024 characters using ADO in Navision. The query I want to executed is generated dynamically during run-time, so stored procedures do not help here. What I did: I output the generated sql to text file and then used special my written automation server…
-
execute an SQL procedure from excel
Hi experts!! Does anyone know how to execute an SQL procedure from excel? I have procedures that create tables in SQL Server. These tables are used in views then I see in excel. I need to implement these procedures to update the data in Excel. Is it possible? thanks!!
-
Who generates SQL query in NAV?
Hello all, Maybe the subject is little bit wrong but here is what I would like to know. I have development and production environment that are pretty much similar. I'm running navision 4 sp3 and with client monitor check in one specific report. For the one specific command (that is repeated for several times) on…
-
Different Collation per. Company – anyone tried it?
(NAV 2009 Classic.) We are having issues with a database that is going to be used from several countries around the globe – both Europe and Asia. Each country has their own Terminal Server set in local non-unicode codepage. Each company is only used in one country, but we are unable to store local chars unless the…
-
What impact does my C/AL have on SQL?
Source: my blog. I wrote a little something about the FIND statements and such ... could be nice for reading on a Sunday evening :wink: . For the better edited version, go to my blog (the tables that I used are a pain in the ass here :( ). This is a very challenging blogpost in my opinion. I see many stories going around…
-
NAV 4.03 build 6 compatibility with Windows 8
I have a quick question: Does anyone know if NAV 4.03 build6 is compatible with Windows 8?
-
Noob question about a SQL Query
Hi all. I think this is a fairly basic query but I mainly concern myself with general admin (backups etc) from the management studio. Basically, I want to select a load of items from the Sales Price Table which are Customer Prices and have Expired. When I find them I want to set a custom field (Blocked Pending Price Check)…
-
Page size vs. record size
Hello. In NAV the max record size is 8000 bytes and the size of a page is 8KB on sql server. Can I conclude then that if sql places a page lock that then only one record will be locked? Thanks.
-
Run non-SELECT SQL statements via ADO from NAV codeunit
Hi, I have a series of custom views which are used as linked tables in NAV. Of course, each view has to be created for each company in NAV. So in SQL, I have a script with something like this in the development database DROP VIEW [DevCompanyA$v_Customer Balance View] GO CREATE VIEW [DevCompanyA$v_Customer Balance View] as…
-
Problem when connecting to SQL
Hi. We have just converted one of our customers from Native to SQL. It seems to work fine for most clients, but some are getting this error message when they are trying to connect: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" Status-ID: IM002 We are using SQL2005 and NAV4SP3…
-
getting sql windows authentication error while running repor
hello experts user when running report from rtc facing error which is 1852 28000[microsoft][ODBC sql server Driver][SQL Server]login failed . the login form untrusted domain and cannot be used with windows authentiation and i am running the same report from server directly then its working fine...suggest me some solution.
-
Device CAL?
Hi If the client is to use a Terminal Server solely for client access (say 50 TS clients) and the NAV/SQL server, how many SQL CAL do I need to purchase?
-
Resolving error "No primary key error for table in SQL Desc"
Hello, Could some please help me in resolving the error "The Pay Journal Line table has no primary key constraint in the SQL Server table description." I am getting this error after running the sp_removedbreplication even though there were no replication was done but i was getting error messages for publications and…
-
SQL connection dropping
We have a server on our DMZ where users on a VPN can connect using RDP and then use the Nav client. we have opened the SQL ports through to our SQL server and all was running OK until 3 weeks ago. We have not made any chnages to our system at all but now users can still log into RDP OK and they can still use Nav ok for a…
-
Restoring ONE company takes long and reindex other companies
Hi, I created a FBK file with the backup of ONE template company. Then deleted the template company. When I try to restore the backup, the process created tables and copy the content. But after that the process stucks at 88%. If I look with SQL Profiller I see that it's recreating many tables and reindexing data from other…
-
Update active directory from SQL Server
Does anyone know of any prepackaged software or callable routines that would allow Active Directory to be updated via SQL or a callable routine from NAV? I have a customer who has been updating phone numbers and other information from the employee file using DTS. They have now moved from SQL Server 2005 to SQL Server 2012…
-
Yes, Virginia, you CAN run Navision 2009 on SQL 2014
I just thought I'd drop y'all a note to let you know that I've tested it, and it appears to work just fine. I know the online documents for SQL 2014 said "no breaking changes", but we've been around long enough to take that with a grain of salt, have we not? 8) As always, YMMV, so test for yourself, but I had no problems.…
-
Can´t find Database/Server with Connection Type = Default
Hello, I´m just desperated. When i´m trying to open the database in de Classic Client (Connection Type = Default) the Database/Server cannot be found. If i am changing Connection Type manually to "TCP/IP Sockets" everything is working fine in the Classic Client! Now, the real problem is that when i´m opening the RTC client…
-
[SQL 2014 4 NAV 2013R2] Enterprise vs. Standar version
Hi All, I am working for a client who needs a complete upgrade of hardware and software. We plan to upgrade to Nav 2013 R2 and SQL Server 2014. We are currently debating on whether to implement Standard Edition or Enterprise Edition. Considering that Enterprise Edition is very costly than standard edition, I need to…
-
SQL Server Web Edition
Hi all According to MS SQL Web Edition is not on the supportet list of NAV2013/2013R2. But it seems to be running fine. Anyone have a comment on this. The reason for using Web Edition would be to get past the 10GB DB and 1GB memory limit, without having to buy the Standard edition.
-
Evaluation Period has Expired - NAV/SQL runtime license
Hi all, We are getting an error telling us that the Evaluation Period for SQL has Expired, so the Management studio will not open and we cannot restart services. As a quick workaround we can set the server date a few days back but it's not a solution. Our NAV license includes an SQL Runtime license, and it has been…