|
Hi everybody
Actually i created a table in sql+, and inserting data using sql+ itself.But after i log out off the screen and log in again i see the data gone. How can i prevent the data from getting vanished without writing commit or set autocommit commands on everytime.
skd
|
|
|
|
|
During interactive usage with sqlplus, Oracle also supports an AUTOCOMMIT option. With this option set to ON each individual SQL statement is treated as a transaction an will be automatically commited right after it is executed. A user can change the AUTOCOMMIT option by typing
SET AUTOCOMMIT ON or
SET AUTOCOMMIT OFF
whereas by typing
SHOW ALL
a user can see the current setting for the option (including other ones).
This was taken from the website:
http://infolab.stanford.edu/~ullman/fcdb/oracle/or-nonstandard.html[^]
|
|
|
|
|
neoghy wrote: How can i prevent the data from getting vanished without writing commit or set autocommit commands on everytime.
This is like asking how I can eat my cake without opening my mouth.
Cheers,
Russ
|
|
|
|
|
Dear Friends,
Client database is in the form of "database.Dat" they don't which version they are using, i want to restore it i sqlserver 2000 with service pack 4
Following error occured
Error:3169 The backed up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database. Restore filelist is terminating abnormally.
Please give a solution
Thanks & Regards
JK
|
|
|
|
|
Hi JK,
It looks to me like you client is using SQL 2005, which isn't backwards compatible with SQL 2000.
Ryan
|
|
|
|
|
is it possible to convert sql 2005 database to sql 2000 sp4
|
|
|
|
|
Just using the file you have, not as far as I know. If you had access to the database, I'm told that you could export the data from SQL 2005 and then import it into SQL 2000, but I haven't done this before and so I can't really tell you exactly how to go about it.
|
|
|
|
|
For open database *.mdb I use ADO-construction
try
{
hr = m_pConnection->Open(_bstr_t(lpstrConnection), _bstr_t(lpstrUserID),
_bstr_t(lpstrPassword), NULL);
return hr == S_OK;
}
catch(_com_error &e)
{
}
When mdb-file has not attribute "ReadOnly", Open returns S_OK.
But when I set this attribute, exception is generated with
ErrorNumber = 0x80004005 and NativeError = 0xfffff88f ("Not a valid password").
I don't undenstand why. Pls., explain me this situation.
And other question: what are error codes concerned with error password (for ODBC and SQL-Server)? Or in other words: How may I detected that in connection string invalid password for opened database?
Thanks
|
|
|
|
|
Can someone answer why the following isnt returning anything?
string strGetPeriodeSQL = String.Format("SELECT * FROM {0} WHERE SDate BETWEEN {1} AND {2} ORDER BY SDate", strTableName, dtStart.ToShortDateString(), dtEnd.ToShortDateString());
I left out the rest of the funktion, just the SQL part is here.
Lars
Resistance is futile - Data (ST:First Contact)
|
|
|
|
|
Are you saying strGetPeriodeSQL does not get populated?
Does the SQL string not execute?
Is no data returned from SQL?
I suspect the latter so:
Take the content of strGetPeriodeSQL to Management Studio and see what the results are.
If you get results then there is a problem with your connection.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thanks for the answer. But I figured out what was wrong. Insted of converting to ShortDateString I needed to convert to ToOADate.
Sorry for the trouble.
Lars
Resistance is futile - Data (ST:First Contact)
|
|
|
|
|
or you can use this way:
<br />
string strGetPeriodeSQL = String.Format("SELECT * FROM {0} WHERE SDate BETWEEN {1} AND {2} ORDER BY SDate", strTableName, dtStart.ToString("yyyy.MM.dd"), dtEnd.ToString("yyyy.MM.dd"));
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
I want to store string character to be stored as password in Oracle table.
|
|
|
|
|
Sounds like you want to store the password similar to "***** " into Oracle?
I are troll
|
|
|
|
|
Yes the password needs to be stored "*****" or any other format in Oracle
|
|
|
|
|
Yes the password needs to be stored "*****" or any other format in Oracle
|
|
|
|
|
|
hi guys,
i am developing an application which uses access mdb files as database.
untill now i used a connection to the files,
using the following code:
Public Class DBconnector
Private _dbConnection As OleDbConnection
Private _dbCommand As OleDbCommand
Private _dbDataReader As OleDbDataReader
Private _dbDataAdapter As OleDbDataAdapter
Private _dbTransaction As OleDbTransaction
'Private _dbADODBConnection As ADODB.
Public Sub New(ByVal cs As String)
_dbConnection = New OleDbConnection(cs)
_dbCommand = _dbConnection.CreateCommand
End Sub
where the connection string is:
"Provider=Microsoft.Jet.OLEDB.4.0;"
& "Data Source=" & TextEditPath.Text
texteditpath is the file path and name.
recently i have encountered an error while trying to create a relationship using "ON DELETE CASCADE" in the constraint clause.
error mentioned theres a syntax error on the constraint clause and there was no real syntax error , after troling microsoft forums , they have told me i need to use ADO connection because this bug results cause of use in DAO ,
also i may add that when i execute the query in the imidiate debug widow of access 2007 it is executed with no errors , how ever when i execute it on the SQL design window of access 2007 i get the same error as i get in the .net frame work
my question is how do i establish an ADO connection to access MDB file
or how do i over come this bug ,
please help im stuck with this for a week now ,
thanks...
Net
modified on Tuesday, March 17, 2009 4:09 AM
|
|
|
|
|
Hi, I am using SQL in my project. I want to fetch only time alone. i know to fetch Date. How to fetch time? Can any one tell?
|
|
|
|
|
Something like this?
DECLARE @d1 DATETIME = '12/19/2007 13:43:23.45', @t1 TIME(2)
SELECT @t1 = @d1
SELECT TimeOnly = @t1
I are troll
|
|
|
|
|
Try this
select convert(varchar(8),getdate(),114)
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
SQL (except int 2008) stores the data as a datetime type, this includes both the data and the time components. It is up to you to FORMAT the data to meet your needs as Ashfield pointed out. You will still be dealing with a datetime type.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi there, I have created an insert statement to create a new record in a database. This is used from a task automation program and the client record is mapped using that so records ARE created on the correct client but i only want 1 record to be created, at the moment if a client has 10 quotes then it will insert 10 new quotes instead of just 1. My code is below:
CREATE PROCEDURE [dbo].[ietsp_CreateDODQuotes]
@ContactID AS INT,
@TaxYear AS INT
AS
SELECT
@TaxYear = TaxProYear
FROM
FlightDeckTest.dbo.iet_TaxYears ty
WHERE
IsCurrent = 'T'
/** Add PTM DOD Quote **/
BEGIN
INSERT INTO FlightDeckTest.dbo.Lead
(
ContactID,
Owner,
Status,
EntitySubType,
ietCreateDate,
ietMumbaiStatus,
ietTaxAdmin,
ietTaxYear,
ietQuoteIncl,
ietQuoteExcl,
ietVAT,
ietProdServID,
ietProdServDesc,
ietPayMethod,
ietCardType,
ietCardHolder,
ietCardNumber,
ietAcctNo,
ietSortCode,
ietIssueNumber,
ietSecurityCode,
ietInstallments,
ietMonthRepay,
ietFinalWithIns,
ietFinalInstallment,
ietAcctName,
ietBankName
)
SELECT
l.ContactID,
l.Owner,
'AWAUTH',
l.entitySubType,
GETDATE(),
0,
l.ietTaxAdmin,
@TaxYear,
l.ietQuoteIncl + CONVERT(DECIMAL(7,2),176.25),
l.ietQuoteExcl,
l.ietVAT,
l.ietProdServID,
'PTM DOD - ie taxguard',
'INVTP',
l.ietCardType,
l.ietCardHolder,
l.ietCardNumber,
l.ietAcctNo,
l.ietSortCode,
l.ietIssueNumber,
l.ietSecurityCode,
l.ietInstallments,
l.ietMonthRepay,
l.ietFinalWithIns,
l.ietFinalInstallment,
l.ietAcctName,
l.ietBankName
FROM
FlightdeckTest.dbo.Lead l
INNER JOIN
FlightDeckTest.dbo.Contact c ON
l.ContactID = c.ContactID
WHERE
((l.ietProdServDesc LIKE '%PTM%' OR l.ietProdServDesc LIKE '%Tax Return%')) AND
(l.Status = 'ACT') AND
(l.ietTaxYear IN (SELECT TaxProYear FROM iet_TaxYears WHERE IsCurrent = 'T'))
END
GO
Any help would be greatly appreciated.
|
|
|
|
|
your not summing anything to only make one record. It will insert all the records that match your where clause so if it matches more then one will insert more then one record.
and please put your code into a code block it makes it easier to read!
|
|
|
|
|
Hi All,
first I installed SQL SERVER 2005 dev edition in my machine and after that I have uninstall it. so I have installed sql server 2000 enterprice in my machine.
BUT when I am going to connect to sql server 2000 through my application, I have received following error message:-
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
This error message is belong to sql server 2005 and NOT FOR sql server 2000 !!!.
but there is no sql server 2005 in my machine at the moment.so how can i get sql server 2005 error message for sql server 2000 ?
please help .
Thanks in advance..
|
|
|
|
|