264] An attempt was made to send an email when no email session has been established

Is there any way I can get sp1 please. I'm getting the same error no matter which email method I use.

Thanks

Sam

I have installed the March CTP SP1 and I am still getting the error "An attempt was made to send an email when no email session has been established" as before.|||

SQL Agent jobs failing to send notficatin mails on 64 bit platfiorm using Databasemail issue is addressed in SP1 CTP

It could be also of another issue that we have bug tracking that we are planning to get it addressed in our next release

Since Databasemail is off by default and setting it on and setting it to new profile requires SQLAgent to be restarted as it is the main thread that starts the mail session

Basically restarting SQLAgent after setting MAPI profile will solve this issue.

Thanks,

Gops Dwarak, MSFT

|||Basically restarting SQLAgent after setting MAPI profile will solve this issue

...Basically this is incorrect (nice guess)

264] An attempt was made to send an email when no email session has been established

Is there any way I can get sp1 please. I'm getting the same error no matter which email method I use.

Thanks

Sam

I have installed the March CTP SP1 and I am still getting the error "An attempt was made to send an email when no email session has been established" as before.|||

SQL Agent jobs failing to send notficatin mails on 64 bit platfiorm using Databasemail issue is addressed in SP1 CTP

It could be also of another issue that we have bug tracking that we are planning to get it addressed in our next release

Since Databasemail is off by default and setting it on and setting it to new profile requires SQLAgent to be restarted as it is the main thread that starts the mail session

Basically restarting SQLAgent after setting MAPI profile will solve this issue.

Thanks,

Gops Dwarak, MSFT

|||Basically restarting SQLAgent after setting MAPI profile will solve this issue

...Basically this is incorrect (nice guess)

264] An attempt was made to send an email when no email session has been established

Is there any way I can get sp1 please. I'm getting the same error no matter which email method I use.

Thanks

Sam

I have installed the March CTP SP1 and I am still getting the error "An attempt was made to send an email when no email session has been established" as before.|||

SQL Agent jobs failing to send notficatin mails on 64 bit platfiorm using Databasemail issue is addressed in SP1 CTP

It could be also of another issue that we have bug tracking that we are planning to get it addressed in our next release

Since Databasemail is off by default and setting it on and setting it to new profile requires SQLAgent to be restarted as it is the main thread that starts the mail session

Basically restarting SQLAgent after setting MAPI profile will solve this issue.

Thanks,

Gops Dwarak, MSFT

|||Basically restarting SQLAgent after setting MAPI profile will solve this issue

...Basically this is incorrect (nice guess)

21776 Error by EM when a view column name is changed.

I am wondering if there is a sp or some other method to fix an issue that
arises when you change the name of a column in a view.
The scenario is:
1. Create the view
2. Alter the view, changing the name of one of the fields
3. Within EM, select the view | Properties | permissions, and then check the
column permissions - you get an error "21776 [SQL-DMO] The name
'<newcolumnname>' was not found in the columns collection..."
The BOL item on ALTER VIEW warns that if you have permissions defined on a
view column, and then change the name of the column, the permissions do not
follow, BUT, in addition to this, you cannot even see the NEW column to
assign the permissions again in the above scenario.
Has anyone run into this?
Thanks
Best regards,
BlairCheck out sp_refreshview in BooksOnLine.
Andrew J. Kelly SQL MVP
"BlairH" <BlairH@.discussions.microsoft.com> wrote in message
news:8AB571A3-779F-497A-A707-703B66FEF13E@.microsoft.com...
>I am wondering if there is a sp or some other method to fix an issue that
> arises when you change the name of a column in a view.
> The scenario is:
> 1. Create the view
> 2. Alter the view, changing the name of one of the fields
> 3. Within EM, select the view | Properties | permissions, and then check
> the
> column permissions - you get an error "21776 [SQL-DMO] The name
> '<newcolumnname>' was not found in the columns collection..."
> The BOL item on ALTER VIEW warns that if you have permissions defined on a
> view column, and then change the name of the column, the permissions do
> not
> follow, BUT, in addition to this, you cannot even see the NEW column to
> assign the permissions again in the above scenario.
> Has anyone run into this?
> Thanks
> --
> Best regards,
> Blair|||Thanks very much Andrew. That's exactly what I was looking for. In
addition, it apears that you have to restart EM in order for the fix to take
effect. (but it does)
Thanks again.
--
Best regards,
Blair
"Andrew J. Kelly" wrote:

