what is the importance of dsn in BO

[system]

Hello All,

I am in product support,most of the times we are getting the issues related to the dsn,anybody please provide me the following details:

1. Why one need to have a dsn:

2. Is the dsn is interface between BO connection and Database.If so how they will interact.

thanks
Rajesh

---

kanukula (BOB member since 2007-05-05)

[system]

Its not the importance in BO but rather the selection done while creating a Busobj connection.
If a connection is based on middleware as ODBC then DSN (from control panel) comes into play while OLEDB can be directly configured by passing the server name & database instance.
A native connectivity in Oracle (TNSNAMES.ora) doesnt require a DSN.

.

---

haider (BOB member since 2005-07-18)

[system]

See this entry on Microsofts website:

A Data Source Name (DSN) is the logical name that is used by Open Database Connectivity (ODBC) to refer to the drive and other information that is required to access data. The name is use by Internet Information Services for a connection to an ODBC data source, such as a Microsoft SQL Server database. To set this name, use the ODBC tool in Control Panel.

---

Andreas (BOB member since 2002-06-20)

[system]

thanks for the reply.

let me know any one ,how this BO connection and DSN interacts.

thanks
Rajesh

---

kanukula (BOB member since 2007-05-05)