|
Hi All,
I have a BCP utility runs by a job CTS in Windows schedular which copies data from
database1 to database2. When it is seleting data from database1 it will make a ".data"
and keeps data in to it.
Normally it is working fine, but the problem is when the ".data" files size is more
than the drive's free size, it is uanble to copy and we are not getting proper exception.
I want the message to be returned to CTS so that CTS can email to team members. Please give
me suggestions or links.
Can any body please help me in completing this task. I am writing some BCP code
sample below. Any kind of help can be very much thankfull.
Please let me know if you need any more information to help.
Thanks a Lot,
Aleem Mohammad
Thanks & Regards,
Md. Abdul Aleem
NIIT technologies
modified on Wednesday, January 21, 2009 2:24 AM
|
|
|
|
|
So what exception IS being thrown and what does the code look like that writes this file??
|
|
|
|
|
bcp returns 0 for errorlevel if the operation was succesfull and if it wasn't, errorlevel is not 0.
Beyond that the only way to get more info about the error is to examine the contents
of the error log file (specified by -e parameter)
|
|
|
|
|
How to implement code for html
|
|
|
|
|
First, use a better subject line. Second, read some documentation or books.
only two letters away from being an asset
|
|
|
|
|
...
"Well, we're getting "F"'d at work. WPF, WCF, and WWF... WTF?" --John Simmons
|
|
|
|
|
Smtnri wrote: How to implement code for html
You've got a couple of choices. The first choice would be to write some code like a real coder, but if I were you I'd go for the hardcore option and whack it out using ones and zeroes.
|
|
|
|
|
I'm so very sorry. Every computer has an IQ requirement of 42. You don't meet this requirement, so pack your computer away, and send it back, stating reason code I D Ten T
|
|
|
|
|
|
|
|
I want to pass string and convert to array in javascript.Somebody said that can use json to achieve it.Could you show me how to write code?
Best Regards.
|
|
|
|
|
You write the code one letter at a time, like this. You don't start writing the code until you understand what needs be written. Therefore, research should focus on JavaScript & JSON. There's a lot of information on Google out there on the JSON-format.
I are troll
|
|
|
|
|
I'm trying to piece together someone else's code. The code was looking for Oracle.DataAccess.DLL for Oracle 10. My GAC has version 9.2.0.700, so I downloaded the dll for version 10, copied it to the \bin\Debug directory and added a reference using the BROWSE tab. When I try to build, however, I get this:
D:\Projects\Gnf.Utils_Source\Gnf.Utils.Oracle\Database.cs(5,18): error CS0234: The type or namespace name 'DataAccess' does not exist in the namespace 'Gnf.Utils.Oracle' (are you missing an assembly reference?)
My output appears to say that my intended version was picked up:
Primary reference "Oracle.DataAccess, Version=10.1.0.400, Culture=neutral, PublicKeyToken=89b483f429c47342".
Resolved file path is "bin\Debug\Oracle.DataAccess.dll".
Reference found at search path location "bin\Debug\".
When I double click on the reference it shows the namespace as :
namespace Oracle.DataAccess.Client
Member of Oracle.DataAccess
In my code I have this
namespace Gnf.Utils.Oracle
{
using Oracle.DataAccess.Client;
It just doesn't seem that it's recognizing that reference. I've tried to use the version 9.2 from the GAC. I've tried creating a new project. I'm not sure what else to look at. I'm very confused.
|
|
|
|
|
What about this?
namespace Gnf.Utils.Oracle
{
using Oracle.DataAccess;
I are troll
|
|
|
|
|
Thanks for the suggestion, but it didn't work. In fact, the intellisense doesn't kick in at all when I type the "Oracle.".
|
|
|
|
|
You could check that the Specific Version property is not set to true for your reference. If it is, perhaps it could cause the problem.
|
|
|
|
|
I tried to build using your suggestion to set SPECIFIC VERSION to FALSE, but it still failed.
|
|
|
|
|
Wait a second... Are the lines in correct order? Shouldn't it be:
using Oracle.DataAccess.Client;
namespace Gnf.Utils.Oracle
{
...
|
|
|
|
|
Yes!!!! That worked! But I don't understand.
I didn't change that code at all, and I'm sure the previous developer built it successfully.
I don't understand why I have to declare this particular thing outside of the namespace, while the others can be defined inside.
using Oracle.DataAccess.Client;
namespace Gnf.Utils.Oracle
{
using Gnf.Utils.Data;
using System;
using System.Collections.Generic;
using System.Data;
using System.Runtime.InteropServices;
using System.Threading;
|
|
|
|
|
I'm not sure. Perhaps you have two namespaces in the file and if the the other one also wants to use classes from Oracle.DataAccess.Client, the using directive would be out of scope, just a guess since I actually never use using directive. I always like to add full namespace to a class definition.
|
|
|
|
|
Well, its a standard practice to use Using before declaring Namespace.
The compiler need to know what references to use (Using) before it can compile the namespace function map.
|
|
|
|
|
|
So I'm coding in .NET (C#), under Visual Studio, and getting some numbers in string format and converting them to double.Parse to doubles. However, it only works if the number strings first have the . replaced with a ,
How can I make the double.parse command give me decimals delimited with dots , not commas?
|
|
|
|
|
Have you checked setting for the local computer? In Vista the formatting is set in the Regional and Language options dialog from the control panel
only two letters away from being an asset
|
|
|
|