Deploying Crystal Repoorts on many MSSQL Servers?

Hi, I' created some crystal reports and in my frontend I'm setting the table logon infor like:
CrystalReport.SetAllTablesLogOnInfo(GLO:DSN,GLO:DSNDB,GLO:DSNUser,GLO:DSNPassword,true)
where I am first priming the GLO:Variables.

IF this format does not look familiar it's because my front end app is developed with Clarion 5.5 Anyway it's looking for a DSN name but I want to be able to use a physical server name? We have about 30 servers in this intranet and I really don't want to have to create DSN's for them all. All of the servers are running MSSQL 2000 and all DB's have the same name and tables.

What is the best practices method of distributing my reports across the intranet? How should I approach this for the best solution.?

Many Thanks,
James
jhreddAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
I haven't seen the ability to use a physical server name except if you use an ADO or OLE connection.  Apparently your reports are built using a dsn connection and in that case you will need to build a dsn to all databases

mlmcc
0
jhreddAuthor Commented:
How can I design the report with the physical server info so I can call it at runtime by the physical server name?

Thanks
James
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jhreddAuthor Commented:
Hi, you are right of course. I had to use an ole db connection.

Thank You,
James
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.