Search Result

Sir,

I have a text file that contain some fields,the fields are given below:-
"","7041","8320 ","hunt_incomin g","7041","S IP/ccm102-00000001","","R ead","REPFLOW,/usr/WINAST/PRAMERICA/ENGLISH/PREVIOUSMENU,1, ,1,5","2011-05-03 03:21:57","2011-05-03 03:21:59","2011-05-03 03:22:36",39,37 ,"ANSWERED","DO CUMENTATION","1 304392917.1",""...

I'm not able to insert the value into a SQL Server database from a Perl script in Linux
code is given below:

#!/usr/bin/perl

use strict;
use DBI;
use Data::Dumper;
use Asterisk::AGI;

my $agi = new Asterisk::AGI;

my $fifth_param = "22";
my $first_param = "04-09-2012";
my $second_param = "04-09-2012";
my $third_param...

OnError,__SEQ Insert ETL Logic Here,{795D68BF-C348-4D7E-87BC-756EC7552FBB},{ D3AF4786-E01E-43CC-B57D-BD3D05491B5D},1 5/05/2012 13:25:13,15/05/2012 13:25:13,-1073450952,0x,S SIS Error Code DTS_E_PRIMEOUTP UTFAILED. The PrimeOutput method on component "SCR_SRC Get Equipment" (1) returned error code 0x80004003. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the...

Please help me how can i play a music file which is stored in sql server...

yahoo player code is as follows :

div :

...

I have a stored procedure running in SQL Server 2000 which returns a value
when I run it in SQL Server Management Studio 2008 (SMS). I have also tested
it in SQL Server 2000 Query Analyzer with the same result. However, when I
run it with VB.Net 2010 I get "nothing" as the value of the return parameter:
cmd.Parameters( "@ReturnCount") .Value.
How do I get a value back? The parameter I am testing...

I am just starting to work with a connection between SQL Servers and Access using vba. I was wondering if anyone knows of some good sites that show the basic functionality as well as how to connect and set up recordsets from the SQL server.

Thanks for the help.

Hi guys,

I am working on a project that simulates an online shares and securities trading environment. Participants can place buy/sell orders and cancel them. If an order is placed before the market closes at 1700, it should only be cancelled before 1700. It however seems that there is a loophole and participants are cancelling orders that would have already been processed.I have attached a copy of the stored procedure that I had tried...

I am working on MS ACCESS 2007.The application I am working on has a dropdown box on one of its pages.The number of values in the dropdown box is so high that it goes beyond the screen size and it becomes difficult to see some values.This dropdown is to be converted into a grid now and the values should be made selectable.
Can anyone guide me how can I go about this?It's a complete new application to me.The data source is sql server 2005.

I need to find a tool that help me to optimize sql server,speed up queries,improve the performance and solve any bottlenecks.

can you tell me their experience or has other tools to advise me?

http://www.sqlserverli festyle.com
http://www.red-gate.com/products/dba/sql-monitor/
http://www.idera.com/Free-Tools/SQL-check/

thanks

A database I am working on is reaching its limitations by using access.

I am considering upgrading to SQL server or mySQL.

The intent of the project is to start off by using access as the front end and the other as the back end. This is just for the introductory phase.

The plan is to eliminate the use of access all together. However I will be learning one of these systems from scratch. I understand most of the...

Hello freinds !

I am developing web application using C#.net. If I run my site on my local server,it runs normally but when I uploaded it on web-server it shows me an error "500 - Internal server error. There is a problem with the resource you are looking for, and it cannot be displayed.".

I am getting problem in fixing this error.My web application also contains Default.aspx...

I have retrieved a date from a form and the
Request.form("D OB") gives me the format of: 12/04/1976.

When I try to use SQL to add the record to the database, I get the error below.

Microsoft OLE DB Provider for SQL Server error '80004005'

Arithmetic overflow error converting expression to data type datetime.

The code generating the error is below:
oRs.Open "MailList",...

Hi, I'm trying to write a Group By query.
I have a table that looks like this:

I want to GROUP BY label using a MAX aggregate function...

Total newbie here, many apologies if I have failed to find an extant answer to this question.
Using:
SQL Server 2000

I need to restore several hundred databases from an external drive to local drive.
Would like to batch, eg, call on a text file listing old and new db names/paths and loop through to end of text doc.

Currently have non-batching script:

...

Hi,

I have stored PDF files into database. Now i wanna to show that pdf file in aspx page. I dont want open,save dialog window. When i click an link in aspx page the PDF should show in PopUp window.

Thanks,
umchi