Navision 3.7 ODBC and SQL2005

speedy73

Hi,
When trying to set up an ODBC Connection via .Net Framework Data Provider for ODBC on SQL 2005 i get the following error:

The supported Datatypes coulnd't be retrieved from the DataConnection.

Has anyone successful set up a connection from SQL2005 to a 3.7 Native Database? Which Driver was used then?

Hope anyone can help me.

kriki

SQL2005 is only supported from 4.0SP1 and up.
If you want a 3.70 on it, you need to do a technical upgrade (=putting the 3.70 objects in a 4.0SP1 DB).

Search the forum for SQL2005 for more info. There is also some problem with security.

speedy73

I don't wanna upgrade the database. I just need to get data from the native database to sql2005 for reporting purposes. :-k

kriki

:oops: Didn't read your post well, I thought you wanted to put the DB on SQL2005 :oops: :oops: :oops:

fredp1

Hi,
Today I was able to transferred c/side 3.6 data using ODBC to SQL2005 using SSIS (the old DTS in SQL2000) via a MS Access db which was acting as a gateway.
Its a bit converluted, but first I just created a ODBC system DSN connection.
Then I used linked tables in MS Access to connect to Navision. If that works then you can use a .net connection to the access db and it worked!
I could not get SQL2005 to use the Navision 3.6 ODBC driver.
It only worked when Access was used as a getway.
It may work for you in 3.7.

Fred