Recent content by Ramjet

Me again, I also went into CIM on workstation and changed community string and it failed to even connect (as it should). Changed it back and it connects but won't clear. The only other option from the error message is the enable sets but again having trouble doing this server side as I...

Thanks to oneworld for getting this thread started for me. I am having the exact same problem with CIM. Brand new DL360's used Smart Start to bring them up. Installed CIM 5.1 on workstation and won't work won't even show green or red light. Upgraded to CIM 5.2 and installed current SOFTPAQ on...

Hello All, I have a DTS package on SQL2000 that of course runs great in DTS builder. When I execute this package from the command line with: dtsrun /s. /e /nPackage_Name It works great but.... When I use this exact command with the SQL Jobs agent it fails. I am sure it has to do with...

Hello All, I have a VB app that uses the following code to connect to an Access 2000 database. I am using MDAC 2.6 and I distribute the MDAC installer in case the recipient doesn't have it yet. This has been working great for several months untill I ran into a user that has Access 97 installed...

Hello All, I have a very simple expression that I am building and want to implement a carriage return but I am at a loss for how to do it. vbcrlf doesn't work, chr(10) & chr(13) don't work so how does one concatenate a carriage return to the end of a text string? In case your wondering the...

Perhaps I am misunderstanding what you are trying to say. So I have the store procedure below and it works IF the two variables I have are hardcoded in the SP. But How do I get those variables from SCR to the SP... More importantly how do I get them from a web form to SCR to the SP...

You are absolutely correct(Of Course) that is what happens but!! This process originates from a web page so what I am ultimately trying to do is get the dates from the web page to CR8 Then to SP. Problem is I can't have message boxs popping up on server for input dates. But otherwise I do have...

I have an TSQL statement built that executes perfectly. I have a CR8 Report that takes the results of the TSQL and displays perfectly. Now I want to add the ability to select records between two dates. If I hardcode the dates into the TSQL statement it works. What I need to know is HOW can I...

Malcom, Your example doesn't work for me? SQL Server7 SCR8 In Crystal I get an ODBC Error saying incorrect Syntax Near BY. Also I though you didn't use ' in stored procedures for select statements? This is exactly what I needed so all I need is to figure out why SCR doesn't like my(your)...

When CR8 grabs a set of records and evaluates them based on an if then clause can I tell it to skip the record? For example: If date > 12/12/2000 then "skip record" else "print record" end if Can this be done somehow?? TIA

I have a User Defined Function and CR8 seems to be ok passing values to it but after my UDF (VB6) does it's manipulations how do I get that value back into CR8??

Well, I still don't understand java enough to get it to work. Here are the results of these 2 lines of code. On IE 5.5 no errors but page doesn't change according to variable value. On IE 5.0 I get Object does not support this property or method. On Netscape 4.x same as IE 5.5 no errors but...

Well, I still don't understand java enough to get it to work. Here are the results of these 2 lines of code. On IE 5.5 no errors but page doesn't change according to variable value. On IE 5.0 I get Object does not support this property or method. On Netscape 4.x same as IE 5.5 no errors but...