Search results for query: *

I have a stored procedure that sends out and email. It runs fine in SSMS and sends the email, but when it runs as a job it fails. The error is 'can not convert nvarchar to real', which I have spent months trying to fix and can not figure out, since I can not find any nvarchar fields. So I would...

Wow George, Thank you so much. This is an excelent explanation of how these joins work. I did not realize that two joins in the same select statement could affect one another. Your code did not work, it seemed not to read my function, however your explaination was so good that I could fix the...

Hi George, Thanks for the reply but this does not work, I am getting the same output. It is interesting though, I didn't realize that you could 'and' in a join without it comparing two things. Thanks

Hello, I am trying to join two tables and have the output include all eqmtids. The hist_eqmtlist table has all eqmtids but the hist_load table has only some. I need the output to include all eqmtids and nulls or zeros for the other columns. I thought an outer join would do it but alas, I have...

The problem was that there was no password set on the data source .dsn file.

I am running a command line utility that grabs a .rpt file, inputs the dates to run it for and spits out a .pdf. Here is the command: C:\Powerview\exe\mms_PrintReport.exe @rpt="C:\Powerview\rpt\Custom\DailyEmail\jpm_de_minekpi.rpt" @dsn="C:\Program Files\Common Files\ODBC\Data...

Hello, I am trying to call one sp with another but am getting an 'Error converting nvarchar to real' error. However, there is no nvarchar in either report. Not only that but other reports that call the sp work fine and seem to be set up the same. I am running this command DECLARE @startd...

I am not sure what you mean by 'You did not return the entire string.' I even ran it a second time to see if the results were the same. The first time I did I got the above posted string repeated twice. This time I got the above string 5 times. What is missing from it? I am using a dsn that is...

This is great code. I ran it, took the string returned and copied and pasted it into my code. Here is the returned string ODBC;DSN=dsn201;Description=JPdb;UID=minedata;PWD=1xx$F;APP=Microsoft® Query;WSID=CAL-L-97076;DATABASE=Power I copied it into my code like this Sheets("DataQuery").Select...

No go. This still throws a '1004' error. Could it be the port? As I understand it the ports tend to be standard, but I couldn't figure out how to check the settings on this server.

Here is the SQL. When run on the server it doens't throw any errors. ALTER PROCEDURE [dbo].[jpm_tiretrack] (@endd int) AS --Altered to report all trucks 11-25-09 /* DECLARE @sDate datetime, @eDate datetime, @startd int, @endd int SET @sDate = '2010-01-01' SET @eDate = '2010-01-28' SET...

I am trying to get an ODBC connection to work from excel. I have copied the excel sheet from a working copy and am trying to point it at a different server. I am a VBA noob and have no idea why it isn't working. Sheets("DataQuery").Select reportdate = ActiveSheet.Range("B1").Value...

I have updated the .msm files to v11 but am still getting the error. Do I need to register these files? And if yes how? Thanks again, this is so far over my head and now so far over due. Help for you guys in this forum is great and greatly appreciated.

That was one of the things I read on-line. So I created a new report in the new version of Crystal and saved it over the old report but I am still getting the invalid tlv error. Is there maybe something else I need for the runtime component version? Thanks

I am upgrading from Sql Server 2000 with Crystal Reports v8.5 to Sql Server 2005 with Crystal Reports v11. There is an xml job that grabs a .rpt puts it into a .pdf and emails it. If I send the email with no attachements it will work. When I add an attachement it throws the 'Invalid TLV record'...

The problem was the folder in the input path needed to be a shared folder.

We are upgrading from sql server 2000 to sql server 2005. I am trying to move an xml script that sends out an email every morning with pdf attachements. Here is the code: <?xml version="1.0"?> <!--XML writer for DataGridView Control--> <XML> <schedule id="1"> <fileSettings...

After viewing another post here http://www.tek-tips.com/viewthread.cfm?qid=1594389&page=1 I changed the exec line to this: EXEC msdb.dbo.sp_send_dbmail @subject = 'NACG - 5500/797 loads', @body = @body, @profile_name = 'ase.reports@xxx.com', @recipients = 'xxx@xxx.com', @copy_recipients...

Thanks SQLBill. Since I copied and pasted the profile name out of the result pane of the sql query that listed my profiles I don't think the name is wrong, am I missing something? Here is the first sql query: SELECT [profile_id] ,[name] ,[description]...

I have been trying all week to get my new sql 2005 server to send out auto emails. The test emails come through fine but the EXEC msdb.dbo.sp_send_dbmail do not. Earlier they said that the email was queuing but no email was sent to my inbox. Now it seems I have regressed. I am seeing this error...