I am on enterprise edition and am trying to investigate the ability of saleforce to access a SQL server database and run a query. I've searched everywhere to get a walkthrough or even a snippet on how to create a visualforce page that calls a query of a local database. Right now I am just trying to read data from a MSSQL database, but I wonder if this will lead to update, insert, or delete ability.

 

Can anyone help?

I was hoping to create a button that changes the value of a dropdown field on an opportunity. Here are the steps I would like to do:

Unlock a record
Change field called "Active"
Lock the record back.

I am on Enterprise edition and would love some direction and help. Thanks!

I was hoping to create a button that changes the value of a dropdown field on an opportunity. Here are the steps I would like to do:

Unlock a record
Change field called "Active"
Lock the record back.

I am on Enterprise edition and would love some direction and help. Thanks!