I have been trying to create a "new" database using then MS SQL Server Option for Navision but I keep getting the same error message: "An ODBC error occurred, but no error information could be retrieved." Get this message either locally or remotely.
If I try to open one of the sample databases it says it is not a Navision db (which is correct).
Thanks for any help on the subject.
0
Comments
For your interest, although functionally the same, the underlying structure is completely different for C/Side and SQL, and the one type cannot read the database of the other type.
You can, however, make a backup in the one, then restore it in the other. That allows rather easy exchange between the two types of database, or between network (SQL) and stand-alone (C/Side) clients.
John
[This message has been edited by John Tegelaar (edited 28-05-2000).]
I had the same error.
I got it when upgrade windows server, and solved when upgrade NF version. My solution is : NF 2.5 only with NT 4.0; NF 2.6 only with Win2000.
Gedas B
Something just came to mind.
If you have plain NF 2.5 and SQL Server 7.0 SP2, you'll get the ODBC error. Navision has a HotFix for this. Should be available on the partnerweb for download.
John
It works fine on NT4
Service Packs ARE important
theese are working configurations:
NF2.50
NT 4.0 SP4 , MS SQL 7 SP1
NF2.60
NT 4.0 SP4 , MS SQL 7 SP2
W2000 Srv , MS SQL 7 SP2
W2000 Srv, MS SQL 2000 + some manual fixes
ODBC-things - it is typical first-try error.
Do rememeber about:
1) correct NT service pack
2) correct MS SQL pack
3) -p option in MS SQL
Unfortunately this sp-compatibility issues are not documented well, but for sure your NTR should know that (even from experience ;-)).
regards
Krzysiek