Seagull Bartender Application
-
I am using BarTender[^] software. And try to print barcodes from DB. I am able to fetch data from DB with sql query. But when i try to use Stored Procedure its giving error like BarTender: error message #3239 OLEDB has encountered error 0x800ade78 Operation is not allowed when the object is closed. But when i use sql query its running ok. also i tried with SP having single select query. Its running also ok. But when i give SP (performing some operations in it) then its giving error. Plz, Can any one help/guide me. Whats the issue in this? Regards
-
I am using BarTender[^] software. And try to print barcodes from DB. I am able to fetch data from DB with sql query. But when i try to use Stored Procedure its giving error like BarTender: error message #3239 OLEDB has encountered error 0x800ade78 Operation is not allowed when the object is closed. But when i use sql query its running ok. also i tried with SP having single select query. Its running also ok. But when i give SP (performing some operations in it) then its giving error. Plz, Can any one help/guide me. Whats the issue in this? Regards
It's normal practice, when having a problem with vendor specific software, to post the question on the forum for that software or email it to the company in question. They will be much better placed to offer advice to you than we possibly could, what with our not knowing this software. I will say though, that the error message looks funnily like you attempting to issue a SQL command on a closed connection, but that's just me reading the error text you posted. I couldn't honestly expect you to have done the same.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith
As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
-
It's normal practice, when having a problem with vendor specific software, to post the question on the forum for that software or email it to the company in question. They will be much better placed to offer advice to you than we possibly could, what with our not knowing this software. I will say though, that the error message looks funnily like you attempting to issue a SQL command on a closed connection, but that's just me reading the error text you posted. I couldn't honestly expect you to have done the same.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith
As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
Pete O'Hanlon wrote:
post the question on the forum for that software or email it to the company in question
I did that, and mailed on id they had provided on their site.
Pete O'Hanlon wrote:
the error message looks funnily like you attempting to issue a SQL command on a closed connection
Any one who know English will say what you had...!! But its like this, its giving an error like this. But i couldn't understand, if i use single select statement its running But the actual procedure i need to call, creates a temp table , insert data in it and then drop this table. its giving error in this?
-
I am using BarTender[^] software. And try to print barcodes from DB. I am able to fetch data from DB with sql query. But when i try to use Stored Procedure its giving error like BarTender: error message #3239 OLEDB has encountered error 0x800ade78 Operation is not allowed when the object is closed. But when i use sql query its running ok. also i tried with SP having single select query. Its running also ok. But when i give SP (performing some operations in it) then its giving error. Plz, Can any one help/guide me. Whats the issue in this? Regards
- You are talking about an error with a third party application. 2) You have not provided any code. It will be tough for anyone to help you in those circumstances.
The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.
-
- You are talking about an error with a third party application. 2) You have not provided any code. It will be tough for anyone to help you in those circumstances.
The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.
string SQL = "SELECT `Calories` FROM `NutritionInformation`";
Engine btEngine = new Engine();
LabelFormatDocument btFormat = btEngine.Documents.Open(@"C:\NutritionLabel.btw");
((OLEDB)btFormat.DatabaseConnections[0]).SQLStatement = SQL;
Well above is part of code. Which i used mentioned at their SDK help file. I am replacing the SQL with sql i want to use - Working I am just mentioning SP name in SQL (Sp contain only single Select) - Working But when i call SP which i had to use actually, its giving error. For above code to work you have to download their SDK and install it, then add reference to Seagull.BarTender.Print.
-
Pete O'Hanlon wrote:
post the question on the forum for that software or email it to the company in question
I did that, and mailed on id they had provided on their site.
Pete O'Hanlon wrote:
the error message looks funnily like you attempting to issue a SQL command on a closed connection
Any one who know English will say what you had...!! But its like this, its giving an error like this. But i couldn't understand, if i use single select statement its running But the actual procedure i need to call, creates a temp table , insert data in it and then drop this table. its giving error in this?
Hum Dum wrote:
But its like this, its giving an error like this. But i couldn't understand, if i use single select statement its running But the actual procedure i need to call, creates a temp table , insert data in it and then drop this table.
This is why they are better placed to solve this than we are. How on earth do you expect us to know what it's doing internally? I would expect that it's expecting a query and you are supplying it with DML and that's causing it to bork. Again - they will know the answer.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith
As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
-
string SQL = "SELECT `Calories` FROM `NutritionInformation`";
Engine btEngine = new Engine();
LabelFormatDocument btFormat = btEngine.Documents.Open(@"C:\NutritionLabel.btw");
((OLEDB)btFormat.DatabaseConnections[0]).SQLStatement = SQL;
Well above is part of code. Which i used mentioned at their SDK help file. I am replacing the SQL with sql i want to use - Working I am just mentioning SP name in SQL (Sp contain only single Select) - Working But when i call SP which i had to use actually, its giving error. For above code to work you have to download their SDK and install it, then add reference to Seagull.BarTender.Print.
-
I am using BarTender[^] software. And try to print barcodes from DB. I am able to fetch data from DB with sql query. But when i try to use Stored Procedure its giving error like BarTender: error message #3239 OLEDB has encountered error 0x800ade78 Operation is not allowed when the object is closed. But when i use sql query its running ok. also i tried with SP having single select query. Its running also ok. But when i give SP (performing some operations in it) then its giving error. Plz, Can any one help/guide me. Whats the issue in this? Regards
This is a complete guess as I have never even heard of that product before but do you have the correct permissions to connect and run a stored procedure? Sorry if that is complete bollocks but worth a try.
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum me, me, me