Search results for query: *

Gryphon451, Thanks for the response. Yes, it does look as if my original procedure is missing some parenthesis. I'm about done for the day so I'll try it out tomorrow and see what I can come up with. Again, thanks! jbehrne If at first you don't succeed, call in an airstrike. - Murphy's...

Hi All, I have problem that I am trying to handle in a SQL Server 2000 stored procedure. This stored procedure returns a list of records where the count from a sub-query is greater than 3. In these returned records I need to assign a priority number to groups of the records. Basically every...

Thanks - I acutally meant to change that to Scope_Identity(). If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations

Hi all, I have a stored procedure that I would like to have return the created autoid (this is the primary key field, an integer and an identity with an autoincrement of 1). However, when I run the following code I receive the following errors: Error 9 Description: An SQLParameter with...

Will this block programs that can run from a USB drive (such as Firefox Portable Edition, etc.)? Programs like this are also a big problem... Thanks, jbehrne If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations

Hi all, I have several computers running WinXP Pro where the user is a Local Admin (due to several required software packages the user must run as an Admin...). Due to this I keep finding that users are installing unwanted software (games, etc.). Does anyone know of a piece of software that is...

A group policy on your AD should let you set some printing limitations. If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations

Hi all, I have to replace an aging LJ 4000N printer with a new one after many years of loyal service. After pricing the HP P2015x I cannot find any information about support of PJL. Does this printer have support for PJL? If not can anyone recommend a new HP laserjet that supports it but is...

Hi all, I'm running SQL Server 2000 with all the latest patches. I am backing up all of my databases and transaction logs on weekdays. My maintenance plan that handles this is supposed to delete any .TRN and .BAK that are older than 5 days. So far the .BAK files are being deleted, but not the...

Yes, I'm positive. I even went so far as to download and try to install MDAC 2.8 (which would not install because it found SP 2 had already been installed). I thought that it was included too! If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations

ThatRickGuy, I initially thought that the samething but Windows update did not turn up any updates. The Windows XP Pro disk that I used for the problem computer has all of the lastest critical and recommened updates slip streamed in it... I got it from my universities Computing Services...

In case anyone else runs across this error here is how I solved it: Copied "ADODB.dll" from another computer and dropped it in the folder "C:\Windows\Assembly" If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations

macleod1021, I'll give your suggestion a shot and see what happens. jbehrne If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations

DJJ, The computer currently has 1.0, 1.1 and 2.0 installed. Will it run with all of the frameworks installed (this isn't a problem on the other computers...). Thanks, jbehrne If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations

Hi All, I recently depolyed an app. on several computers that I built using VB.Net 2005. All of the computers are running Win XP w/SP2 with all of the latest patches, etc. applied. On one computer whenever I run the application I get the following error: Unhandled exception has occurred in...

Hi all, I am going to split an Access 2002 database frontend and backend. I don't want to use a mapped drive connection for the location of the backend and I'm looking at a UNC connection. Any pros/cons for using this as opposed to a mapped drive connection? Thanks, jbehrne If at first you...

Hi all, I've got two reports that I finished creating recently. One report is a correspondence letter to contacts in various departments that my organization deals with. The second report contains billing data for review by the same contact. Here is the problem that I am facing. I need to...

Try this: Me.DataGridView1.DataBindings.Clear() Me.DataGridView1.DataSource = Nothing If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations

I was thinking that I may have to run the status form on a different thread - but I was going to wait to see if anyone else had conquered this problem... It's interesting to see that the functionality (as far as this status form example goes) offered in 2003 was lost in 2005. jbehrne If at...

Hi all, I wrote an application in VB 2003 that interfaces with a MS SQL database. When the user performs various tasks (adding/editing/deleting records) a form (containing 1 label) is displayed that shows the status of the task. For instance, when the user opens a form that displays data in a...