Results 1 to 8 of 8

Thread: Simple Question about files/Server

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Apr 2004
    Location
    Alabama
    Posts
    126

    Simple Question about files/Server

    Ok, in the past, i used to use a CD to play files that could change that were too big or i didn't want to place within the installation.

    If all these files are placed on a server instead of CD, I will have to know the exact address in order for the app to find the files?

    I know i can use app.path or something when i use it in the installation, I guess i can place the path in the DB and have it find it from there.

    This might seem simple guys but i've never done this before and some simple confirmation or another idea or two would be greatly appreciated.

  2. #2
    Banned randem's Avatar
    Join Date
    Oct 2002
    Location
    Maui, Hawaii
    Posts
    11,385

    Re: Simple Question about files/Server

    maurices5000,

    Don't understand the problem... If you can install from a CD, why would installing from a location on the network change things unless some location information was hard coded?

    Could you explain what you mean?

  3. #3

    Thread Starter
    Lively Member
    Join Date
    Apr 2004
    Location
    Alabama
    Posts
    126

    Re: Simple Question about files/Server

    we are installing it on the network which means we don't need CDs. Plus the newest computers don't have CD-ROM Drives on them.

    Thanks!

  4. #4
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Simple Question about files/Server

    You could always make an assumption that a "mapped" network drive points to your location - let's say you always look at R: for your large files.

    You would have to make sure that every client machine has R: mapped to the network share/location.

    Otherwise you have to have a registry entry/ini file or something on each client machine that has the \\SERVER\PATH... entry.

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

  5. #5

    Thread Starter
    Lively Member
    Join Date
    Apr 2004
    Location
    Alabama
    Posts
    126

    Re: Simple Question about files/Server

    Is it a little too much to ask you to break that down just a little bit more? I'm not really a network person.

  6. #6
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Simple Question about files/Server

    Go into any folder - click on the TOOLS menu and select MAP network drive.

    Dialog box appears - allowing you to chose a DRIVE LETTER (defaults to Z: ) and then a path\folder to where that goes to.

    Avoid using Z: - some client machines might have already mapped Z: that's why I suggested going back further in the alphabet. R: was just a suggestion - it's really up to you. M: is sometimes used by EXCHANGE to map a virtual drive for e-mails. Obviously A: through F:, G: or H: should be avoided - potential for real drives on the client machine.

    At any rate, if you select R: and map it to the \\SERVERNAME\FOLDER of the location of the "large data", then you simply open that file with R: in the VB code.

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

  7. #7

    Thread Starter
    Lively Member
    Join Date
    Apr 2004
    Location
    Alabama
    Posts
    126

    Re: Simple Question about files/Server

    thanks! Very much!

  8. #8
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Simple Question about files/Server

    There ought to be a way to do this through a LOGON BAT file...

    On my SMALL BUSINESS SERVER, when we setup a user, they all execute a LOGON bat file.

    It looks like this:

    Code:
    net use g: \\server01\data
    net time \\server01 /set /y
    It maps G: to a folder on the server (\\server01\data).

    What type of network are these users on?

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

Posting Permissions

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



Click Here to Expand Forum to Full Width