Oracle BE

[Rohan via AccessMonster.com]

I have an access database with tables, and links to tables in an Oracle Back
End.

I want to move all my access tables to the backend, but feel I will be unable
to add
new records to the newly linked tables because there will be no autonumber
field
in the oracle tables.

Is there a solution using triggers/sequencers ?

Any help or comments on this matter would be helpful.

Rohan.

 

[David Portas]

I have an access database with tables, and links to tables in an Oracle Back
End.

I want to move all my access tables to the backend, but feel I will be unable
to add
new records to the newly linked tables because there will be no autonumber
field
in the oracle tables.

Is there a solution using triggers/sequencers ?

Any help or comments on this matter would be helpful.

Rohan.

Oracle has sequences and they can be used as surrogate keys. I
recommend you hire some Oracle expertise if you haven't already done
so. Designing an Oracle database on the basis of experience with Access
could lead to some expensive mistakes. Access Jet has almost nothing in
common with enterprise DBMS.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

 

[aaron.kempf]

David;

I think that you're full of shit.

MDB -- Access experience is critical to understanding databases.

Sure, Enterprise RDBMS are more powerful-- but you need the basic
understanding before you can do anything.

I am a SQL Server developer because of the fact that i started in
Access.
Access allowed me to grow into SQL Server and thus Oracle; any other
RDBMS you need i can work on.

I've worked extensively on SQL 7,2000 and 2005. I've worked on mySql
and Oracle and DB2 and Sybase.

my knowledge from access allowed me to make 6 figures.

Most idiot MDB developers are scared to learn a real database.

I urge you to ignore this conceited 'SQL Server MVP' (gag) and keep
your chin up--- figure out a way to do this in Oracle yourself.

a) you don't need an autonumber field. you need a primary key. If
Access prompts you for the primary key and you don't know it-- find
someone that does.
b) screw oracle in the mouth
c) screw MDB in the mouth
d) convince your oracle folk to get a real database like sql server
e) keep on using oracle and mdb linked tables until they get their act
together and realize that MS has won the TPC war.

 

[Baz]

David;

I think that you're full of shit.

MDB -- Access experience is critical to understanding databases.

Sure, Enterprise RDBMS are more powerful-- but you need the basic
understanding before you can do anything.

I am a SQL Server developer because of the fact that i started in
Access.
Access allowed me to grow into SQL Server and thus Oracle; any other
RDBMS you need i can work on.

I've worked extensively on SQL 7,2000 and 2005. I've worked on mySql
and Oracle and DB2 and Sybase.

my knowledge from access allowed me to make 6 figures.

Most idiot MDB developers are scared to learn a real database.

I urge you to ignore this conceited 'SQL Server MVP' (gag) and keep
your chin up--- figure out a way to do this in Oracle yourself.

a) you don't need an autonumber field. you need a primary key. If
Access prompts you for the primary key and you don't know it-- find
someone that does.
b) screw oracle in the mouth
c) screw MDB in the mouth
d) convince your oracle folk to get a real database like sql server
e) keep on using oracle and mdb linked tables until they get their act
together and realize that MS has won the TPC war.

What an unpleasant person you are.

 

[David Portas]

[snip]

Aaron, you are a waste of space.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

 

[aaron.kempf]

what the **** you talking about asshole

homedude-- the arrogant sql guy-- was saying 'access knowledge wont
help you with oracle'

and im saying he's full of shit

access is the first database anyone SHOULD learn.
they should use it for about a week lol.

I just want to know what the **** this david portas jack ass is saying
you're discouraging this mdb-kiddie from learning a real database

and i just want to know who the **** you think that you are david.

Of course we should be encouraging MDB-kiddies to be learning a real
database.

Microsoft has proven time, and time again their lack of dedication to
the RDBMS market-- if they gave a shit then they would take it
seriously.

i have a list of 10 bugs in access.

when Microsoft stops fucking around and starts fixing bugs-- is when
it's ok for these kids to keep on using MDB.

as it is; microsoft is too proud and drunk on their own success to
remain competitive.

so yeah-- go ahead kid; learn Oracle.

experiment with Oracle.

right-click link, files of type = 'odbc' and make a friggin ton of
linked tables to oracle.

most importantly you need to write SQL Passthrough queries; because MDB
sucks balls you've got to write all your queries on the server side.

start a new query, view, sql view-- query tab, special query types; i
wish i remembered the verbage-- sql passthrough.

under the edit menu select properties; maybe you can just right click..
the 2nd or 3rd argument down is 'odbc connection string'.

i personally prefer SPT to linked tables for everything-- because you
can do a simple copy and paste of the odbc connection string property..
in linked tables; it's a big old pain in the ass because it's a read
only property.. so if you want to set it as a custom string; you need
to do it programmatically

yes; go ahead bud-- screw around with the oracle side. see if you can
make updates; but try updates on the base tables; not updates against
views or access-side joins.

 

[aaron.kempf]

but then again; SQL Server is a vastly superior system; if you know and
love mdb you should use adp (really really similiar to mdb but it's got
a real query engine; it doesn't crap out when randomly (like mdb does)
when you stack queries on top of queries.

Acceess Data Projects.

File, New, Project (New Data) and i think that there is a big fat
wizard for upsizing your MDB database onto a real server.

Oracle is better than MDB but SQL Server is better than oracle.

Oracle; i mean-- do you still have to buy the developers tools? i
mean-- does it still cost 10 grand per developer?

Access Data Projects are the best IDE in the world for writing sprocs
and views.

you can't use it against SQL 2005; so do most of your dev in 2000;
migrate it to 2005 for production use.

 

[Marcin]

but then again; SQL Server is a vastly superior system; if you know and
love mdb you should use adp (really really similiar to mdb but it's got
a real query engine; it doesn't crap out when randomly (like mdb does)
when you stack queries on top of queries.

Acceess Data Projects.

File, New, Project (New Data) and i think that there is a big fat
wizard for upsizing your MDB database onto a real server.

Oracle is better than MDB but SQL Server is better than oracle.

Oracle; i mean-- do you still have to buy the developers tools? i
mean-- does it still cost 10 grand per developer?

Access Data Projects are the best IDE in the world for writing sprocs
and views.

you can't use it against SQL 2005; so do most of your dev in 2000;
migrate it to 2005 for production use.

===========================================================================
FULL LEGAL SOFTWARE !!!
Games, video, program, image, chat, questbook, catalog site, arts, news,
and...
This site it is full register and legal software !!!
Please download and you must register software !!!

PLEASE REGISTER SOFTWARE:
http://www.webteam.gsi.pl/rejestracja.htm
DOWNLOAD LEGAL SOFTWARE:
http://www.webteam.gsi.pl

Full question and post: http://www.webteam.gsi.pl

Contact and service and advanced technology:
http://www.webteam.gsi.pl/kontakt.htm
FAQ: http://www.webteam.gsi.pl/naj_czesciej_zadawane_pytania.htm

Please add me URL for you all site and search engines and best friends !!!

Me site:
SERWIS WEBNETI: http://www.webneti.gsi.pl
PORTAL WEBTEAM:http://www.webteam.gsi.pl
LANGUAGE: http://www.webneti.cjb.net

==========================================================================