Nav 4.0, SQL 2005 - ODBC Data source name not found

JDVyska

I'm having an interesting quirk with 4.0 SP1. I've installed the client on the server running SQL2005 (Minimum install options).

Whenever I try to open a database, if I lookup on Server Name or Database Name, I get the error message:

The following ODBC error occurred:

Error: [Microsoft][ODBC Driver Manager] Data source name was not found and no default driver was specified.

But, any client machines on the network running 4.0 SP1 executable can connect to this SQL 2005 server just fine.

To my knowledge, you don't have to setup a DSN for Navision. Does anyone have any theories on what might be the Navision/SQL2005 resolution for this?

(Googled the error message, but that primarily produces a LOT of results about Beta SQL2005 installation issues.)

Thanks!
Jeremy

Edit: Sort of solved.

ara3n

SP2 is comming out in couple of weeks, maybe this will be fixed.

JDVyska

For anyone else running into this issue, what we found was, however the SQL
2005 environment was setup, the SQL ODBC drivers installed was simply called
"SQL Native Client" instead of "SQL Server". Navision seems to not use the
"SQL Native Client", even under SP1.

The fix we had to do to continue on was to install the SQL 2000 ODBC driver,
then it was fine. Here's hoping Navision is not expecting to use any of the
new functionality in the "SQL Native Client"

J