Error exporting report

Hello

I've developed an ASP.NET WebApplication (VS.NET 2002) with some Crystal Reports in it to report the data.

This reports are automatically exported into a pdf-File (using the Report.Export function)

To give the user the ability to change the language of the WebApp, all the texts are stored in a MS SQL 2000 Database.

I set the Text-Property of the TextObject in the Report with the following code:

Dim TextObjekt As CrystalDecisions.CrystalReports.Engine.TextObject
TextObjekt = Report.ReportDefinition.ReportObjects.Item("Text14")
TextObjekt.Text = Data.Tables(0).Rows(0).Item("TransText") & ":"

I thought this works fine, till I changed the Text in the database.

Examples:

1.) Text in the database = "Mobil 1"
--> The report works fine, the PDF is successfully created and the TextObject shows "Mobil 1:"

2.) Text in the database = "Hello Echo"
--> The Report works and the PDF is created, but the TextObject shows "Hello Ec"

3.) Text in the database = "PSA"
--> Report.Export crashes with the following error:
"Error #5 - Error in file C:\DOKUME~1\STEFAN\ASPNET\LOKALE~1\Temp\temp_c67a4fca-9bd3-4aa6-935b-0ad7a389f034.rpt:
Error found in Export-DLL : \n0\nCrystalDecisions.CrystalReports.Engine"

Has anyone an idea how I can solve this absolutly strange problem?

Thanks and best regards
GulliwahnDoes that PSA have any special charaters?
Do very Database on the Report and try againsql

Error executing xp_cmdshell from within a SQL task in a DTS package...

Hello

I am trying to execute xp_cmdshell' from within a DTS package that
was created by another person. When I try to execute that SQL Task'
selectively from within the package, I get the following error
message:

Error Title: Package Error
Error Details:
Error Source: Microsoft OLE DB Provider for SQL Server
Error Description: xpsql.cpp: Error 87 from GetProxyAccount on line
604

Why is this error message popping up? When I create a new package
(myself) and create an exact same SQL task as above and run it, the
SQL task runs fine.

Appreciate any help / feedback.

Thanks in Advance
Jagannathan SanthanamWhen a sysadmin role member executes xp_cmdshell, it runs under the
security context of the SQL Server service account. However, when a
non-sysadmin user executes the proc, it runs under the SQL Agent proxy
account.

It looks like there is an issue with your configuration of the proxy
account and/or SQL Server service account security. Enterprise Manager
automatically assigns the necessary rights to these accounts when these
are specified or changed via the GUI. Alternatively, you can manually
assign the following Windows rights to the accounts.

<Excerpt
href="http://support.microsoft.com/default.aspx?scid=kb;en-us;264155"
MSSQLServer and SQLServerAgent Services
- Act as part of the Operating System.
- Increase Quotas.
- Replace a process level token.
- Log on as a batch job.
SQLAgentCmdExec Account
- Log on as a batch job.

NOTE: You must restart the entire server, not just the SQL Services, in
order for any changes made to user rights permissions to take effect.

</Excerpt
--
Hope this helps.

Dan Guzman
SQL Server MVP

--------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index...epartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--------

"Jagannathan Santhanam" <jags_32@.yahoo.com> wrote in message
news:605df08e.0311170307.39d9b1f1@.posting.google.c om...
> Hello
> I am trying to execute 'xp_cmdshell' from within a DTS package that
> was created by another person. When I try to execute that 'SQL Task'
> selectively from within the package, I get the following error
> message:
> Error Title: Package Error
> Error Details:
> Error Source: Microsoft OLE DB Provider for SQL Server
> Error Description: xpsql.cpp: Error 87 from GetProxyAccount on line
> 604
>
> Why is this error message popping up? When I create a new package
> (myself) and create an exact same SQL task as above and run it, the
> SQL task runs fine.
> Appreciate any help / feedback.
> Thanks in Advance
> Jagannathan Santhanam

Error creating merge replication

