[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: ODBC not connecting to Sybase database specified

What sqr version do you use for connect with sybase sybase/ctlib or 
sybase/odbc.  This is because when you create a report with Brio Report Builder 
you connect with ODBC but for run this use the personal SQR installed in the 
PC.  May be your problem is the database that use in the DSN is one and when 
you run the report the default database for the user is another database 
different from the DSN.  Be sure the database is the correct in the DSN.

        -----Original Message----- 
        From: Ward, Daniel [mailto:dward@JHANCOCK.COM] 
        Sent: Thu 4/18/2002 3:12 PM 
        To: SQR-USERS@list.iex.net 
        Cc: 
        Subject: ODBC not connecting to Sybase database specified
        
        

        I am having a database connection problem with ODBC, SQR and Sybase.  I 
make
        an ODBC connection
        selecting a Sybase database on the server.  So far so good.  When I run 
my
        SQR program  (which tells me what
        database I am connected to)  After I choose my data connection, I get
        connected to a different one than I selected
         in my ODBC connection.
        I would appreciate any tips on how to make sure the database I want is 
the
        one I get.
        I am running Brio report builder 6.1.3 (Build 90), Under Windows NT, 
Using
        Sybase version 12
        
        
        Daniel Ward
        John Hancock Financial Services, Inc.
        (813) 664-6556
        dward@jhancock.com