Database Login In Crystal

[Atley]

I have created a report in Crystal and it runs fine and comes up in the
viewer and everything is great in my little world, EXCEPT:

It always prompts me for a password to the database, even after I extended
my code to include:

Private Sub frmReportViewer_Load(ByVal Sender as System.Object, ByVal e as
System.EventArgs) Handles MyBase.Load

Dim MyReport as New rptFinishedGoods
MyReport.SetDatabaseLogin("tryingtofind","theanswe r","CSISQL","CSI")
Me.CrystalReportViewer1.ReportSource = MyReport
End Sub
What in the world am I doing wrong?

[Ken Onweller \(.NET MCSD\)]

Try Brian Bischof's book, especially the chapter on Database Connectivity.

http://www.crystalreportsbook.com

"Atley" <at*****@hotmail.com> wrote in message
news:eZ**************@TK2MSFTNGP11.phx.gbl...

I have created a report in Crystal and it runs fine and comes up in the
viewer and everything is great in my little world, EXCEPT:

It always prompts me for a password to the database, even after I extended
my code to include:

Private Sub frmReportViewer_Load(ByVal Sender as System.Object, ByVal e as
System.EventArgs) Handles MyBase.Load

Dim MyReport as New rptFinishedGoods
MyReport.SetDatabaseLogin("tryingtofind","theanswe r","CSISQL","CSI")
Me.CrystalReportViewer1.ReportSource = MyReport
End Sub
What in the world am I doing wrong?

[Atley]

I did not find anything in that book that helped me with this issue, any
other suggestions?
"Ken Onweller (.NET MCSD)" <an*******@discussions.microsoft.com> wrote in
message news:ee*************@TK2MSFTNGP09.phx.gbl...

Try Brian Bischof's book, especially the chapter on Database Connectivity.

http://www.crystalreportsbook.com

"Atley" <at*****@hotmail.com> wrote in message
news:eZ**************@TK2MSFTNGP11.phx.gbl...

I have created a report in Crystal and it runs fine and comes up in the
viewer and everything is great in my little world, EXCEPT:

It always prompts me for a password to the database, even after I extended my code to include:

Private Sub frmReportViewer_Load(ByVal Sender as System.Object, ByVal e as System.EventArgs) Handles MyBase.Load

Dim MyReport as New rptFinishedGoods
MyReport.SetDatabaseLogin("tryingtofind","theanswe r","CSISQL","CSI")
Me.CrystalReportViewer1.ReportSource = MyReport
End Sub
What in the world am I doing wrong?

[scorpion53061]

Yes.

Don't use crystal.
Use Word Automation.

"Atley" <at*****@hotmail.com> wrote in message
news:uX****************@TK2MSFTNGP09.phx.gbl...

I did not find anything in that book that helped me with this issue, any
other suggestions?
"Ken Onweller (.NET MCSD)" <an*******@discussions.microsoft.com> wrote in
message news:ee*************@TK2MSFTNGP09.phx.gbl...

Try Brian Bischof's book, especially the chapter on Database Connectivity.

http://www.crystalreportsbook.com

"Atley" <at*****@hotmail.com> wrote in message
news:eZ**************@TK2MSFTNGP11.phx.gbl...

I have created a report in Crystal and it runs fine and comes up in the viewer and everything is great in my little world, EXCEPT:

It always prompts me for a password to the database, even after I

extended my code to include:

Private Sub frmReportViewer_Load(ByVal Sender as System.Object, ByVal e as

System.EventArgs) Handles MyBase.Load

Dim MyReport as New rptFinishedGoods

MyReport.SetDatabaseLogin("tryingtofind","theanswe r","CSISQL","CSI") Me.CrystalReportViewer1.ReportSource = MyReport
End Sub
What in the world am I doing wrong?