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

[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 
perhaps specifying the database name along with the table name?

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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

[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 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:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php