Re: oracle with c# - C# Discussion Boards

Re: oracle with c#

V.22-Jul-05 4:02

22-Jul-05 4:02

copy paste the error please.

No hurries, no worries.

Re: oracle with c#

seyakuza23-Jul-05 10:52

seyakuza

23-Jul-05 10:52

i'm in my conpany,my app works on my computer because i have oracle 8 but the computer that is not mime has oracle 9 so it isn't workin there but i'll write when i sit the comp that have problem....

Re: oracle with c#

seyakuza22-Jul-05 2:11

seyakuza

22-Jul-05 2:11

i wrote codes with using visual studio 2003 can this be problem..?

bigalı

Re: oracle with c#

Michael P Butler22-Jul-05 3:00

Michael P Butler

22-Jul-05 3:00

How are you connecting to the Oracle Database? ODBC? Microsoft Oracle Data Provider? Oracle's Data Provider?

What version of Oracle client is installed on the machine?

Michael

CP Blog [^] Development Blog [^]

Re: oracle with c#

seyakuza22-Jul-05 3:30

seyakuza

22-Jul-05 3:30

with System.Data.oracleClient

exeption says this provides oracle 8.'something' or lower

my problem is

Connecting to Oracle 9 using the Microsoft .NET Framework

help please

tnx

Re: oracle with c#

Michael P Butler22-Jul-05 3:43

Michael P Butler

22-Jul-05 3:43

This article[^] has example code for connecting to Oracle 9.

I've only ever had problems in the past when the Oracle 9 client wasn't correctly installed on the machine or the TNS names had got screwed up.

Michael

CP Blog [^] Development Blog [^]

Re: oracle with c#

seyakuza22-Jul-05 3:50

seyakuza

22-Jul-05 3:50

Oracle 8i Release 3 (8.1.7) Client or later must be installed for this provider to function.

i need to connect 9i

how cAN İ DO THİS WİTH VSTUDİO 2003

Re: oracle with c#

Dave Kreskowiak22-Jul-05 4:50

Dave Kreskowiak

22-Jul-05 4:50

You seem to be missing the point. What version of the Oracle CLIENT is installed on your machine? It would appear that you don't have the proper Oracle Client installed on the machine to connect to the server.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: oracle with c#

Michael P Butler22-Jul-05 5:17

Michael P Butler

22-Jul-05 5:17

Unless you have the Oracle 9i client software installed, then you probably can't.

Michael

CP Blog [^] Development Blog [^]

Re: oracle with c#

Anonymous22-Jul-05 7:44

Anonymous

22-Jul-05 7:44

i think i had the same problem a time ago
you need to install Oracle Data Provider ( i think you can download 4 free)
and use the objects in the Oracle.DataAccess namespace ( firs add the dll to the project )

Re: oracle with c#

seyakuza24-Jul-05 4:32

seyakuza

24-Jul-05 4:32

how can i find it..?

also i found something in the oracle's web...
it s writing thet 'you can connect to 9i with this for .NET ftamework' i try but i couldn t do...

aqny other ideas..?

tnx

Rational Rose (not XDE) and C#

LiamD21-Jul-05 23:59

LiamD

21-Jul-05 23:59

I am wondering how people manage the transfer of design in Rational Rose to Visual Studio and C# (and vice versa). I know the Rational has XDE which allows round trip development - this is not an option for me. I am using Rose Pro ver 8.3.

I want to be able create code in VS using C# and take the class diagram over to Rose. And also create a model in Rose and transfer that to VS as easily as possible.

I could retype all the information between the two but this seems a long winded way of doing it. Does anyone have suggestions on how to achieve this with greater ease?

Thanks,
Liam

concatenate text into a .def file

Member 211897921-Jul-05 23:30

Member 2118979

21-Jul-05 23:30

Hi I want to update a .def file from different window forms .I want to concatenate some text in the .def file and dont want to lose already available text in the .def file. Is there a option to directly concatenate into a file or do I need to store all the information in a class and then write it.

Thanks and Regards
KR

Re: concatenate text into a .def file

Mike Dimmick22-Jul-05 0:02

Mike Dimmick

22-Jul-05 0:02

When creating your StreamWriter, use a constructor[^] which takes a boolean 'append' parameter. Specify 'true' for this parameter.

