G
Guy Lapierre
Does anyone know how to create an ODBC connection to BCM? I'm looking to
access the BCM information from Access.
access the BCM information from Access.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
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
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
G
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.
databases in MSDE but I have been unsuccessful connecting to this one since
day 1.
L
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?
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?
G
Guy Lapierre
I had to share the database. Thanks, Luther!