Connecting to MySQL from Oracle using MyODBC driver

2001-12-13 Thread Alfisi, Steve 

Dear Sir or Madam,

I am currently trying to connect an Oracle 8.1.7 database running on
Windows NT 4.0 to a MySQL database running on Linux (not sure of the MySQL
or Linux versions). When I try to select from a table I am getting the
following error...

ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
[Generic Connectivity Using ODBC][S1000] [9013]General error in
nvITrans_BeginT
-   rc = -1. Please refer to the log file for details.

I know the ODBC connection works because I connected from another
application to the MySQL database, so it has to be something to do with
Oracle viewing MySQL. I know the Oracle ODBC connections out work because I
am able to connect to Microsoft Access and SQL Server. I would appreciate
any assistance you may have.

Thanks,

Steven Alfisi
Programmer - Database Specialist
Orchid BioSciences
303 College Road East
Princeton, NJ 08540
(609) 750-2750

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Connecting to MySQL from Oracle using MyODBC driver

2001-12-13 Thread styb 

it wuld be nice if mysql supported sub queries
ie.

select A.MESSAGEID from MESSAGEDATA as A where A.MESSAGEID
in (select B.MESSAGEID from MESSAGES as B where
B.SUBJECT='Invitation to join the hanky panky group')


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php