Oracle NLS problem - Database Discussion Boards

First Prev Next

Re: Monitor connection pool - ODP.Net 10g

Wendelius28-Jul-08 11:49

Wendelius

28-Jul-08 11:49

You're welcome Smile | :)

Mika

question on size of relational DB

Mohammad Daba'an28-Jul-08 9:02

Mohammad Daba'an

28-Jul-08 9:02

hi all, I want just to know some thing about the size of DB, if we have DB with 2 tables with no relations between both of them (no PK and FK) so does its size is less than the same one which we make a relation between both of its tables. I want to know even there is a small increment on the size of DB where there is a relation between its tables instead of the one where there is no relation between their table.

thanks for the help from all Laugh | :laugh:

Thanks alot
Hamody

Re: question on size of relational DB

Wendelius28-Jul-08 10:40

Wendelius

28-Jul-08 10:40

Hi,

When you add relation between tables (foreign key) only a small amount of data is added to system tables. The foreign key is enforced without any additional space requirements on your tables (however the system tables where the foreign key is defined are stored in the same database so they use a small amount of space, as data always does).

When defining primary key, the information is also added to system tables, but in this case an index is typically also built to quarantee performance of the primary key. The size of the index can vary a lot so there's no way of saying how much space it will consume without the knowledge of the primary key definition along with table definition.

Hope this helps,

Mika

ExecuteSql note responding

krishnan.s28-Jul-08 2:59

krishnan.s

28-Jul-08 2:59

Hi ,
Iam using PostGre8.1 , while executing query using ExceuteSQL command in VC++ if the DBServer is Switched off, the ExecuteSQL command is not responding due to which my application gets hanged.
Is there any way to avoid this case?

Thanks

Re: ExecuteSql note responding

Wendelius28-Jul-08 8:45

Wendelius

28-Jul-08 8:45

I'm not very familiar with PostGre, but I would imagine that this happens because the server side does not inform the client about shutdown. This leaves the client in a state where it thinks that the operation is still running.

You should try to find info about following things:
- is there a way to configure a heart-beat checking in PostGre. This means that the existence of the server is checked once in a while
- are there server side configuration possibilities that would allow the server to inform the clients that the server is shutting down before the connection is broken
- can you define a maximum amount of time in connection string that a single operation can last.

Hope this helps,

Mika

update,delete,insert operations on the database table using ado.net in c#

swapnamoturu28-Jul-08 2:02

swapnamoturu

28-Jul-08 2:02

well can u help me in implementing a code for update,insert,delete operations on the database table using ado.net in c# and bind it to datagrid view.

Re: update,delete,insert operations on the database table using ado.net in c#

Vimalsoft(Pty) Ltd28-Jul-08 6:25

Vimalsoft(Pty) Ltd

28-Jul-08 6:25

see this
http://www.codeproject.com/script/Articles/MemberArticles.aspx?amid=3942021[^]

And forget to vote Smile | :)

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

Oracle NLS problem

Muammar©27-Jul-08 23:35

Muammar©

27-Jul-08 23:35

Hi everyone,
I have Oracle 10g Standard Edition installed in my laptop, I changed the following registry keys..

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
"NLS_LANG"="ARABIC_YEMEN.AR8MSWIN1256"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES\ID0]
"NLS_LANG"="ARABIC_YEMEN.AR8MSWIN1256"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0]
"NLS_LANG"="ARABIC_YEMEN.AR8MSWIN1256"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1]
"NLS_LANG"="AMERICAN_AMERICA.WE8MSWIN1252"

Everything is working fine, the data can be saved and viewed in Arabic in SqlPlus but not on my .Net app.

Please help

ps.

