473,701 Members | 2,731 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

VB.NET/Crystal - How do I change a report's connection "integrated security" to FALSE?

I am writing a Windows forms VB.Net/MS SQL application via VS 2003 that
utilizes Crystal Reports. I want to be able to dynamically set the
report data source at run time.

I'm trying to change the the reports "integrated security" from TRUE to
FALSE via the "Set Location" dialog in the report designer with no
success. It is not intuitive (at least not to me.)

I get the following error:

"Error in file....Invalid table number."

The error is being generated at this line of my code:

'DatabaseName is changing at runtime, specify the table location.
CrTable.Locatio n = "UpsizeUATSQLBa ckup.dbo." &
CrTable.Locatio n.Substring(CrT able.Location.L astIndexOf(".") + 1)

If I change "UpsizeUATSQLBa ckup.dbo." to the original db location i.e.
"UpsizeUATSQL.d bo" it works fine.

I've seen other posts on the web that state that the "integrated
security" for the report connection has to be FALSE, otherwise the
connection is hard coded into the report.

Article c2011430 on CR support site seems to indicate that you can
change it in Crystal 9, where previously you could not, due to a bug.

My question is how do I change the report's connection "integrated
security" to FALSE?

Tks for any guidance/help you can provide.

....Henry
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 20 '05 #1
7 11245
Henry <an*******@devd ex.com> wrote in news:eXRfCpbdEH A.2384
@TK2MSFTNGP09.p hx.gbl:
I am writing a Windows forms VB.Net/MS SQL application via VS 2003 that
utilizes Crystal Reports. I want to be able to dynamically set the
report data source at run time.


Why don't you pass a dataset instead?

