Scripting Problem

Hello Good Day, I have tried to used VBScript in Print Distributor. I know this is a valid VBScript but when I put it in Print Distributor it will give an error in the log file. This is the VBScript Code.

dim cn

dim rs

dim strConnection



Set cn = CreateObject("ADODB.Connection")

Set rs = CreateObject("ADODB.Recordset")



strConnection = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Projects.mdb"

cn.open strConnection

and the error message is "13/06/2008 14:17 Syntax error in line: 9 column: 1 in .\source\actions.cpp at 1715" which point to this line "cn.open strConnection". What I have done wrong? Hope you could help me with this.


Chris Ian Fiel

Chris,

Although it says syntax error it probably isn't. It might be a permissions problem, if you are running the Print Distributor service under an account which doesn't have access to the connection it could be causing a problem.