Access DB to Oracle DB

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Access DB to Oracle DB

    I'm trying to convert an access table to an oracle table. I have not had any
    problems except for the date/time field in access which contains an
    odbcdatetime. I tried to store this in the date field in oracle, but it seems
    to only retain the date. any thoughts?

    frank

    frankjshin Guest

  2. Similar Questions and Discussions

    1. ASP.NET Impersonation to access Oracle database...
      Hi all, I am trying to work out how I can use impersonation to connect to an Oracle 9i database such that I can avoid sending a clear text...
    2. Oracle Table Access With Oracle OLEDB Driver
      If I use the Oracle client to access the Oracle database with DW 2004, it does not display any tables. If I use the Microsoft client it does work. ...
    3. Access Violation when using Visual Interdev to access Oracle
      I am running Windows 200 Pro, IIS 5.0 and trying to connect to an Oracle 8.1 database. Prior to applying a security patch to W2k, the ASP...
    4. Problem to access Oracle DB
      Do you have the Oracle Client and Networking components installed on the machine on which you're running this app? HTH, Kevin Spencer...
    5. Access to Oracle and Informix DB
      "Rich Campbell" <rich.campbell@att.com> wrote: So far, I've used separate programs written in Oracle Pro*C and Informix ESQL/C. The Pro*C...
  3. #2

    Default Re: Access DB to Oracle DB

    Make sure you are using an oracle datatype that stores both date and time. See
    [url]http://www.techonthenet.com/oracle/datatypes.htm[/url]
    mxstu Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139