Re: ODBC not connecting to Sybase database specified

[Elvis Pressly <elvisdman@HOTMAIL.COM>]

Daniel,

When you setup ODBC thru ODBC administration, you make sure that
the ODBC driver you have chosen is for Sybase otherwise Report Builder
will never connect to the right database. I have created DSN for
different platform and they have different drivers and all of them
works.


>From: "Miele, Angelo A." <AMiele@BCBSM.COM>
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: Re: ODBC not connecting to Sybase database specified
>Date: Fri, 19 Apr 2002 11:11:38 -0400
>
>Dan,
>
>I experienced the same problem.  Report Builder for Sybase uses the ODBC
>connection when you are developing the report.  But when you "Process" the
>report the Sybase Open Client drivers are used.  If you go the
>Edit->Preferences window, you can see the actual command line that is
>issued
>to SQRW to run the report.  You will notice that the server name, userid,
>and password are included.  Unfortunately, you cannot edit this command
>line
>directly.  The runtime parameter -db<databasename> can be used to tell SQRW
>the database name.  I have tested this by executing a report using SQRW
>from
>DOS and it works.
>
>I have been told that you can specify add ional runtime parameters by
>entering them in the "Run Parameters" section on the Preferences window,
>but
>it doesn't seem to be working for me.  It's a good idea to check out all
>the
>options in the Preferences window.  Feel free to call me if you'd like more
>information.  For now, I have asked our DBA to create a userid that
>defaults
>to the correct database.
>
>Angelo Miele
>Blue Cross Blue Shield of Michigan
>CDFC
>Mail Code 1518
>(313) 225-9881
>
>
>-----Original Message-----
>From: Ward, Daniel [mailto:dward@JHANCOCK.COM]
>Sent: Friday, April 19, 2002 8:50 AM
>To: SQR-USERS@list.iex.net
>Subject: Re: ODBC not connecting to Sybase database specified
>
>
>         To construct my report, I am using Brio report builder 6.1.3
>(Build
>90).    By the way it works in version 4.3.2.1 but not since we upgraded
>         to version 6.1.3.  The steps I followed were.
>
>         1.  I created an ODBC connection  Under Windows NT ODBC
>administrator.
>         2.  I pointed to Sybase, gave it the database name and password.
>         3.  Now I am done with the ODBC part.
>         4.  I opened Brio report builder,  brought in my simple report
>that
>does a simple select from the database and tells me what db I am using.
>         5.  The report runs with no errors, but the one I am hitting is
>not
>the one I setup through ODBC.
>
>         It looks like a default database is being brought in somehow.
>         Do you know where I can check this DSN parameter?  I see it in the
>books and help, but it does not look like it is working correctly.
>
>         Thanks again.
>
>
> > -----Original Message-----
> > From: Juan Alvarado [SMTP:juan@GYSSA.COM]
> > Sent: Thursday, April 18, 2002 6:47 PM
> > To:   SQR-USERS@list.iex.net
> > Subject:      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
> >
> >




_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com