--
Lucas Tam (RE********@rog ers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 20 '05 #2
Hi Henry,

Sorry; I was out all evening and just saw your post.

I am changing mine in crystal 10.0, however it should also work in cr 9.

Go to set location; then select 'new connection'; connect via ole db; when
it asks for a pwd and login, enter the appropriate sql server login; check
or uncheck for integrated security, etc. Once finished, you should check
properties and it should show the connection as integrated security false.

HTH,

Bernie Yaeger

"Henry" <an*******@devd ex.com> wrote in message
news:eX******** ******@TK2MSFTN GP09.phx.gbl...
I am writing a Windows forms VB.Net/MS SQL application via VS 2003 that
utilizes Crystal Reports. I want to be able to dynamically set the
report data source at run time.

I'm trying to change the the reports "integrated security" from TRUE to
FALSE via the "Set Location" dialog in the report designer with no
success. It is not intuitive (at least not to me.)

I get the following error:

"Error in file....Invalid table number."

The error is being generated at this line of my code:

'DatabaseName is changing at runtime, specify the table location.
CrTable.Locatio n = "UpsizeUATSQLBa ckup.dbo." &
CrTable.Locatio n.Substring(CrT able.Location.L astIndexOf(".") + 1)

If I change "UpsizeUATSQLBa ckup.dbo." to the original db location i.e.
"UpsizeUATSQL.d bo" it works fine.

I've seen other posts on the web that state that the "integrated
security" for the report connection has to be FALSE, otherwise the
connection is hard coded into the report.

Article c2011430 on CR support site seems to indicate that you can
change it in Crystal 9, where previously you could not, due to a bug.

My question is how do I change the report's connection "integrated
security" to FALSE?

Tks for any guidance/help you can provide.

...Henry
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 20 '05 #3
I was able to change "integrated security" to FALSE by pausing mySQL Server & then, in the report designer, I right click on theFieldExplore r/DatabaseFields and select 'Verify Database' fromthe menu. Since it can't find the database, it prompts for theconnection info. Start-up SQL server again & then fill out theconnection info (with integrated security unchecked). Then saveyour report.

:>kris
I am writing a Windows forms VB.Net/MS SQL application via VS2003 that
utilizes Crystal Reports. I want to be able to dynamically setthe
report data source at run time.

I'm trying to change the the reports "integrated security" fromTRUE to
FALSE via the "Set Location" dialog in the report designer withno
success. It is not intuitive (at least not to me.)

I get the following error:

"Error in file....Invalid table number."

The error is being generated at this line of my code:

'DatabaseName is changing at runtime, specify the tablelocation.
CrTable.Locatio n = "UpsizeUATSQLBa ckup.dbo." &
CrTable.Locatio n.Substring(CrT able.Location.L astIndexOf(".") +1)

If I change "UpsizeUATSQLBa ckup.dbo." to the original dblocation i.e.
"UpsizeUATSQL.d bo" it works fine.

I've seen other posts on the web that state that the"integrated
security" for the report connection has to be FALSE, otherwisethe
connection is hard coded into the report.

Article c2011430 on CR support site seems to indicate that youcan
change it in Crystal 9, where previously you could not, due toa bug.

My question is how do I change the report's connection"inte grated
security" to FALSE?

Tks for any guidance/help you can provide.

....Henry
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

User submitted from AEWNET (http://www.aewnet.com/)
Nov 21 '05 #4
Hi,

ON Crystal 10 (perhaps 9 as well):
1. go to 'set database location'
2. in the top, open the name of the server and properties until you see the
tables
3. on the bottom, click 'history'
4. select the server name in the bottom
5. you will now see a connection info request
6. fill out the request and enter user id and pwd; uncheck 'use integrated
security'
7. click next
8. click finish
9. now select the table to replace the table above - same name
10. click the 'update' button

You're done. I had to do this to over 150 reports some time ago. It's a
bit buggy, so after you save, reopen the report to verify that the change
'took'.

HTH,

Bernie Yaeger
"Guest" <Guest@aew_nosp am.com> wrote in message
news:Op******** ******@TK2MSFTN GP14.phx.gbl...
I was able to change "integrated security" to FALSE by pausing my SQL Server
& then, in the report designer, I right click on the
FieldExplorer/DatabaseFields and select 'Verify Database' from the menu.
Since it can't find the database, it prompts for the connection info.
Start-up SQL server again & then fill out the connection info (with
integrated security unchecked). Then save your report.

:>kris
I am writing a Windows forms VB.Net/MS SQL application via VS 2003 that
utilizes Crystal Reports. I want to be able to dynamically set the
report data source at run time.

I'm trying to change the the reports "integrated security" from TRUE to
FALSE via the "Set Location" dialog in the report designer with no
success. It is not intuitive (at least not to me.)

I get the following error:

"Error in file....Invalid table number."

The error is being generated at this line of my code:

'DatabaseName is changing at runtime, specify the table location.
CrTable.Locatio n = "UpsizeUATSQLBa ckup.dbo." &
CrTable.Locatio n.Substring(CrT able.Location.L astIndexOf(".") + 1)

If I change "UpsizeUATSQLBa ckup.dbo." to the original db location i.e.
"UpsizeUATSQL.d bo" it works fine.

I've seen other posts on the web that state that the "integrated
security" for the report connection has to be FALSE, otherwise the
connection is hard coded into the report.

Article c2011430 on CR support site seems to indicate that you can
change it in Crystal 9, where previously you could not, due to a bug.

My question is how do I change the report's connection "integrated
security" to FALSE?

Tks for any guidance/help you can provide.

....Henry
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

User submitted from AEWNET (http://www.aewnet.com/)
Nov 21 '05 #5
Bernie,

At least I succeeded in finding a solution for a progressbar with the fill
of the datatable.

Interested or did you found it yourself already

I used an access database to get it slow, however it is terrible slow.

Cor
Nov 21 '05 #6
Hi Cor,

Thanks, but yes, I already got it working - thanks, as always.

Bernie

"Cor Ligthert" <no************ @planet.nl> wrote in message
news:eB******** ******@TK2MSFTN GP15.phx.gbl...
Bernie,

At least I succeeded in finding a solution for a progressbar with the fill
of the datatable.

Interested or did you found it yourself already

I used an access database to get it slow, however it is terrible slow.

Cor

Nov 21 '05 #7
Did you post how you did it and if so what was the thread name?

If not, will you please? :)

"Bernie Yaeger" <be*****@cherwe llinc.com> wrote in message
news:be*****@ch erwellinc.com:
Hi Cor,

Thanks, but yes, I already got it working - thanks, as always.

Bernie

"Cor Ligthert" <no************ @planet.nl> wrote in message
news:eB******** ******@TK2MSFTN GP15.phx.gbl...
Bernie,

At least I succeeded in finding a solution for a progressbar with the
fill
of the datatable.

Interested or did you found it yourself already

I used an access database to get it slow, however it is terrible slow.

Cor


Nov 21 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
6987
by: McKirahan | last post by:
What is "active content"? My ASP page just returns HTML.... I have a page with an .htm extension that has a form whose action is an ASP page which generates a report after updating a database with the form data. Under Windowx XP SP2 the IE6 "Information Bar" has the message: "To help protect your security, Internet Explorer has restricted this
5
5102
by: RWC | last post by:
Hello, I have a database that I need to connect with that resides on my personal intranet server. I'm on a different subnet than this server (running through two different gateways). When I try to open the database from my laptop, I get the warning "Microsoft Access cannot open this file This file is located outside your intranet or on an untrusted site. Microsoft Access will not open the file due to potential security problems. ...
1
1558
by: Tom | last post by:
Hi, I am currently on a project where one site needs to send the user credentials to another site, through web services. Scenario: * "User 1" will authenticate to "Site A" using NTLM ("Site A" provides front-end presentation of data) * "Site A" will request confidential information about "User 1" to "Site B"
4
2456
by: Dean Slindee | last post by:
I would like to provide a menu item that the users can click that launches the same "Windows Security" window that doing a Ctrl+Alt+Delete launches, but thru a Process.Start. Is this possible, and what is the name of the ..exe and it's location? Thanks, Dean Slindee
1
2858
by: Tom Purdom | last post by:
Hi All, I am developing a Outlook interop plugin which performs task time allocation. However when i attempt to fire my custom event to notify that an allocation has been generated the security exception "Request Failed" is thrown. The events sole subscriber is the main class of the interop plugin. Anyone experienced this problem in the past? Or can you give me more information about this type of security exception. I have read about...
14
4483
by: BillCo | last post by:
Hi folks, I have an a2k ap which is called from a batch file via task scheduler on at night - it runs a bunch of updates, imports stuff from other databases and generally preps the main backend for another day's work. It logs everything and generates an email which it sends to a few people, issuing warnings if there were problems. Have you guessed the problem yet? Outlook 2003 / SP2 - "...Trying to send a mail...", "...use address
2
1734
by: jvvhie | last post by:
Hello, I am writing a pure-Python game engine that interprets the code of game objects within the same process with the exec statement. My main goal is to make as much power available as possible and exec seems like the best way to do that. This is my "proof-of-concept" code(only 18 lines and some whitespace, including the test): http://people.ucsc.edu/~jhofmann/programmables.py
19
2576
by: hansBKK | last post by:
Upfront disclaimer - I am a relative newbie, just starting out learning about PHP, mostly by researching, installing and playing with different scripts. I am looking for a host that will provide the right environment for this - running a wide variety of PHP applications. I realise that security is also important, but for now flexibility is more important to me. Note that I'm **not** looking for people to recommend hosting companies, I...
2
2331
by: Mike McGuire | last post by:
I currently have a .NET 2.0 Application that uses "Security.SecureString" to securly pass a password to the process that I am starting within the app. I want to create something similar for a few of our web servers, but the web team does not want to install .NET 2.0 on the servers Is there anything similar to "Security.SecureString" for .NET 1.1? Mike
0
8736
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9229
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8977
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8934
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6571
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5904
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4662
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2398
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2035
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.