Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: ideasworking
- Order by date
-
refresh linked server?
Hi, Thanks for the response. This is a small facility with a dozen employees. I am the pseudo network administrator, application developer, DBA, help desk, electrician, controls engineer, and so on... so Tek-tips is my IT support. I don't see the network being much of a problem. There is...- ideasworking
- Post #3
- Forum: Microsoft SQL Server: Programming
-
refresh linked server?
Hello, Has anyone come up against a problem with an SQL 2000 server losing it's connection to a linked server even though the linked server is healthy? I have this problem. It seems every once in awhile the connection between the servers times out, hiccups, or something and then I have to...- ideasworking
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
images slow to load
Hello, I'm trying to tailor my web pages to suit end user screen size. Now my pages are loading like I'm using dialup. I'm new to javascript so maybe I've done something wrong. Anyone care to review my code? TIA, Lou <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"...- ideasworking
- Thread
- Replies: 1
- Forum: Javascript
-
Arithmetic overflow error converting varchar to data type numeric.
Alex, Thank you so much... I was about to erase this problem from my brain with a bottle of rum. Now I'm going to celebrate finishing this SP with that same bottle of rum. Either way the bottle never had a chance, ha ha ha. It never occured to me that I had to convert to to anything other than...- ideasworking
- Post #7
- Forum: Microsoft SQL Server: Programming
-
Arithmetic overflow error converting varchar to data type numeric.
I also tried the following which result in the same result. select @UpdateSQL = 'UPDATE [Reporting].[dbo].[DailyTotals] SET [1010Gas] = ''' + convert(numeric(18,1),@GasUsed) + ''' WHERE [DateAndTime] = ''' + CONVERT(CHAR(10), @TenYesterday, 120) + ''''- ideasworking
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Arithmetic overflow error converting varchar to data type numeric.
I think I am putting quotes around @GasUsed. Can you provide an example of what you mean? Thanks, Lou- ideasworking
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Arithmetic overflow error converting varchar to data type numeric.
Hello, I could use some help identifying a problem with my stored procedure. This stored procedure subtracts the values from two tables and updates a third table with the result.... er well, that's the way I want it to work. All three tables have datatype numeric (18,1). The value in...- ideasworking
- Thread
- Replies: 7
- Forum: Microsoft SQL Server: Programming
-
record locking with PHP and MS SQL
I have read some other people's post about having problems with queries and url redirects. I'm wondering if this is a common problem and how is it resolved? I have several web pages that display records and allow me to modify the records. So what a record modification the browser is redirected...- ideasworking
- Post #8
- Forum: PHP
-
mssql_query to delete not working.
Thank you, I should have tried that myself. I typically write values to this table that do not have seconds. However when I was making the changes a couple weeks ago I wrote some SPs that included seconds. There was no way that query was going to delete the record for 2007-01-08 01:29:34. I...- ideasworking
- Post #5
- Forum: PHP
-
mssql_query to delete not working.
I took your advice and changed the date formatting. Now the query appears as However it still doesn't work. Any other ideas? TIA, Lou- ideasworking
- Post #3
- Forum: PHP
-
mssql_query to delete not working.
Hello, About a week or so ago I upgrade PHP to version 5.2 and ever since I have had trouble with mssql_query. I'm trying to delete a record and the query fails to delete the record. The query looks fine it's.... Here's my code. Any idea why this isn't working? Thanks, Lou...- ideasworking
- Thread
- Replies: 4
- Forum: PHP
-
Can't see web page on server - Failed Authentication
I went back and looked at the registry again... it was late last night and I missed LSA key. It was there and I disabled the LoopBackCheck. Now I am able to see the web page when browsing at the server.- ideasworking
- Post #5
- Forum: Microsoft: Windows servers
-
Can't see web page on server - Failed Authentication
Hello, I'm using Windows Integrated Authentication. There's no domain controller, this is just a single Windows box. I read some stuff last night about a loop back check. I looked in the registry and there was no LSA key... so I don't suspect it's the loob back check. I'm stumped... I would...- ideasworking
- Post #4
- Forum: Microsoft: Windows servers
-
record locking with PHP and MS SQL
I have narrowed the problem down a little further given your advice. I have learned two things. 1) The problem appears to berelated to hyperlinks. I have two links "Yesterday" and "Tomorrow". Sometimes while clicking on these links the server will stop displaying the pages. 2) I have to stop...- ideasworking
- Post #7
- Forum: PHP
-
record locking with PHP and MS SQL
Hello, I'm sorry you are correct... the info provided was not very helpful. The next time this problem occurs I will attempt to narrow down the culprit. In the mean time I wondered if seeing the PHP page I created to update these records might help identify the problem. This page is a little...- ideasworking
- Post #5
- Forum: PHP
-
record locking with PHP and MS SQL
Hello, Ok, maybe it's not not a record sharing violation that is causing PHP to loose it's connection to MS SQL. Here's are the details... Everyday a new record is created in the table and every minute that record is updated using a trigger from another table. This is a consolidated record...- ideasworking
- Post #3
- Forum: PHP
-
record locking with PHP and MS SQL
Hello, It seems I have created a bit of a cluster bleep... and I need some help sorting it out. Here's the situation. I have a table that updates the most recent record every minute. However there are times when I need to manually update the same record. When I attempt to manually update the...- ideasworking
- Thread
- Replies: 7
- Forum: PHP
-
FTP being hammered by...
Thanks to everyone. I am going to block port 21, it's the easiest most secure way to deal with the issue. Cheers! Lou- ideasworking
- Post #7
- Forum: Microsoft: Windows servers
-
FTP being hammered by...
Hello, I was looking in the event viewer and I see that over the past several days someone has made about 80,000 attempts to gain access to my Win2003 server via FTP. I could block the FTP port at the firewall... but to be honest I'd like to keep it open as I often FTP to this server. What else...- ideasworking
- Thread
- Replies: 6
- Forum: Microsoft: Windows servers
-
MS Query doesn't work after upgrade to PHP 5.2
After a few hours of working through this to determine the problem I have narrowed the problem down to the command that closes the mssql connection. I removed this line mssql_close; and now everything works fine. Well maybe I shouldn't say that yet... I'm not sure what the implications will...- ideasworking
- Post #2
- Forum: PHP
