Post reply

SQL/ ODBC AND JOINING TABLES

  • September 22, 2006 at 11:57 am

    #94373

    :

  • September 22, 2006 at 3:50 pm

    #662046

    What is the error you get? It looks fine at first sight (although you are not specifying the owner of PROD_MAST_SUBS and are not using stored procedures for abstraction)

  • September 25, 2006 at 7:42 am

    #662211

    Hello Jo,

    This is what I'm getting:

    System.Data.Odbc.OdbcException: ERROR [HY000] [IBM][UVODBC][1401032]Error ID: 29 Severity: ERROR Facility: FPSRVERR - Line 1, column 49 (around "JOIN"): Syntax error. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Odbc.OdbcCommand.ExecuteReader() at odbc.Page_Load(Object sender, EventArgs e) in c:\Inetpub\wwwroot\odbc.aspx.cs:line 25

    but now I think I might need to go to IBM for the answer since It's actually a Universe Database I am connecting too.

    Thanks so much!!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply