Results 1 to 5 of 5

Thread: MS Remote

  1. Nov 22nd, 2002, 01:59 PM #1
    Mc Brain
    Mc Brain is offline

    Thread Starter
    Need-a-life Member Mc Brain's Avatar
    Join Date
    Apr 2000
    Location
    Buenos Aires, Argentina
    Posts
    6,808

    MS Remote

    Is there any way to know what database you're connecting to??
    Emiliano F. Martín


    If a post has helped you then please Rate it! (and give the user points he/she deserves by clicking on the image).
    Encourage the person who helped you to keep doing it, and give him the points he deserves.


    MP3 Organizer: Freeware to logically organize all your MP3s.
    Reply With Quote Reply With Quote
  2. Nov 22nd, 2002, 02:01 PM #2
    James Stanich
    James Stanich is offline
    PowerPoster
    Join Date
    Aug 2000
    Location
    IN SILENCE
    Posts
    6,441

    Well

    Huh?

    Name of database? Wouldn't that be part of the connection string?
    Remaining quiet down here !!!

    BRAD HAS GIVEN ME THE ULTIMATIVE. I have chosen to stay....
    Reply With Quote Reply With Quote
  3. Nov 22nd, 2002, 02:04 PM #3
    Mc Brain
    Mc Brain is offline

    Thread Starter
    Need-a-life Member Mc Brain's Avatar
    Join Date
    Apr 2000
    Location
    Buenos Aires, Argentina
    Posts
    6,808
    Nop. In the Connection String you set the IIS, and you refer to an INI (msdfmap.ini) where the connection string resides.

    Anyway, isn't there any Trans-SQL query to get the database which you're connecting to?
    Emiliano F. Martín


    If a post has helped you then please Rate it! (and give the user points he/she deserves by clicking on the image).
    Encourage the person who helped you to keep doing it, and give him the points he deserves.


    MP3 Organizer: Freeware to logically organize all your MP3s.
    Reply With Quote Reply With Quote
  4. Nov 22nd, 2002, 02:07 PM #4
    Mc Brain
    Mc Brain is offline

    Thread Starter
    Need-a-life Member Mc Brain's Avatar
    Join Date
    Apr 2000
    Location
    Buenos Aires, Argentina
    Posts
    6,808
    Actually, you refer to a "part" of the INI. The INI is always that one (as far as I know). You can create several different connections, each of them with different [names].
    Emiliano F. Martín


    If a post has helped you then please Rate it! (and give the user points he/she deserves by clicking on the image).
    Encourage the person who helped you to keep doing it, and give him the points he deserves.


    MP3 Organizer: Freeware to logically organize all your MP3s.
    Reply With Quote Reply With Quote
  6. Nov 22nd, 2002, 02:29 PM #5
    Mc Brain
    Mc Brain is offline

    Thread Starter
    Need-a-life Member Mc Brain's Avatar
    Join Date
    Apr 2000
    Location
    Buenos Aires, Argentina
    Posts
    6,808
    Found it!! Thanks to a friend online... I got the answer. It is:

    SELECT DB_Name()
    Emiliano F. Martín


    If a post has helped you then please Rate it! (and give the user points he/she deserves by clicking on the image).
    Encourage the person who helped you to keep doing it, and give him the points he deserves.


    MP3 Organizer: Freeware to logically organize all your MP3s.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width