Prev: Matrix rotation function
Next: shape recognition
From: David Hamilton on 7 May 2010 12:57
I am trying to retrieve data from a table stored in an Oracle database using the query builder. I can see the DSN, but I get the following error message after I input my login credentials: "Unable to get information from data source". I am able to read data from the Oracle database using other tools (like MS Access); and I can read data into Matlab from a Sybase database. Are there any known issues/workarounds for Oracle data sources? (I am using the Oracle ODBC driver v10).
From: David Hamilton on 7 May 2010 13:37
Follow up:

Using the DATABASE command in Matlab command window, I got the following error message:

>> conn=database('DSN','id','password');
>> conn.message
ans =
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Again, I can read the database using other tools, so the driver actually seems to work.

"David Hamilton" <d.hamilton(a)moodys.com> wrote in message <hs1gp1$lal$1(a)fred.mathworks.com>...
> I am trying to retrieve data from a table stored in an Oracle database using the query builder. I can see the DSN, but I get the following error message after I input my login credentials: "Unable to get information from data source". I am able to read data from the Oracle database using other tools (like MS Access); and I can read data into Matlab from a Sybase database. Are there any known issues/workarounds for Oracle data sources? (I am using the Oracle ODBC driver v10).
From: Robert Barrie on 24 May 2010 01:30
I am getting the same error trying to connect to my Oracle db using ODBC. Hopefully someone can shed some light on it???
From: Ivan on 26 May 2010 10:29
"Robert Barrie" <askme(a)ifuwant.com> wrote in message <htd2te$d7k$1(a)fred.mathworks.com>...
> I am getting the same error trying to connect to my Oracle db using ODBC. Hopefully someone can shed some light on it???


Hi everybody!,

I get the same error when I try to connect to an Oracle DB using the Microsoft ODBC driver for Oracle. I've checked that the user DNS is correctly defined and the tnsnanes.ora file is correctly established because I can connect to DB using TOAD (DB administrator). When I execute the sentence conn = database ('data_source_name','user_name','password'), I got the following error:

[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:no se ha podido resolver el identificador de conexión especificado Please verify that login information and database url are valid.

I don't know what's happening and why it doesn't work because I could establish the connection in a previous environment (Matlab R2007a and Oracle V8 under a Windows 2000 OS). Actually, I've upgraded that environment and I'm using Matlab R2010a and Oracle v10 under a Windows Vista OS. Any advice?. Thanks a lot and regards!.
 | 
Pages: 1
Prev: Matrix rotation function
Next: shape recognition