Web Development

Ask something
Discussion Locked

help on vb6, mysql, and crystal reports

0 helpful
6 replies

by dizyden

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

hi

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

6 replies

by lea.pearson

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.

by will.widgren

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.

by salusamuel

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

.Open
End With
Exit Sub
ConnectError:
MsgBox Err.Description
End Sub

-----------------------

this should work.

by meron_bisrat

Hi,

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.

This discussion is closed to new replies.