View Single Post
  #1 (permalink)  
Old June 17th, 2015, 12:58 PM
cdaye99 cdaye99 is offline
Registered User
Points: 27, Level: 1
Points: 27, Level: 1 Points: 27, Level: 1 Points: 27, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2008
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
Reply With Quote