473,324 Members | 2,257 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

SQL Server to Oracle

Hello,

Well unfortunately, I have to get an Oracle back end working with my
product and am having a hard time doing it. I was wondering if anyone
has had the same experience and could give me a little insight into
what I am doing wrong (if anything). I installed Oracle 10g on a
machine which ended up not being able to run it fast enough, though I
did manage to import the database that I wanted to use. After failing
at some syntax problems, I was finally able to return records, but it
was so slow, that we decided to install Oracle on a faster machine.
After that was done, I thought I was connecting to the newer machine,
but alas, I was actually connecting to the old machine when I found
that some structure changes were not being recognized. I shut off the
old machine, and now the name I was using to connect to it "ORCL",
could not be recognized. I uninstalled and reinstalled it to a new
name "GE", but it still doesn't recognize the name. Just wondering if
without trying to get into an Oracle/SQL Server contest, if there is a
simple stupid thing that I am missing. I don't want to learn Oracle,
I just want the thing running as a back end to do some simple SQL
stuff. I almost had this working, it is just the naming issue. Any
help would be great.

Thanks

-Jevon Thurlow
Jul 20 '05 #1
2 1666
Hi

You may want to either go through the SQLNet configuration wizard or look at
TNSNAMES adn SQLNET.ora files on the client to make sure they point to the
correct server.

John

"JThurlow" <jt******@lablite.com> wrote in message
news:5c**************************@posting.google.c om...
Hello,

Well unfortunately, I have to get an Oracle back end working with my
product and am having a hard time doing it. I was wondering if anyone
has had the same experience and could give me a little insight into
what I am doing wrong (if anything). I installed Oracle 10g on a
machine which ended up not being able to run it fast enough, though I
did manage to import the database that I wanted to use. After failing
at some syntax problems, I was finally able to return records, but it
was so slow, that we decided to install Oracle on a faster machine.
After that was done, I thought I was connecting to the newer machine,
but alas, I was actually connecting to the old machine when I found
that some structure changes were not being recognized. I shut off the
old machine, and now the name I was using to connect to it "ORCL",
could not be recognized. I uninstalled and reinstalled it to a new
name "GE", but it still doesn't recognize the name. Just wondering if
without trying to get into an Oracle/SQL Server contest, if there is a
simple stupid thing that I am missing. I don't want to learn Oracle,
I just want the thing running as a back end to do some simple SQL
stuff. I almost had this working, it is just the naming issue. Any
help would be great.

Thanks

-Jevon Thurlow

Jul 20 '05 #2
JThurlow wrote:
Hello,

Well unfortunately, I have to get an Oracle back end working with my
product and am having a hard time doing it. I was wondering if anyone
has had the same experience and could give me a little insight into
what I am doing wrong (if anything). I installed Oracle 10g on a
machine which ended up not being able to run it fast enough, though I
did manage to import the database that I wanted to use. After failing
at some syntax problems, I was finally able to return records, but it
was so slow, that we decided to install Oracle on a faster machine.
After that was done, I thought I was connecting to the newer machine,
but alas, I was actually connecting to the old machine when I found
that some structure changes were not being recognized. I shut off the
old machine, and now the name I was using to connect to it "ORCL",
could not be recognized. I uninstalled and reinstalled it to a new
name "GE", but it still doesn't recognize the name. Just wondering if
without trying to get into an Oracle/SQL Server contest, if there is a
simple stupid thing that I am missing. I don't want to learn Oracle,
I just want the thing running as a back end to do some simple SQL
stuff. I almost had this working, it is just the naming issue. Any
help would be great.

Thanks

-Jevon Thurlow


As someone that has performed many SQL Server to Oracle migrations:
Usually for products that needt to be platofrm neutral ... you are,
in my opinion, absolutely doomed to failure. You have broken the
cardinal rule of doing this which is to learn the product which
requires reading documentation and books.

If you don't know what multiversion read consistency is then get a
copy of Tom Kyte's book "Expert one-on-one Oracle" and read it ...
read the first three chapters until you get it.

Are you used to working with temp tables? In Oracle ... never.
Are you used to working with limited record locking? In Oracle ... never.
Are you used to working with autonumber? In Oracle ... never.
Are you used to working with only AFTER triggers?
Are you used to lock escalation?
And much much more!
--
Daniel A. Morgan
University of Washington
da******@x.washington.edu
(replace 'x' with 'u' to respond)
Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Ton | last post by:
I have a question about connectivity between different databases. Oracle, DB2400 and SQL_server. It is easy to integrate application products that are running on different DB platforms? What...
3
by: David Gray | last post by:
Hello all, Having problems connecting to an Oracle 9i database from within SQL/Server 2000 using the Security/Linked Servers feature. Server1 (SQL/Server) ----------- Windows Server 2003,...
27
by: Oracle Newbie | last post by:
I got a new Job where I have to handle Oracle databases on Linux. My previous experience is with Sql Server on Windows NT. I want to know how difficult will this shift be and what do I need to...
11
by: Ellen K | last post by:
Hi all, I set up our Oracle Financials as a linked server to one of my SQL Server boxes. On running a test query, I got the following error message: OLE DB provider 'MSDAORA' supplied...
11
by: jrefactors | last post by:
I want to know the differences between SQL Server 2000 stored procedures and oracle stored procedures? Do they have different syntax? The concept should be the same that the stored procedures...
10
by: Andrea M. Segovia | last post by:
Hello, I am a newbie to Oracle databases.... We have a visualization front-end tool connected to an Oracle back-end database on a Tru64 UNIX server. We also have clients with MS access...
8
by: danbredy | last post by:
Hi, I'm attempting to connect to an Oracle database using SQL Server 2005 Express (OS is Windows XP Professional) and having absolutely no luck. Here is the information SQL Plus gives me about...
42
by: Paul | last post by:
Anyone know where I can find some good resources to help us choose between SQL and Oracle ( Progress Openedge as well ) . Any comments on what you would choose ?? We are creating a new Warehouse...
5
by: dreadnought8 | last post by:
I've worked with mdbs, and with SQL Server to a lesser extent, with Access as a front end, on commercial-strength systems for quite a while, starting with A97. The last 8 months or so, I've been...
0
by: sathyguy | last post by:
when i type the below in my RHEL AS 4's Firefox 1.5 http://appsworld.ncc.com:7777/forms/...&form=test.fmx iam getting the below error... The requested URL /forms/frmservlet was not found on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.