Good Evening -
I am trying to use a web based application to produce reports from Crystal Reports 8 attached to a MAS90 ODBC.
Has anyone done this?
What is the proper Connection String?
I set up several SQL's to create the recordsets I need for the report but keep getting an error on the execute.
Set oConn = Server.CreateObject("ADODB.Connection"
strConnect= "DSN=SOTAMAS90;Directory=w:\90w\mas90;SERVER=SERVER"
cn.Open(strConnect)
set objTimeCard = Server.CreateObject("ADODB.Recordset"
strSQLTimeCard = "SELECT * from [TC1_TimeCardMasteFile] where DateWorked >='" & strStartDate & "' and DateWorked <='" & strEndDate & "'"
set objTimeCard = cn.execute(strSQLTimeCard)
Any help would be great.
I am trying to use a web based application to produce reports from Crystal Reports 8 attached to a MAS90 ODBC.
Has anyone done this?
What is the proper Connection String?
I set up several SQL's to create the recordsets I need for the report but keep getting an error on the execute.
Set oConn = Server.CreateObject("ADODB.Connection"
strConnect= "DSN=SOTAMAS90;Directory=w:\90w\mas90;SERVER=SERVER"
cn.Open(strConnect)
set objTimeCard = Server.CreateObject("ADODB.Recordset"
strSQLTimeCard = "SELECT * from [TC1_TimeCardMasteFile] where DateWorked >='" & strStartDate & "' and DateWorked <='" & strEndDate & "'"
set objTimeCard = cn.execute(strSQLTimeCard)
Any help would be great.