ODBC Connection to BCM

[Guy Lapierre]

Does anyone know how to create an ODBC connection to BCM? I'm looking to
access the BCM information from Access.

 

[Luther]

There's an applet in the Administrative Tools section of Control Panel
for creating named DSN, and I believe there are similar wizards in
Access.

This page has an example of the command-line for connecting OSQL (a
simple ODBC tool that MSDE Setup installs) to BCM.

http://beyng.blogspot.com/2005/06/how-to-run-sql-against-bcm-database.html

 

[Guy Lapierre]

Thank you. I am aware of the wizards. I connect to other SQL Server
databases in MSDE but I have been unsuccessful connecting to this one since
day 1.

 

[Luther]

Assuming you are on the same machine (no firewall issues) then perhaps
you need the port number after the instance in the DSN. Add: ,56183

One other thing, have you turned on sharing, or are you trying to
access a private database?

 

[Guy Lapierre]

I had to share the database. Thanks, Luther!