By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,573 Members | 1,824 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,573 IT Pros & Developers. It's quick & easy.

Substitute DSN with data source authenication at runtime to view/access Crystal reports

P: n/a
I created several CR reports (in r8.5 and r10) using a system DSN named
"CrystalUser" with username and login ID and use them in my VB.NET app. In
order for my clients to run the
report, the same DSN must be created in their machine. I would like to know
if I can substitute the DSN at runtime with info provided by the VB.NET
application instead.

Your help is greatly appreciated.

Bill

Nov 21 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
http://www.vbcity.com/forums/topic.asp?tid=99737
"Bill Nguyen" <bi*****************@jaco.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
I created several CR reports (in r8.5 and r10) using a system DSN named
"CrystalUser" with username and login ID and use them in my VB.NET app.
In order for my clients to run the
report, the same DSN must be created in their machine. I would like to
know
if I can substitute the DSN at runtime with info provided by the VB.NET
application instead.

Your help is greatly appreciated.

Bill

Nov 21 '05 #2

P: n/a
On Sat, 7 May 2005 20:07:33 -0700, "Bill Nguyen"
<bi*****************@jaco.com> wrote:
I created several CR reports (in r8.5 and r10) using a system DSN named
"CrystalUser" with username and login ID and use them in my VB.NET app. In
order for my clients to run the
report, the same DSN must be created in their machine. I would like to know
if I can substitute the DSN at runtime with info provided by the VB.NET
application instead.

Your help is greatly appreciated.

Bill
I got this code from Crystal

Dim objTab As CrystalDecisions.CrystalReports.Engine.Table
Dim objLogInf As CrystalDecisions.Shared.TableLogOnInfo
For Each objTab In cr.Database.Tables
objLogInf = objTab.LogOnInfo
objLogInf.ConnectionInfo.ServerName = "Server"
objLogInf.ConnectionInfo.Password = "password"
objLogInf.ConnectionInfo.UserID = "user"
objTab.ApplyLogOnInfo(objLogInf)
Next

Doug Taylor


Nov 21 '05 #3

P: n/a
Doug;
I added this to my routine (using Reportdocument control) and it's not
working. It seemed to me that the table login was ingnored, the app still
looking for DSN info.
How did you get it work in your app?
THanks
Bill

"Doug Taylor" <Do************@tayNOSPAMmade.demon.co.uk> wrote in message
news:oo********************************@4ax.com...
On Sat, 7 May 2005 20:07:33 -0700, "Bill Nguyen"
<bi*****************@jaco.com> wrote:
I created several CR reports (in r8.5 and r10) using a system DSN named
"CrystalUser" with username and login ID and use them in my VB.NET app.
In
order for my clients to run the
report, the same DSN must be created in their machine. I would like to
know
if I can substitute the DSN at runtime with info provided by the VB.NET
application instead.

Your help is greatly appreciated.

Bill


I got this code from Crystal

Dim objTab As CrystalDecisions.CrystalReports.Engine.Table
Dim objLogInf As CrystalDecisions.Shared.TableLogOnInfo
For Each objTab In cr.Database.Tables
objLogInf = objTab.LogOnInfo
objLogInf.ConnectionInfo.ServerName = "Server"
objLogInf.ConnectionInfo.Password = "password"
objLogInf.ConnectionInfo.UserID = "user"
objTab.ApplyLogOnInfo(objLogInf)
Next

Doug Taylor

Nov 21 '05 #4

P: n/a
Mad;
This looks like something good for creating DSN in client machines. I'll
work on it and get back to you.
Thanks for your help.
Bill

"Mad Murdoch" <ma*@here.net> wrote in message
news:um**************@TK2MSFTNGP09.phx.gbl...
http://www.vbcity.com/forums/topic.asp?tid=99737
"Bill Nguyen" <bi*****************@jaco.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
I created several CR reports (in r8.5 and r10) using a system DSN named
"CrystalUser" with username and login ID and use them in my VB.NET app.
In order for my clients to run the
report, the same DSN must be created in their machine. I would like to
know
if I can substitute the DSN at runtime with info provided by the VB.NET
application instead.

Your help is greatly appreciated.

Bill


Nov 21 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.