General discussion

Locked

help on vb6, mysql, and crystal reports

By dizyden ·
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

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| 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

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

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


this should work.

Collapse -

qn

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

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.

Back to Web Development Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums