-
Posting Date - Date vs DateTime on SQL
Hi, How popular would the request be to have MS change the Posting Date to a DateTime variable? Can I get a show of hands? On table 36 we've added a CreatedDateTime variable, and it's passd through to table 112 when posted. To calculate turn around time of the order from Create to Post, I currently need to estimate the…
-
Cside ODBC connection problem
we have new server (server 2003 64-bits) installed with SQL Sever 2005 (also 64-bits). This server is used for our Datawarehouse and is replacing our current 2000 sql server. To maintain the DWH, daily a selection from Navision is made using the C/side odbc connection. However we cannot install the ODBC driver on the 64…
-
Permission fails for table as view on different db
SQL Server 2000 Navision 4 SP3 I have a table in Navision which is a view in the Navision DB. It calls a table in a different DB. In Query Analyzer I can log on as the user getting an error and it works fine but in Navision i get the "combination user ID and password invalid.." message. If I assign them db_owner it works…
-
NAV 4.0 SP 1 - SQL connection issue
We have NAV 4.0 SP 1 SQL Option. In most of time, when the end users access database, the Net Type is Defaut and it work well. But now I found when I select TCP/IP socket type, the access error message is "can not found the server....". However, if Name Pipes, the access work well. I am not sure why TCP/IP socket doesn't…
-
Recordlevellocking in SQL
Sorry but I'm absolutely newbie in this topic. If I am using Navision 4 SP3 with SQL Server. Is it normal that I have errors showing "Table serial no. is locked by other user..." . Is this normal having a table lock when I'm using SQL?. Thanks,
-
Move Nav 3.7 (4.0 SP3) from SQL 2000 to SQL 2005/64
Hello, we want to move our Navision 3.7 (4.0 SP3) database from Win2000/SQL 2000 to a new server with Win2003-64/SQL 2005-64. What is the correct way: a) Navision backup. Create new db. Navision restore. b) SQL backup. Export users with SQL-Script. SQL restore db and users. We have tested b) successfully, but we are not…
-
Replication Betn 2 database with null in some column
I create two database having same datain SQL server for navision. When I add some information in 1st database it should be replicate in 2nd database . But I want zero data in some columns and other columns should be replicated with data. I used transactional replication but it will not work properly. Which type of…
-
Batch report changes data in other companies
I have a weird thing: I create a batch report on a table (table is local, so each company has its own table and also in SQL Server the companyname+$ prefix). I change a decimal field in the table with te report with the following code in the OnAfterGetRecord trigger: <field> := ROUND(<CurrentFieldValue>,0.01); MODIFY; In…
-
Cannot find the user '$ndo$shadow'
I just did a technical upgrade from Nav 4.01 to 5.0. I also upgraded from SQL 2000 to a SQL 2005 db. The db seems fine from the testing I've done as far as viewing\modifing data - doing regular user based transactions however when I attemp to import objects I get the following message: 15151,"42000",[Microsoft][ODBC SQL…
-
Table blocked
Hi, I use Nav 4.0 + SP3 and SqlServer2005. One user run a proces that block a table a long time. Another user want to use this table and obtain an lock error. Can I force the second user to wait until the table will be no locked?? Thanks Asier
-
Recommended security setup for SQL and ODBC?
What is the recommended setup for a NAV SQL implementation where users should be able to read from the SQL db using ODBC? I would like to be able to setup the entire security in NAV when we get new users (besides the AD creation). I have changed to enhanced security, since this was the only way to get the permissions…
-
Cannot delete Warehouse Activity Line in SQL version
I'm using Navision 5.0 with SQL 2005. When I'm trying to delete lines from the Warehouse Activity Line table (table 5767), I'm getting the following error: ---------------------------Microsoft Dynamics NAV---------------------------The Warehouse Activity Line does not exist. Identification fields and values:Activity…
-
SQL Reporting Services: visibility
Hello, I'm currently learning reporting services and it seems fine, but one of the things I can't figure out how to do is the equivalent of Navision's CurrReport.SHOWOUTPUT: dynamically changing the visibility of a line. Usually there is a Visible property and one can assign an Expression to set it, however, f.e. a row in…
-
Maintainable SQL queries on a NAV db
Taking some further steps towards discovering Reporting Services and T-SQL, the second bump I found on the road is that it's better not to hardcode the database and company name in the query - it means we have to use EXEC and string concatenation, but that generally looks like line noise, a total mess, so we need to find a…
-
index/key with datatime
Hello I know having a date at start of key is not good, but what about datetime?
-
TSQL to process a high volume of data?
At first, I sent this text to one well-known :) Mibuso-User who had told in the thread "Replacing CAL with SQL" about experiences using TSQL in Combination with NAV to process massive data. In fact, currently I work on a similar project. The customer has a relatively high posting load (around about 150.000 posted Orders…
-
SQL Security model and synchronization question
Am I doing something wrong or does the SQL server version of Dynamics NAV 4.0 users need both db-owner and public right for to be able to log on the Database? Or is there a way to go around not giving the db-owner rights to a user :roll:
-
[S]Is Navision backup still necessary when using SQL option?
Do you still need to do Tools --> Backup in Navision if you're doing a full backup using SQL?
-
Client technical upgrade from Update 2 to Update 6
Hi We have a Navision 4.03 with SQL Server 2005. The clients are patched with Update 2. As far as I understand, it is quite a good idea to upgrade the clients to Update 6 and turn of the IndexHinting. What is the proper way to upgrade the clients to Update 6, i.e. do we need to create a new DB with a new client and apply a…
-
Migrate a Navision DB to another SQL Server
Hi We are thinking about to migrate a Navision DB from one SQL server to another. I have some doubts about the SQL server logins: Windows-Logins: I guess this should be alright because Navision sync. process will create the windows logins automatically. DB users that have special database roles should also still work,…
-
finsql - prompts for sa-password
We are running MBS 3.7 on a MSDE-database. This works fine, but it is a bit annoying that we have to enter the sa-password everytime we open the Navision-client (finsql.exe). It is possible to get rid of this?
-
SQL server not listed on NAV client
I have up running SQL service with navision database on it, but the server itself wont show up on Navision clients server list when I'm trying to open it. But if I type the server name manually on the servername textfield and browse databases it founds the database and I'm able to connect it. Anyone had this problem? :-k…
-
Outlook Synchronization 4.0,3
Getting an error during an Outlook Synchronization when adding a new contact. "finswl.exe has encountered a problem adn needs to close." which it proceeds to do. Client has recently been upgraded to Nav. 4.0.3 SQL. The previouly could do the Outlook Synchronization. Now they cannot. Can this problem be sesolved with Update…
-
SQL 2k5 Problem(Unable to modify)
Dear All, When I am modifying anythin in the database from one machine to the SQL server 2005 based Database then I recived the error message that 'You dont have permission to modify the database.Ctact your administrator'. Also when I create new users and giving them the super permission then error message comes that ' You…
-
SQL –NAV Technical Kit DVD
Hi I've seen this offer on partnersource., filed under "December 2007 North America Partner News for Microsoft Dynamics NAV" Somebody knows what excactly is on this DVD? Is it just a compilation or does it contain new tools, etc? Regards Thomas
-
Replace C/AL code with Transact-SQL?
I was just browsing a SQL-NAV course and noticed this sentence: Source: http://download.microsoft.com/download/8/d/0/8d0a3a30-e0af-46b5-b17e-b6fd250b847f/NAV_p%C3%A5_SQL_05_06_07%20-%20ny.pdf Could anyone please explain when and how this is to be used, or a link to more information? (Besides taking the course ;-))
-
SQL Error "Optional feature not implemented"
For one of our customers we are trying to upgrade Navision SQL client version from 3.60 to 4SP3. We successfully created a test database for vanilla 4SP3 but they decided that they wanted to go further and take it to 4SP3 Update 6. We restored their live SQL backup into a test database and converted it. On the surface it…
-
Navision 5.0 upgrade from 4.0.1
Final stages of the upgrade to 5.0, i am running the Synchronization and am getting an error: "Table 5007 does not exist.". Where is this table being referenced? thanks
-
How can I use Navision to connect SQL SERVER 2000
I want to use Navision to connect SQL server 2000, Now I use the Navision database. When I create database for SQL SERVER, I must use "Windows Authentication" to create database, I don't use "Database server Authentication" to Create database,Why? When I use "Database server Authentication" to create database, I imput the…
-
SQL Rebuild Index vs NAV Client Optimize!!
Someone told me that doing table Optimization with Navision Client is better than using SQL 2005 Rebuild Index task. Is this true? :-k I hope not, because the client optimization cannot be Scheduled to night hours How often should the rebuild index used? Thanks