Error 3709 moving script to 2008 server
I have a script that has run fine on Windows server 2003, but when I moved it to 2008 I get error 3709 when trying to connect to the file. Any ideas on what changes between 2003 and 2008?
Thanks Chuck
Const adOpenStatic = 3
Const adLockOptimistic = 3
Const adCmdText = &H0001
'Open Loan input file
Set objLoanConnection = CreateObject("ADODB.Connection")
Set rsLoanFile = CreateObject("ADODB.Recordset")
rsLoanFile.Index = LoanNUM
On Error Resume Next
objLoanConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strInput_file_path & ";" & _
"Extended Properties=""text;HDR=YES;FMT=Delimited"""
rsLoanFile.Open "SELECT * FROM Loan.txt", _
objLoanConnection, adOpenStatic, adLockOptimistic, adCmdText
|