Hi everyone,
while configuring an Jet Express Installation for a customer, i get the following error message if I try to test the connection:
"HY024 Database is Invalid or Cannot be Accessed"
I checked the database server and authentification. I can choose the database in a lookup, so the database server seems to be correct and authentification seems to work.
Connecting to the same database with the classic client itselfs and the same authentification works without a problem.
Any suggestion?
Kind regards,
Marvin Powell
P.S.: This is a separate issue from my previous post today.
Date
Votes
8 comments
-
Jet Reports Historic Posts Hello Marvin -
The most common case for this error, is that the database is in single-user mode and has an open connection on it (using that single user slot), when you try to access it on another connection, e.g. NAV.
You will first want to make sure that you are not accessing a local version of the NAV databaseeand that your NAV Database is set to multiuser and that the user has permissions to upload licences –> http://dynamicsuser.net/forums/p/49424/255011.aspx
It is also possible for this error to occur due to firewall settings. If the NAV client has been granted special permissions to access the server through the firewall - but C/Front has not - this error could result.
-HP -
Jet Reports Historic Posts Hello,
the database is in MULTI_USER mode.
The link you provided to grant the user the permission to upload licences suggests that the user needs sysadmin or db_owner permissions on the sql server. But this cant possibly be the only solution to using Jet Express. Maybe he could be missing another permission? The user has the SUPER role for all companies and is using the "Standard" security model for the database.
How can I check if C/Front is blocked by the firewall? Or how can I set it up to not block it? -
Jet Reports Historic Posts Hello Marvin -
Unfortunately, I am not a network administrator and would not know how to adjust your firewall. Your network admin may be better equipped to answer questions about how to check firewall settings.
-HP -
Jet Reports Historic Posts Hello,
i've checked the problem with the network administrator - the traffic isn't blocked by a firewall.
I've also tried to connect to the database in Jet Express with a login that has sysadmin privileges on the SQL Server.
But the error message still stays the same.
Is there something else i could try?
Best regards,
Marvin -
Jet Reports Historic Posts Hello Marvin -
You might be able test to see if C/Front is able to connect to the database.
Fortunately, Microsoft provides a utility (Sample.exe) to do just this. That utility is located in the same folder as the cfront.dll file (typically: C:\Program Files\Microsoft Dynamics NAV\SDK\Cfront) and uses the following parameters:
-w … Driver name (NDBCN or NDBCS)
-d … Database name
-t … Run the Exception Handler test.
-s … Server name
-p … Navision path
-n … Nettype (e.g. tcp, netb)
The default driver is NDBCN (Navision Attain Database Server). The default Nettype is tcp.
Here is an example:
-HP -
Jet Reports Historic Posts Hi!
doesn't Jet Express come with the correct version of C/Front included?
I'm pretty sure the customer doesn't have the Dynamics NAV SDK installed on his local machine. Is this necessary?
Best Regards,
Marvin Powell -
Jet Reports Historic Posts Hi Marvin -
For systems where the NAV SDK has not been installed, Jet Express includes selected versions of the CFRONT dlls and does its best to select the correct version.
For performance reasons and the most reliable result, it is recommended that the Dynamics SDK be installed on the local system.
-HP -
Jet Reports Historic Posts After Installing the SDK and changing the settings in JET Express accordingly, it now works fine.
I really don't know why, but it works.
Please sign in to leave a comment.