.Net/C# Roundtrip code generator
roz2000 - I don’t have any personal experience with .NET code generation tools, but I can refer you to a very good website that provides information and resources on code generation. Checkout: http://www.codegeneration.net/ On this site, you will find interviews, technical articles, book references, and product/tool lists for specific platform. There are some very good [...]

View Answer   |  September 30, 2004  1:44 PM
Lifecycle development

BAI Transfer using CL Program
We transfer to two different banks using two different methods. For payroll we use FTP and send the data in the format the bank needs. For the other, the file is deposited in a global mailbox where the bank retrieves it. Of course, this method requires you have a mailbox account and password. These processes [...]

View Answer   |  September 29, 2004  12:58 PM
Online transaction processing

How do you create query with multiple totals by date
I believe you need to sort by and use the date field and the type filed that you group by. try that.

View Answer   |  September 29, 2004  8:49 AM
SQL

Problem in installing Siebel 7.7 dedicated server.
Which operating system are you running on your server ? In general, it seems that you must use an user account that has the right to “log on as a service”. Siebel application obviously needs to start background services, which will require that kind of user account. You may need to add/change user account policy [...]

View Answer   |  September 28, 2004  2:07 AM
Development, Hardware, IT architecture, Lifecycle development, Tech support, Web development tools

Windows XP patch (non-SP2), IIS, and ASP.NET Forms Authentication
Never mind. I got it to work. Thanks.

View Answer   |  September 27, 2004  3:45 PM
ASP.NET, Microsoft Internet Information Server, Windows

Installing Oracle 9i Standard Edition on Windows Server 2003 with Xeon CPU: Why does Java Virtual Machine fail?
I am in the process of doing a similar thing. Installing Oracle EE 9.2.0.1.0 on Win 2003. The box is 64 bit but the op system is 32 bit. So I am installing the 32 bit version of Oracle. In order to do this the recomendation was to add a patch to the Oracle Installation [...]

View Answer   |  September 27, 2004  5:57 AM
Database Management Systems, Hardware, Intel PC hardware, Intel servers, Java, Microsoft Windows, Oracle, Standard Edition, Tech support, Windows on Intel, Windows Server 2003

Lotus Script Error Message: Subscript out of range.
Without seeing the code, my guess is that your “Subscript out of range” issue is due to the array(s) in the program not being DIMensioned with enough elements. Check the loop that is used to update the array(s) and see if the original programmer has included code to count the number of items being processed [...]

View Answer   |  September 24, 2004  10:17 AM
Development, Exchange, IBM, Lotus Domino

PATINDEX Instruction Result Difference between SQL 7 and SQL 2000.
Sorry but I am just a novice at SQL. I probably wouldn’t be much help to you.

View Answer   |  September 24, 2004  10:08 AM
Development, SQL

Presentation of information to Customer Service Reps.
Well not so much a package as a tool. VARPG will work great and IBM supports it in Websphere. And its free if you bought the websphere product for your 400. Tell you programmers to try it out. It is so simple to program subfiles in that it is almost scary sometimes.

View Answer   |  September 23, 2004  12:58 PM
CRM, Development

VB Program error
Hi Abby, When using a ODBC driver, you normally have 2 types of ODBC timeouts : a Connect Timeout and a General Timeout. The Connect Timeout is the time the driver waits to validate the connection wanted. If passed, your connection fails. The other one is the time delay the driver uses to check if [...]

View Answer   |  September 17, 2004  5:05 AM
Visual Basic

Additional information: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
What database are you using? SQL? Access? What was the server OS before your upgrade? You said Windows 2003, but was it 2000?

View Answer   |  September 15, 2004  12:43 PM
VB.NET

VB6 DLL Sourcecode
Since VB6 DLLs are compiled into machine code, I know of no way to reverse engineer a VB6 DLL back into source code.

View Answer   |  September 14, 2004  10:38 AM
Development, Lifecycle development, Tech support

Creating a query that will return specific days-3
Hi, See http://www.novicksoftware.com/UDFofWeek/Vol2/T-SQL-UDF-Vol-2-Num-14-udf_DT_NthDayInMon.htm for a Nth day in month UDF. Regards, Andy Novick Software http://www.NovickSoftware.com

View Answer   |  September 2, 2004  10:21 AM
SQL

Creating a query that will return specific days-2
What’s exactly the problem. What are you trying to do and how ?

View Answer   |  September 1, 2004  12:13 PM
SQL

Creating a query that will return specific days
These problems can be solved using a calendar table. Check out this link http://www.aspfaq.com/show.asp?id=2519

View Answer   |  September 1, 2004  12:07 PM
SQL

System variable for BAPI
As far as I know there is no system variable, but you might wish to check the usability of function block “SYSTEM_CALLSTACK”. In et_callstack you will find EVENTTYPE “FUNC” in combination of EVENTNAME “BAPI_*”. Good luck. Heiner

View Answer   |  August 26, 2004  7:41 AM
Development

Mailbox/Calendar Authority
Can we assume that the user can change other preferences, just not colors? As the owner then she is listed as such on the Mail/Basics tab? What is her access in the ACL? Have you tried replacing the design of the mail file? Can other ‘normal’ users change the colors OK?

View Answer   |  August 25, 2004  12:07 PM
Address book, Agents, Backup & recovery, Calendar, iNotes, Lotus, Lotus Domino, Monitoring, Password and ID management, Performance/Availability, Smarticons, Web access

SQL Server query
http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid526288_tax285649,00.html

View Answer   |  August 25, 2004  12:52 AM
SQL

HI GUYS – OPTIMIZATION
Since you mentioned that you have a front end [program] to run this query, consider splitting your query into multiple queries using your front end to pass the results to the subsequent queries. It has been my experience that the smaller queries run faster. I’ve made the assumption that you already have appropriate indexes on [...]

View Answer   |  August 23, 2004  10:23 AM
Development, Lifecycle development

massive powerpoint presentation
I found this: http://www.zdnetindia.com/help/specials/powerpoint/stories/16501.html and this: Prior to PowerPoint 97, there was no internal file compression code inside of PowerPoint, and files could get pretty big quickly. The most common cause of large files is the addition of large bitmaps. PowerPoint 97 compresses these bitmaps, but previous versions do not. To keep your presentations as [...]

View Answer   |  August 17, 2004  9:22 AM
Desktop management applications, Desktops, Microsoft Systems Management Server, Programming Languages, Tech support