Data Driven Published Report - Not displaying recipients

I'm setting up my first data driven published report. I have a very simple
query that goes out and returns a list of email recipients. I enter my SQL,
then click "validate" and the server says that it has successfully validated
my query. This SHOULD allow the fields in the subsequent form to be
populated with my returned field list. However, the "Database Fields" drop
down in the delivery extension form only shows one blank line. When i select
that line, i get the error "Blank database field names cannot be used"
Where did my field names go?
TIA,
--
Brian Grant
Senior Programmer
SI International
www.si-intl.comMake sure that the query has a column name for the email recipients. You
may need to add an 'As suchandsuch' to get a column name.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"G" <brian.grant@.si-intl-kc.com> wrote in message
news:#e75$ashEHA.3632@.TK2MSFTNGP09.phx.gbl...
> I'm setting up my first data driven published report. I have a very simple
> query that goes out and returns a list of email recipients. I enter my
SQL,
> then click "validate" and the server says that it has successfully
validated
> my query. This SHOULD allow the fields in the subsequent form to be
> populated with my returned field list. However, the "Database Fields" drop
> down in the delivery extension form only shows one blank line. When i
select
> that line, i get the error "Blank database field names cannot be used"
> Where did my field names go?
> TIA,
> --
> Brian Grant
> Senior Programmer
> SI International
> www.si-intl.com
>|||Thanks for the reply Daniel.
Aliasing my one returned "email_address" field was something i tried, but to
no avail. My query simply returns one field, "email_address". I've also
validated that the query correctly returns 3 records when ran directly
against the database.
The database is Informix, using ODBC for connections. It validates just
fine, still no fields showing up though. This is looking more and more like
a bug.
Any other ideas?
Thanks,
Brian
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:OtWODUthEHA.2544@.TK2MSFTNGP10.phx.gbl...
> Make sure that the query has a column name for the email recipients. You
> may need to add an 'As suchandsuch' to get a column name.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "G" <brian.grant@.si-intl-kc.com> wrote in message
> news:#e75$ashEHA.3632@.TK2MSFTNGP09.phx.gbl...
> > I'm setting up my first data driven published report. I have a very
simple
> > query that goes out and returns a list of email recipients. I enter my
> SQL,
> > then click "validate" and the server says that it has successfully
> validated
> > my query. This SHOULD allow the fields in the subsequent form to be
> > populated with my returned field list. However, the "Database Fields"
drop
> > down in the delivery extension form only shows one blank line. When i
> select
> > that line, i get the error "Blank database field names cannot be used"
> >
> > Where did my field names go?
> >
> > TIA,
> >
> > --
> > Brian Grant
> > Senior Programmer
> > SI International
> > www.si-intl.com
> >
> >
>|||Update: When I moved the date into a SQL Server database, everything worked
just fine. So, the problem seems to only occurr when using an ODBC
connection to get the list of recipients.
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:OtWODUthEHA.2544@.TK2MSFTNGP10.phx.gbl...
> Make sure that the query has a column name for the email recipients. You
> may need to add an 'As suchandsuch' to get a column name.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "G" <brian.grant@.si-intl-kc.com> wrote in message
> news:#e75$ashEHA.3632@.TK2MSFTNGP09.phx.gbl...
> > I'm setting up my first data driven published report. I have a very
simple
> > query that goes out and returns a list of email recipients. I enter my
> SQL,
> > then click "validate" and the server says that it has successfully
> validated
> > my query. This SHOULD allow the fields in the subsequent form to be
> > populated with my returned field list. However, the "Database Fields"
drop
> > down in the delivery extension form only shows one blank line. When i
> select
> > that line, i get the error "Blank database field names cannot be used"
> >
> > Where did my field names go?
> >
> > TIA,
> >
> > --
> > Brian Grant
> > Senior Programmer
> > SI International
> > www.si-intl.com
> >
> >
>

daily backup and log shipping

Hi,
I am in the process of setting up log shipping for a large database ~ 1GB over VPN and slow WAN link.
I intend to setup and sync the servers on main office and ship after that, the warm standby db to remote site.
My question is how the daily full backups of database will afect my log shipping.
To keep this servers in sync I intend to use only daily transaction logs backups/restores. I do not want to copy a full backup of 1GB daily over the WAN. However at local site I still want to perform a daily full backup.
As I know when a full backup run it will also truncate the transaction logs, so if these large daily full backups will not be copied and restored over the WAN, the warm standby server will run out of sync. This is because a part of transaction log that will be truncated when full backup is done will not be restored to remote site.
Is there any way to do full backups after initial sync without truncating the transaction logs? Has anyone an answer to my problem?
Thank you,
Zorba
Zorba,
A full database backup does not truncate the transaction log. When you start log shipping, you can make as many full backups of the primary database as you want - it will not affect log shipping. However, you cannot make both a full database backup and a transaction log backup of the same database at the same time.
Hope this helps,
Ron
Ron Talmage
SQL Server MVP
"Zorba" <nospam@.nonexistent> wrote in message news:OX0Z6LemEHA.3336@.TK2MSFTNGP10.phx.gbl...
Hi,
I am in the process of setting up log shipping for a large database ~ 1GB over VPN and slow WAN link.
I intend to setup and sync the servers on main office and ship after that, the warm standby db to remote site.
My question is how the daily full backups of database will afect my log shipping.
To keep this servers in sync I intend to use only daily transaction logs backups/restores. I do not want to copy a full backup of 1GB daily over the WAN. However at local site I still want to perform a daily full backup.
As I know when a full backup run it will also truncate the transaction logs, so if these large daily full backups will not be copied and restored over the WAN, the warm standby server will run out of sync. This is because a part of transaction log that will be truncated when full backup is done will not be restored to remote site.
Is there any way to do full backups after initial sync without truncating the transaction logs? Has anyone an answer to my problem?
Thank you,
Zorba