> Check out sp_refreshview in BooksOnLine.
>
> --
> Andrew J. Kelly SQL MVP
>
> "BlairH" <BlairH@.discussions.microsoft.com> wrote in message
> news:8AB571A3-779F-497A-A707-703B66FEF13E@.microsoft.com...
>
>|||All you should have needed to do after issuing sp_refreshview was to refresh
that node in EM. But restarting works too<g>.
Andrew J. Kelly SQL MVP
"BlairH" <BlairH@.discussions.microsoft.com> wrote in message
news:5EF6E77B-79A3-46AB-8070-3842A950407F@.microsoft.com...[vbcol=seagreen]
> Thanks very much Andrew. That's exactly what I was looking for. In
> addition, it apears that you have to restart EM in order for the fix to
> take
> effect. (but it does)
> Thanks again.
> --
> Best regards,
> Blair
>
> "Andrew J. Kelly" wrote:
>

20536: Unable to logon server

I have VB 6.0 Application calling Crystal Report 7.0 based on SQL Server 2000 datbase.

I use the LogonServer method with parameter p2ssql.dll to make the database connection.

I have used the above method for my Crystal Report for last 6 years and worked fine until now but now I get the "20536: Unable to logon server " in few XP OS machines.

This again works in the test XP machine I have used, I have almost tried all things I can try to fix the problem.

Does anyone have similar problems and if so how they dealt with it.

Any help in this regard is highly appreciated.

ThanksHigher security levels in XP, at a guess.
Do you have subreports??
If so, you may find that before your OS was allowing subreports to use login info from parent report, but now is breaking because OS demands you supply login info for each subreport.
In which case. iterate thru subreports collection and supply same login info to each subreport.

dave

2005 issues with BinaryWrite?

I have moved over some data from 2000 to SQL 2005. The data is the
same, but now some existing working code is not working with the
BinaryWrite method of Response.BinaryWrite in an ASP page.
In a field in a table that is ntext. It contains HTML data tags. ie.
<P><B>this is</b> etc... etc.. </P>
Before moving to 2005 the following classic ASP code worked (recordset
setup correctly):
dim mFieldSize, mBytes
mFieldSize = rs.Fields("keywords").ActualSize
mBytes = rs.Fields("keywords").GetChunk(mFieldSize)
Response.BinaryWrite mBytes
now with the data in 2005 I get this error:
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another. Is this a coding error, or a type error
problem that I have to do differently with 2005?
If anyone knows of the solution to this problem please let me know.
Thanks
*** Sent via Developersdex http://www.codecomments.com ***Have you tried Response.Write instead of Response.BinaryWrite? It might be
that SQL 2005 is returning a variant datatype family of Unicode rather than
binary because the underlying data is Unicode (ntext).
Hope this helps.
Dan Guzman
SQL Server MVP
"E L" <smakawhat@.yahoo.com> wrote in message
news:uoLwI110GHA.1268@.TK2MSFTNGP02.phx.gbl...
>I have moved over some data from 2000 to SQL 2005. The data is the
> same, but now some existing working code is not working with the
> BinaryWrite method of Response.BinaryWrite in an ASP page.
> In a field in a table that is ntext. It contains HTML data tags. ie.
> <P><B>this is</b> etc... etc.. </P>
> Before moving to 2005 the following classic ASP code worked (recordset
> setup correctly):
> dim mFieldSize, mBytes
> mFieldSize = rs.Fields("keywords").ActualSize
> mBytes = rs.Fields("keywords").GetChunk(mFieldSize)
> Response.BinaryWrite mBytes
> now with the data in 2005 I get this error:
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another. Is this a coding error, or a type error
> problem that I have to do differently with 2005?
> If anyone knows of the solution to this problem please let me know.
> Thanks
> *** Sent via Developersdex http://www.codecomments.com ***