Hello:
I have implemented many trasactional replications on my SQL Server 2005
standar and thay are working ok.
Now, I am trying to implement a merge replication (in the same server) of a
table with a filter and when I click the finish option of the wizard in the
last step I receive the next error:
"Object reference not set to an instance of an object. (CreatePubWizard)"
What is happening?
Please, can anybody help my to solve this problem?
Thanks in advance
Jesús
its hard to say what the problem is. Recreate your publication using the
wizard, but this time when you get to the Wizard Actions dialog, select
Generate a script file, and deselect create the publication. Click next,
give the publication a name and click Finish. Then using Query Analyzer or
SSMS recreate the publication.
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Cetel Sistemas" <CetelSistemas@.discussions.microsoft.com> wrote in message
news:067B6719-0D4F-4E8E-9BDB-0A8189FF981B@.microsoft.com...
> Hello:
> I have implemented many trasactional replications on my SQL Server 2005
> standar and thay are working ok.
> Now, I am trying to implement a merge replication (in the same server) of
> a
> table with a filter and when I click the finish option of the wizard in
> the
> last step I receive the next error:
> "Object reference not set to an instance of an object. (CreatePubWizard)"
> What is happening?
> Please, can anybody help my to solve this problem?
> Thanks in advance
> Jess

Error converting data type varchar to numeric

Hello:
I'm getting the famous "Error converting data type varchar to numeric" error
upon using an If, then statement.
I'm not too familiar with the use of CAST or CONVERT, which I understand
eliminates this sort of error.
How do I use either of those terms in the following SELECT CASE statement:
CASE UPR30300.PAYROLCD WHEN 'BREVN' THEN UPR40600.DSCRIPTN
WHEN 'OVTMN' THEN UPR40600.DSCRIPTN WHEN 'BNDIS' THEN UPR40600.DSCRIPTN WHEN
'BNSHR' THEN UPR40600.DSCRIPTN
ELSE '0' END As [Payroll Description]
I don't get why SQL thinks I'm trying to do something numeric. All of the
fields in the above statement are string--not numeric. I don't know nuttin'
'bout no numbers!
Thanks!
childofthe1980sPlease don't multi-post. See answer in .programming.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:910EE9BB-3328-432C-9BC6-B06BF2C558CD@.microsoft.com...
Hello:
I'm getting the famous "Error converting data type varchar to numeric" error
upon using an If, then statement.
I'm not too familiar with the use of CAST or CONVERT, which I understand
eliminates this sort of error.
How do I use either of those terms in the following SELECT CASE statement:
CASE UPR30300.PAYROLCD WHEN 'BREVN' THEN UPR40600.DSCRIPTN
WHEN 'OVTMN' THEN UPR40600.DSCRIPTN WHEN 'BNDIS' THEN UPR40600.DSCRIPTN WHEN
'BNSHR' THEN UPR40600.DSCRIPTN
ELSE '0' END As [Payroll Description]
I don't get why SQL thinks I'm trying to do something numeric. All of the
fields in the above statement are string--not numeric. I don't know nuttin'
'bout no numbers!
Thanks!
childofthe1980s|||I have to multi-post, or I don't get an answer.
There is no answer over at the other section either, Tom--just a request to
post data which I cannot post.
This is ridiculous.
childofthe1980s
"Tom Moreau" wrote:

> Please don't multi-post. See answer in .programming.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
> message news:910EE9BB-3328-432C-9BC6-B06BF2C558CD@.microsoft.com...
> Hello:
> I'm getting the famous "Error converting data type varchar to numeric" err
or
> upon using an If, then statement.
> I'm not too familiar with the use of CAST or CONVERT, which I understand
> eliminates this sort of error.
> How do I use either of those terms in the following SELECT CASE statement:
> CASE UPR30300.PAYROLCD WHEN 'BREVN' THEN UPR40600.DSCRIPTN
> WHEN 'OVTMN' THEN UPR40600.DSCRIPTN WHEN 'BNDIS' THEN UPR40600.DSCRIPTN WH
EN
> 'BNSHR' THEN UPR40600.DSCRIPTN
> ELSE '0' END As [Payroll Description]
> I don't get why SQL thinks I'm trying to do something numeric. All of the
> fields in the above statement are string--not numeric. I don't know nutti
n'
> 'bout no numbers!
> Thanks!
> childofthe1980s
>
>|||Help us help you:
http://www.aspfaq.com/etiquette.asp?id=5006
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:BA8EFDC4-B4C3-4635-931F-90539E6DB06F@.microsoft.com...
I have to multi-post, or I don't get an answer.
There is no answer over at the other section either, Tom--just a request to
post data which I cannot post.
This is ridiculous.
childofthe1980s
"Tom Moreau" wrote:

