Our “warehouse” data base is in SQL Server 2000 and we populate it from the native Navision data base. All the data transfer is done via SQL Server DTS using then Navision ODBC. Everything has worked perfectly on Navision 2.50. We are in the process of upgrading to 3.70 and the new ODBC driver seems to be a problem. I have created a dsn using the odbc driver and can access the Navision data base from SQL tools such as WinSQL, but as soon as I try to create a DTS package, I get the following message when I try to set the DTS transform properties: Error Source: Microsoft OLE DB Provider for ODBC Drivers Error Description: [Microsoft Business Solutions ApS][Microsoft Business Solutions-Navision ODBC Driver]Expected lexical element not found: Context:Error calling OpenRowset on the provider. The dsn is setup as a server via TCP. I don’t know what the error is trying to tell me. Any help would be greatly appreciated. Thanks.
I had forgotten to change the identifiers option of the odbc dsn from “all but DOT” to a-z, etc.