ODBC Help!

From: blaflin (blaflin_at_discussions.microsoft.com)
Date: 08/23/04 

Date: Mon, 23 Aug 2004 11:57:02 -0700

I'm stumped by a problem using ODBC with ASP.NET.

I have an ASP.NET application where I am writing data through an ODBC
interface to a Navision database. (The primary data source is a SQL Server
database. Data from the SS database is copied to the Navision database at
discreet events.) I was forced to use ODBC to connect to Navision due to
1) Navision only provides ODBC access (and the driver is quirky at that)
2) ADO.NET won't work
3) ODBC .NET doesn't support a Navision interface

The interface works as designed on the development machine (Windows XP Pro)
as well as on the test machine (Windows 2000). However, the application can't
open the connection to Navision on our production server (Windows 2000
Server). And I'm kinda stumped???

I know the ODBC connection is good because I have some classic ASP
components that use the same connection without a problem. I thought it might
be a permission problem with the ASPNET user, so I temporarily put the ASPNET
user in the Administrators group. No joy. Also, there's nothing in the event
log.

One other bit of information. I changed the configuration on the development
machine to point to the production data sources to try to reproduce the
problem while stepping through in the debugger. But it worked fine. So I'm
kinda stumped.

Any ideas would be greatly appreciated!!!!

Relevant Pages

  • Re: ODBC Help!
    ... why doesn't ODBC.NET support the Navision interface? ... Is it a problem with the Navision driver or the ODBC .NET provider? ... (The primary data source is a SQL Server ... Data from the SS database is copied to the Navision database at ...
    (microsoft.public.data.odbc)
  • Re: ODBC Help!
    ... code on the production server, I determined that the code is hanging on the ... why doesn't ODBC.NET support the Navision interface? ... > Is it a problem with the Navision driver or the ODBC .NET provider? ...
    (microsoft.public.data.odbc)
  • Using Asynchronous ODBC ?
    ... I am currently trying to setup a query tool for our in-house database, ... Navision, using PHP and ODBC. ... I am running PHP 5.1.4 on IIS on my development box. ...
    (alt.php)
  • Problem importing data in SQL (DTS - ODBC - Navision Attain)
    ... I have a problem with importing data in SQL. ... I'm using DTS and ODBC to connect to Navision db. ... Microsoft OLE DB Provider for ODBC Drivers ...
    (microsoft.public.sqlserver.odbc)
  • PHP and Navision C/ODBC
    ... I have a problem trying to access with PHP to a Navision Database ... I have created the system DSN, named "NavisionSystem", with the Navision ...
    (microsoft.public.sqlserver.odbc)
Quantcast