Stability. What an interesting concept. -- Chris Maunder

Re: concatenate text into a .def file

Dave Kreskowiak22-Jul-05 4:47

Dave Kreskowiak

22-Jul-05 4:47

If you want to append this text to the very end of the file, then follow what Mike said. Otherwise, you'll have to read the file in, write the beginning of the file back out until you reach the point where you want to append your text, append your text, then continue writing out the rest of the .def file.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Customize errors

lovelylooney21-Jul-05 23:23

lovelylooney

21-Jul-05 23:23

Hello All,

I want to customize error messages returned by exceptions. For example I want to customize the following error

"Error [42000] [Microsoft] [Odbc SQL Server Driver] [SQL Server] could not find stored procedure"

I know I can restrict exception.message and throw a customized error, but how I will know whether the error is because of this..or something else...

Could anyone please let me know how can I do that in C#...

Thanks

Looney

Re: Customize errors

MihirV22-Jul-05 0:19

MihirV

22-Jul-05 0:19

hi
you have to write two catch Block to handle ODBC and other type of exception..

try<br />
{<br />
//..Code that generate error<br />
}<br />
catch(OdbcException odbc_ex)<br />
{<br />
for (int i=0; i < myException.Errors.Count; i++)<br />
{<br />
if (odbc_ex.Errors[i].NativeError == 42000)<br />
Console.WriteLine("Procedure not found...");<br />
else<br />
Console.WriteLine(odbc_ex.Errors[i].Message);<br />
}<br />
}<br />
catch(Exception ex)<br />
{<br />
//..<br />
}

Mihir...

Re: Customize errors

lovelylooney23-Jul-05 20:09

lovelylooney

23-Jul-05 20:09

Thanks a lot. I will follow what you have said.

Export / Inport of data

nidhelp21-Jul-05 23:21

nidhelp

21-Jul-05 23:21

Hi,
how do i export and import data to a database, thumbdrive, zipdrive etc.. (but first i got to create a database and i dono how to do dat)..

Thz a lot!

passing and recieving specific index of array

iramg21-Jul-05 22:59

iramg

21-Jul-05 22:59

hello
plz tell me how to pass a specific index of the array to a function and how to recieve that what will be function call code and function declaration code.
like if i want to pass array [1] element. so wht will be the passing and receiving code.
thanks

Re: passing and recieving specific index of array

MihirV21-Jul-05 23:20

MihirV

21-Jul-05 23:20

void FunctionCaller()
{
string [] ArrStr = new string[]{"str1","str2","str3"};
int [] ArrInt = new int[]{1,2,3,4,5};
MyFunction(ArrStr[1]);
MyFunction(ArrInt[2]);
}

void MyFunction(object ArrElement)
{
Console.WriteLine(ArrElement);
}

may be helpful to you Smile | :)

Mihir...

Check if a string doesn't starts with a caracter

anderslundsgard21-Jul-05 22:18

anderslundsgard

21-Jul-05 22:18

Well, how would you: check if a string doesn't starts with a caracter.

I've gladly take tips on good string searching/manipulating classes. I'm wellknown of StringBuilder...

_____________________________

...and justice for all

APe

Re: Check if a string doesn't starts with a caracter

AmmuRaj21-Jul-05 22:43

AmmuRaj

21-Jul-05 22:43

U means "string doesn't starts with a character" ?

If so,
if(!strName.StartsWith(ch))

Ammu

Re: Check if a string doesn't starts with a caracter

anderslundsgard21-Jul-05 23:25

anderslundsgard

21-Jul-05 23:25

But I like to check if it starts with a or b or c or.....

Don't really like to do this:

if (str.StartsWith("a")...)....
if (str.StartsWith("b")...)....
if (str.StartsWith("c")...)....
if (str.StartsWith("d")...)....
if (str.StartsWith("e")...)....

_____________________________

...and justice for all

APe

Re: Check if a string doesn't starts with a caracter

lovelylooney21-Jul-05 23:42

lovelylooney

21-Jul-05 23:42

private void txtFirstName_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)

if(txtbox1.Text.Length == 0)
{
if (!Char.IsLetter(e.KeyChar))
e.Handled=true;
}
}

The above code in will check for each key press and will only allow characters...You can modify the code to ur advantage...

Looney

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.