|
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
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
All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)
|
|
|
|
|
Hey and thank you guys!
I just re-installed Oracle and it's working now!
ps. Thanks Mustafa 
All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)
|
|
|
|
|
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
|
|
|
|
|
if your application is windows base client need MSDE(Microsoft sqlserver database engeen) to connect to server.if no nothing is needed.
sepel
|
|
|
|
|
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 )
|
|
|
|
|
sorry i don't work by it.
sepel
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
"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
|
|
|
|
|
"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
|
|
|
|
|
hey, Really thanx for proper guidence..
really 
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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...
|
|
|
|
|
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
|
|
|
|
|
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
Try ROT13, gonna fool them all, and very easy to implement.
Kjetil
|
|
|
|
|
Friendz,
1)How to write SQL connectionString on web.config file using c#?
1)And how i call that connectionString to my webApplication?
CheeN
|
|
|
|
|
Please don't cross post. It is considered impolite on this site.
Another CP member has replied to you in the other forum
"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
|
|
|
|
|
Thanks....
My question is I need to make a stored procedure for testing use. The pseudo-code is:
BEGIN
Open input file for reading
Create new output file REJECTE.txt in the delete folder
While not EOF in input file {
For every line of the input file {
Run update dbo.ITEMS table set
ITEMS_SLS_FLG = B where ITEM_ID = A (A & B are from input file)
IF update fails because ITEM_ID is not found on dbo.ITEMS table
Write to output file "ITEM ID ITEM_ID is not found in the table"
Else IF any other error return failure
Close input file
Close output file
}
}
Close input file
Close output file
Return success
END
My question is how to open, read and write to a txt file in a SQL stored procedure? The input file has the below format:
A B
125345 1
235649 1
765430 0
...... .
if you have the experience or knowledge handling this kind of problem, please do me a favor, many thanks....
|
|
|
|
|
Hi,
Don't recall any direct file operation procedures, but could you use another approach:
- write informatical messages to a table using normal SQL
- create a stored procedure which writes to a file yourself using managed code (C#) and install that procedure to SQL Server
- use trace (not actually designed for this but...). For more info see sp_trace_create
Hope this helps you,
Mika
|
|
|
|
|
Look into SSIS packages. It might look hard to do at first, but making a package is not that hard.
|
|
|
|
|
Below is a snipet of code that I'm using to develop some XML processing.
SET @XMLSTRING = '<DATAMATRIX> <FSDATAMATRIX> <DM_OBJECT_TYPE>ITEM0</DM_OBJECT_TYPE> <FIELD1>UNITED STATES</FIELD1><FIELD2>BEVERAGES, ALCOHOLIC</FIELD2><FIELD3>123</FIELD3><FIELD4>FEMA</FIELD4><FIELD5>NO</FIELD5></FSDATAMATRIX></DATAMATRIX>'
PRINT @XMLSTRING
EXEC sp_xml_preparedocument @idoc OUTPUT, @XMLSTRING
SELECT *
FROM OPENXML (@idoc, '/DATAMATRIX/FSDATAMATRIX',1)
EXEC sp_xml_removedocument @idoc
The problem I'm having is that I can't seem to get the values of FIELD1, FIELD2, FIELD3 by using the OPENXML procedure.
Can someone shed some light on this ? Thanks.
|
|
|
|
|
Hi,
couldn't quite reproduce the problem.
SELECT * FROM OPENXML (@idoc, '/DATAMATRIX/FSDATAMATRIX/FIELD1',1)
id parentid nodetype localname prefix namespaceuri datatype prev text
4 2 1 FIELD1 NULL NULL NULL 3 NULL
9 4 3 #text NULL NULL NULL NULL UNITED STATES
Since text is independent node inside Field1 this doesn't return a single value but two rows, one for node and one for content
Mika
|
|
|
|
|
Oops. I should have stated that my code does work, but not the manner I was hoping. Yes, I got the same results you are seeing but I wanted to be able to see 1 row returned. In an ideal world, it would have showed me "FIELD1" and the value of "UNITED STATES". I'm a novice at XML processing, so please bear with me.
Is what I'm asking for possible ? If not I will have to work around it by using some logic that will link the two records together by the node type and parent id. Thanks again for the quick response.
|
|
|
|
|
No problem
One way is to use SQL to manipulate results. For example:
SELECT set1.localname, set2.text
FROM OPENXML (@idoc, '/DATAMATRIX/FSDATAMATRIX',1) set1
INNER JOIN
OPENXML (@idoc, '/DATAMATRIX/FSDATAMATRIX',1) set2
ON set1.id = set2.parentid
WHERE set1.LocalName = 'FIELD1'
Remember that you can define the columns you need from the xml by using WITH clause.
Of course if you can modify the XML, you could set the texts as attributes instead of elements, which could simplify your code.
Hope this helps,
Mika
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