> Please don't multi-post. See answer in .programming.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
> message news:910EE9BB-3328-432C-9BC6-B06BF2C558CD@.microsoft.com...
> Hello:
> I'm getting the famous "Error converting data type varchar to numeric"
> error
> upon using an If, then statement.
> I'm not too familiar with the use of CAST or CONVERT, which I understand
> eliminates this sort of error.
> How do I use either of those terms in the following SELECT CASE statement:
> CASE UPR30300.PAYROLCD WHEN 'BREVN' THEN UPR40600.DSCRIPTN
> WHEN 'OVTMN' THEN UPR40600.DSCRIPTN WHEN 'BNDIS' THEN UPR40600.DSCRIPTN
> WHEN
> 'BNSHR' THEN UPR40600.DSCRIPTN
> ELSE '0' END As [Payroll Description]
> I don't get why SQL thinks I'm trying to do something numeric. All of the
> fields in the above statement are string--not numeric. I don't know
> nuttin'
> 'bout no numbers!
> Thanks!
> childofthe1980s
>
>|||"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:BA8EFDC4-B4C3-4635-931F-90539E6DB06F@.microsoft.com...
>I have to multi-post, or I don't get an answer.
> There is no answer over at the other section either, Tom--just a request
> to
> post data which I cannot post.
Don't MULTI-post, CROSS-post. (and only then to a select number of groups).

>
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com

Error connecting to instance using Server Management Studio

Hello!
I have been messing with this all day and it is beginning to aggrivate me.
I am installing an instance of SQL Server 2005 on one of our machines to
support WSUS and SCOM 07. I installed it a bit differently because I wanted
the data files in a specific location and I dont know if that woudl cause
this problem (i doubt it but you never know) To start the installation I
type at the run prompt:
E:\Servers\setup.exe INSTALLSQLDATADIR=D:\MSSQL2005\DATA\
Where E is the optical drive
After the install I also installed SP2. When i go to connect to and manage
the instance using 2005 management studio I get the following error:
===============================================
TITLE: Connect to Server
Cannot connect to EARTH-PA\SQLSERVER2005.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance
Specified) (Microsoft SQL Server, Error: -1)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLS erver&EvtID=-1&LinkId=20476[/url]
================================================== =
I should note that this is SQL Server 2005 Standard, meaning that by default
remote connections are enabled (even though I am not connecting remotely...I
am trying to connect on the same machine on which it is installed) I
verified that remote and local connections were enabled in SQL Server Surface
Area Configuration.
Any ideas as to what could be causing this? Could it be possible that
starting the installer that way is throwing it off? In configuration manager
it has the default locations of the master etc databases set properly.
Any help would be much appreciated...thanks!
1. Check if your instance is running (I know, I know :-)).
2. Check if SQL Server Browser service is enabled and is running.
3. Check the TCP/IP port of the instance (use Configuration Manager). Set
static port.
4. If steps 1 and 2 did not help try to connect to the instance with SSMS
using the following instead of EARTH-PA\SQLSERVER2005:
tcp:EARTH-PA,<port_number_set_in_step_3>
Regards
Pawel Potasinski
Uytkownik "Ehren" <Ehren@.discussions.microsoft.com> napisa w wiadomoci
news:AD3DDD41-6FB3-438A-A3FD-418FB466961D@.microsoft.com...
> Hello!
> I have been messing with this all day and it is beginning to aggrivate me.
> I am installing an instance of SQL Server 2005 on one of our machines to
> support WSUS and SCOM 07. I installed it a bit differently because I
> wanted
> the data files in a specific location and I dont know if that woudl cause
> this problem (i doubt it but you never know) To start the installation I
> type at the run prompt:
> E:\Servers\setup.exe INSTALLSQLDATADIR=D:\MSSQL2005\DATA\
> Where E is the optical drive
> After the install I also installed SP2. When i go to connect to and
> manage
> the instance using 2005 management studio I get the following error:
> ===============================================
> TITLE: Connect to Server
> --
> Cannot connect to EARTH-PA\SQLSERVER2005.
> --
> ADDITIONAL INFORMATION:
> An error has occurred while establishing a connection to the server. When
> connecting to SQL Server 2005, this failure may be caused by the fact that
> under the default settings SQL Server does not allow remote connections.
> (provider: SQL Network Interfaces, error: 26 - Error Locating
> Server/Instance
> Specified) (Microsoft SQL Server, Error: -1)
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLS erver&EvtID=-1&LinkId=20476[/url]
> ================================================== =
> I should note that this is SQL Server 2005 Standard, meaning that by
> default
> remote connections are enabled (even though I am not connecting
> remotely...I
> am trying to connect on the same machine on which it is installed) I
> verified that remote and local connections were enabled in SQL Server
> Surface
> Area Configuration.
> Any ideas as to what could be causing this? Could it be possible that
> starting the installer that way is throwing it off? In configuration
> manager
> it has the default locations of the master etc databases set properly.
> Any help would be much appreciated...thanks!

