none
Cannot connect to Northgate Reality Database using ADO.Net RRS feed

  • Question

  • I can connect to a Reality Database useing Exel 2007 via ODBC which uses the old version of ADO.

    I cannot connect using SSIS or any invironment from Visual Studio 2008 through the same ODBC which uses ADO.NET

    I have tried XP, Vista, Windows7, 2003 and 2008 Sever (64bit and 32bit)

    ADO.NET is the common factor in the failure to connect.

    Is there a work arround?

    Reality - http://www.northgate-reality.com/

    Tuesday, April 6, 2010 2:05 PM

Answers

All replies

  • When you try to connect in Visual Studio 2008 and in .NET code, what steps do you follow to try to connect to the Excel spreadsheet and what error message do you receive?
    David Sceppa
    Tuesday, April 6, 2010 9:33 PM
    Moderator
  • I think we would need to see the ODBC connection string you use from Excel and also the error that is being generated.

    Paul ~~~~ Microsoft MVP (Visual Basic)
    Friday, April 9, 2010 5:33 PM
  • Thanks Paul

    The Connection Sting is slightly complicated, that is uses an entry in WINSNI.IN Table and adds the User ID and Password in the ODBC Setup

    [ReportServer]

    Protocol=DDATCP

    Dbase=dbaseName

    Host=IP Addreess

    Port=1203

    I can connect in both Exel and SSIS.  Excel works fine but When I use the same query, (Select * From TableName) in SSIS Using an ADO.NET source the Test Connnect works fine but I get the fallowing error when I try to preview

    There was an error displaying the preview.

    ERROR [pNŘ] [ReportServer]Bad command received by server X'802B'. (RLXSQL32.DLL)

     

    Tuesday, April 20, 2010 4:18 PM
  • I can connect in both Exel and SSIS.  Excel works fine but When I use the same query, (Select * From TableName) in SSIS Using an ADO.NET source the Test Connnect works fine but I get the fallowing error when I try to preview

    There was an error displaying the preview.

    ERROR [pNŘ] [ReportServer]Bad command received by server X'802B'. (RLXSQL32.DLL)

    Tuesday, April 20, 2010 4:19 PM
  • Are you using the Data Designer tools or ADO.NET code (e.g. System.Data.Odbc) in order to connect with this system?

    Paul ~~~~ Microsoft MVP (Visual Basic)
    Tuesday, April 20, 2010 4:57 PM
  • The Data Designer

     (Mainly the Visual Tools that come with SQL for SSIS Packages)
    Wednesday, April 21, 2010 9:57 AM
  • This issue sounds similar to another user's where they have an ODBC driver that doesn't meet the compliance level required by the visual data design tools. I believe the driver needs to be ODBC level 3 compliant in order to be supported by the Visual Studio data designer tools.

    Maybe you could check with the vendor to see what the compliance level of the ODBC driver is. Some of the older drivers are only level 2 compliant.

    Paul ~~~~ Microsoft MVP (Visual Basic)
    Wednesday, April 21, 2010 12:28 PM
  • Thanks Paul

    Northgates Latest ODBC Driver is only Level 2 compliant and they don't seem to be updating it

    Is there a work arround

    Tommy

     

    Wednesday, April 21, 2010 2:30 PM
  • Okay, might I suggest another strategy? Instead of using an 18-year-old data access interface (like ODBC) how about using a .NET Managed provider? There seems to be one available for Reality databases. See http://www.sqlsummit.com/DataProv.htm.

    __________________________________________________________________
    William Vaughn
    Mentor, Consultant, Trainer, MVP
    http://betav.com
    http://betav.com/blog/billva
    http://www.hitchhikerguides.net

    “Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)”

    Please click the Mark as Answer button if a post solves your problem!

    Wednesday, April 21, 2010 4:27 PM
    Moderator
  • Thanks Paul

    Northgates Latest ODBC Driver is only Level 2 compliant and they don't seem to be updating it

    Is there a work arround

    Tommy

     


    With respect to Visual Studio, you should still be able to connect using code via the System.Data.Odbc namespace. I don't know what the solution would be for SSIS since I'm not familiar with it.
    Paul ~~~~ Microsoft MVP (Visual Basic)
    Wednesday, April 21, 2010 5:46 PM
  • Thanks William

    Looks promissing.  I'm downloading an evaluating of  mv.Net and mv.SSIS from BlueFinity

    I'll let you know if this solves my problem

    Thursday, April 22, 2010 9:19 AM
  • Hi tommy,

    Just wondering if you were successfull in using Bluefinity driver for accessing Reality Database.

    I'm working for a client who use this DB and are currently using RealSQL driver which is causing a lot of issues.

    Would be good to know.

    Thanks

    Megha

    Tuesday, March 4, 2014 3:17 AM