Bar codes ?

Hi guys
I am new in SQL RS. I want to print bar codes on my report. Is it
possible with RS ? Do I need external procedure ? Any suggestion will
be welcome !
Thanks
Jean-MarcJean-Marc,
In one of our projects I ran into the same requirement and was able to
handle it very easily with a barcode font. There are a number of sources
barcode fonts on the Internet which you can find quickly using the search
engine of your choice. Once you install the barcode font on your system you
can just select it in the report designer and your reports will display
barcodes. Just remember that any system running the report that uses the
barcode font will have to have the barcode font installed in order for them
to work.
Hope this helps.
Walter Voytek - Co-Author, "Pro SQL Server Reporting Services" (Apress)
http://www.sqlpros.com/
<jean-marc.audrin@.future.ca> wrote in message
news:1102619463.420068.212260@.f14g2000cwb.googlegroups.com...
> Hi guys
> I am new in SQL RS. I want to print bar codes on my report. Is it
> possible with RS ? Do I need external procedure ? Any suggestion will
> be welcome !
> Thanks
> Jean-Marc
>|||Hi Jim
Thanks a lot for your answer. Now I know that it is possible.
I'm going to try what you say.
Jean-Marc
Jim wrote:
> Jean-Marc,
> In one of our projects I ran into the same requirement and was able
to
> handle it very easily with a barcode font. There are a number of
sources
> barcode fonts on the Internet which you can find quickly using the
search
> engine of your choice. Once you install the barcode font on your
system you
> can just select it in the report designer and your reports will
display
> barcodes. Just remember that any system running the report that uses
the
> barcode font will have to have the barcode font installed in order
for them
> to work.
> Hope this helps.
> Walter Voytek - Co-Author, "Pro SQL Server Reporting Services"
(Apress)
> http://www.sqlpros.com/
>
> <jean-marc.audrin@.future.ca> wrote in message
> news:1102619463.420068.212260@.f14g2000cwb.googlegroups.com...
> > Hi guys
> >
> > I am new in SQL RS. I want to print bar codes on my report. Is it
> > possible with RS ? Do I need external procedure ? Any suggestion
will
> > be welcome !
> > Thanks
> > Jean-Marc
> >

Backup to Unix/Linux

Hi, I have data sitting on an external MSSQL 2000 host that needs to be
backed up. Currently I'm using DTS on a Win2k desktop, but this isn't really
practical as this machine is used as a workstation.
Has anyone heard of any methods to backup to a Unix/Linux server?
Any help would be appreciated.
TIA JoIf the server can see a volume on the network then it should be possible to
write to it. If Windows can't see it then SQL Server won't either.
--
David Portas
SQL Server MVP
--|||"David Portas" wrote:
> If the server can see a volume on the network then it should be possible to
> write to it. If Windows can't see it then SQL Server won't either.
> --
> David Portas
> SQL Server MVP
> --
>
Thanks for the reply David. I can create a Samba share, but do you know of
any scripts or tools that can copy pull the data down? I only have DTS access
to my database on the hosting provider.
I realise most people have access to a Windows server, just wondering if
anyone had done/tried/heard of it.
Jo|||You can create a DTS package with one connection and a T-sql task... The
T-sql task would be a backup command ie.
backup database prod to disk = '\\myserver\mysharename\mybackup.bak' with
init
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jo" <Jo@.discussions.microsoft.com> wrote in message
news:E1948BEF-BBF2-45A0-8695-14D766726225@.microsoft.com...
>
> "David Portas" wrote:
> > If the server can see a volume on the network then it should be possible
to
> > write to it. If Windows can't see it then SQL Server won't either.
> >
> > --
> > David Portas
> > SQL Server MVP
> > --
> >
> Thanks for the reply David. I can create a Samba share, but do you know of
> any scripts or tools that can copy pull the data down? I only have DTS
access
> to my database on the hosting provider.
> I realise most people have access to a Windows server, just wondering if
> anyone had done/tried/heard of it.
> Jo

Backup to Unix/Linux

Hi, I have data sitting on an external MSSQL 2000 host that needs to be
backed up. Currently I'm using DTS on a Win2k desktop, but this isn't really
practical as this machine is used as a workstation.
Has anyone heard of any methods to backup to a Unix/Linux server?
Any help would be appreciated.
TIA Jo
If the server can see a volume on the network then it should be possible to
write to it. If Windows can't see it then SQL Server won't either.
David Portas
SQL Server MVP
|||"David Portas" wrote:

