Re: ODBC Help!

From: Brannon Jones (brannonjNOSPAM_at_gmail.com)
Date: 08/23/04

  • Next message: Brannon Jones: "Re: return yesterdays date?" 
    Date: Mon, 23 Aug 2004 13:19:44 -0700

    What is the error that you are getting? Where is the error coming from?
    SInce you say you aren't using ODBC.NET, does that mean you are using
    classic ADO through the COM interop? Or are you using ODBC directly through
    P/Invoke?

    Just out of curiosity, why doesn't ODBC.NET support the Navision interface?
    Is it a problem with the Navision driver or the ODBC .NET provider?

    Brannon

    "blaflin" <blaflin@discussions.microsoft.com> wrote in message
    news:816973F4-1449-4976-861B-B9C3BAA1FB7F@microsoft.com...
    > 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!!!!
    >

  • Next message: Brannon Jones: "Re: return yesterdays date?"

    Relevant Pages

    • ODBC Help!
      ... I have an ASP.NET application where I am writing data through an ODBC ... Data from the SS database is copied to the Navision database at ... ODBC .NET doesn't support a Navision interface ...
      (microsoft.public.data.odbc)
    • Re: If then else containing value not at the end or in the beginni
      ... ODBC, and you have the necessary bits of the Jet database engine on ... b.open your mail merge main document and disconnect from the data source. ... Now you either need some VBA, or you need a DATABASE field. ... Sub MyConnect() ...
      (microsoft.public.word.mailmerge.fields)
    • Re: Does connection string need anything on system?
      ... Open DataBase Connectivity (ODBC) is a Microsoft standard (albeit an old ... This DSN needed to be configured to know which database ... driver was going to be needed and which actual data source was being used. ... connection string? ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Does connection string need anything on system?
      ... This DSN needed to be configured to know which database driver was going to be needed and which actual data source was being used. ... This is what the ODBC Manager tool in Control Panel> Admin Tools is for...setting up a DSN. ... With OLEDB, you code directly against the provider and, as long as the provider is present on the target machine, the code can talk to it. ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: link data fails because of extra quote mark (odbc ole db)
      ... Formal / tracked support would be via an incident. ... I'm pretty sure at this point that its a problem in either visio, ... the ole db provider for odbc. ... Data Source Name: text test ...
      (microsoft.public.visio.general)