G Guy Lapierre Jun 29, 2005 #1 Does anyone know how to create an ODBC connection to BCM? I'm looking to access the BCM information from Access.
Does anyone know how to create an ODBC connection to BCM? I'm looking to access the BCM information from Access.
L Luther Jun 29, 2005 #2 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
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
G Guy Lapierre Jul 3, 2005 #3 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.
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.
L Luther Jul 3, 2005 #4 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?
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?
