connecting to all databases using one odbc connection..PLEASE HELP

2002-03-05 Thread Edward Peloke
I asked yesterday but got no responses...anyone have any ideas how I can use one odbc connection but have access to all databases on the MSSQL server??? Thanks, Eddie - Before posting, please check:

Re: connecting to all databases using one odbc connection..PLEASE HELP

2002-03-05 Thread Christopher Thompson
On Tuesday 05 March 2002 11:11 am, Edward Peloke wrote: I asked yesterday but got no responses...anyone have any ideas how I can use one odbc connection but have access to all databases on the MSSQL server??? I have not tried this but have you considered using the use command? Or even

RE: connecting to all databases using one odbc connection..PLEASE HELP

2002-03-05 Thread Todd Williamsen
It won't let you since Windows ODBC only lets you create ONE DSN per DATABASE -Original Message- From: Edward Peloke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 12:11 PM To: MySql Subject: connecting to all databases using one odbc connection..PLEASE HELP I asked