General discussion


help on vb6, mysql, and crystal reports

By dizyden ·

im using vb6 as my front end and mysql for the database....i want to learn on how to use crystal report on my applications...the first time i've used crystal report i've have problems in passing date parameters from vb to crystal report....hope you could help me with this problem

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by dizyden In reply to help on vb6, mysql, and c ...

update....i need help...

Collapse -

Crystal Reports & VB6 Date

by lea.pearson In reply to

I have not used VB6 with Crystal Reports but I guess the problem is a simple case of the Date format in VB6. You probably just need to convert it to another format which is compatible.

Collapse -

May be parameter format

by Will.Widgren In reply to Crystal Reports & VB6 Dat ...

I use Crystal Reports with .NET, and while learning have had problems as well. One thing I often overlooked was the format of the Parameter you created in Crystal reports. I think it defaults to String, so you have to change it.

Collapse -

Which version

by davidbranch In reply to May be parameter format

Whate version of crystal reports are you using?

Collapse -

VB 6 and Mysql databases version 4.1 or 5.0

by salusamuel In reply to help on vb6, mysql, and c ...

make sure you intall ODBC 3.51 driver. configure it in control panel if you are using windows. in you vb application, use this code in a module

Public Sub Connection()
'On Error GoTo ConnectError

Set conConnection = New ADODB.Connection
With conConnection
.CursorLocation = adUseClient
.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
& "SERVER=localhost;" _
& "DATABASE=StcokControlIntegration;" _
& "UID=root;" _
& "PWD=*****;" _
' & "OPTION=" & 3

End With
Exit Sub
MsgBox Err.Description
End Sub


this should work.

Collapse -


by meron_bisrat In reply to help on vb6, mysql, and c ...


I have no reply to ur question but I have a question myself.How can I make the communication between mysql,crystal report and vb6.

Related Discussions

Related Forums