I'll show you the code that I'm using, then I'll give you the error.
This is process.asp here.
<% Language=VBScript %>
<% Response.Buffer = True %>
<!-- #include file="jobinclude.asp" -->
<!-- #include file="officeinclude.asp" -->
<%
Dim objConn, objJob, strJob
Set fdfacx = Server.CreateObject("Fdfapp.fdfapp"
Set fdfNew = fdfacx.FDFCreate
strJob = request.querystring("job"
blnValid = JobValidity(strjob)
...
%>
-------------------------
This is jobinclude.asp
<%
Function JobQuery(strJob)
Set objConn = CreateObject("ADODB.Connection"
objConn.ConnectionString =
"Provider=MSDASQL.1;Persist Security
Info=False;Extended Properties=""Driver={Microsoft Visual FoxPro Driver};UID=;SourceDB=\\fshv5\vol2\SOFTWARE\Mars\tlmarcor.dbc;SourceType=DBC;Exclusive=No;Back
groundFetch=No;Collate=Machine;Null=Yes;Deleted=Yes;"&q
uot;"
objConn.Open
Set objJob = CreateObject("ADODB.Recordset"
Set objJob.ActiveConnection = objConn2
strQuery = "SELECT custname FROM jobs WHERE job
= '" & Trim(strjob) & "'"
objJob.Open strQuery
JobQuery = objJob
End Function
Function JobValidity(strJob)
objQuery = JobQuery(strJob)
If objQuery.BOF = True and objQuery.EOF = True Then
JobValidity = False
else
JobValidity = True
End If
End Function
...
%>
---------------------------
And here's the error I get.
[Microsoft][ODBC Visual FoxPro Driver]Cannot open file \\fshv5\vol2\SOFTWARE\Mars\tlmarcor.dbc
---------------------------
Strange thing is... it works perfectly in ColdFusion or even a DLL file on the server. So why does this one fail? Do I have to move the include file off the server - which seems like something I can't do? (Connecting remotely or saving in the directories of the server is things I can't seem to do for some reason... works anywhere else on the hard drive)
Thanks for any help that you may have.
This is process.asp here.
<% Language=VBScript %>
<% Response.Buffer = True %>
<!-- #include file="jobinclude.asp" -->
<!-- #include file="officeinclude.asp" -->
<%
Dim objConn, objJob, strJob
Set fdfacx = Server.CreateObject("Fdfapp.fdfapp"
Set fdfNew = fdfacx.FDFCreate
strJob = request.querystring("job"
blnValid = JobValidity(strjob)
...
%>
-------------------------
This is jobinclude.asp
<%
Function JobQuery(strJob)
Set objConn = CreateObject("ADODB.Connection"
objConn.ConnectionString =
"Provider=MSDASQL.1;Persist Security
Info=False;Extended Properties=""Driver={Microsoft Visual FoxPro Driver};UID=;SourceDB=\\fshv5\vol2\SOFTWARE\Mars\tlmarcor.dbc;SourceType=DBC;Exclusive=No;Back
groundFetch=No;Collate=Machine;Null=Yes;Deleted=Yes;"&q
uot;"
objConn.Open
Set objJob = CreateObject("ADODB.Recordset"
Set objJob.ActiveConnection = objConn2
strQuery = "SELECT custname FROM jobs WHERE job
= '" & Trim(strjob) & "'"
objJob.Open strQuery
JobQuery = objJob
End Function
Function JobValidity(strJob)
objQuery = JobQuery(strJob)
If objQuery.BOF = True and objQuery.EOF = True Then
JobValidity = False
else
JobValidity = True
End If
End Function
...
%>
---------------------------
And here's the error I get.
[Microsoft][ODBC Visual FoxPro Driver]Cannot open file \\fshv5\vol2\SOFTWARE\Mars\tlmarcor.dbc
---------------------------
Strange thing is... it works perfectly in ColdFusion or even a DLL file on the server. So why does this one fail? Do I have to move the include file off the server - which seems like something I can't do? (Connecting remotely or saving in the directories of the server is things I can't seem to do for some reason... works anywhere else on the hard drive)
Thanks for any help that you may have.