VB disabling VBscript on a ASP page

Hi,
I have a page that contains a Sub _onclick statement, followed by a SQL connection statement. The SQL statement will not run. I am told it is because I have VB code and VBscript code on the same page, and the VB code kills the VBscript code. Is that true? If yes, how do I fix it?
many thanks for your help

Hi:),

That's not true .....,Just post the code and I will examine it

Regards,
Andi Zain

hi, there it is

<script language="VBScript"><!--
Sub window_onLoad()
mrktco.Additem "CLC Marketing Ltd 69"
mrktco.Additem "Sunningdale 19"

end sub

--></script>
<script language="VBScript"><!--
Sub letsgo_Click()

if mrktco.text = "CLC Marketing Ltd 69" then selection = 69 end if
if mrktco.text = "Sunningdale 19" then selection = 19 end if

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DSN=CLCWEB;UID=****;PWD=*******;DATABASE=CLCACC;"

SQLcommand="exec clcacc..get_screen_3_amounts '"&selection &"'"
SET CA=Conn.Execute(SQLcommand)

if selection = "" then
msgbox "Please select a Marketing Company",32,"ICT Intranet"
end if

if selection = "69" then
Window.location.href = "http://sqlreports.clublacosta.com.local/SQLreports/Accounts/Developments/Screen_3_amounts.xls"
end if

if selection = "19" then
Window.location.href = "http://sqlreports.clublacosta.com.local/SQLreports/Accounts/Developments/screen_3_Amounts.xls"
end if

End Sub

--></script>

Hi:),

change this line of code from

Set Conn = Server.CreateObject("ADODB.Connection")

to

Set Conn = CreateObject("ADODB.Connection")




Regards,
Andi Zain

Hi

I get the message that this page is accessing a data source on another domain.

even if I say yes, it does not give me any results and stays on the same page.