Search results for query: *

What is the best way to get the most current dates from a list for each id? ID Date 1044 2009-07-31 14:17:43.000 1044 2009-07-31 14:15:44.000 1044 2009-07-31 14:11:44.000 1047 2009-07-31 14:33:19.000 1047 2009-08-11 16:58:41.000 1047 2009-08-10 11:51:01.000 1051 2009-08-10 12:51:01.000...

I have done a number of odbc programs. I am running Access 2003 and Sql Server 2005. I have a basic connection (below) and I am able to execute stored procedures and run updates but I am not able to return a simple recordset? Any Ideas. Simi Private Sub Command10_Click() 'New as400 test...

I am using Debian. Once I log into the desktop from the console I can then VNC to it from a remote host. Is it possible to set it so I can log in remotely without having to log into the console first? Thanks Simi

I have a MSDE database that is at the 2 gig limit. We removed alot of history. There should be pleanty of space if it were reduced. I have tried sp_shrinkfile and it did not work. What is the best way to reduce the .mdf. Thanks Simi

I am just learning GDI. I am just trying to draw some lines etc. All the examples on the web occur from screen load. I want to draw when i hit a button. What do I need to change. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click...

I have a query that I wrote that does not work, and a couple of versions that do. I don't understand why the first one does not work. Basically I want to take a varchar field and concat it into a single value like below. List.... 5524289008 5524289011 5524255010 5524255097 5524251254...

Need some help with single and double quotes. I am trying to build a dynamic query but I can't get the quotes right around the date. declare @mydate datetime set @mydate=getdate() declare @comp set @comp='1st' --Version 1 exec('UPDATE [MyDatebase].[dbo].[' + @comp + ' table]' + ' SET...

I was reviewing someone else's code and came across the following code... It is a stored procedure that alters itself? But I don't see that it alters anything. It also has 2 nested begin and end statement but they seem to be redundent? Thanks Simi ALTER PROCEDURE...

I have a brand new windows 2003 server 64 bit. My programs can see user DSN's s but can't find system DSN's. Anybody have any idea's. I can't imagine a security setting but anything is possible. Thanks Simi

I am attempting to export some records in SQL Server 2005 from a view to a xls file. The same query reports 26000 records but only about 22000 show up in the file. There are no error or warnings. It appears to complete normally. The query is a simple Select * from.... Any thoughts? Thanks Simi

I have a regular date time field like 2008-08-20 15:05:24.000 I need to convert it to a integer time like 150,524 Any thoughts? Thanks Simi

I have a Log that has grown to 19 gig. It is set to 19136 MB initial size. Autogroth by 10 percent, unrestricted growth. I am not sure how to handle it. I assume that it does not need to be that large. I am backing it up nightly. Should I delete it and create a new smaller log size? Since the...

I have a null value in a table. When I read it, it automatically fails. I have tried several things I found on the net but nothing works. As long as it is a string it works. Any suggestions.... Dim mySelectQuery As String = "select * from dbo.znid where left(znidadd,7)= '" &...

I need to combine string with a consecutive number. Like Option1 Option2 Option3 etc. Is there a way to do it without using a cursor? Somthing like select field1, 'option' + MagicNumber as OptNum Thanks Simi

I have a vb.net 2003 program that makes an ODBC connection to an AS400 then it performs an insert query to put a single record in a table. In testing it works perfectly. But in production from time to time it hangs up. I believe it may have something to do with the state of the AS400. When it...

I have a custom program I wrote in vb.net 2003 for an Ingenico i6550 USB MSR device. Apparently any user with only basic USER windows permissions cannot gain access to the OPOS driver and causes a error when calling the program. They also cannot gain access to the user interface of the driver...