airvector
asked on
Crystal Report Prompted Database Login
Everything run well on Dev Machine.
Testing on client prompted Database Login
Tried entering the required information does not work, kept saying Login failed no matter what.
Tried on vb.net
objReport.SetDatabaseLogon ("user", "pass")
still isn't going thru
on the rpt file i used connectionstring:
DRIVER={MySQL ODBC 5.1 Driver};DATABASE=mydb;OPTI ON=3;SERVE R=myServer ;UID=myUse r;PWD=myPa ssword
Testing on client prompted Database Login
Tried entering the required information does not work, kept saying Login failed no matter what.
Tried on vb.net
objReport.SetDatabaseLogon
still isn't going thru
on the rpt file i used connectionstring:
DRIVER={MySQL ODBC 5.1 Driver};DATABASE=mydb;OPTI
ASKER
Test was done using same Database, user, pass, server
vb.net used:
With crConnectionInfo
.ServerName = "server"
.DatabaseName = "db1"
.UserID = "client"
.Password = "pass"
End With
Crystal Report Document uses:
DRIVER={MySQL ODBC 5.1 Driver};DATABASE=mydb;OPTI ON=3;SERVE R=myServer ;UID=myUse r;PWD=myPa ssword
vb.net used:
With crConnectionInfo
.ServerName = "server"
.DatabaseName = "db1"
.UserID = "client"
.Password = "pass"
End With
Crystal Report Document uses:
DRIVER={MySQL ODBC 5.1 Driver};DATABASE=mydb;OPTI
Are you changing the database as it appears since the last line has different values from the connection info.
mlmcc
mlmcc
ASKER
this is my script that i tried
it works on Dev machine and not on the client
it works on Dev machine and not on the client
Dim CRViewer As New FormCrystalViewer
Dim CRViewer As New FormCrystalViewer
Dim objReport As New ReportDocument
'Load Crystal Report File
objReport.Load(My.Settings.CR_PATH & "CRLateOrders.rpt")
Dim crTableLogonInfos As New TableLogOnInfos
Dim crTableLogonInfo As New TableLogOnInfo
Dim crConnectionInfo As New ConnectionInfo
Dim crTables As Tables
Dim crTable As Table
With crConnectionInfo
'.ServerName = "server"
'.DatabaseName = "db"
.UserID = "client"
.Password = "pw"
End With
crTables = objReport.Database.Tables
For Each crTable In crTables
crTableLogonInfo = crTable.LogOnInfo
crTableLogonInfo.ConnectionInfo = crConnectionInfo
crTable.ApplyLogOnInfo(crTableLogonInfo)
Next
CRViewer.CRViewer.ReportSource = objReport
CRViewer.Show()
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Totally forgot about that
mlmcc