Go to same server to get the database...

[heyhey84]

I had make a drop-down list. I want to make it link to the same server to get different database.

<p><b>Select:
<select name=&quot;country&quot;>
<option value =&quot;singapore&quot;>Singapore</option>
<option value =&quot;malaysia&quot;>Malaysia</option>
<option value =&quot;china&quot;>China</option>
</select>
</p>
<script type=&quot;text/vbscript&quot;>
select case OPTION
case &quot;singapore&quot;
set objConn2.ConnectionString = &quot;dsn=a;uid=sa;pwd=sa;&quot;
case &quot;malaysia&quot;
set objConn2.ConnectionString = &quot;dsn=b;uid=sa;pwd=sa;&quot;
case else
end select
</script>

It cannot work. May i know why?