Error connecting to instance using Server Management Studio

Hello!
I have been messing with this all day and it is beginning to aggrivate me.
I am installing an instance of SQL Server 2005 on one of our machines to
support WSUS and SCOM 07. I installed it a bit differently because I wanted
the data files in a specific location and I dont know if that woudl cause
this problem (i doubt it but you never know) To start the installation I
type at the run prompt:
E:\Servers\setup.exe INSTALLSQLDATADIR=D:\MSSQL2005\DATA\
Where E is the optical drive
After the install I also installed SP2. When i go to connect to and manage
the instance using 2005 management studio I get the following error:
========================================
=======
TITLE: Connect to Server
--
Cannot connect to EARTH-PA\SQLSERVER2005.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instanc
e
Specified) (Microsoft SQL Server, Error: -1)
For help, click:
http://go.microsoft.com/fwlink?Prod...-1&LinkId=20476
========================================
===========
I should note that this is SQL Server 2005 Standard, meaning that by default
remote connections are enabled (even though I am not connecting remotely...I
am trying to connect on the same machine on which it is installed) I
verified that remote and local connections were enabled in SQL Server Surfac
e
Area Configuration.
Any ideas as to what could be causing this? Could it be possible that
starting the installer that way is throwing it off? In configuration manage
r
it has the default locations of the master etc databases set properly.
Any help would be much appreciated...thanks!1. Check if your instance is running (I know, I know :-)).
2. Check if SQL Server Browser service is enabled and is running.
3. Check the TCP/IP port of the instance (use Configuration Manager). Set
static port.
4. If steps 1 and 2 did not help try to connect to the instance with SSMS
using the following instead of EARTH-PA\SQLSERVER2005:
tcp:EARTH-PA,<port_number_set_in_step_3>
Regards
Pawel Potasinski
Uytkownik "Ehren" <Ehren@.discussions.microsoft.com> napisa w wiadomoci
news:AD3DDD41-6FB3-438A-A3FD-418FB466961D@.microsoft.com...
> Hello!
> I have been messing with this all day and it is beginning to aggrivate me.
> I am installing an instance of SQL Server 2005 on one of our machines to
> support WSUS and SCOM 07. I installed it a bit differently because I
> wanted
> the data files in a specific location and I dont know if that woudl cause
> this problem (i doubt it but you never know) To start the installation I
> type at the run prompt:
> E:\Servers\setup.exe INSTALLSQLDATADIR=D:\MSSQL2005\DATA\
> Where E is the optical drive
> After the install I also installed SP2. When i go to connect to and
> manage
> the instance using 2005 management studio I get the following error:
> ========================================
=======
> TITLE: Connect to Server
> --
> Cannot connect to EARTH-PA\SQLSERVER2005.
> --
> ADDITIONAL INFORMATION:
> An error has occurred while establishing a connection to the server. When
> connecting to SQL Server 2005, this failure may be caused by the fact that
> under the default settings SQL Server does not allow remote connections.
> (provider: SQL Network Interfaces, error: 26 - Error Locating
> Server/Instance
> Specified) (Microsoft SQL Server, Error: -1)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...-1&LinkId=20476
> ========================================
===========
> I should note that this is SQL Server 2005 Standard, meaning that by
> default
> remote connections are enabled (even though I am not connecting
> remotely...I
> am trying to connect on the same machine on which it is installed) I
> verified that remote and local connections were enabled in SQL Server
> Surface
> Area Configuration.
> Any ideas as to what could be causing this? Could it be possible that
> starting the installer that way is throwing it off? In configuration
> manager
> it has the default locations of the master etc databases set properly.
> Any help would be much appreciated...thanks!

Error at parse query

Hello

I have the following:

One data flow task in the control flow
In this data flow task I have an OLE DB Source with the following sql command

'.... where cc = ?'

Then I click on the Parameters button and I map the ? to the right Parameter

Parameter0 = User::var_cc

When I click on parse query I get the following message :

"Parameter Information cannot be derived from SQL statements. Set parameter information before preparing command."

Anyone has an idea?
ThxThis is a known issue. Parse Query does not know how to use the parameters you mapped.

If you do not get any error after clicking OK, your query should be fine and you can safely ignore the error from Parse Query.