Member Avatar for anto_nee

can any one explain me about connecting data reports,ms sql and vb6.0

  • 2 Contributors
  • 1 Reply
  • 89 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by debasisdas

Dani AI

Generated

A compact, practical plan to get a VB6 DataReport showing SQL Server data today (for ). is right that tutorials exist, but here is a focused, tested workflow plus quick troubleshooting so the job finishes without chasing pages.

Two quick ways: visual (Data Environment + Data Report) or code (ADO recordset bound to the report). Visual is fastest when you can design at design time: create a Data Environment that connects to SQL Server, add a Command (set its SQL or stored proc and parameters), then drag fields from the Data Environment onto the Data Report layout. At runtime the Data Report will use the Data Environment recordset and Show will display it.

If you prefer code or need dynamic SQL, open an ADODB connection and recordset, assign the recordset to the DataReport.DataSource, then show the report. Example pattern:

Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset

Set cn = New ADODB.Connection
cn.Open "Provider=SQLOLEDB;Data Source=SERVERNAME;Initial Catalog=DBNAME;Integrated Security=SSPI;"

Set rs = New ADODB.Recordset
rs.Open "SELECT * FROM MyTable", cn, adOpenStatic, adLockReadOnly

Set DataReport1.DataSource = rs
DataReport1.Show

Quick troubleshooting: add a project reference to "Microsoft ActiveX Data Objects 2.x Library" before using ADO constants; test the SQL connection separately (UDL/SSMS/ODBC) to isolate auth or driver issues; if the Data Report item is missing, verify your VB6 install included the Data Report Designer. Note that VB6/DataReport are legacy components—if deployment machines lack VB6 runtimes or 32-bit DB drivers, install the correct runtime/driver or use a simple CSV export as a last-minute fallback.

Member Avatar for debasisdas

u can easily find all that in this site or by little web-searching.
you only need to help your self in doing all that search.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.