I also tried changing the current NLS parameters using the following but it didnt work either Frown | :(

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE AL16UTF16;
SHUTDOWN IMMEDIATE;

Please help me out guys Frown | :(

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Re: Oracle NLS problem (Solved!)

Muammar©28-Jul-08 1:38

Muammar©

28-Jul-08 1:38

Hey and thank you guys!
I just re-installed Oracle and it's working now!

ps. Thanks Mustafa Blush | :O

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Deployment Related Issue

sunil goyalG27-Jul-08 22:50

sunil goyalG

27-Jul-08 22:50

hi all,
i want to Install the application on My client machines . My application is based on Server-client.So i think that i install Sql server on Server-side Machine and Application on Client -side Machine. I want to ask whether above assumption is right or not ?
If right ,then whether there are any requirement of run-time environment on client Machine so it can connect to Sql Server database which reside on server
and if i wrong, then please suggest the steps

Re: Deployment Related Issue

sepel28-Jul-08 0:12

sepel

28-Jul-08 0:12

if your application is windows base client need MSDE(Microsoft sqlserver database engeen) to connect to server.if no nothing is needed.

sepel

Re: Deployment Related Issue

sunil goyalG28-Jul-08 1:36

sunil goyalG

28-Jul-08 1:36

I already Use SQL Express 2005 . So can you provide the info according to this Configuration.
I am New Bie(with respect to MSSQL Server )

Re: Deployment Related Issue

sepel28-Jul-08 19:27

sepel

28-Jul-08 19:27

sorry i don't work by it.

sepel

how to store Hindi [Non English] data in postgreSQL

priyankaaJ27-Jul-08 22:21

priyankaaJ

27-Jul-08 22:21

I want to store the Hindi language (Indian Reginal language)
what kind of changes I have to make in postgreSQL.
plz help...

modified on Monday, July 28, 2008 4:32 AM

Re: how to store Hindi [Non English] data in postgreSQL

Rupesh Kumar Swami27-Jul-08 23:33

Rupesh Kumar Swami

27-Jul-08 23:33

I think there are no special requirement at back end side .But require changes at front end side . Like the font of the control which contains Hindi character. Use "Krunti Dev 010" like font. Also you can Use System.Text.encoding
Hope this helps

Rupesh Kumar Swami
Software Developer,
Integrated Solution,
Bikaner (India)

My Company
My Article

Re: how to store Hindi [Non English] data in postgreSQL [modified]

priyankaaJ27-Jul-08 23:43

priyankaaJ

27-Jul-08 23:43

"krunti Dev 010" is not available .
please give me another solution if any???

and how to use "System.Text.encoding" ??

modified on Monday, July 28, 2008 6:52 AM

Re: how to store Hindi [Non English] data in postgreSQL

sunil goyalG28-Jul-08 1:25

sunil goyalG

28-Jul-08 1:25

"krunti Dev 010" is not available .

where you look for this font. In databse ?. At front-End side ,set the font of controls like textbox to Hindi Font. "Krunti Dev 010" is just as example.

and how to use "System.Text.encoding" ??

Use Imports System.Text namespace and find Encoding Examples on Google[^]

Hope this helps

Re: how to store Hindi [Non English] data in postgreSQL

priyankaaJ28-Jul-08 1:36

priyankaaJ

28-Jul-08 1:36

hey, Really thanx for proper guidence..
really Smile | :)

Sqloledb.dll error

giri_jazz27-Jul-08 21:06

giri_jazz

27-Jul-08 21:06

Dear All,

Webpage is unable to retrive the data from SQL Server database. I am getting the below error;

Error Type:
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.

I have already tried the following suggestions available in net

1. installing MDAC
2. installing MDAC sp1
3. regsvr32 Sqloledb.dll
4. windows registry repair
5. repair windows os

Everything is fine except regsvr32 SQLOLEDB.dll is showing the error.
DLLRegisterServer failed. Return code was:0x80004005

Pls suggest...

- Savee

Re: Sqloledb.dll error

Bassam Saoud28-Jul-08 11:31

Bassam Saoud

28-Jul-08 11:31

If I get this error, the first thing I do is make sure that my connection string is correct. I will not assume that something is wrong with MDAC installation.

Re: Sqloledb.dll error

giri_jazz28-Jul-08 18:48

giri_jazz

28-Jul-08 18:48

The connection string is perfect. It is working fine in other systems. The sqloledb.dll is corrupted in my system and not able replace it b'coz dllregistryserver is failing...

how avoid user to expnd my database on client pc [modified]

sepel27-Jul-08 20:29

sepel

27-Jul-08 20:29

hi all.
i deploy my application and sql database on user pc.
some user have installed enterprise manager on their system. so they easily see my database and can modify it.
i want to configure my sql database to avoid them to expand my database in enterprise manager.
how i can it?

sepel

modified on Monday, July 28, 2008 6:04 AM

Re: how avoid user to expnd my database on client pc

Kjetil Svendsen28-Jul-08 5:48

Kjetil Svendsen

28-Jul-08 5:48

Hi.

As long as the application users have their own login on the DB server, the only thing you can do is trusting then, which seems like a terrible bad idea.

A quick, dirty and somewhat funny solution is password encryption: What they type is not what they use Smile | :)

Try ROT13, gonna fool them all, and very easy to implement.

Kjetil

How to write SQL connectionString on web.config file using c#?

sacr8327-Jul-08 18:03

sacr83

27-Jul-08 18:03

Friendz,

1)How to write SQL connectionString on web.config file using c#?
1)And how i call that connectionString to my webApplication?

CheeN

Re: How to write SQL connectionString on web.config file using c#?

Paul Conrad27-Jul-08 19:49

Paul Conrad

27-Jul-08 19:49

Please don't cross post. It is considered impolite on this site.

Another CP member has replied to you in the other forum Smile | :)

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Last Visit: 31-Dec-99 18:00 Last Update: 28-Apr-24 5:48

Refresh

ᐊ Prev 1...1106 1107 1108 110911101111 1112 1113 1114 1115 Next ᐅ

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