Hi there, been trying to extract a CSV out of this database but for some reason, I'm getting this error.
Line 57
Char 2
Permission denied
800A0046
Microsoft VBScript runtime error
Line 57 is in bold.
Set outFile = FSO.OpenTextFile(path_output, 8, True)
Set con = CreateObject("ADODB.Connection")
con.ConnectionString="Provider=VFPOLEDB.1;Data Source=" & path_input & ";Mode=Share Deny None;Extended Properties="";User ID="";Password="";Mask Password=False;Cache Authentication=False;Encrypt
Password=False;Collating Sequence=MACHINE;DSN="";DELETED=True;CODEPAGE=1252;MVCOUNT=16384;ENGINEBEHAVIOR=90;TABLEVALIDATE=3;REFRESH=5;VARCHARMAPPING=False;ANSI=True;REPROCESS=5;"
con.Open
Set rs = con.execute(sql_query)
count = rs.fields.Count
write_element "Name", count, rs, outFile, separator
do until rs.EOF
write_element "Value", count, rs, outFile, separator
rs.MoveNext
loop
Permissions and security are accessible on all folders, subfolders and files in them. What gives, in this case? Is there anything else that I might have missed out?