alwaysAnewbie
Programmer
I am trying to access a database via the UNC. The short of it is I can write to and read from the directory using:
Set ScriptObject = Server.CreateObject("Scripting.FileSystemObject"
Set MyFile = ScriptObject.OpenTextFile("\\nt3\care\vcare4x\database\fc01\testfile.txt", 8,true)
I get the dreaded 80004005 Microsoft Jet database engine cannot open the file '(unknown)'. when I try this code:
MdbFilePath = "\\nt3\CARE\VCARE4X\DATABASE\FC01\vc40clin_IIS.mdb"
Conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";"
The application is running as a domain user. Everyone has full control of %TEMP% and %TMP%.
Why does the FSO work but not the ADO?
Set ScriptObject = Server.CreateObject("Scripting.FileSystemObject"
Set MyFile = ScriptObject.OpenTextFile("\\nt3\care\vcare4x\database\fc01\testfile.txt", 8,true)
I get the dreaded 80004005 Microsoft Jet database engine cannot open the file '(unknown)'. when I try this code:
MdbFilePath = "\\nt3\CARE\VCARE4X\DATABASE\FC01\vc40clin_IIS.mdb"
Conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";"
The application is running as a domain user. Everyone has full control of %TEMP% and %TMP%.
Why does the FSO work but not the ADO?
