473,287 Members | 1,899 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

Print Label on LOCAL Zebra Printer from WEBSITE Inventory DB

I have developed a web-based inventory system for my estate jewelry business
using ASP.Net 2.0 and Microsoft SQLServer. The inventory database is also the
basis of my website (www.lookwhatifound.biz). I want to print jewelry tags on
a local Zebra printer with the label consisting of fields from the web-based
SQLServer database.

I'm pretty sure I can create the label as a file using ZPL and download the
file using the RESPONSE object.

How can I direct Internet Explorer to send the downloaded file to the (USB)
Zebra printer?

Security isn't a big issue here, since the database maintenance pages are
accessable only to me and this program will only run on my computer.

I'd appreciate any suggestions.

Paul Buzza
Apr 25 '07 #1
4 3155
"Paul Buzza, oldster using new tools"
<Pa***************************@discussions.microso ft.comwrote in message
news:F4**********************************@microsof t.com...
>I have developed a web-based inventory system for my estate jewelry
business
using ASP.Net 2.0 and Microsoft SQLServer. The inventory database is also
the
basis of my website (www.lookwhatifound.biz). I want to print jewelry tags
on
a local Zebra printer with the label consisting of fields from the
web-based
SQLServer database.

I'm pretty sure I can create the label as a file using ZPL and download
the
file using the RESPONSE object.

How can I direct Internet Explorer to send the downloaded file to the
(USB)
Zebra printer?

Security isn't a big issue here, since the database maintenance pages are
accessable only to me and this program will only run on my computer.

I'd appreciate any suggestions.

Paul Buzza
Paul, I think you can create a desktop agent which can from time to time
connect to your online database and print the label.
Apr 25 '07 #2
Some kind of a thick client would do the trick.
Perhaps an embedded activex control or windows forms control.

--
I hope this helps,
Steve C. Orr,
MCSD, MVP, CSM, ASPInsider
http://SteveOrr.net
"Paul Buzza, oldster using new tools"
<Pa***************************@discussions.microso ft.comwrote in message
news:F4**********************************@microsof t.com...
>I have developed a web-based inventory system for my estate jewelry
business
using ASP.Net 2.0 and Microsoft SQLServer. The inventory database is also
the
basis of my website (www.lookwhatifound.biz). I want to print jewelry tags
on
a local Zebra printer with the label consisting of fields from the
web-based
SQLServer database.

I'm pretty sure I can create the label as a file using ZPL and download
the
file using the RESPONSE object.

How can I direct Internet Explorer to send the downloaded file to the
(USB)
Zebra printer?

Security isn't a big issue here, since the database maintenance pages are
accessable only to me and this program will only run on my computer.

I'd appreciate any suggestions.

Paul Buzza
Apr 25 '07 #3
Thanks, Steve. I think that would work. I've found a piece of software
(Printfil) that will do the print function, so I just need to store the file
into a specific directory. Having never written an ActiveX control, I looked
for tutorials, and they seem to use the VB development envoronment. I used
the free MS tools (Visual Web Developer Express) to create the site; would
Visual Studio Express be a tool I could use to develop a very simple control
that would save a file to a specific directory on the local computer?

"Steve C. Orr [MCSD, MVP, CSM, ASP Inside" wrote:
Some kind of a thick client would do the trick.
Perhaps an embedded activex control or windows forms control.

--
I hope this helps,
Steve C. Orr,
MCSD, MVP, CSM, ASPInsider
http://SteveOrr.net
"Paul Buzza, oldster using new tools"
<Pa***************************@discussions.microso ft.comwrote in message
news:F4**********************************@microsof t.com...
I have developed a web-based inventory system for my estate jewelry
business
using ASP.Net 2.0 and Microsoft SQLServer. The inventory database is also
the
basis of my website (www.lookwhatifound.biz). I want to print jewelry tags
on
a local Zebra printer with the label consisting of fields from the
web-based
SQLServer database.

I'm pretty sure I can create the label as a file using ZPL and download
the
file using the RESPONSE object.

How can I direct Internet Explorer to send the downloaded file to the
(USB)
Zebra printer?

Security isn't a big issue here, since the database maintenance pages are
accessable only to me and this program will only run on my computer.

I'd appreciate any suggestions.

Paul Buzza
Apr 26 '07 #4
On Apr 26, 5:24 pm, Paul Buzza, oldster using new tools
<PaulBuzzaoldsterusingnewto...@discussions.microso ft.comwrote:
I've found a piece of software
(Printfil) that will do the print function, so I just need to store the file
into a specific directory.
you can't do that because of security reasons

Apr 26 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

56
by: peng | last post by:
Hi, I am development a project using C#.Net. Inside application, it needs to print labels on different Zebra label printers on the network. I used a shell script, but it only worked on the...
13
by: ATJaguarX | last post by:
I have a Zebra S500 and multiple S600 label printers. http://www.zebra.com/id/zebra/na/en/index/products/printers/industrial_commercial/s600.html They are currently being used in our legacy...
2
by: Crazyhorse | last post by:
Hi, I am trying to print labels to a zebra printer using the print document object in vb.net. Printing works fine to my local printer but with the Zebra, the data light indicator just flickers a...
24
by: Tony Girgenti | last post by:
Hello. Developing a Windows Form program in VS.NET VB, .NET Framework 1.1.4322 on a windows XP Pro, SP2. Before printing a document, i want to set the font to a font that is only available...
2
by: Flying Kite | last post by:
Hi All, I want to know how to print chinese characters on Zebra Printer, following code working fine with English string, but it's not working for Chinese string. It shows ASCII characters instead...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.