Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Reports w/ODBC to MAS90 using ASP

Status
Not open for further replies.

bbyrd36

Programmer
Oct 3, 2001
3
US
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 = &quot;SELECT * from [TC1_TimeCardMasteFile] where DateWorked >='&quot; & strStartDate & &quot;' and DateWorked <='&quot; & strEndDate & &quot;'&quot;

set objTimeCard = cn.execute(strSQLTimeCard)

Any help would be great.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top