Search results for query: *

Hi, I'm struggling with dates in vb6. I'm trying to take todays date and output in the format 'ddmmyy'. I thought this would be relatively easy and currently have the code below. Dim today As Date today = Format(Date, "ddmmyy") MsgBox today The output is 04/07/2751, so obviously I'm missing...

Hi, I have an issue on a hp-ux 11 server. One of the IT staff changed the netconf file and on reboot the server is generating a "init command respawning to rapidly" statement and will not boot up. I have been trying to get the server to boot up into single user mode from the Web Console. After...

Hi, We recently lost power unexpectedly to our server. Now when we try and start it we receive the following. > SQL> startup > ORACLE instance started. > Total System Global Area 110033940 bytes > Fixed Size 76820 bytes > Variable Size 76230656 bytes > Database...

Hi, I'm planning a disk mirror strategy on HP-UX 11. Is it correct that you can only define one volume per physical disk using LVM? Thanks SOL I'm only guessing but my guess work generally works for me.

Hi, I have a live tablespace that once exported from the database and imported into a test database is about 50% larger than the original tablespace. Can anyone help me to understand what could be causing this phenomenon please? Regards SOL I'm only guessing but my guess work generally works...

Hi, I have an Oracle 8.1.7 instance on a HP-ux server. I have had to restore the entire instance to another server in order to recover a table. However I cannot get the instance to start up on the new server. I have managed to start the listener however when trying a "startup nomount" in svrmgrl...

Hi, I am running Oracle 8.1.7 over HP-UX 11.00. The database has just gone down with ORA-01115: IO error reading block from file 9 ( block # 299188 ) ORA-01110: data file 9: '/ord/data/datafile001.dbf' ORA-27072: skgfdisp: I/O error HP-UX Error: 5 : I/O Error Additional information: 299188...

Hi folks, Got a problem on my HP-UX 10 server. When a user connects via telnet it takes upward of 3-4 minutes for the login prompt to appear. This does not happen on the console however, and I'm told it doesn't happen on all terminals trying to connect either. After logging in performance is...

Hi, I had xp_cmdshell all nicely set up and executeable. The database was being run as th machines local admin account. I then needed to set up sql mail. So I set up my MAPI profile and changed sql server to run as the domain account that I had set up a mail account for. I've given the domain...

Hi, I have a series of sql statements some of them within nested ifs. Some of them return recordsets. However if that branch of the if statement doesn't get executed then my recordset doesn't get opened. At the bottom of my script I have a tidy up where I close all the recordsets. However if a...

Hi, Our IT manager has accidentally dropped a datafile. The schema that it relates to is inconsequential. Can I remove reference to this schema and restart the database?

Hi, We have an Oracle 8i database on a windows 2000 server. Over the weekend our IT department decided to move the server to another site and shut down the server without stopping the database and then relocated the server and gave it a new IP address. Now I cannot get the instance to start...

Hi, I'm trying to write a trigger that calls a VB6 program. I've got about this far create TRIGGER scheme.trigger ON owner.dbo.table before INSERT, DELETE AS begin declare @ni int, @nd int declare @cmd varchar (8000) select @ni = count(*) from Inserted select @nd = count(*) from Deleted --...

Hi, I have the following section of VB code which runs a query on an access database and displays the result in a dataview. It used to work fine on Access 97, now however the database has been upgraded to 2000 and when I try and run it, it seems to get stuck in the loop section. Any ideas what...

Hi, Can anyone tell me if it's possible to create compiled T-sql code on SQL server so that new other parties can steal your code? SOL I'm only guessing but my guess work generally works for me.

Hi, I'm looking to buy a new server to run HP-UX 11, running an Oracle 8i database ( 2Gb ) for about 25 users mainly transactional processing. What's the best ( and cheapest ! ) server I could get to do this? What spec should I be looking for. Any suggestions on previous experience, where to...

Hi, I have a recordset with about 15 columns, however I only want data from 3 of the columns. How can I easily create a new recordset with just the columns of data I need? i.e. can I drop unwanted columns from the recordset or create a subset of the recordset? Regards SOL SOL I'm only guessing...

I've written a procedure that drops all the tables in a tablespace and copies across tables from another tablespace into the cleared tablespace. Does anybody know of a neat way to copy across the indexes as well? SOL I'm only guessing but my guess work generally works for me.

Hi, I've managed to work out that there is a practical limit to the number of rows that can be loaded into a flexgrid. I'd like to try and write a routine so that as the user scrolls down the data grid new rows are added to the bottom of the dataset and removed from the top. What's the best way...

Hi, I've managed to work out that there is a practical limit to the number of rows that can be loaded into a flexgrid. I'd like to try and write a routine so that as the user scrolls down the data grid new rows are added to the bottom of the dataset and removed from the top. What's the best way...