| Author |
Message
|
| mca |
 Posted: Fri Feb 01, 2013 9:32 am Post subject: ODBC vs. JDBC Drivers to connect to SQL Server from Broker |
 |
|
Disciple
Joined: 09 Mar 2005
Posts: 196
|
We are trying to access SQL Server 2005 DB from message flow compute node/DB Node. For this, is it better to use ODBC drivers or JDBC Drivers to install in MB server?
If so, what would be the advantage of choosing one of it? |
|
| Back to top |
|
 |
| Vitor |
| Posted: Fri Feb 01, 2013 9:54 am Post subject: Re: ODBC vs. JDBC Drivers to connect to SQL Server from Brok |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mca wrote: |
| We are trying to access SQL Server 2005 DB from message flow compute node/DB Node. For this, is it better to use ODBC drivers or JDBC Drivers to install in MB server? |
The Compute Node only uses ODBC.
You shouldn't install any ODBC drivers but use the ones supplied with the WMB software.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mca |
| Posted: Fri Feb 01, 2013 10:01 am Post subject: |
|
|
Disciple
Joined: 09 Mar 2005
Posts: 196
|
Thanks.
Can the Java Compute node use ODBC Driver too? How about DB Nodes (DataInsert/DataUpdate/DataDelete etc)? |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Feb 01, 2013 10:46 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mca wrote: |
| Can the Java Compute node use ODBC Driver too? How about DB Nodes (DataInsert/DataUpdate/DataDelete etc)? |
These nodes use the data source type described in the InfoCenter entry for that node.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mca |
| Posted: Fri Feb 01, 2013 11:07 am Post subject: |
|
|
Disciple
Joined: 09 Mar 2005
Posts: 196
|
| So, i do not need JDBC driver for Broker to communicate with SQL Server ? |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Feb 01, 2013 2:17 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mca wrote: |
| So, i do not need JDBC driver for Broker to communicate with SQL Server ? |
You need a JDBC driver for those components that use a JDBC.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
