Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bdrunion

    Inserting into TEXT field from Oracle

    I was able to resolve the issue by doing 2 things: 1) The table in MySQL needed to have a primary key 2) The MySQL database needed to be started in --ansi mode
  2. bdrunion

    Inserting into TEXT field from Oracle

    Yes, I get the same error if I do a simple select (SELECT SHORT_TEXT FROM ROT_MFG_SCHEDULER@mysql;) in SQL*Plus, T.O.A.D, or anything using Oracle's SQL*Net. However, I can retrieve the data through Access (using ODBC), or in mysql.
  3. bdrunion

    Inserting into TEXT field from Oracle

    There error I receive (even when just trying to select from a TEXT field via ODBC) is.... [Generic Connectivity Using ODBC][unixODBC][MySQL][ODBC 3.51 Driver][mysqld-4.0.17-standard-log]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the...
  4. bdrunion

    Inserting into TEXT field from Oracle

    I am inserting data into a mySQL table from Oracle via an Oracle Stored Procedure. I can load data into all fields, except for TEXT fields. I receive an INVALID syntax error whenever I try to insert data into a TEXT field. I have 3 fields which will have text > 255 characters so I can not set...

Part and Inventory Search

Back
Top