Re: FLASH: database to Flash

[D]

If you are infact trying to set up the DSN on your local machine (assuming

it is Win9.X).. here is how you do it.... it will vary slightly depending on

the type of database you are using... so I'm going to give you the

instructions for MS access...


start > settings > control panel > ODBC Sources > System DSN tab


Click the "add" button. You will now see a list of available ODBC

drivers.... Select the appropriate one...

In this case MS Access...

Once highlighted, click the "finish" button.

You will now get the configuration screen for the access ODBC connection..


type in your datasource name (can be whatever you want it to be-but remember

it... because this is how you will need to make the ASP connection).. then

type in the description for your data source... again anything you want it

to be.


Now you need to select or create the database you want to use.... if you

have an existing one, press the "select" button which will basicly allow you

to browse to the location of the database. Be sure that if it is an existing

one, that it is located outside your web... or it will not work.


Or if you need to create a new one.... press the "create" button.. this

again will allow you to browse to where you want the file to be located...

again make sure that it is outside of your web.


**Next two steps are optional**


If you want the database to be  password protected, press the "advanced"

button.


If you want to modify the buffer size of time out options, press the

"options" button.


Your DSN is now created, and you should be able to call it from your ASP

script. Once you upload the flash to the server, the server will need to be

config'd to have the same DSN.


And obviously, if you use other database types like Sequel (SQL) Server,

etc, the setup will be a little different in the config screens.


If you have any questions, please feel free to mail me off list.


-dk-









----- Original Message -----

From: "Cheri Harder" <

chericahome [dot] com

>

To: <

flasherchinwag [dot] com

>

Sent: January 16, 2000 1:31 PM

Subject: Re: FLASH: database to Flash



> Hi, D.  Yes, you hit my question right on the head...at least I think I

know

> how to ask it, now.  How do I get a system DSN put up on the server...  I

> know how to set up a local file as a data source with ODBC configuration,

> don't know how to do it on the "Server" side of my machine (Personal Web

> Server being the "server" side)

>

> I suppose it would be the same question if I were using Access as the

> database, or any other database...I just need to be able to test the Flash

> connection to a database on my own computer, with ASP.  Maybe I'm going

> about it all wrong, but seems like I'm so close...

>

> ~~~~Cheri Harder~~~~~

>

charderawsolution [dot] com

> Advantage Web Solution

> "Developing your internet storefront"

> www.awsolution.com

>

>

> > You need to  get a system DSN put up on the server...  Or you can do it

> with

> > a DSNless connection....

>

>

>

>

> 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

>

>




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