| Author |
Message
|
| berguss22 |
 Posted: Fri Oct 29, 2004 3:12 am Post subject: DataSource Not found problem in Database Node |
 |
|
Apprentice
Joined: 10 Mar 2004
Posts: 31
|
I have written a very simple database node with the ESQL statement INSERT INTO Database.ALAA.BOOKSTOREORDER ( FIRSTNAME,TITLE,EDITION) VALUES (Body.FirstName, Body.Title,Body.Edition);
using a message set and imported the databsse connection to the project I keep getting the error:
( WBRK_BROKER.alaa ) Database error: SQL State 'IM002'; Native Error Code '0'; Error Text '[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified'.
The strange thing is Airline reservation works just fine
Any suggestions???? |
|
| Back to top |
|
 |
| mgk |
| Posted: Fri Oct 29, 2004 4:16 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Have you specified the datasource property on the node?
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| berguss22 |
| Posted: Fri Oct 29, 2004 4:22 am Post subject: |
|
|
Apprentice
Joined: 10 Mar 2004
Posts: 31
|
| yes I did specify that property name of the databse TEST1. |
|
| Back to top |
|
|
| mgk |
| Posted: Fri Oct 29, 2004 5:10 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Just to confirm, it is not the name of the DATABASE you should specify on the node property, but the DATASOURCE, which you must define in the SYSTEM DSN tab of the Datasources (ODBC) control panel applet on windows.
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| berguss22 |
| Posted: Fri Oct 29, 2004 9:01 am Post subject: |
|
|
Apprentice
Joined: 10 Mar 2004
Posts: 31
|
I have added an ODBC DataSource through Adminstrative tools and used the datasource name in the Database node I use but I still get the same exception in the ExceptionList tree.
Any Suggestions |
|
| Back to top |
|
|
| rkford11 |
| Posted: Fri Oct 29, 2004 9:37 am Post subject: |
|
|
Partisan
Joined: 06 Jun 2004
Posts: 316
|
| berguss22 wrote: |
I have added an ODBC DataSource through Adminstrative tools and used the datasource name in the Database node I use but I still get the same exception in the ExceptionList tree.
Any Suggestions |
Have you tested the ODBC connection? |
|
| Back to top |
|
|
|
|
