|
I have run into a slight problem in some VB6 code called from 'classic' asp page. The VB6 code does a bit of processing and then proceeds to insert a series of rows into a DB table within a loop, e.g.
<br />
<br />
do<br />
<br />
'call generic insert function to DB, connection opened and closed<br />
<br />
'increment counter<br />
<br />
loop<br />
<br />
And this has been working fine for many years. One client has found a problem - I debug in here and when the counter gets to around 3950 rows (changes each time), i get the following error when performing the insert:
DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Anybody any ideas as to why this would be happening?
|
|
|
|
|
Take a look at the event log on the server where SQL Server sits to see if any events have been raised (such as the database shutting down).
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
It's a development machine i'm testing it on, with a local sql server - nothing of note in the event logs.
|
|
|
|
|
In that case - connect Query Analyser to this instance and take a look at all of the messages that it fires when the connection *closes". Just a thought there - you are closing the connection between saves aren't you?
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
I'll give that a go. And yes, they should all be closed...
|
|
|
|
|
Ok. Just got back to this now. We are using a single connection object that is opened at the start and then closed after performing all the inserts...
My trace just shows many Audit Logon messages rather than connection open messages.
|
|
|
|
|
Hi,
I have created a web page, where the user sees a list of all the available reference files present on the server.
The List is shown as
C:\XYZ\News\Ace & Star Awards.pps
C:\XYZ\Current\Bravery Awards.doc
C:\XYZ\Latest\Humanitarian Rules.txt
I have given hyperlinks to the user for each of this link by creating a hyperlink dynamically like
for (int Counter = 0; Counter < lbFiles.Items.Count; Counter++)
{
HyperLink hLink = new HyperLink( );
hLink.Text = lbFiles.Items[Counter].ToString( );
hLink.NavigateUrl = lbFiles.Items[Counter].ToString( );
Page.Controls.Add(hLink);
}
Now how do i make the webpage open the appropriate actual word/ pps or txt file as per what the link is clicked ?
Do I need to replace the C:\XYZ\News with something else ?? How do I do that ?
Pls guide me.. I have never done this before.
Thanks and best regards
Omkar Ghaisas
|
|
|
|
|
Omkar Ghaisas wrote: C:\XYZ\News\Ace & Star Awards.pps
This is a local file, right ? You need to read the file into memory in your page, do a response.BinaryWrite of the file bytes, and set the MIME type to correspond to the file type. Then response.End, and the file will be sent to the user. Make your link go to a page that does this for you, and it will all work.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Hi all,
I am creating application in which I have to fetch record from database after
every 60 sec.
How can I call database fetching function after each 60 sec. duration.
It is possible in windows application by using timer but what about web application.
Please help me ...it's urgent.
Regards,
Nagraj
|
|
|
|
|
If you want to show a new record every 60 seconds, you can create a timer in your page, and either refresh blindly, or use AJAX to make the calls. If the former, you need a seperate thread that collects another record every 60 seconds.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Thanks for response...Can you please send me any link related to this.
Regards,
Nagraj
|
|
|
|
|
May I know the difference between Appserver and Webserver ? Purpose / advantage / Disadvantage of the above.
Thanks in advance.
Regards,
Kumuda Srinath
|
|
|
|
|
Googled:
Difference between Appserver and Webserver[^]
Surely it's easier to do your homework through Google.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
hi ,
wish u happy new year.
i have created a setup and installed the console appln in a diffent system .Everything is working except a form which has report viewer to display output.i think i have Not follwed the procedure to create setup for applns which have reports properly.the error which is dispaly when i try to display the report using report viewer in the application is
"System.Runtime.Interopservices.com exception
(0x80040154):com object wutg cksud{...} is either not valid or not register
at crystal desicions.crystal reports.ReportDocument.[]=()
-do- .Internalinit()
-do- .ctor()
at projname.projname..ctor
at projname.frmname.btn10_click()
any suggestion is welcome...
thank you for ur time and help in advance..
enjoy..
|
|
|
|
|
Looks like you don't have Crystal Reports installed.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
thanks for the reply,
but i dont think we need to install crystal reports on the client machine for viewing or running the report using the application which i already created.
enjoy..
|
|
|
|
|
But you will need the dlls for the report viewer. They need to be included in your setup package.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
thnsk for reply
can u please suggest the dlls that can be included and where there would be present to include. i am using segate crystal reports and visual studio2003 .
-- modified at 8:17 Tuesday 9th January, 2007
enjoy..
|
|
|
|
|
Hi dears,
I want to delete a bmp file that is shown in page by click Delete button! but an error with message 'Access to the path ".../t.jpg" denied ...' occures! how can I fix it?
www.behzadi.net
|
|
|
|
|
Set the required permissions for that folder (write).
BTW, is t.jpg really a bmp file? :P
|
|
|
|
|
Use these lines
string urlFile_ToDelete = Request.PhysicalApplicationPath + url_image;
File.Delete(urlFile_ToDelete);
Be sure that the asp.net process over the IIS have the permission to modify the archives that belong to the folder where the image is.
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
keep Learning and you never will be out of date...
|
|
|
|
|
Hai all,
Here my question is simple and try to understand exactly.
I am using different panels in a single form.
I have given these panels in a TABLE's single row( means in a row,differnt columns, and each column contains each panel).On the page load it is showing all the panels in that table row.
My requirement is,can i show each column means each(one) panel at a time(one panel at one tome).can i set any property of the table to show in this way???TabIndex in the table meant for what???
Can anyone try to unerstand the problem and give me the solution???
kissy
|
|
|
|
|
my browser is not showing image button and images while iam running the web application....
if the page is made to view in browser with out running the web application then it is showing image button and images in a browser
after running the web application iam getting the problem with the image buttons and image controls...
please any body help me to overcome this problem .!
hope i wil get some suggestion.....
byeee guys
srikanth raju
|
|
|
|
|
Can you specify what exactly you mean by "running the web application"?
If you view the page without "running the application", how do you do that? The application has to be running for it to show the page, so you have to mean something else...
---
Year happy = new Year(2007);
|
|
|
|
|
I think he means the path is set up in IIS, so he can run it with F5 from VS, or he can just type 'localhost' in the browser. I think one works and the other does not because the paths in his app get screwed up by the setup of his web app.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
