Hi Joe,
Are you still having trouble with this?
Dr B
DrBunchman
Last Activity: Apr 3 '19, 12:28 PM
Joined: Jan 18 '08
Location:
-
Hi, I opened a thread, and I am uncertain where it is supposed to go. It is Microsoft Visual C# 2008 question.
This is the thread: http://bytes.com/topic/net/answers/8...ab#post3497599 -
No problem.
The crucial question is whether both databases are on the same SQL Server. If so then you only need to open and close one connection. Think of the connection as being to the SQL server with a default database specified in the connection string rather than being a connection to the database itself.
Give it a try and let me know how it goes.
Dr BLeave a comment:
-
Hi TimSki,
Assuming that you have two databases called Database1 and Database2 on the same server then you only need one connection and can use the following SQL query:
Let me know if this helps,Code:SELECT * FROM Database1.dbo.Table1 UNION SELECT * FROM Database2.dbo.Table2
Dr BLeave a comment:
-
I've taken the number of hours and number of minutes from the Date variable and used them to calculate the total like this:
Hope this helps,Code:Dim iRec As Integer = 300 Dim iTotal As Integer Dim dt As Date = "07:30" iTotal = (dt.Hour * iRec) + ((dt.Minute / 60) * iRec) Response.Write(iTotal)
Dr BLeave a comment:
-
Hi Varinder,
What is it you are trying to acheive? I can't see why you would be multiplying a Date by an Integer but if you let us know we may be able to help.
Incidentally, in VB.NET you can use
Integer.Parse(V TAR_Hr) rather than CInt(VTar_Hr)
and
Date.Parse(VYpt ime) rather than (CDate(VYptime)
Also the very useful TryParse function:
If Integer.TryPars e(VTAR_Hr,...Leave a comment:
-
Hi ram09,
You've posted your question in the ASP Forum which is for Classic ASP only - I've moved it for you but in future please post all ASP.NET questions in the .NET Forum.
Regards,
Dr BLeave a comment:
-
Hi Jerry,
Sounds like a tricky one as it doesn't seem to be a consistent problem. I've googled that error message and found this:
80004005, Microsoft OLE DB Provider for ODBC Driver Error 80004005, Microsoft Jet Database Engine Error 80004005, Error 80004005, Provider Error 80004005
Is there anything here which helps you?
Does the website normally work if you don't forget to upload the database...Leave a comment:
-
Hi MrCorbeaux,
Further to Jared's answer to your question I just wanted to say welcome to Bytes! Please take the time to read the Posting Guidelines if you have not done so already.
Please don't forget to wrap your code in CODE tags - it makes your posts much easier to read.
Thanks,
Dr BLeave a comment:
-
Hi Jerry,
If you haven't made any changes to your scripts then GoDaddy must have done something at their end.
What's the error that you are getting?
Dr BLeave a comment:
-
Hi PaullyB,
Welcome to Bytes.com! I hope you find the site useful.
You've posted your question in the ASP Forum which is for Classic ASP only - I've moved it for you but in future please post all ASP.NET questions in the .NET Forum.
If there are commas already embedded in the fields in your CSV file then there is nothing that you can do. They must be removed/replaced prior to the CSV file being created....Leave a comment:
-
Hi freefony,
You seem to be using a mixture of Classic ASP and ASP.NET here - can you confirm which language you are intending to use?
Thanks,
Dr BLeave a comment:
-
No problem winash, glad you got it sorted :-)Leave a comment:
-
Hi STAMG,
Welcome to Bytes.com! I hope you find the site useful.
You've posted your question in the ASP Forum which is for Classic ASP only - I've moved it for you but in future please post all ASP.NET questions in the .NET Forum.
Regards,
Dr BLeave a comment:
-
Hi balurbabu,
Welcome to Bytes.com! I hope you find the site useful.
You've posted your question in the ASP Forum which is for Classic ASP only - I've moved it for you but in future please post all ASP.NET questions in the .NET Forum.
Regards,
Dr BLeave a comment:
-
HI MATTXtwo,
Instead of using a For loop could you not use:
Does this fix the problem? If not, can you say which line is causing the error.Code:Do Until rs.EOF 'Process your record rs.MoveNext Loop
Dr BLeave a comment:
-
Hi nirmala26,
What do you mean by it only shows partially? Is it being cut off at the bottom, top etc?
You will find that you will often get issues with the appearance of your web pages if you develop them using Internet Explorer no matter which version - I would recommend that you use FireFox or Opera to develop your site and the w3 markup validator to check the generated html to ensure that your mark up is correct....Leave a comment:
-
You could use the ToShortDateStri ng function like this:
Hope this helps,Code:Date.Parse(strDate).ToShortDateString()
Dr BLeave a comment:
-
gowthamkg,
Please don't forget to wrap your code in CODE tags - it makes your posts much easier to read - and please read the Posting Guidelines if you have not done so already.
Which alert box is causing you the problem?
Dr BLeave a comment:
-
Try 192.168.1.206/SRTS/login.html
localhost is the servername when you are browsing the site from the machine that the IIS is on - you don't use it when browsing it remotely.
Let me know if that works
Dr BLeave a comment:
No activity results to display
Leave a comment: