Search results for query: *

Hi, I just connect a unix server in my Lan. I already configure the Ip address correctly. But went I try to login into system remotely trought a telnet connection (using a PC or another unix server), the unix server return an error "Not on system console", and logout inmediately...

Hi, i need to send a group of invoices as html-type attachment to a specific email address in a batch proccess through a cfm page. the invoice index table looks like this : Invoice No Email 10000000 hgdsh@mailserver.com 10000001 asdff@mailserver.com 10000002...

I want to generate a bootable diskette with a DOS NTFS DRIVER in MS NT 4.0. I'am having trouble with a virus, I can clean it only in a DOS enviroment, but the PC have a NTFS partition, when a boot from an ordinary diskette with FAT, It can not recognize the drive C (ntfs).

I need to know if is possible execute a Stored procedure from a Oracle Database 8.0.5, in ColdFusion 5 professional. I try with ODBC driver from Microsoft & Oracle, but dreamwaver told me [b]"Error calling GetProcedures, Stored Procedures for Oracle are not supported"[b] Any kind of...

I need to know if is possible execute a Stored procedure from a Oracle Database 8.0.5, in ColdFusion 5 professional. I try with ODBC driver from Microsoft & Oracle, but dreamwaver told me "Error calling GetProcedures, Stored Procedures for Oracle are not supported" Any kind of help...

I have a W2k server with Coldfusion 5 pro, and i notice that in the administrator not appear Oracle OLEDB driver. What can i do?. I try installing Oracle OLEDB Driver, but the database is in 8.0.5 and the driver is for 8.0.7, and i don't know how to make work it.

Hi, i need a list of the all Stored Procedures (and parameters) in the database. The database is in 8.0.5 and access only through SQL Plus.

Hi, i have a server containing a database for each month of the year, each db have 5 tables and a 10 stored procedures. All tables and all sp have the same name in every database. eg. ---TABLES--- Jan01.dbo.RevenueDetail_tb Feb01.dbo.RevenueDetail_tb Mar01.dbo.RevenueDetail_tb ---STORED...

Hi everyone i need a help from you. I am trying to search the next register after the last one, because i need to show it automatically in a input text created by html, before the user create a new count. The code make me an error The lines below describe the search: declare @letracuenta...

HI EVERYONE! I GOT A PROBLEM GETTING AN IDENTITY FROM A TABLE. I AM AMKING A STORE PROCEDURE THAT INSERT A NEW COUNT INTO A COUNT TABLE BUT I NEED TO GET THE PRIMARY KEY (ID) TO EXECUTE THE OTHER PROCEDURE THAT DEPEND ON THE PRIMARY KEY INSERTED BUT IT DOES NOT WORK. I WOULD REALLY APPRECITE...

I need update a column in a table with the sum of all previous rows for each row. for example: Day | Amount | SubTotal 1 | 1200 | 1200 2 | 300 | 1500 3 | 2100 | 3600 I search here and look in BOL, and i can't find any syntax or...

Hi!!!!, I have a coldfusion server conected to a SQLServer and I need to perform a few sql statements before each update in any table. For example, I wish to save a)the user that perform the update b)the older value and the new value for each field changed c)every field changed. I create a...

I have a varchar column with data like '20020304113200' with the format YYYYmmDDhhMMss in 24(h), and i need convert this data to datetime value. I really appreciate any kind of help. Sorry about my bad english, my natural language is spanish.

Hi, i need convert a stored procedure into a online function. My tables are DAY01, DAY02 ... DAY31, and y need to put the SP in a select query. the sp is: ALTER PROCEDURE dbo.sp_get_calls @day varchar(15) AS begin declare @sql varchar(400) set @sql = 'SELECT * FROM DAY' + @table +...

I have problems transfering text files from a win client to a Sco Unix server using ftp via tcp/ip. I have no message response from the ftp command. When I tried to transfer small files, no bigger than 13k, the ftp ran sucessfully. But when the files exceed this size the ftp give no response...

Hi, i run a schedulled task everyday at 3:00am, and one or twice on a week, the importing process fails and return the ORA-01013 - Cancel Request by User. This happend without any user request cancel the process. I think this error is a ODBC problem, but i need a workaround for this issue. I'm...

I have a fact table with items solds and i need identify the serial number of the first item buyed by a customer. Sales: ----------------------------------- CustomerID, SerialNumber, SaleDate ----------------------------------- 000000001 1234567890 10/02/2001 000000001 2314321432...

I have a UNIX server on my intranet and a MS Proxy server 2.0 with a leased line. I need to internet users can connect to Unix server in a especific ports (9000 & 5016). Do i need a Proxy client for Unix and its exists? I really appreeciate any kind of help or ideas.

Hi, i have a table on the SQL server that i create with the next sentence: CREATE TABLE [dbo].[INFOCARD Usadas] ( [ID] [numeric](18, 0) IDENTITY (1, 1) NOT NULL , [PLANID] [numeric](10, 0) NULL , [FECHA USO] [datetime] NULL , [SERIAL] [char] (15) COLLATE Traditional_Spanish_CI_AS NULL ...

Hi, i'm looking for a start point for the Datawarehousing world. I´m a db developer and understand some terms, but i am very, very frustate because don´t find info for beginers. I really apreciatte any kind of help. Thanks