Updating custom table in Mediabin repository

hi there,

I am looking at capturing some user information in a custom table created in the Mediabin repository. There is a custom form which a user fills out before downloading/emailing an asset from mediabin. The info in the form should be inserted into the database table that has been created. Is there any documentation on how this can be done? Is it just ASP code with opening a connection to DB, executing SQL query and closing the connection? Are there any pre-defined functions/APIs that can be used?

Appreciate any ideas/help.

Thanks,
Resh

Find more posts tagged with

Comments

msrinivas

You should be able to do it the ASP way. I would highly recommend that your custom data be stored in a seaprate DB from the MediaBin Repository DB in SQL Server.

HTH

Migrateduser

The ASP web client never opens database connections in order to better "fit" into secure installations that desire to have only a minimal number of ports open on their firewall. The typical configuration is: web server outside the firewall and MediaBin server inside; one port is opened to allow the web client to communicate with MediaBin server.
Therefore, if you wanted to "capture" information from the client application, you would need to create new code to write to a database. I'm guessing your web server is behind the firewall (on the intranet only), so opening additional ports is not an issue.

lyman

I will second the recommendation to use a separate DB. The you really could use out-of-the-box ASP provided your web server can see this database, without having to worry about compromising MediaBin security.

Cheers,

Lyman Hurd