Re: ODBC Help!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

Date: Mon, 23 Aug 2004 13:59:02 -0700

I'm not getting any error message. By placing some debug statements in the
code on the production server, I determined that the code is hanging on the
statement to open the connection. My code is as follows:

Dim NavConn As New ADODB.Connection
NavConn.ConnectionString = "....."
NavConn.CursorLocation = CursorLocationEnum.adUseServer
NavConn.Open()

It just stops on the Open statement. The progress bar in the client's
browser never shows the page loading as completing.

As far as why I'm not using ODBC.NET, it has been quite a while since I
tired it. I may try to rework this with ODBC.NET. I know the ODBC.NET
documentation says that it has only been tested with SQL Server, Access, and
Oracle.

"Brannon Jones" wrote:

> 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!!!!
> >
>
>

Relevant Pages

  • Re: Alternative to using DSN to connect to database
    ... you have to use .NET ODBC provider. ... Server is NOT optimized. ... Just because of the Admiistrator thinking DSN is easier for him to control ... > Basically my problem is that the ODBC Connection Manager in Control Panel ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Server extremely slow
    ... terms of what is meant by a dis-connected ado recordset. ... table in a mdb file could be considered disconnected from the server ... Well, ok, but keep in mind the disk drive is on sql server! ... 10 reocrds from the server via odbc does not produce more ...
    (comp.databases.ms-access)
  • Re: Need ODBC for every front end, or just server?
    ... on the server, and, in response to some other signal ... > to use the ODBC driver is on the workstation, ... >> Do I need the ODBC license and install on every Front End PC, ...
    (microsoft.public.access.externaldata)
  • Linked Servers: Invalid schema
    ... Have you put a trace on the ODBC ... call 'in query analyser)- that gets ... database you are trying to connect to and schema refers to ... >server in Enterprise Manager and I have also used it ...
    (microsoft.public.sqlserver.odbc)
  • 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)