p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   Visual Basic 2008 Essentials (http://p2p.wrox.com/visual-basic-2008-essentials-358/)
-   -   Error 3709 moving script to 2008 server (http://p2p.wrox.com/visual-basic-2008-essentials/94616-error-3709-moving-script-2008-server.html)

cdaye99 June 17th, 2015 11:58 AM

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


All times are GMT -4. The time now is 11:19 PM.

Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
2013 John Wiley & Sons, Inc.