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 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
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) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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,...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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...
|
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...
| |