I have a SQL query:
select distinct vt_contact.vt_folder_id, jobmaster.customernumber
from fp_vticket.dbo.vt_contact, confirm.dbo.jobmaster
where vt_folder_id = customernumber
This uses two SQL databases: fp_vticket and confirm.
The problem occurs when I have two include files on my ASP page:
<!-- #include file="database_connection.asp" -->
<!-- #include file="database_connection2.asp" -->
Microsoft VBScript compilation error '800a0411'
/FPNew2/client/database_connection2.asp, line 14
I understand why, but how do I work around this. Code for the
database_connection file attached (both files are the same except for the name
of the database).
Thanks in advance for a solution to this one!