I am attempting to search a database by partnumber by using a join of a batch entered file of partnumbers. The test code is below. I don't have any problem with the connection as I can see both the SQL in a recordset and the text file values with Dreamweaver recordsets. I don't have a problem if the join is two tables in a single connection. The problem seems to be how to connection and define two different connections. It seems to be the way I am setting up the connections either through a command or conneciton object or my approach.

There seems to be a method of using the IN to specify known types for external reference like dbase IV type etc. However a suggested method was to use the Microsoft Text File driver to connect to the text which works in isolation. It just seems I can't get the syntax write for two different connections in the same SELECT.


Help???

<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../Connections/arrowhead.asp" -->
<!--#include file="../Connections/lsprint.asp" -->
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
'Dim MM_arrowhead_STRING
'MM_arrowhead_STRING = "dsn=arrowhead;uid=xxx;pwd=xxx;"
%>
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
'Dim MM_lsprint_STRING
'MM_lsprint_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\url/public;Extended Properties=Text;"
%>
<HTML>
<HEAD>
<TITLE>Parts OBS Seach by Batch</TITLE>
</HEAD>
<BODY>
<%
Dim objCommandA, objRSA
Set objCommandA = Server.CreateObject("ADODB.Command")

objCommandA.ActiveConnection = MM_arrowhead_STRING




objCommandA.CommandText = "SELECT hawker.Summarytest.PartNumber,LSPRINT#TXT.PARTNUMB ER " & _
"FROM LSPRINT#TXT INNER JOIN hawker.SummaryTest " & _
"ON hawker.Summarytest.PartNumber = LSPRINT#TXT.PARTNUMBER"
' objCommandA.CommandType = adCmdText

Set objRSA = objCommandA.Execute
Set objCommandA = Nothing


While Not objRSA.EOF
Response.Write objRSA("PARTNUMBER") & "<BR>"
objRSA.MoveNext
Wend

objRSA.Close
Set objRSA = Nothing
objRSL.Close
Set objRSL = Nothing
%>
</BODY>
</HTML>