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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Crystal Report whith ASP

Status
Not open for further replies.

JCooL

Programmer
Oct 21, 2001
89
US
Hi there,

I got a Crystal Report with ASP sample, but on it i have to connect by a ODBC, i'll want connect using the string connection.

This is the way of the crystal sample code

Set oADOConnection = Server.CreateObject("ADODB.Connection")

oADOConnection.Open ("Sample Database")

Set oADORecordset = Server.CreateObject("ADODB.Recordset")

Set oADORecordset = oADOConnection.Execute("Select [Employee ID],[First Name], [Last Name] From Employee")

Set oRptTable = session("oRpt").Database.Tables.Item(1)
oRptTable.SetPrivateData 3, oADORecordset

Thanks to advance
 
um... so what's the question??

_________________________________________________________
for the best results to your questions: FAQ333-2924
01001111 01101110 01110000 01101110 01110100
onpnt2.gif
[/sub]
 
How can i use

provider=microsoft.jet.oledb.4.0;data source=" & server.MapPath("data\table.mdb")

instead of

ODBC connection

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top