-
Hi Sangam, I have no personal experience with Oracle Discoverer, but you use SQL Server for your Navision database then you can connect Oracle Discoverer directly to this database. There are many sites describing this online (ex: http://dbaspot.com/forums/oracle-tools/145291-connect-discoverer-ms-sql...
-
Dear All, We just migrated to Sql database from nav Dynamic 5.0. The problem we are having now is that the users are not being able to change their password on their own from nav sql and again what are the roles and permission that needs to be given for them to be able to perform the same function just...
-
Actual SQL field names you can see only in SQL tools - "Query Editor" for SQL2000, later versions SQL Enterprise manager. As said above, don't forget the brackets if name contains spaces, for example [Global Dimension No_] And, table names begin with Company name: ...FROM [dbo].[ CompanyName...
-
Hi there! I am trying to build a reporting Excel spreadsheet using VB and SQL. While trying to query info from a table using SQL script, I can see some field names such as GL Posting Code. Normally such fields are created using the underscore like GL_Posting_Code. In Navision the fields do not have the...
-
Hi Sangam, I have no personal experience with Oracle Discoverer, but you use SQL Server for your Navision database then you can connect Oracle Discoverer directly to this database. There are many sites describing this online (ex: http://dbaspot.com/forums/oracle-tools/145291-connect-discoverer-ms-sql...
-
Dear All, We just migrated to Sql database from nav Dynamic 5.0. The problem we are having now is that the users are not being able to change their password on their own from nav sql and again what are the roles and permission that needs to be given for them to be able to perform the same function just...
-
Actual SQL field names you can see only in SQL tools - "Query Editor" for SQL2000, later versions SQL Enterprise manager. As said above, don't forget the brackets if name contains spaces, for example [Global Dimension No_] And, table names begin with Company name: ...FROM [dbo].[ CompanyName...
-
Hi there! I am trying to build a reporting Excel spreadsheet using VB and SQL. While trying to query info from a table using SQL script, I can see some field names such as GL Posting Code. Normally such fields are created using the underscore like GL_Posting_Code. In Navision the fields do not have the...
-
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 Colleagues; I am pleased to report to you that I have apparently resolved this troublesome issue. The steps I took are as follows: SQL Server steps: 1: A new login was created in SQL Server with no domain specification using SQL...
-
Joshi; Thx for the suggestion. I added the user to the Super (data) group, In sql,he has public and db_datareader only. I can log on and access the profile in NAv, so I'm not sure what that tells me. Anyway, it's still having its dbase user mapping disabled after every user security synch. Cheers...