How a server oracle can read mdb(access) database
Hi. I have a server "A" with oracle 10g express (free) and a server
"B" with an Access database.
I need that an application that uses oracle server can reads tables on
"B". How can i do this?
Can do i make a Local View on "A" of "B"?
On Apr 30, 11:49 am, Raimo <m0...@yahoo.it> wrote:
> Hi. I have a server "A" with oracle 10g express (free) and a server
> "B" with an Access database.
> I need that an application that uses oracle server can reads tables on
> "B". How can i do this?
> Can do i make a Local View on "A" of "B"?
You can attach odbc tables in Access, but performance sucks big time
when Access tries to resolve queries on remote tables.
Keep all your data in Oracle and use passthrough queries so that
Oracle does the clever stuff. (Or keep everything in Access - but
concurrent access sucks).
On 30 Apr, 14:28, "C. (http://symcbean.blogspot.com/)" <..> wrote:
> On Apr 30, 11:49 am, Raimo <molok> wrote:
> > Hi. I have a server "A" with oracle 10g express (free) and a server
> > "B" with an Access database.
> > I need that an application that uses oracle server can reads tables on
> > "B". How can i do this?
> > Can do i make a Local View on "A" of "B"?
> > thanks
> You can attach odbc tables in Access, ...Access MS SQL Server tables from Oracle 9i
I need to access MS SQL Server tables (SQL Server 2000 on Windows 2000)
from applications running on Oracle 9i on a Solaris 8 (Sparc) server. I
think I am in the same situation as the person in
<firstname.lastname@example.org> (which is from 2002).
I took a look at the Heterogenous Connectivity Admin Guide, and found I
have the choice of Transparent Gateway (15K$) or Generic Connectivity.
Has anybody used G.C. to do this before? Are there free/open source
ODBC drivers for Solaris 8? Could I use unixODBC as a driver manager?
"Thorsten Jens" <email@example.com> wrote in
> I need to access MS SQL Server tables (SQL Server 2000 on Windows 2000)
> from applications running on Oracle 9i on a Solaris 8 (Sparc) server. I
> think I am in the same situation as the person in
><firstname.lastname@example.org> (which is from 2002).
> I took a look at the Heterogenous Connectivity Admin Guide, and found I
> have the choice of Transparent Gateway (15K$) or Generic Connectivity.
> Has anybody used G.C. to do this before? Are there free/open source
> ODBC drivers for Solaris 8? Could I use unixODBC as a driver manager?
PERL can inter-operate with both DBs "concurrently".
Let me know i...Accessing Oracle Tables from MS Access
How difficult is this? I'm having a tough time getting a simple select to
I am using MS Access 2002 and Windows XP.
What do I have to do to make a simple select statement like this work:
select id from emp
I have stumbled upon many websites although none straight to the point.
Any help in how to get this done, or pointing me in the right direction of a
book or website, would be greatly appreciated!
Yes, I do have the table links working.
But I did want to run the select for such things as grabbing the next number
off of a sequence. As in:
select test.nextval fro...Re: Accessing MS SQL server or ORACLE database from the HP3K
One small clarification to my previous question:
We are not trying to migrate our IMAGE data to another platform. We are
trying to provide an enhancement where data that already exist in a
database on another platform can be viewed, extracted and used to
"complete" an existing entry in the IMAGE database, thus eliminating the
need for the user to manually 're-enter' the data.
I was asked the following question today and decided to turn to y...Re: Accessing MS SQL server or ORACLE database from the HP3K #3
if nothing else helps, you could use Java and JDBC with the JDBC
driver of the respective target database. A small example showing
access to an Image/SQL database can be found on the following web
page (and can be adjusted to use an MSSQL or Oracle JDBC driver
and database URL/logon fairly easily)...
http://www.editcorp.com/Personal/Lars_Appel/JavaDemo/ -> JdbcProgram
Calling Java from COBOL as a subprogram, however, is probably not
the way that I would go, if exploring this road. I would probably
let a program similar to the above run as a "gateway" in a sep...Re: Accessing MS SQL server or ORACLE database from the HP3K #6
On July 9, 2003 11:23 am, Duane Percox wrote:
> * Performance was not that great so you wouldn't want to use this
> for production, but proof of concept and for learning it is ok.
Do you have any performance numbers for it all on Linux?
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
...Re: Accessing MS SQL server or ORACLE database from the HP3K #3
In a message dated 7/8/03 5:23:24 AM Pacific Daylight Time,
> It's not MS SQL or Oracle but for what it's worth, we once had a Cobol
> accessing a PostgreSQL database that resided on a Linux server by using the
> libraries included with Mark Bixby's PostgreSQL port.
I for one would absolutely love to see an example of that! Sometime soon (?)
I hope to be able to finally spend some time working with PostgreSQL on MPE
and/or Linux. Having a known working example of how to access it via COBOL is
a great ...Access MS-ACCESS database on server from client????
I m currently developing a java based application and want to know how
can i make client access database located on the server?
"HeMan_Speaks" <Lunar20092010@gmail.com> wrote in message
>I m currently developing a java based application and want to know how
> can i make client access database located on the server?
I think you're going to have to expand a little bit more in your question
here, as is not 100% quite clear what you're trying to do.
You might want to make a little bit of a distinction between MS access, the
development system that allows you to write code, build forms, and build
reports, and that of the database engine that you choose to use with MS
access. When you build an application MS access, you then choose your
database engine, that might be oracle, SQL server, or perhaps more often
leave the default jet database.
So when you say make a client access application, are you talking about a
piece of software that you plan to install and each computer? The fact that
your introducing the issue of java further complicates your question.
Perhaps your question is simply you have some java code running on a server,
and with to open a mdb file (an access database file). In this situation
you're not really using MS access at all here (you using what is called the
jet database engine to read that mdb file). For all the trouble in this type
of sce...How to get table names from ms access(mdb file) by using odbc library.
I am writing a c++ program get the data from mdb file using odbc
By the way, I couldn't get table list from mdb file.
i goolgled it up little bit, what i found is only using the ADO(or OLE
i'm not sure) library and
"SELECT Name FROM MSysObjects WHERE Type In (1,4,6) AND Left([Name],
4)<>"MSYS" this query.
i already wrote a lot of part of this program so i don't want to
switch database library.
And the query gives "no read permission on 'MSysObjects' " error
If you know how to get the table list from a mdb file by using odbc
library, please share your experience.
If you using odbc to a mdb file, then you MUST have jet installed, and
THEREFORE you MUST also have dao installed on your machine (in fact, out of
the box, windows xp, server 2003, vista etc DOES HAVE the jet database
engine installed by default (thus you don't need to install anything on a
windows computer to read mdb files.
here is a windows (vbs) script that displays all tables...you can use late
binding in your project, and you should little trouble getting a list of
tables using the following idea.
Set dbeng = CreateObject("DAO.DBEngine.36")
strMdbFile = "C:\Documents and Settings\Lawrence\My
Set db = dbeng.OpenDatabase(strMdbFile)
for each table in db.tabledefs
The above is not a vba script. Paste the above into a te...Re: <Another Pluh>Re: Accessing MS SQL server or ORACLE database from the HP3K
From: "PeteVickers" <pete@GUI-INNOVATIONS.COM>
> forgive the 2nd plug, but we have just uploaded the NewsWire review to the
> web site, or use the direct link
> "Paul H. Christidis" <email@example.com> wrote in message
> > Is there a way for an IMAGE/VPLUS based application to connect, extract,
> > and present to the user (based on his input) data residing on an MS SQL
> > server or an ORACLE database on a different host?
MPE/iX Enterpr...Accessing a MS Access database across two servers
The technical support guys at my company have set up my system so that
the server containing the MS Access database is on one server, while
the pages that should access the database are on another server.
When the pages and database are on the same server, I usually just
connect through ODBC.
The problem is that I don't know how to set up an ODBC connection to
link from one server to a database in another.
Anyone know what I am getting at and know of a possible solution, or a
link to a site which may help.
thanks in advance
"Singularity" <Brendan.Collins@Sin...Accessing 2 tables having same name but different databases ms-access
I have an application with MS-Access as backend and JSP/ tomcat as
For getting better response time(as access is very slow compared to
other RDBMS's), I have split the main DB into two DB's on different
disks on my server for better performance.I have kept the table names
same but changed the DB names. How do I access tables from both the
This is what I have done; I made different connection to the
respective DB's i.e. con and con2. When I want to access data, I am
using 2 result sets for retriving data from the tables, but getting no
result. Here is my code:
rs2_1=stmt2_1.executeQuery("select * from Requests where
Status='Released' AND LoginName='"+login+"' order by Req_No");
rs=stmt.executeQuery("select * from Requests where Status='Released'
AND LoginName='"+login+"' AND Req_No> 5500 order by Req_No");
So, rs & stmt are for latest records and rs2_1 & stmt2_1 correspond
the records from older DB.
I think, I'm forgetting some small thing but cant get it.
What do you mean "no result"? Does "next()" return false for both rs2_1 an=
If you're really trying to improve response time, you should probably be ru=
nning the two queries in separate threads ... but as you acknowledge, Acces=
s may not have as high performance as other RDBMSs. You would also see rel=
iability adv...MS Access database with a file extension of .mde
Can you kindly assist me in opening a MS Access database with a file
extension of .mde?
I get an error message stating "This database is in an unrecognized
Any help is greatfull.
This usually indicates an attempt to open an Access 2000 database in an
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with
no warranties, and confers no rights.
"mary" <firstname.lastname@example.org> wrote in message
news:a0a64947.0311151242.4df0c...SQL Server "Linked Server" to MS Access Database
I have a very frustrating problem. I have a situation that works fine
on some computers, but not on others. I have SQL Server Express 2005
and Access 2003 loaded on 4 computers. I have set up a "Linked
Server" in SQL Server linked to my Access database. I am running
queries on t-SQL against the Access tables through the linked server.
On all of the computers, I can do select queries and they all work
great but what I need to do is run Update, Insert, Delete queries as
well. On a couple of the computers, it works fine, locally and across
the LAN, and a VPN as far as that goes. B...MS Access VBA making multiple tables in database from a main table.
I have a database table called "tbl_personal" and struggling to VBA
program a bit of code to
create multiple tables in a database from the main "tbl_personal"
In this case the 'color' column is the field I would like to look at.
1. Identify the number of unique records in column 'color'
2. For each color record that is label as red in the "tbl_personal"
table, create a table
called 'red' and populate with all red records in from the
3.Then move onto the next unique color and repeat the whole process
4. When all unique color tables are created in MS Access database end
with a msg "batch process done"
name surname age color country
aa aaa 1 red UK
bb bbb 10 green USA
cc ccc 20 blue China
dd ddd 30 red Germany
ee eee 40 green France
ff fff 1 blue Italy
gg ggg 20 red Spain
hh hhh 40 yellow Canada
ii iii 34 black Italy
Is this doable automatically in MS Access?
Are you sure you want to do this?
I would expect 3 tables vis:
Table of Personel with PersonelID, Suname, FirstName, ColourID, CountryID &
DateOfBirth (Age will be out of date next birthday and should be
Table of Colours ColourID & Colour
Table of Countries CountryID & Country.
You can then use simple queries to return all the red people or people who
live in UK.
Am I missing something?
<email@example.com> wrote in message
news:495c4ca6...Possible to keep MS Access interface and migrate the MS Access to MS SQL Server?
Would it be possible to migrate the MS Access 2000 to MS SQL Server
My application is using MS Access 2000 as database and as user
interface such as forms. Now, I want to migrate the backend database
from MS Access 2000 to MS SQL Server 2000. However, I want to keep the
MS Access 2000 interface. Would it be possible?
If I migrate the MS Access to SQL Server, would the queries, back-end
VBA, macro, tables and forms be affected? Do I need to change the MS
Access data type to SQL server supported data type?
Which tool I can use to do the migration? Upsizing wizard or exporting...SqlSpec
Do you wish you had comprehensive, easily navigable documentation for
your SQL Server, Oracle, Analysis Server, MySQL, and Access databases?
Are you a SQL Developer or DBA that just inherited a huge, complex
database with no supporting docs and don't know where to start
learning how it's put together?
Are you an independent contractor working with SQL Server, Oracle,
Analysis Server, MySQL, or Access? Your clients would LOVE you if you
could provide comprehensive documentation about the databases you
Are you a Project Manager who is tired of developers making changes to
databases on live servers and not updating the corresponding spec?
SqlSpec will make sense of it all and generate easy-to-read docs for
you for any database on the following platforms:
* SQL Server 2000/2005
* Oracle 9i (and above)
* MySQL 5.0 (and above)
* Analysis Server 2005
* Access 97/2000/XP/2003
SqlSpec generates documentation in two formats: HTML or CHM. HTML is
useful for publishing your documents on the web or an intranet site.
CHM is useful if you want a single, compact file containing all your
documentation about one or more databases. The CHM is indexed so it is
easily searchable for any keyword. This way you can easily determine
which objects reference the "EmployeeID" column, for example.
You can download a fully featured trial version here: http://www.elsasoft.org
...MS-Access, ODBC access with Visual C++ 6.0, and external actions on database
[was redirected here] I have a problem that I can distill down to the
1/ A Visual C++ 6.0 program connects to a MS Access database using an
ODBC connection and sleeps for a long time. The connection takes all
defaults and uses CDatabase::useCursorLib in the OpenEx command.
2/ The database is well over 400MB large with over 200 tables and is
3/ Another process starts a winzip on that database that takes about 45
to 60 seconds to complete (wzzip -a -ex aaa.zip aaa.mdb).
4/ The Windows Task Manager shows 100s of MBs of available memory being
consumed....Import MS Office Excel Comma Separated Values Files into a MS Access 2003 database
I have been tasked with Importing MS Office Excel Comma Separated
Values Files into a MS Access 2003 database. These files were exported
from a DB2 database.I have also been given the DDL code. I have
Googled a solution to this task and have tried creating these tables
using the DDL code in a query within a blank MS Access database. Is
there a more expedient way to achieve this? I noticed, for example,
that a field in DB2 has a data type of "decimal" while the same field
would have the data type of "number".
What follows is the DDL:
-------...How to set Data source in MS Word as MS Access Databases via DDE(*.mdb;*.mde).
How to set Data source in MS Word as MS Access Databases via
Everytime i click the command button to merge the data, it gives me
item not found and i know that its a problem with my datasource. when i
click ok then it opens the word doucment prompting me which datasource
you want to use, when i click DDE then it gives me the merged data. Is
there anyway i can set it permanantely in my codes below.
Private Sub SetQuery(strQueryName As String, strSQL As String)
On Error GoTo ErrorHandler
'set the query from which the merge
' document will pull its i...import oracle tables to ms access
I want to import some tables from Oracle 9i to MS Access 2000.
I'm able to import the table structures and data using File->Get
External Data->Import . (I don't want to import links)
However, this does not allow me to import constraints and
relationships between tables.
Is there some way to do so.
If not through a menu or utility, is it possible to write code for
Thanks in advance
Arti Potnis wrote:
> I want to import some tables from Oracle 9i to MS Access 2000.
> I'm able to import the table structures and data using File->...MS-access file on Oracle 9i
I am wondering wether it's possible to connect an Oracle 9i
client-version to a MS-access file. If it's possible please let me
> I am wondering wether it's possible to connect an Oracle 9i
> client-version to a MS-access file. If it's possible please let me
> know how.
No. But for what possible reason would you want to do it? Take whatever
is in MS Access and put it into the real database.
(replace 'x' with a 'u' to reply)
Daniel Morgan wrote:
> Mads wrote:
>> I am wondering wether it's possible to connect an Oracle 9i
>> client-version to a MS-access file. If it's possible please let me
>> know how.
> No. But for what possible reason would you want to do it? Take whatever
> is in MS Access and put it into the real database.
Actually you can, thru heterogeneous services you can connect to an
MSaccess "database" from an Oracle database thru ODBC and treat it like
a linked database.
Unless they discontinued that in 9i...
Glen A Stromquist wrote:
> Daniel Morgan wrote:
>> Mads wrote:
>>> I am wondering wethe...Win2000 Server can access client but client cannot access server files.
We're running 2000 Server feeding 4 PC's and two Macs.
Last week I found one PC can no longer access files on the server
whereas the server can access any files on that PC. I suppose it's a
good sign that it is at least working in one direction. I just need
to get it back to working both ways.
Though I am very competent with stand alone PCs I'm not very
experienced with networks.
I'd very grateful of any suggestions regarding settings I should check
that would re-connect the link of this PC to the server.
If there are any web sites you can recommend for network ne...Create MS/ACCESS database app for non-ms/access users
Is it possible to create an MS/ACCESS database application and package
it for users who do not have MS/ACCESS loaded in their PCs?
I was told that this is possible, but I don't know what software is
needed. Do you know? If so, please answer this post. Thanks.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Per Sue Bricker:
>Is it possible to create an MS/ACCESS database application and package
>it for users who do not have MS/ACCESS loaded in their PCs?
>I was told that this is possible, but...