Windows Server 2003 Web Edition Configuration
Did you remember to publish from your local file system to the website and get NO error reports? as for sql2005 you can use msde instead of full blown sql server. Also ensure that your permissions are set properly

View Answer   |  January 21, 2007  7:36 AM
Database, DataCenter, DB2, Desktops, Development, Interoperability, Management, Microsoft Windows, Oracle, OS, Security, Servers, Software, SQL, SQL Server, Tech support, Web development tools, Web site design & management

Oracle Database Issue
I had a similiar issue where my listener locked up not allowing access to the database from an external source nor could I connect when using tnsnames via: sqlplus user/password@database. The fix action I received was to perform one of the two following: 1 – In 10g ORACLE_HOME, rename $ORACLE_HOME/opnm/conf/ons.config to something else. Example. cd [...]

View Answer   |  January 12, 2007  12:28 PM
Database, DB2, Linux, Oracle

Visual Basic 2005
I presume you are doing this for a class project. First, change the entire string you get to lower case using the LCase function. Then change the first character in the string to uppercase using the UCase function. Then find the location of the blank separating the two parts of the name using the InStr [...]

View Answer   |  January 11, 2007  12:06 PM
Database, DB2, Oracle

Count distinct rows on multiple columns
If you just wanted a count of the student IDs present, you could use COUNT(DISTINCT id). However, you want a running tally-mark. This involves sorting the file to temporary storage, then looking for changes, and putting a 1 in the slot where you have the changes: WITH sorted AS( SELECT * FROM sampleData ORDER BY [...]

View Answer   |  April 19, 2013  11:35 PM
Access, Data/Application Integration, Database, DB2, Desktops, Development, Management, Microsoft Windows, Oracle, Oracle Business Applications, Oracle development, OS, PeopleSoft, Programming Languages, Security, Servers, SQL, SQL Server, T-SQL, Windows

database access
1. Place the database in a directory the is accessible to the user running the program. 2. In your VB project, add a reference to the Microsoft ActiveX Data Objects 2.* Library (ADO) 3. You can use the OLEDB or ODBC along with ADO to connect to the database. If you need help with the [...]

View Answer   |  January 3, 2007  2:28 PM
Database, DB2, Oracle

iSeries accessibility to VB.NET, ASP 2.0/3.0 ,NET programmers in Visual Studio
If you install Client Access for iSeries on your developer’s machines they should have the proper DB2 ODBC drivers installed. Cheers, Paul

View Answer   |  December 28, 2006  8:46 AM
Access, ASP.NET, C, Database, DataCenter, DataManagement, DB2, DB2 Universal Database, Desktops, ESRI, HEAT, HTML, Management, Microsoft Office, Microsoft Windows, MySQL, Oracle, OS, PC/Windows Connectivity, Perl, PHP, Security, Servers, SQL Server, T-SQL, VB.NET, VBScript, Web site design & management, WebSphere Studio, XML

DB2/400 Stored Procedure Security
Very good question. On the 400, files and tables are the same thing. So, users may or may not have the right to execute your stored procedure. For your stored procedure to run successfully, users must have execute rights on it, and read rigthts on any file/table the procedure will use.

View Answer   |  December 26, 2006  5:48 PM
Database, DB2, Oracle, SQL

Exchange Server Messaging Solution
Dear qiayakumar There are several methods to monitor the Exchange 2003/2007 communications. The first is to create a mailbox (call it Traffic) which is being shared by the monitoring body (give permission to those users to read the shared INBOX). This will have both incoming and outgoing messages for the whole server. Through the biult-in [...]

View Answer   |  December 18, 2006  7:40 AM
Brightmail, CipherTrust, ClearSwift, Data warehousing applications, E-business, Ecommerce applications, Exchange, Exchange security, McAfee, MessageLabs, Microsoft Windows, Postini, Rockliffe, Spam, SpamAssassin, SurfControl, Symantec, TrendMicro

Converting datetime (time portion) to varchar
If you are using MSSQL then you can use the convert function like this: select convert(char(11),getdate(),108) the 108 at the end is a canned format for just the time in 24 hour format.

View Answer   |  December 12, 2006  8:20 AM
Database, DB2, Oracle, SQL Server

RUN TIME ERROR 339
sounds like you have not installed the needed runtime files on this machine. search the entire hard drive for this file. and see if it exists. please explain how you moved your application over to this machine. Did you create setup disks? If so, with what tool?

View Answer   |  December 8, 2006  12:15 PM
Data analysis, Database, DB2, Development, Interoperability, Oracle, Software, Tech support, Windows

Query
You may find RUNSQLSTM easier than using query. Just cut and paste your statement into a source member, add a semicolon to the end of the statement. then use command RUNSQLSTM to execute it.

View Answer   |  December 6, 2006  10:40 AM
Database, DB2, Oracle, SQL

Delivery system
what is ur main intention in delivery system? could you explain your question in detail….

View Answer   |  December 6, 2006  7:19 AM
Database, DB2, Oracle, SQL

AMD Sempron
what does your bios report? Check your bios manual you may have to paly with some of the settings to get the throughput you want

View Answer   |  December 6, 2006  7:09 AM
390, Cabling, DataCenter, DB2, Desktop management applications, Desktops, Hardware, Hubs, Linux, Mainframe, Management, Microsoft Windows, Networking, OS, Routers, Security, Servers, SQL Server, Switches, Systems management software, Tech support

convert public folder IPM.POST to IPM.NOTE
The MS article 817809 should resolve the issue if you satisfy the prerequisites under the the MORE INFORMATION section. If you have Exchange 2000 and have installed service pack 3 and the August roll-up patch you still have to make the registry change “Incoming defaults to IPM.Note” shown toward the bottom of the article. If [...]

View Answer   |  December 4, 2006  7:09 PM
Application security, Availability, Bandwidth, Biometrics, Business/IT alignment, Database, DataCenter, Desktops, Digital certificates, E-business, Encryption, Exchange, Exchange security, Identity & Access Management, Instant Messaging, Management, Microsoft Windows, Networking, OS, provisioning, Secure Coding, Security, Security tokens, Servers, Single sign-on, Spam, SQL Server

XML Publisher with Shipping Docs
We’ve run into that issue, from what we’ve been told is that this functionality does not work in 11.5.10, but will be more integrated in version 12. That’s functionality we’re looking for as well and is a big inconvenience for our warehouse staff that have to go out and run the packing slips separately.

View Answer   |  December 4, 2006  1:17 PM
Business Intelligence, Data/Application Integration, Oracle, Oracle development, XML

Cold Fusion
Sun Document ID: 101796 1. Impact The Java Cryptography Extension (JCE) 1.2.1 is an optional package for J2SE 1.2.x and 1.3.x that provides a framework and implementations for encryption, key generation, key agreement, and Message Authentication Code (MAC) algorithms. The digital certificate that was used to sign the JCE 1.2.1 jar files will expire on [...]

View Answer   |  December 4, 2006  11:05 AM
Content management applications, Software, Web site design & management

Database Tuning Advisor “not permitted” error on SQL Server 2005 DE
I do NOT think the tuning will work with what MS gave developer’s. Tuning is generally something that happens when developer products begin hitting the real world. I suspect that is when Microsoft expects to be paid for allowing production work to actaully begin. Microsoft likely also thinks: As a developer on your own workstation [...]

View Answer   |  November 29, 2006  6:15 PM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server

XML Publisher Issue
You probably have an incorrect code on your template. You may have to disable your templates and recreate them with the correct code because you cannot change the code. Verify that the make sure that the code on the template matches the short name in the concurrent programs screen. Also check MLS Function, if it [...]

View Answer   |  November 28, 2006  6:27 PM
Business Intelligence, Data/Application Integration, Oracle, Oracle development, XML

Daylight savings – Change in politics
Microsoft has posted an update to Windows XP that resolved this problem. They MAY also have updates for other Windows versions (I haven’t checked). Jay

View Answer   |  November 25, 2006  7:09 AM
Database, DataCenter, DB2, Desktops, Hardware, Linux, Management, Microsoft Windows, Networking, Oracle, OS, Security, Servers, SQL Server

Oracle SQL and compare date
Just subtract one date from the other and the number of days between will be calculated by Oracle. Magic!

View Answer   |  April 18, 2013  6:40 AM
BPEL, Business Process Execution Language, Database, DB2, Oracle, Oracle 9i, SQL