> If the server can see a volume on the network then it should be possible to
> write to it. If Windows can't see it then SQL Server won't either.
> --
> David Portas
> SQL Server MVP
> --
>
Thanks for the reply David. I can create a Samba share, but do you know of
any scripts or tools that can copy pull the data down? I only have DTS access
to my database on the hosting provider.
I realise most people have access to a Windows server, just wondering if
anyone had done/tried/heard of it.
Jo
|||You can create a DTS package with one connection and a T-sql task... The
T-sql task would be a backup command ie.
backup database prod to disk = '\\myserver\mysharename\mybackup.bak' with
init
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jo" <Jo@.discussions.microsoft.com> wrote in message
news:E1948BEF-BBF2-45A0-8695-14D766726225@.microsoft.com...[vbcol=seagreen]
>
> "David Portas" wrote:
to
> Thanks for the reply David. I can create a Samba share, but do you know of
> any scripts or tools that can copy pull the data down? I only have DTS
access
> to my database on the hosting provider.
> I realise most people have access to a Windows server, just wondering if
> anyone had done/tried/heard of it.
> Jo
|||"Wayne Snyder" wrote:

> You can create a DTS package with one connection and a T-sql task... The
> T-sql task would be a backup command ie.
> backup database prod to disk = '\\myserver\mysharename\mybackup.bak' with
> init
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
"Wayne Snyder" wrote:

> You can create a DTS package with one connection and a T-sql task... The
> T-sql task would be a backup command ie.
> backup database prod to disk = '\\myserver\mysharename\mybackup.bak' with
> init
Thanks for the reply Wayne. I'm still learning, but I'm not sure if I have
access to do this (this command would have to be run on the server?). The
database is sitting on a web host, I only have access (that I'm aware of?) by
using Enterprise Manager. I'm don't often work with MSSQL, but what I
initially thought was using a Perl or shell script that connects to the
correct port and runs some commands to initiate a backup. I was hoping that
someone had already written one too. I'm probably crazy :-P
The site I'm doing this for only has a Linux server that gets backed up
daily. Thanks for the help and patience guys :-)
Jo

Backup to Unix/Linux

Hi, I have data sitting on an external MSSQL 2000 host that needs to be
backed up. Currently I'm using DTS on a Win2k desktop, but this isn't really
practical as this machine is used as a workstation.
Has anyone heard of any methods to backup to a Unix/Linux server?
Any help would be appreciated.
TIA JoIf the server can see a volume on the network then it should be possible to
write to it. If Windows can't see it then SQL Server won't either.
David Portas
SQL Server MVP
--|||"David Portas" wrote:

> If the server can see a volume on the network then it should be possible t
o
> write to it. If Windows can't see it then SQL Server won't either.
> --
> David Portas
> SQL Server MVP
> --
>
Thanks for the reply David. I can create a Samba share, but do you know of
any scripts or tools that can copy pull the data down? I only have DTS acces
s
to my database on the hosting provider.
I realise most people have access to a Windows server, just wondering if
anyone had done/tried/heard of it.
Jo|||You can create a DTS package with one connection and a T-sql task... The
T-sql task would be a backup command ie.
backup database prod to disk = '\\myserver\mysharename\mybackup.bak' with
init
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jo" <Jo@.discussions.microsoft.com> wrote in message
news:E1948BEF-BBF2-45A0-8695-14D766726225@.microsoft.com...
>
> "David Portas" wrote:
>
to[vbcol=seagreen]
> Thanks for the reply David. I can create a Samba share, but do you know of
> any scripts or tools that can copy pull the data down? I only have DTS
access
> to my database on the hosting provider.
> I realise most people have access to a Windows server, just wondering if
> anyone had done/tried/heard of it.
> Jo|||"Wayne Snyder" wrote:

> You can create a DTS package with one connection and a T-sql task... The
> T-sql task would be a backup command ie.
> backup database prod to disk = '\\myserver\mysharename\mybackup.bak' with
> init
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
"Wayne Snyder" wrote:

> You can create a DTS package with one connection and a T-sql task... The
> T-sql task would be a backup command ie.
> backup database prod to disk = '\\myserver\mysharename\mybackup.bak' with
> init
Thanks for the reply Wayne. I'm still learning, but I'm not sure if I have
access to do this (this command would have to be run on the server?). The
database is sitting on a web host, I only have access (that I'm aware of?) b
y
using Enterprise Manager. I'm don't often work with MSSQL, but what I
initially thought was using a PERL or shell script that connects to the
correct port and runs some commands to initiate a backup. I was hoping that
someone had already written one too. I'm probably crazy :-P
The site I'm doing this for only has a Linux server that gets backed up
daily. Thanks for the help and patience guys :-)
Jo