-
Sort order after changing to SQL database
Hello, we are planning a change from cside to sql database. And now we have problems with the sort order during our tests. We still get an error message when we want to change the SQL Data Type value into Variant. we did it like this way: open the table "27 Item" in the object designer in design mode. Then properties of…
-
Upgrade SQL Server 2000 to SP3 With Navision 4.0 Database
I have a navision 4.0 database on a SQL Server 2000 (with no Service pack on the sql and the navision). I want to upgrade SQL Server 2000 to SP3. Do i have to upgrade Navision 4.0 to Sp3 to ? Is Navision 4.0 with no SP works with SQL Server 2003 with SP3? I have tested both senarios SQL Server With or Without SP3 and…
-
User Groups in Sql
Hi Everybody, Has anyone ever used the User Groups in SQL and therefore in Naviison as well. I have used them in Navision 4.1 but there have been so many problems realted to them that had to opt for the users themselves. Any feedback is welcome.
-
Sinchronize single login
I try to sinchronize an user and an error apper telling something about time out expired. It doesn't happen always so I don'nt know what can produce this. Can someone help me, please? Thanks
-
Error while creating a new company in Navision 4.0
Hi, I am geting a Warning dialog box while creating a new company in my SQL server database. The message says, "The Microsoft Business Solutions - Navision TableRelation properties and the SQL Server foreign keys have not been synchronised successfully." Give me suggestions to proceed further. Thanks and regards, Vasu
-
UserName password combination invalid
Hi, I'm new to the company I work for, but have been working with NAV as a Developer on and off since 1998. Anyway. We use SQL 2005. We are running 4.00 SP3 on the front end, and 3.70.A on the back end. We use database authentication. A user was getting the Username/password combination is invalid message. I went into SQL…
-
Calling SQL Server 2005 Stored Procedures
Hi, I am new to Navision, I have SQL server Knowledge. Can anyone please tell me how to call a storedprocedure from Navision.. Which are the global variables i need to create.. Thanks in advance Shibily.
-
Clustering in SQL
The Primary Key of Value Entry Table is Clustured Index in SQL Server 2000 & we are going to change the key property to Non-Clustered in SQL. So is there any bad impact from the Navision(Version 3.7) point of view???? Looking forward for your suggesion & thank you in advance. Regards, Paul
-
questions regard navision 5.0 in regards to the SQL database
Hello there got a question regarding Does navision 5.0 support a 64 bit SQL environment? another question is does implementation of the Navision 5.0 require mixed mode authentication or windows authentication? thanks!
-
Transaction is not commited for some users
On sunday our customer installed MS SQL 2005 SP2 and trasnfered the database from MS SQL 2000 server to this new server. They are using 4.0.3.25638 (NAV 4.00SP3+update6) version of NAV client, objects are on 3.70B version. Today we found out that in some situations and for some users aren't some transactions commited into…
-
Getting Decimals from SQL Query
Hello, I've been searching the forums for some time but I haven't been able to find a solution to my problem. Though it's pretty standard stuff. O:) I'm making SQL Queries in my (SQL 2000) DB and getting sums from the DB. select sum(Quantity) as SMQ, sum(Amount) as SMA from ['+CompName+'$Sales Invoice Line] ... I can't…
-
Navision ODBC driver
i am running Navision 4.0 and i have also installed the Navision 4 ODBC driver but yet still anytime i want to run the Navision sql client it complians of my ODBC drivers out of date, i should update it. Do anyone knows how to solve this?
-
importing the Navision demo database to sql 2005
How can i import the Navision demo database into my sql 2005 server? Tried connecting to it from another pc but it says the Navision demo database does not exit on the sql server. Can someone help please..
-
NAS and Login SQL with Authenfication Windows
HI, I have a NAS which run on SQL Base. When I use authenfication windows (with OLEDB), NAS can't log on Base. When I use base authentifcation, NAS can log on Base. Somebody have a idea ??
-
Maintain relationships-> DataPerCompany must be
Our customer has a problem, he has converted a native 3.70 database to sql 2000. In the native db, the table contact was set open (DataPerCompany=No). Now he wants to use the function Maintain Relationships (File > Database > Alter > Tab:Intergration). When using this function the following error occurs:The Microsoft…
-
Data migration SQL
May I just use attach and detach database Nav for migration SQL from sql standard edition to enterprise edition? rgds, Angelo
-
SQL NAV installation
I recently installed SQL Server 2005. In order to be able to use Windows Authentification for the NAV SQL client, I need to install 2 extended stored procedures on the SQL Server: xp_ndo_enumusergroups and xp_ndo_enumusersids. How do I do that? Thanks.
-
SQL Server Security
Hi , I have assigned one database user whose role is super in Dynamics NAV. What should be the minimum Database role to be given to the database user at SQL server level, so that database user at max can only view the data from the SQL server. Expecting an early reply. Thanks & Regards, Aniruddha
-
Collation Issue
A month ago we upgraded from SQL 2000 to SQL 2005 and from NAV 4.01 to NAV 4.03 Update 6. Since then, several of our users noticed that when they pull up the item list, the items aren't in the right order that they are used to. We identified that there was a collation issue that caused this and to restore our db. We…
-
How to turn on Index Hinting for NAV?
I've heard of the arguments for Index Hinting. I want to incorporate it into my methods to optimize SQL using NAV. I've searched the properties in NAV and couldn't find Index Hinting property. Is it something on the SQL Mgnt Studio that I need to turn on? And can I turn it on per table? Or does it have to be for the whole…
-
SQL Server error ... accessing the Sessions table
We've been struggling with variations of the same theme of error message. Generally, the message is: The following SQL Server error(s) occurred while accessing the Sessions table: 229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]The SELECT permission was denied on the object 'Session', database '<database…
-
Lost indexes
Hi, we are using NAV 4.0 on SQL 2005. Last week I made test environment using: create new database from backup. All data are restored but without any index/keys. Keys are defined in Navision client but in SQL are all tables without keys. How can I copy indexes from our live database? Or how to "implement" Navision keys on…
-
NAV5SP1 - Consequences of Bulk Inserts?
The announcement of NAV5SP1 mentions Bulk Inserts are introduced, but does anyone know what it means? I guess it means that all inserts are buffered and inserted bulked in some way, but when? Right before the commit or right before any other transaction to any table or the exact table? If it doesn't insert until the…
-
SQL Server Error on Field Rename
Setting : Attain 3.70 B Client Running on SQL Issue : After Renaming a field in a Table, I could NOT save the Modifications made. I get the following error: The following SQL Server error(s) occured while accessing the Employee Table: 15333, "42000",[Microsoft][ODBC SQL Server Driver][SQL Server] error: The qualified…
-
Problem Importing Object that Overwrite Existing Table
Hello I have a navision database where the database name is '366-NaviDB'. When I try to import objects where a table exists with new fields or Keys I have the following error: The Following SQL-Server error(s) occured while accessing the Sales Header(or any table) table: 15333, "42000", [Microsoft][ODBC SQL Server…
-
Where is Flow Field??
Hi, I 've got a table with an FlowField. If I see this table in SqlServer, this field doen't appear!! Where's it? I need to use it because i run some t-sql sentences against this table. Any suggestions?? Thanks Asier
-
SQL View - Not Working???!!!
Hi all, I'm trying to use a SQL View to display a large quantity of information across several tables. The View is written and returns the data as expected. However, in Navision the table is "blank" In Navision, the table's LinkedObject property is set to 'Yes' as is the LinkedTransaction (same database / server). If I try…
-
Questions to database login
Hi I'm running some tests with db login and got some questions. Navision 4.03, Standard Security with SQL Server 2005. 1) If there is and old db login without an sql login, the synchronization stops and the system is not synchronised for all other logins. Is that true? If yes, is there a workaround (appart from adding the…
-
SQL Report Count issue
Here is another SQL Reporting services issue that I am experiencing. Your imput is appreciated. I get the following error on the report that I am working on, as soon as I added a new item to my dataset. The error is: An internal error occured on the report server. See the error log for detail. I added a new item to the…
-
SQL reporting Services issue
Hi there. I am creating a new report in SQL and I need to know the qty on hand and the qty outstanding on a sales order. I have the following query, however it is not giving me the correct results. It seems like the grouping is not working the way I want it an it generates bad results for the above quantities. SELECT…