Re: FLASH: database to Flash

[RedStar]

Cheri,


OK let's do a quick 101 on ODBC with web servers under win32


1-INTRO

Typically the web server is installed as an NT or Win95/98 service.

This means that the web server may not have the same environment and

permissions as the web developer.


2-Defining the DSN

2.1- Which type of DSN ?

You should use a system DSN and not a user DSN. The system DSN is global

while a user DSN is local to the user. As the web server will most

probably be logged in as a different user than the web developer this is

the reason why a script may work in all situations but when called from

the server fails.

2.2- the case of file based drivers

When using file based drivers a few tips will help ease the pain:

1-If the file is on an NTFS partition or on a remote computer check that

the web server has permissions to access that file.

2-If the file is on a remote computer try using a UNC path rather than

the c:\ notation. This is quite important as permissions and more

importantly drive mappings are not equal. The bad news is that some

drivers don't allow UNC paths. The workaround is to use regedit to

navigate to HKEY_LOCAL_USERS\SOFTWARE\ODBC\"Your DSN". Locate the DBQ

key. It's value is the full path to the file. Make the necessary

changes. Do this only if you know what you are doing ! Messing with

regedit can bring much pain.


.redstar.



flasher is generously supported by...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

  Streaming Media WEST '99 Conference & Exhibition

  "The Worlds largest Internet Audio & Video Event"

 December 7 - 9, San Jose Convention Center, California


Reserve your space today at http://www.streamingmedia.com

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

  To unsubscribe or change your list settings go to

http://www.chinwag.com/flasher or email

helpchinwag [dot] com