| | | 
Supreme Being
       
Group: Forum Members Last Login: 6/21/2007 3:27:09 PM Posts: 95, Visits: 748 |
| | I want to copy the import.exe and import.exe.config files to a server and execute the process from there. Do I need a copy of Point installed? I'm trying to run the import right now and I'm getting "The Application has generated an exception that can not be handled." |
| | | | 
Sepal

Group: Moderators Last Login: Today @ 6:19:09 AM Posts: 1,183, Visits: 9,259 |
| | Import.exe is a .net application and the default security context will not let it run from a remote location. Point 5.1's version of import.exe has a strong name so you can set up a code access policy. go to the control panel open administrative tools click .net configuration 1.1 expand runtime security policy expand machine expand code groups expand all code right click localintranet_zone choose new. name it what you would like click next select Strong Name from the drop down click the import button and brows to import.exe and select it. click next. allow full trust just click next. click finished. it should now work on this system.
Disclaimer: This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post. |
| | | | 
Supreme Being
       
Group: Forum Members Last Login: 6/21/2007 3:27:09 PM Posts: 95, Visits: 748 |
| | I added it both to LocalIntranet_Zone and My_Computer_Zone. Neither worked. I am trying to run it from the D: drive on a 2000 server. |
| | | | 
Sepal

Group: Moderators Last Login: Today @ 6:19:09 AM Posts: 1,183, Visits: 9,259 |
| Sorry although that was the first thing to come to my mind, and is probably part of the issue you will need to make sure you have all of its dependancies in the same directory with import.exe pdd.dll, AesLib.dll, Sqlite.dll, sbautils.dll, sbaparam.dll, mfc71.dll, msvcp71.dll, msvcr71.dll and Implode.dll
Disclaimer: This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post. |
| | | | 
Supreme Being
       
Group: Forum Members Last Login: 6/21/2007 3:27:09 PM Posts: 95, Visits: 748 |
| | Adding the dependent DLLs worked. Thank you very much for your help. |
| | | | 
Supreme Being
       
Group: Forum Members Last Login: 6/21/2007 3:27:09 PM Posts: 95, Visits: 748 |
| | OK. When I double click my VB Script to execute the import statement with parameters, it works correctly. When I call the statement from the commandline (cscript ImportFiles.vbs or wscript ImportFiles.vbs), the import process does not work. Why? Here is the important parts of the VBS code I'm using. ======== importfiles.vbs =========== Option Explicit Const ImportDefinition = "Final.imp" Const ImportLocation = "J:\PROSPECT" Const ImportFile = "D:\ScheduledTasks\WebAppImport\ImportCode\Import.exe" Dim WshShell, ImportCommand Set WshShell = CreateObject("WScript.Shell")
ImportCommand = ImportFile & " " & FileName & " " &_ ImportDefinition & " " & ImportLocation Wscript.echo ImportCommand ' Debugging purposes WshShell.Run (ImportCommand, 1, true) Set WshShell = nothing ========== |
| | | | 
Supreme Being
       
Group: Forum Members Last Login: 6/21/2007 3:27:09 PM Posts: 95, Visits: 748 |
| | Adding a path to my ImportDefinition ImportDefinition = "G:\Final.imp" executing this from the commandline now give me the first error I posted. "Application has generated an exception that can not be handled." I have added the import.exe program all over the .Net 1.1 config. |
| | | | 
Sepal

Group: Moderators Last Login: Today @ 6:19:09 AM Posts: 1,183, Visits: 9,259 |
| sorry just want to make sure if you double click the vb script it still works right? Also where is FileName comming from?
Disclaimer: This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post. |
| | | | 
Supreme Being
       
Group: Forum Members Last Login: 6/21/2007 3:27:09 PM Posts: 95, Visits: 748 |
| | Copy and paste error. File namne is coming from part of the main pgm that parses the directory looking for files. it is a path to a CSV. Yes doubleclicking still works. Now I'm to the point of just trying to call the import.exe directly from the command line with arguments and it isn't working. |
| | | | |
|