473,714 Members | 2,351 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problems querying oracle db from Access 2000


I am trying to query a table in oracle from Access 2000 using the
following criteria.

select * from table1 where DATE_RECEIVED between '1/jan/2003' and
'30/jun/2003'

I am using the Oracle odbc driver.

Records should be returned but nothing.

I have tried using different formats, but nothing works.

I am new to Oracle and need some assistance on this small issue.

Any help is appreciated.

Thanks,

Johann

--
Posted via http://dbforums.com
Jul 19 '05 #1
3 3979
Hi Jhweb

Try this
select * from table1
where
DATE_RECEIVED
between to_date('1/jan/2003','dd-mon-yyyy') and
to_date('30/jun/2003','dd-mon-yyyy')
regards
Hrishy

P.S:If now roes are returned then run the query in sql plus and see
what is happening..If there is a mismtach the odbc driver is doin
somethin funny
Jul 19 '05 #2
Hi,

little correction inside.
I point it out because Johann wrote that
he's new to the Oracle world.

"hrishy" <hr*****@yahoo. co.uk> schrieb im Newsbeitrag
news:4e******** *************** ***@posting.goo gle.com...
Hi Jhweb

Try this
select * from table1
where
DATE_RECEIVED
between to_date('1/jan/2003','dd-mon-yyyy') and
between to_date('1/jan/2003','dd/mon/yyyy') and
to_date('30/jun/2003','dd-mon-yyyy')
to_date('30/jun/2003','dd/mon/yyyy')


regards
Hrishy

P.S:If now roes are returned then run the query in sql plus and see
what is happening..If there is a mismtach the odbc driver is doin
somethin funny


Greetings,
Guido
Jul 19 '05 #3
jhweb <me*********@db forums.com> wrote in message news:<32******* *********@dbfor ums.com>...
I am trying to query a table in oracle from Access 2000 using the
following criteria.

select * from table1 where DATE_RECEIVED between '1/jan/2003' and
'30/jun/2003'

I am using the Oracle odbc driver.

Records should be returned but nothing.

I have tried using different formats, but nothing works.

I am new to Oracle and need some assistance on this small issue.

Any help is appreciated.

Thanks,

Johann


You could do what Guido is saying there, but by nature of the ODBC
from Access to Oracle, you should just type in the date format the way
Access normally takes it. Access will format the date to it's liking,
but when it is sent through the ODBC driver to Oracle the date will be
converted to the Oracle date format. FYI...the Oracle date formate is
'04-AUG-03 12:00:00 AM' for today.

Oracle does it's date format as date / time. It's confusing for new
users...I was in your shoes a little over a year ago.

http://sqlzoo.net/howto/oracletip70465.htm
Jul 19 '05 #4

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

Similar topics

11
3309
by: Markku Uttula | last post by:
I think I'm doing something wrong. I'm able to connect to Oracle just fine, execute queries and all, but I'm having serious problems with the speed :( For example, the following PHP-script on my machine executes about 6 seconds: <? $db_conn = ocilogon("my_username", "my_password", "my_database"); $loop_count = 1000;
2
6104
by: neptune | last post by:
I currently link a table to an Oracle db. Anytime I open a query based off it, I have to input username & password. Is there a way to do this automatically? I'd prefer to use linked tables, but I've read a pass-through query can pass the passwords automatically. The directions seem straightforward, but I can't get one to work. The select query from the ODBC linked table looks like: SELECT OSCAR_TBLSALESMAN.SALESMAN,...
5
2371
by: Shane | last post by:
I wonder if someone has any ideas about the following. I am currently producing some reports for a manufacturing company who work with metal. A finished part can contain multiple sub-parts to make up the finished part. The sub-parts can also be made up of sub-parts and those sub-parts can also be made up of sub-parts etc etc. All parts are contained within the same table and I have a seperate table
5
4351
by: premmehrotra | last post by:
I am using Microsoft Access 2000 and Oracle 9.2.0.5 on Windows 2000. When I export a table from Access to Oracle using ODBC I get error: ORA 972 identifier too long I think the error is because one or more columns in Access table are longer than 30 characters. My question is how one can overcome this problem. I also see several column names which have /, ? or spaces in name
3
4079
by: premmehrotra | last post by:
I am using Access 2000 and Oracle 9.2.0.x on a Windows 2000. I have setup Oracle 9.2 ODBC Driver (I have not yet figured how to set Microsoft's Oracle ODBC driver). I am exporting a table from Access to Oracle and I get following error: ODBC Call Failed: ORA-12571: TNS Packet Failure Error I see table and its indexes created in Oracle. However, there are no
5
3809
by: Microsoft | last post by:
Hi, I have Visual Basic .net 2003 (Standard Edition) & SQL Server 2000 Developer Edition. When trying to create a connection in the server explorer from the .net IDE I get a number of problems; a.. Under the "Connection" tab, under "1. Select or enter a server name:" when I either select the drop down box or click the refresh button I get an error dialog saying "Error enumerating data servers. Enumerator reports Unspecified error'". The...
2
4237
by: egoldthwait | last post by:
I need to convert a 17mb access 2000 db to Oracle and house it in a Citrix farm. The issue: we have never converted an Access Db to Oracle but can probably use Oracle's Workbench to assist with this. Also - the citrix folks do not want us to keep the FE in Access as the queries and other activities consume a lot of power. The users will be in 3 different offices across the globe all accessing the 1 Oracle DB in Citrix. Does anyone have...
5
5030
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 working on Access 2000/2002 with pass through queries and linked tables to an Oracle 10g backend (ODBC). Access seems (still) to beat everything else hands down as a front end/ prototyping tool for WIndows based systems. With my type of small...
3
239
by: jhweb | last post by:
I am trying to query a table in oracle from Access 2000 using the following criteria. select * from table1 where DATE_RECEIVED between '1/jan/2003' and '30/jun/2003' I am using the Oracle odbc driver. Records should be returned but nothing.
0
9316
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9177
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9077
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7954
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6637
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5951
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4465
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3159
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2524
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.