Difference Between Sql Server And Oracle
Sep 3, 2001someone tell me what is the difference between oracle and Sql Server.
looking forward for ur reply
Vivek S. Potdar
vivek_potdar2000@yahoo.com
vivek_potdar@bhojvirtualuniversity.com
ADVERTISEMENT
What Is Difference Between Odbc, Oledb, Sql And Oracle
Mar 6, 2006i notice that in toolbox panel, there are these kind of different dataadapter and dataset, what is difference between them, and under which situation we use which one?
View 2 Replies View RelatedSetting Up Oracle Linked Server : Need Help : Sql2005 Running On XP Linking In Oracle 10.2
Oct 26, 2006Is there any step by step help sites for setting up SQL 2005 linked (oracle 10) server?
I find MSDN articles but they referance winNT and 2000, I'm not getting very far and I'm not a DBA but need to get this working asap.
Data Access :: Accessing Oracle Tables From Server Via Oracle DBLINK?
May 8, 2015we recently got a scenario that we need to get the data from oracle tables which is installed on third party servers. we have sqlserver installed on ourservers. so they have created a DBLINK in oracle server to our sqlserver and published the DBLINK name.
what are the next steps that i need to follow on my sqlserver in order to access the oracle tables ?
Trouble With: Linked Server To Oracle Using OraOLEDB.ORacle Provider
Jan 11, 2007Hi--
I am running SQL Server 2005 on Win2k3:
Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft Analysis Services Client Tools 2005.090.2047.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML 2.6 3.0 4.0 6.0
Microsoft Internet Explorer 6.0.3790.1830
Microsoft .NET Framework 2.0.50727.42
Operating System 5.2.3790
I have the OraOLEDB.Oracle provider installed to the (C:oraclexe) directory.
I am having problems querying from linked oracle server. When i setup oracle as a linked server and purposely enter an incorrect password the query i run tells me i have an incorrect password. So it at least knows that. when i set the correct password and run a query I get this error:
(i replaced the real server name with "someServer".)
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "OraOLEDB.Oracle" for linked server "SomeServer" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "SomeServer".
This is how I set up my Linked server:
Provider: "Oracle Provider for OLE DB"
Product Name: SomeServer
Data Source: SomeServer
Provider String: "Provider=OraOLEDB.Oracle;Data Source=SomeServer;User Id=MyLogin;Password=MyPassword"
The query I run is:
Select * from [Someserver].[schema or database]..[tbl_name]
Any help??? What am i missing?
Can Anyone Give Me A Layman's Explanation Of The Difference Between CURRENT_TIMESTAMP And GETDATE() (if There Is A Difference)?
Oct 24, 2007Question is in the subject.
Thanks in advance
-Jamie
Difference Between SQL Server 2005 And SQL Server 2008 SSRS(Sql Server Report)
Apr 15, 2008Hi all,
Please tell me about difference between SQL Server 2005 and SQL Server 2008 SSRS(Sql Server report)
Why to upgrade for Sql Server 2008
Thanks,
Ashok
Difference Between 64-bit And 32-bit SQL Server??
Mar 12, 2008We are a medium sized Telecom Company.
I wish to know the performance benifits of using SQL Server 64 bit over 32-bit and under what conditions should one make a transition from 32 bit environment to 64 bit one.
Pls discuss in detail.
Thank you.
P.S: We are presently on Windows 64 bit.
What Are The Difference Between SQL Server 2000 And SQL Server 2005 Express Edition
Mar 3, 2006What are the difference between SQL Server 2000 and SQL Server 2005 Express Edition.?
Or where i can find the list of differences. ?
Can SQL Server 2000 and SQL Server 2005 Express Edition can be used interchangeably for basic database operations?
Hope to get some response soon.
Regards
Sanjeev
Difference Between MS Sql Server Management Studio And MS Sql Server 2005 Express?
May 30, 2008What is the difference between MS SQL Server Management Studio Express and MS SQL Server 2005 Express Edition? i download SQLEXPR.EXE, do i also need to download the other?
thank you.
Time Difference In Sql Server
May 21, 2007hi to all,
very urgent query
how to minus the two times(hh:mm:ss)in sql server
regards
ammu
Difference Between The MS SQL And The SQL Server? (was Newbie To MS SQL)
Nov 30, 2005Hi,
I am totally a newbie to MS SQL. I have a question regarding the MS SQL: What is the difference between the MS SQL and the SQL Server? Is it the same? and what should be install for MS SQL on the server and the client side???
Time Difference In SQL Server
Dec 6, 2007I am new to SQL Server and am trying to write a query that subtracts the time difference in the same column. I need to know the time difference between BatchSequence 2, LoadSequence 1 and BatchSequence 13, LoadSequence 3. Below is an example of the data. Thanks in advacne for the help!
BatchSequenceLoadSequenceScanLabelProcessDate
13 1Part Number11/1/2007 6:08:02 AM
13 2Scan Trace11/1/2007 6:08:03 AM
13 3Slot Position11/1/2007 6:08:04 AM
2 1Part Number11/1/2007 5:53:06 AM
2 2Scan Trace11/1/2007 5:53:07 AM
2 3Slot Position11/1/2007 5:53:08 AM
Difference Between Access And SQL Server
Jul 20, 2005I have the following query in Access:SELECT a.interest_parent_id, a.interest_element_id, b.alr_category_id ASinterest_category_id, a.allergy_parent_id, a.allergy_element_id,c.alr_category_id AS allergy_category_idFROM (AllergyDrugPermutation AS a INNER JOIN alr_category_drug_map AS b ONa.interest_element_id = b.drug_id) INNER JOIN alr_category_drug_map AS c ONa.allergy_element_id = c.drug_idand all is well!When I create the same query in SQL sever (using the desinger), I get:SELECT a.interest_parent_id, a.interest_element_id, b.alr_category_id ASinterest_category_id, a.allergy_parent_id, a.allergy_element_id,c.alr_category_id AS allergy_category_idFROM dbo.AllergyDrugPermutation a INNER JOINdbo.alr_category_drug_map b ON a.interest_element_id =b.drug_id INNER JOINdbo.alr_category_drug_map c ON a.allergy_element_id =c.drug_idThe only structural difference I see here is that SQL removed the ( and )from around the first join and created the double join.When I run this query I get stuck in a loop and eventually the sever willtime out. If I only have the first join there is no time out issues but ofcourse the result is not what I desire.Can someone help me out here and tell me what is wrong with the statementused in SQL?Thank you in advance,Eric
View 3 Replies View RelatedDifference Between The Versions Of SQL Server
Jun 22, 2006Do you find that there is a big difference between the different
versions of SQL server (6.5, 7, 2000, 2005) as is between Microsoft
programming languages (VB.4, VB5, VB6, .Net and now .Net 2)
Or is the difference in SQL server minimal and very small compared to the programming languages I mentioned.
Thanks a lot
MySQL Vs. MS SQL Server. What's The Difference?
Jul 19, 2007I'm a beginner programmer and databases are still a bit of a mystery to me. I have some basic questions that I can't find direct answers for anywhere but which I think should be fairly simple for someone acquainted with using databases in programming.
1. MySQL & MS SQL Server (or Express)...what's the difference? Are they mutually compatible? Are all SQL files written in the same file format?
2. If I write create a MySQL database on my website to store customer data, can my application which was written with VB 2005 Express (and which uses MS SQL Server Express) read those database files? Vice-versa?
3. If I create a MS SQL database in VB express for my application, is that database on some huge central server somewhere or is my computer used as the server, or what? (yeah, I know that's probably a really stupid question but I can find the answer in any of the three programming books I've bought in recent months or online either.)
4. I've read the MySQL is free unless I use the databases within an actual application from which I'm making money, in which case I need to buy a license. What about MS SQL Server or MS SQL Express? Microsoft can be so withholding about what costs money, what is free, and what is temporarily free.
That's all for now...I hope someone can answer my stupid questions.
Difference Between Running MS SQL Server 2000 On A Desktop PC And A Server
Jul 20, 2005Hi Everyone,Apparently, I was being asked on a question, "Why don't we procure adesktop PC to run MS SQL Server 2000 rather than a buying a server?".From a Management point-of-view, buying a desktop PC is much cheaperthan a server. However, I just wanted to understand that is it aviable solution given the database size is something around 200 GB?Equipping with more memory, more storage and a more powerful CPU on adesktop PC could really taking up the role to support the DBMS?Besides this "sensitive" costing concerns, what will be othersdifference in running the SQL Server 2000 on the two differenthardware architecture? For example, IO rate, reliability, RAID-1support, performance, … etc.(Note: The operating system is Microsoft Windows 2000 EnterpriseEdition)Regards,Ambrose
View 1 Replies View RelatedSQL Server Vs. Express Behaviour Difference...
Jun 4, 2008Hi all,
I want to share an experience I made in the last few days and like to hear your comments about it. I am developing an ASP.Net 2.0 Web Application using SQL Server 2005 on my local system. After implementation was done, I had to deploy the application to the production server. Because of license problems, on the server is the express edition of SQL Server installed. The system worked fine for about 2 month. But the last week we noticed, that there was deadlocks in the application. After searching a while I noticed, that there were a lot of open connections. When you open SQL Server Management Studio and look at Management > Activity Monitor, you can see all opened connections in the connection pool.
So the problem was, that with every request, a new connection was created, instead of using the existing ones, even if the state of the connections was sleeping. On SQL Express, if a specific limit of connections is reached, it'll wait for a connection to be released, but there is no release, so it threw a timeout error. But suprisingly, on SQL Server there also were a lot of connections created, but there were never a deadlock, which I can't explain. Also I can't explain, why it also worked for 2 months on SQL Express.
The architecture:
I have data classes, which are implementing IDisposable. In the dispose method, I call Dispose on the connection and set it to null. And in code I instanciate my data classes in using blocks. So on reaching the end of the using block the data class instance is disposed. In the dispose method the connection is disposed. So I thought, that everythink will work fine, but it doesn't.
The problem was solved by calling Close() on the connection in the Dispose method in my data class just before calling conn.Dispose().
So does this make sense to you? The fact, that it solved my problem lets me believe to that solution, but I can't really say why. So if you have any ideas or knowledge, I'd love to hear it.
Regards,
Koray
Any Difference Between MSDE And SQL Server 2000 :-?
Apr 19, 2005Hi,
I am developing an web-database application using ASP.net,c# and MSDE. and after the completion of the project i want to deploy the database over the server whichs got sql server professional edition.
Are there any changes to be made while deploying it over the server and also will the connection string for MSDE and SQL client the same ?
Please do clear me the confusions i have got ..
thanks inadvance
What's Difference Between Desktop And Server Version
Oct 19, 1999As we known, we can build up the data in not only in Server version but also in Sesktop version. So, what's the difference? Except the power that Server can provide compared to the desktop computer. Whatelse?
Thanks! Guru!
Linked Server Time Difference
May 31, 2006I am using SQL 2000 and/or SQL 2005 to link to an Oracle Db usingOPENQUERY.The SQL 2000 box is SP4 on Win2000.I can run a query thru Q.A. for SQL 2000 or I can run an Oracle querythru SQL-Plus to see the data. But, if I run a date-query using thelinked server then SQL Server returns a TIME that is off by 4 hours.SQL Query:SELECT * FROM OPENQUERY( ORASERVER, 'SELECT MYDATE FROM MYTABLE')Oracle Query:'SELECT MYDATE FROM MYTABLE'Oracle results:04/16/2006 01:07:00SQL 2000 result:04/16/2006 05:07:00Has anyone seen this before? Is there a fix?I have searched the newsgroups and MS Kb but can not find an answer.Thanks,Marty
View 1 Replies View RelatedDifference Between Sql Server 2005 And 2008
Feb 25, 2008
Hi,
do any body know the article that can give me berif idea about the difference between sql server 2005 and 2008, acutally i want to move over to 2008. but if the difference is not that much then i m might think about that.
Thanks and looking forward.
Difference Between MSDE And SQL Server 2000
Sep 10, 2007
Hello everyone,i want to know abt the "Difference between MSDE and SQL Server 2000". For example the features they support, capacity and requirements etc...
Reply me asap.
Thanx in Advance.
Difference Between 'Production Server' And 'Development Server'
Aug 22, 2000Hi everybody,
Can anyone explain to me, what is 'Test Server','Production Server' and 'Development Server'?.
tks in advance,
vasu.
Difference Between SQL Server 2005 And SQL Server 2008?
Mar 18, 2008Hi,
What is difference between SQL Server 2005 and SQL Server 2008?
If i want to migrate from 2005 to 2008 , what i need to do with my existing database. I mean to say how can i transfer my database from 2005 to 2008.
Thanks.
Regards
Kashif Chotu
Difference Between Remote Server And Linked Servers?
Oct 25, 2000Hi Everybody,
Can anyone tell me what is the difference between Remote Server and Linked Servers.
thks in advance,
Srinivasan.
What Is The Difference Between SQL Server 2005 Installed With .NET And A Standalone One
Aug 19, 2006Please could anyone tell me what are the real differences between SQL Server 2005 bundled along with Visual Studio.NET and a standalone one.
Thanks in advance.
Transact SQL :: Difference Between HOLDLOCK And UPDLOCK In Server
Jul 15, 2015just see same kind of two sql statement
BEGIN TRAN
SELECT *
FROM authors AU
WITH (HOLDLOCK, ROWLOCK)
WHERE AU.au_id = '274-80-9391'
COMMIT TRAN
BEGIN TRANSELECT *
FROM authors AU
WITH (UPDLOCK, ROWLOCK)
WHERE AU.au_id = '274-80-9391'COMMIT TRAN
i like to know what is the difference between HOLDLOCK and UPDLOCK in sql server. explain with example to better understand.
Difference Between Destination Adapter And Bcp In Sql Server 2005
Aug 24, 2007
Hi,
Will someone please tell me what is the difference between Destination adapter and bcp in Sql server 2005 ?
Thanks and Regards
Altaf Nizamuddin
Issues Using Parameterised Reports Connecting To Oracle Using ODBC And Microsoft OLE DB Provider For Oracle
Sep 12, 2007I have an issue using parameterised reports connecting to Oracle using "ODBC" and "Microsoft OLE DB Provider for Oracle" using parameteried reports. The following error is generated "ORA-01008 not all variables bound (Microsoft OLE DB Provider for Oracle)" and a similiar one for ODBC. It works fine for simple reports. Do these 2 drivers have issues passing parameters for a remote Oracle query?
Thanks.
Output Column Has A Precision That Is Not Valid (loading From Oracle Using OraOLEDB.Oracle.1)
Apr 2, 2007Hi!
I'm loading from Oracle using the OraOLEDB.Oracle.1 provider since I need unicode support and I get the following error:
TITLE: Microsoft Visual Studio
------------------------------
Error at myTask [DTS.Pipeline]: The "output column "myColumn" (9134)" has a precision that is not valid. The precision must be between 1 and 38.
------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC0204018 (Microsoft.SqlServer.DTSPipelineWrap)
------------------------------
BUTTONS:
OK
------------------------------
For most of my queries to Oracle I can cast the columns to get rid of the error (CAST x AS DECIMAL(10) etc), but this does not work for:
1) Union
I have a select like "SELECT NVL(myColumn, 0) .... FROM myTable UNION SELECT 0 AS myColumn, .... FROM DUAL"
Even if I cast the columns in both selects (SELECT CAST(NVL(myColumn, 0) AS DECIMAL(10, 0) .... UNION SELECT CAST(0 AS DECIMAL(10, 0)) AS myColumn, .... FROM DUAL) I still get the error above.
2) SQL command from variable
The select basically looks like this:
"SELECT Column1, Column2, ... FROM myTable WHERE Updated BETWEEN User::LastLoad AND User::CurrentLoad"
Again, even if I cast all columns (like in the union), I still get the same error.
Any help would be greatly appreciated. Thanks!
Oracle Connection Fail With Microsoft OLEDB Provider For Oracle MSDAORA.1
Feb 22, 2006Hello,
On my dev server I have working ssis packages that use connections Microsoft OLEDB provider for Oracle MSDAORA.1 and Oracle provider for oledb and OracleClient data provider.
I use one or the other according to my needs.
In anticipation and to prepare for the build of a new production server, I have build a test server from scratch and deployed to it the entire dev.
Almost everything works except Microsoft OLEDB provider for Oracle.
ssis packages on the test machine will return an error
Error at Pull Calendar from One [OLE DB Source [1]]: The AcquireConnection method call to the connection manager "one.oledb" failed with error code 0xC0202009.
Error at Pull Calendar from One [DTS.Pipeline]: component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.
[Connection manager "one.oledb"]: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Oracle error occurred, but error message could not be retrieved from Oracle.".
I have used the same installers for OS, SQL and Oracle SQL*Net on both dev and test machines. The install and then the restore/deployment on Test went fine.
Does anyone could point me to the right direction to solve this issue?
Thanks,
Philippe
Oracle Publication Error:The Permissions Associated With The Administrator Login For Oracle Publisher 'test1' Are Not Sufficient
Jan 12, 2006Hi,
I am trying to make an oracle publiching from sql server 2005 enterprise final release, i installed the oracle client 10.2 (10g) on the same server where sql server already installed, i made different connection to oracle database instance and it was ok.
from sql server : right click on publication -New oracle publication-Next-Add Oracle Publisher-Add button-Add Oracle Publisher-i entered server insttance test1 and their users and passwords--connect --->
the oracle publisher is displayed in the list of publisher but when press ok i got the following error :
TITLE: Distributor Properties
------------------------------
An error occurred applying the changes to the Distributor.
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=Microsoft.SqlServer.Management.UI.DistributorPropertiesErrorSR&EvtID=ErrorApplyingDistributor&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
SQL Server could not enable 'test1' as a Publisher. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The permissions associated with the administrator login for Oracle publisher 'test1' are not sufficient.
Changed database context to 'master'. (Microsoft SQL Server, Error: 21684)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=21684&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Any idea about this error ?
Thanks
Tarek Ghazali
SQL Server MVP.