Database Issues

Oracle database access problem over WAN

We are using ERP applications where application serve is at one location and database server at different location. both locations are connected through a 2 MBPS MPLS link ( latency 4-5 ms). problem is that sometimes i can login to the application and sometimes i get TNS packet writer failure...

get a anr record from databse by using max (one Field) and orderby (one filed) desc

Hi, I have a table. It can have multiple records for the key value. Ex secid   time       source 1       02:04    a 1      02:04    b 2 3 Now i want only one record of secid for a descending orderby of (source) and for a max time stamp. and later i will join the secid with...

Database Issues - Trying to prove that something has to be done

Hello Everyone, I'm currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some...

Access/Word Mail Merge Currency lost digits

I made a Donations database which merges with a Word document that provides a receipt. The data that comes over drops zeros after the decimal. Ex: $700.00 appears as $700 ...Even worse $700.60 appears as 700.6 How do I get the decimals to show?

Adding new entries to a table via a combo box in a form

I have a Database for tracking conference attendance. Because of this I want to be able to both retrieve attendees and also adding new attendees. I have a form that allows me to retrieve attendees already input into a table via a combo box, but I can't add new attendees via that same combo box. ...

Database Question.

Hello all .. I am doing an Internship with a company in Nashville that does community branding. Recently I received a project to design a database which would house all of the information that we would need to show to potential clients to gain their business. Such as particular information...

Finding the appropriate settings for copying tables within databases

I have a table in a database that has 104456 records. I would like to copy the data to another table within that database. When I execute the command “insert into ChangeInsuranceTxnHistory select * from ChangeInsuranceTxn”, the following error occurs: "Could not allocate space for object...

Logical file

I created a logical file that used a select and values criteria. The file had duplicate records. When I created the same file with a higher security level, the file created without the duplicates. Does anyone know why I would have the duplicate records? The file was deleted ok so it didn't just...

Auto-Reply Message for mailbox

Good Morning Exchange God!, Is there a way to have an instant reply message that reads:" Verbiage" When someone sends an email to the mailbox whaterver@something.com, I know we can set it up with the out of the office assistant, but the subject line is appended with Out Of office message. Thanks...

Exchange2000 IM Problem

We have been running Exchange2000 IM for the past few months and it has been working as well as expected with any problems. then all of sudden we started gettting login errors: Exchange Instant Messaging Sign-In Faliure The email address does not match the username and password of the person...

Losing the GUI for Outlook Web Access after login

I am having an issue on Exchange Server 2003. When a user logs on to Outlook Web Access via our secure site, there is no GUI interface. It turns into what looks like a "directory" structure that is completely unuseable. We also host our website on this server, and when we first put the site up, we...

Exchange 2003 STD database keeps filling up

Our Exchange database keeps filling up and shutting us down. We have 2003 Std so I know the limit is 16GB. When we view the mailboxes in the management concole nobody exceeds 50MB, we have 150 users, which should total no more than 7.5GB. > Where is the other space being taken up? > Is the...

Exchange 2K IM Server Question

I have setup a test lab for E2K IM. I installed a separate Win2K server in the test AD Domain; all the latest updates etc. Installed the IM portion of the installation. I ran SP3 on the new server and and reapplied SP3 on the current E2K server that hosts email only. In SM i setup the new virtual...

Oracle 9i Query Time

What would be an expected time to run a query that will extract 1.4 million records? There are two tables involved. Customer and Address. And No Condition.

Exchange 2000 issues

I seem to have 2 issues. Both are on the same setup. Windows 2000 Server running Exchange 2000. Both have all the latest patches and SP's. 1) Mail will flow inbound just fine. Some mail will flow outbound just fine. Certian addy's just have in the SMTP queue ( AOL,Yahoo, Bellsouth ). Other mail...

Need an Exchange migration guru

Hello, ITKE techies. My name is Christine Polewarczyk. I am the editor for SearchExchange.com, which is part of the Windows Family of TechTarget sites. Thank you so much for being a participant in ITKE beta. ITKnowledgeExchange is blossoming into a great hub for peer information exchange. I have...

Oracle DataBase Connectivity

Hi, Gurus, I am a Oracle Db Administrator managing about 5 Gb DB on windows NT. There are approx 100 user connecting concurently from clients on Win 9x,XP And Win NT Ws. Last Day What happened one Xp Client Hung causing all to hung. The client machine was hard booted. After that any one trying to...

Exchange 2000 server: 1-2 clients receiving Outlook error "0x800CCC0F"

1-2 people at my company are receiving the error "0x800CCC0F" when attempting to send/receive in Outlook 2003. This has been happening approximately once a month for the past four months. I have been deleting their mailboxes and re-adding them and this always solves the problem until the next month...

Microsoft: Active Directory Migration Tool (ADMT)

Hi, I want to migrate a couple of users, computers and groups from an Windows NT 4.0 Domain to Active Directory (Windows 2003 NATIVE MODE Domain). The migration is not for the entire NT Domain, is only a group of users and computers from this one. I had used ADMT on a single forest to reorganize...

Starting isql*plus

Hi every one! I know that to start isql*plus in a browser, you are supposed to type something like: http://localhost:<port_number>/isqlplus Problem is, how do you determine the localhost and port number? Second, how can i use Enterprise manager to create reports about my tables in the Oracle...