Problem with Linked Server

Dear All,
I have 2 SQL Server computers, let say Server A and B.
I created a linked server from A to B, so I can make query that the data
from Server B, and it's success.
Now, I create a linked server from B to A, but it failed.
Here's the error message:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
What's the problem with server B?
Both of the servers are using windows authentification.
Thanks
Agus
Hi
You may want to check out:
http://www.windowsitpro.com/Article/...3670.html?Ad=1
John
"Agus Setiawan" wrote:

> Dear All,
> I have 2 SQL Server computers, let say Server A and B.
> I created a linked server from A to B, so I can make query that the data
> from Server B, and it's success.
> Now, I create a linked server from B to A, but it failed.
> Here's the error message:
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
> What's the problem with server B?
> Both of the servers are using windows authentification.
>
> Thanks
> Agus
>
|||Hello,
Verify also that your account have the Windows rights on those two servers
and that they are on the same domain. The best way is having a service
account.
Hope this will help,
P. Ruello
DBA
"Agus Setiawan" wrote:

> Dear All,
> I have 2 SQL Server computers, let say Server A and B.
> I created a linked server from A to B, so I can make query that the data
> from Server B, and it's success.
> Now, I create a linked server from B to A, but it failed.
> Here's the error message:
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
> What's the problem with server B?
> Both of the servers are using windows authentification.
>
> Thanks
> Agus
>
|||I have similar problem right now with linked server.
I can run distributed query from Server A to B by using my login.
But I can't run distributed query from Server B to A by using my login.
If I run distributed query from Server B to A by using login that is
used by server B, it's success.
Why?
Thanks
Robert Lie
P.Ruello wrote:
> Hello,
> Verify also that your account have the Windows rights on those two servers
> and that they are on the same domain. The best way is having a service
> account.
> Hope this will help,
|||Hi
You may want to check out http://support.microsoft.com/?id=238477
John
"Robert Lie" wrote:

> I have similar problem right now with linked server.
> I can run distributed query from Server A to B by using my login.
> But I can't run distributed query from Server B to A by using my login.
> If I run distributed query from Server B to A by using login that is
> used by server B, it's success.
> Why?
> Thanks
> Robert Lie
>
> P.Ruello wrote:
>

Problem with Linked Server

Dear All,
I have 2 SQL Server computers, let say Server A and B.
I created a linked server from A to B, so I can make query that the data
from Server B, and it's success.
Now, I create a linked server from B to A, but it failed.
Here's the error message:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
What's the problem with server B?
Both of the servers are using windows authentification.
Thanks
AgusHi
You may want to check out:
http://www.windowsitpro.com/Article...23670.html?Ad=1
John
"Agus Setiawan" wrote:

> Dear All,
> I have 2 SQL Server computers, let say Server A and B.
> I created a linked server from A to B, so I can make query that the data
> from Server B, and it's success.
> Now, I create a linked server from B to A, but it failed.
> Here's the error message:
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
> What's the problem with server B?
> Both of the servers are using windows authentification.
>
> Thanks
> Agus
>|||Hello,
Verify also that your account have the Windows rights on those two servers
and that they are on the same domain. The best way is having a service
account.
Hope this will help,
--
P. Ruello
DBA
"Agus Setiawan" wrote:

> Dear All,
> I have 2 SQL Server computers, let say Server A and B.
> I created a linked server from A to B, so I can make query that the data
> from Server B, and it's success.
> Now, I create a linked server from B to A, but it failed.
> Here's the error message:
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
> What's the problem with server B?
> Both of the servers are using windows authentification.
>
> Thanks
> Agus
>|||I have similar problem right now with linked server.
I can run distributed query from Server A to B by using my login.
But I can't run distributed query from Server B to A by using my login.
If I run distributed query from Server B to A by using login that is
used by server B, it's success.
Why?
Thanks
Robert Lie
P.Ruello wrote:
> Hello,
> Verify also that your account have the Windows rights on those two servers
> and that they are on the same domain. The best way is having a service
> account.
> Hope this will help,|||Hi
You may want to check out http://support.microsoft.com/?id=238477
John
"Robert Lie" wrote:

> I have similar problem right now with linked server.
> I can run distributed query from Server A to B by using my login.
> But I can't run distributed query from Server B to A by using my login.
> If I run distributed query from Server B to A by using login that is
> used by server B, it's success.
> Why?
> Thanks
> Robert Lie
>
> P.Ruello wrote:
>sql

Problem with Linked Server

Dear All,
I have 2 SQL Server computers, let say Server A and B.
I created a linked server from A to B, so I can make query that the data
from Server B, and it's success.
Now, I create a linked server from B to A, but it failed.
Here's the error message:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
What's the problem with server B?
Both of the servers are using windows authentification.
Thanks
AgusHi
You may want to check out:
http://www.windowsitpro.com/Article/ArticleID/23670/23670.html?Ad=1
John
"Agus Setiawan" wrote:
> Dear All,
> I have 2 SQL Server computers, let say Server A and B.
> I created a linked server from A to B, so I can make query that the data
> from Server B, and it's success.
> Now, I create a linked server from B to A, but it failed.
> Here's the error message:
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
> What's the problem with server B?
> Both of the servers are using windows authentification.
>
> Thanks
> Agus
>|||Hello,
Verify also that your account have the Windows rights on those two servers
and that they are on the same domain. The best way is having a service
account.
Hope this will help,
--
P. Ruello
DBA
"Agus Setiawan" wrote:
> Dear All,
> I have 2 SQL Server computers, let say Server A and B.
> I created a linked server from A to B, so I can make query that the data
> from Server B, and it's success.
> Now, I create a linked server from B to A, but it failed.
> Here's the error message:
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
> What's the problem with server B?
> Both of the servers are using windows authentification.
>
> Thanks
> Agus
>|||I have similar problem right now with linked server.
I can run distributed query from Server A to B by using my login.
But I can't run distributed query from Server B to A by using my login.
If I run distributed query from Server B to A by using login that is
used by server B, it's success.
Why?
Thanks
Robert Lie
P.Ruello wrote:
> Hello,
> Verify also that your account have the Windows rights on those two servers
> and that they are on the same domain. The best way is having a service
> account.
> Hope this will help,|||Hi
You may want to check out http://support.microsoft.com/?id=238477
John
"Robert Lie" wrote:
> I have similar problem right now with linked server.
> I can run distributed query from Server A to B by using my login.
> But I can't run distributed query from Server B to A by using my login.
> If I run distributed query from Server B to A by using login that is
> used by server B, it's success.
> Why?
> Thanks
> Robert Lie
>
> P.Ruello wrote:
> > Hello,
> > Verify also that your account have the Windows rights on those two servers
> > and that they are on the same domain. The best way is having a service
> > account.
> > Hope this will help,
>

Problem with JDBC Driver for MS SQL Server

Dear All,

I developed an web application which use MS SQL Server 2000. I
encounter the following SQLException "[Microsoft][SQLServer 2000
Driver for JDBC]Error setting up static cursor cache". Did anyone
encounter this problem before? What does this exception mean and how
to solve this problem?

[Remarks: The web application work properly on development machine and
this machine but encounter this exception when move to another
machine, so is this exception related to the machine?]

Thank you for your attention.

Yours faithfully,
Benny
Benny wrote:

> Dear All,
> I developed an web application which use MS SQL Server 2000. I
> encounter the following SQLException "[Microsoft][SQLServer 2000
> Driver for JDBC]Error setting up static cursor cache". Did anyone
> encounter this problem before? What does this exception mean and how
> to solve this problem?

I think it has to do with OS user file permissions in temp directories.
Joe Weinstein at BEA

> [Remarks: The web application work properly on development machine and
> this machine but encounter this exception when move to another
> machine, so is this exception related to the machine?]
> Thank you for your attention.
> Yours faithfully,
> Benny|||I have been investigating the same thing. I have added the C:\Documents and Settings\Administrator\Local Settings\Temp to every policy file that I could find (both the java.policy and catalina.policy files). This does not seem to help. Hmmmmm.... I will keep working on it, but if you have figured it out, I would really appreciate you letting me know how to resolve this.

This is a win2k environ w sqlserver 2000.

Problem with insert Time to database

Dear all,
I have insert the time to my database but it appear also the date by default.
This is my code in C# :
DateTime date = DateTime.Now;
int hour = date.Hour;
int minute = date.Minute;
int second = date.Second;
string requestedTime = hour+":"+minute+":"+second;
string query = "INSERT INTO workorder([timeRequest]) VALUES("'"+requestTime+"'");
in my database , the column timeRequest appear :1/1/1900 11:59:05 AM
I dont want the date by default to appear, i want only the time like : 11:59:05 AM in my database,
Anyone can help me?
Best Regards,
Moniphal

Use parameterized command to insert data to database. By example:

SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "INSERT INTO workorder(timeRequest) VALUES (@.TimeRequest)";
cmd.CommandType = CommandType.Text
cmd.Parameters.Add(new SqlParameter("@.TimeRequest",myDateTime));
cmd.ExecuteNonQuery();

Problem with export of a table to a text file

Dear MSSQL- experts,

I have a strange problem with SQLSERVER 2000.
I tried to export a table of about 40000 lines into a text file using
the Enterprise manager
export assitant. I was astonished to get an exported text file of about
400 MB instead 16 MB which is the normal size of that data.
By examining this file with a text editor I found that the file
included alongside the data of my table MANY zeros which caused the big
file size.

Does someone of you have an idea what could cause the export of
trillions zeros into my textfile and how to only export the significant
data of my table ?

Best regards,

DanielPosting the table definition (CREATE TABLE) would help a lot.

Roy Harvey
Beacon Falls, CT

On 24 Aug 2006 02:07:36 -0700, "Daniel Wetzler"
<Daniel.Wetzler@.sig.bizwrote:

Quote:

Originally Posted by

>Dear MSSQL- experts,
>
>I have a strange problem with SQLSERVER 2000.
>I tried to export a table of about 40000 lines into a text file using
>the Enterprise manager
>export assitant. I was astonished to get an exported text file of about
>400 MB instead 16 MB which is the normal size of that data.
>By examining this file with a text editor I found that the file
>included alongside the data of my table MANY zeros which caused the big
>file size.
>
>Does someone of you have an idea what could cause the export of
>trillions zeros into my textfile and how to only export the significant
>data of my table ?
>
>Best regards,
>
>Daniel

|||Hi Roy,

thanks for your answer.

Here's the table definition :

CREATE TABLE [dbo].[Variables] (
[ID] [varchar] (140) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Var_ref] [int] NOT NULL ,
[Group_Ref] [int] NULL ,
[Machines_Ref] [int] NULL ,
[TransfersID] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[Compatibility] [int] NULL ,
[CompatibilityL1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Category] [int] NULL ,
[CategoryL1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[AnalysisResponsible] [tinyint] NULL ,
[AnalysisPriority] [int] NULL ,
[AnalysisDelta] [int] NULL ,
[AnalysisDeltaValue] [varchar] (30) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[Value] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Type] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Length] [int] NULL ,
[Address] [int] NULL ,
[Offset] [int] NULL ,
[Title1] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Title2] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Title3] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Title4] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[AggregationTitle1] [nvarchar] (100) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[AggregationTitle2] [nvarchar] (100) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[AggregationTitle3] [nvarchar] (100) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[AggregationTitle4] [nvarchar] (100) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

Best regards,

Daniel

Roy Harvey schrieb:

Quote:

Originally Posted by

Posting the table definition (CREATE TABLE) would help a lot.
>
Roy Harvey
Beacon Falls, CT
>
On 24 Aug 2006 02:07:36 -0700, "Daniel Wetzler"
<Daniel.Wetzler@.sig.bizwrote:
>

Quote:

Originally Posted by

Dear MSSQL- experts,

I have a strange problem with SQLSERVER 2000.
I tried to export a table of about 40000 lines into a text file using
the Enterprise manager
export assitant. I was astonished to get an exported text file of about
400 MB instead 16 MB which is the normal size of that data.
By examining this file with a text editor I found that the file
included alongside the data of my table MANY zeros which caused the big
file size.

Does someone of you have an idea what could cause the export of
trillions zeros into my textfile and how to only export the significant
data of my table ?

Best regards,

Daniel

|||There were no surprises in the table definition. Storage of a row in
SQL Server, with all the varying length columns at their upper limit,
is around 2000 bytes, for whatever that is worth. Output of a maxed
out row to a unicode text file should be no more than a few hundred
bytes longer.

Did you save the DTS package that the export wizard created? Have you
tried running the wizard again? Did you specify fixed-width or
delimited? ASCII or UNICODE? (I expect UNICODE to handle the
NVARCHAR columns.)

I would run the wizard again, being sure to save the package. That at
least will give something to inspect on the code side if the output
file is still screwy.

Roy Harvey
Beacon Falls, CT

On 24 Aug 2006 06:11:12 -0700, "Daniel Wetzler"
<Daniel.Wetzler@.sig.bizwrote:

Quote:

Originally Posted by

>Hi Roy,
>
>thanks for your answer.
>
>Here's the table definition :
>
>
>CREATE TABLE [dbo].[Variables] (
>[ID] [varchar] (140) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>[Var_ref] [int] NOT NULL ,
>[Group_Ref] [int] NULL ,
>[Machines_Ref] [int] NULL ,
>[TransfersID] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
>,
>[Compatibility] [int] NULL ,
>[CompatibilityL1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS
>NULL ,
>[Category] [int] NULL ,
>[CategoryL1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
>,
>[AnalysisResponsible] [tinyint] NULL ,
>[AnalysisPriority] [int] NULL ,
>[AnalysisDelta] [int] NULL ,
>[AnalysisDeltaValue] [varchar] (30) COLLATE
>SQL_Latin1_General_CP1_CI_AS NULL ,
>[Value] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>[Type] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>[Length] [int] NULL ,
>[Address] [int] NULL ,
>[Offset] [int] NULL ,
>[Title1] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>[Title2] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>[Title3] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>[Title4] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>[AggregationTitle1] [nvarchar] (100) COLLATE
>SQL_Latin1_General_CP1_CI_AS NULL ,
>[AggregationTitle2] [nvarchar] (100) COLLATE
>SQL_Latin1_General_CP1_CI_AS NULL ,
>[AggregationTitle3] [nvarchar] (100) COLLATE
>SQL_Latin1_General_CP1_CI_AS NULL ,
>[AggregationTitle4] [nvarchar] (100) COLLATE
>SQL_Latin1_General_CP1_CI_AS NULL
>) ON [PRIMARY]
>GO
>
>Best regards,
>
>Daniel
>
>
>
>Roy Harvey schrieb:
>

Quote:

Originally Posted by

>Posting the table definition (CREATE TABLE) would help a lot.
>>
>Roy Harvey
>Beacon Falls, CT
>>
>On 24 Aug 2006 02:07:36 -0700, "Daniel Wetzler"
><Daniel.Wetzler@.sig.bizwrote:
>>

Quote:

Originally Posted by

>Dear MSSQL- experts,
>
>I have a strange problem with SQLSERVER 2000.
>I tried to export a table of about 40000 lines into a text file using
>the Enterprise manager
>export assitant. I was astonished to get an exported text file of about
>400 MB instead 16 MB which is the normal size of that data.
>By examining this file with a text editor I found that the file
>included alongside the data of my table MANY zeros which caused the big
>file size.
>
>Does someone of you have an idea what could cause the export of
>trillions zeros into my textfile and how to only export the significant
>data of my table ?
>
>Best regards,
>
>Daniel

Problem with different version of SQL Server

Dear All,
I have a server that is running SQL Server 6.5 and SQl Server 7.0.
Then I install an instance of SQL Server 2000 and run the SQL Server
Upgrade wizard. But the database selection screen, some of the SQL
Server 6.5 databases are not listed, so I canceled the SQL Server
upgrade wizard.
I need to make SQL Server 6.5 databases are listed in the wizard. So
What should I do?
Thanks
Robert Lie
Hi
Does the user that is logged in have permissions to the databases?
What databases are missing? The upgrade wizard will not upgrade System
databases.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Robert Lie" wrote:

> Dear All,
> I have a server that is running SQL Server 6.5 and SQl Server 7.0.
> Then I install an instance of SQL Server 2000 and run the SQL Server
> Upgrade wizard. But the database selection screen, some of the SQL
> Server 6.5 databases are not listed, so I canceled the SQL Server
> upgrade wizard.
> I need to make SQL Server 6.5 databases are listed in the wizard. So
> What should I do?
> Thanks
> Robert Lie
>
|||I agree with Mike, it is probably a permsission problem... You will only see
the databases you have permissions for... Log in as a system admin and try
again.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:1117431463.159386.73310@.g49g2000cwa.googlegro ups.com...
> Dear All,
> I have a server that is running SQL Server 6.5 and SQl Server 7.0.
> Then I install an instance of SQL Server 2000 and run the SQL Server
> Upgrade wizard. But the database selection screen, some of the SQL
> Server 6.5 databases are not listed, so I canceled the SQL Server
> upgrade wizard.
> I need to make SQL Server 6.5 databases are listed in the wizard. So
> What should I do?
> Thanks
> Robert Lie
>
|||No, I have a full access since i'm the administrator.
Should I run MS Server-Switch application then rerun the SQL Server
upgrade wizard?
Pls some advice.
Thanks
Wayne Snyder wrote:
> I agree with Mike, it is probably a permsission problem... You will only see
> the databases you have permissions for... Log in as a system admin and try
> again.
>

Problem with different version of SQL Server

Dear All,
I have a server that is running SQL Server 6.5 and SQl Server 7.0.
Then I install an instance of SQL Server 2000 and run the SQL Server
Upgrade wizard. But the database selection screen, some of the SQL
Server 6.5 databases are not listed, so I canceled the SQL Server
upgrade wizard.
I need to make SQL Server 6.5 databases are listed in the wizard. So
What should I do?
Thanks
Robert LieHi
Does the user that is logged in have permissions to the databases?
What databases are missing? The upgrade wizard will not upgrade System
databases.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Robert Lie" wrote:

> Dear All,
> I have a server that is running SQL Server 6.5 and SQl Server 7.0.
> Then I install an instance of SQL Server 2000 and run the SQL Server
> Upgrade wizard. But the database selection screen, some of the SQL
> Server 6.5 databases are not listed, so I canceled the SQL Server
> upgrade wizard.
> I need to make SQL Server 6.5 databases are listed in the wizard. So
> What should I do?
> Thanks
> Robert Lie
>|||I agree with Mike, it is probably a permsission problem... You will only see
the databases you have permissions for... Log in as a system admin and try
again.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:1117431463.159386.73310@.g49g2000cwa.googlegroups.com...
> Dear All,
> I have a server that is running SQL Server 6.5 and SQl Server 7.0.
> Then I install an instance of SQL Server 2000 and run the SQL Server
> Upgrade wizard. But the database selection screen, some of the SQL
> Server 6.5 databases are not listed, so I canceled the SQL Server
> upgrade wizard.
> I need to make SQL Server 6.5 databases are listed in the wizard. So
> What should I do?
> Thanks
> Robert Lie
>|||No, I have a full access since i'm the administrator.
Should I run MS Server-Switch application then rerun the SQL Server
upgrade wizard?
Pls some advice.
Thanks
Wayne Snyder wrote:
> I agree with Mike, it is probably a permsission problem... You will only s
ee
> the databases you have permissions for... Log in as a system admin and try
> again.
>

Problem with different version of SQL Server

Dear All,
I have a server that is running SQL Server 6.5 and SQl Server 7.0.
Then I install an instance of SQL Server 2000 and run the SQL Server
Upgrade wizard. But the database selection screen, some of the SQL
Server 6.5 databases are not listed, so I canceled the SQL Server
upgrade wizard.
I need to make SQL Server 6.5 databases are listed in the wizard. So
What should I do?
Thanks
Robert LieHi
Does the user that is logged in have permissions to the databases?
What databases are missing? The upgrade wizard will not upgrade System
databases.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Robert Lie" wrote:
> Dear All,
> I have a server that is running SQL Server 6.5 and SQl Server 7.0.
> Then I install an instance of SQL Server 2000 and run the SQL Server
> Upgrade wizard. But the database selection screen, some of the SQL
> Server 6.5 databases are not listed, so I canceled the SQL Server
> upgrade wizard.
> I need to make SQL Server 6.5 databases are listed in the wizard. So
> What should I do?
> Thanks
> Robert Lie
>|||I agree with Mike, it is probably a permsission problem... You will only see
the databases you have permissions for... Log in as a system admin and try
again.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:1117431463.159386.73310@.g49g2000cwa.googlegroups.com...
> Dear All,
> I have a server that is running SQL Server 6.5 and SQl Server 7.0.
> Then I install an instance of SQL Server 2000 and run the SQL Server
> Upgrade wizard. But the database selection screen, some of the SQL
> Server 6.5 databases are not listed, so I canceled the SQL Server
> upgrade wizard.
> I need to make SQL Server 6.5 databases are listed in the wizard. So
> What should I do?
> Thanks
> Robert Lie
>|||No, I have a full access since i'm the administrator.
Should I run MS Server-Switch application then rerun the SQL Server
upgrade wizard?
Pls some advice.
Thanks
Wayne Snyder wrote:
> I agree with Mike, it is probably a permsission problem... You will only see
> the databases you have permissions for... Log in as a system admin and try
> again.
>

Problem with Dependencies and Default Values

Dear Anyone,

Im having trouble with RS2005 with regards to dependencies of report parameters and the default value. Below is my scenario:

1st parameter:

List of Letters from A to Z

Multiple Select

2nd Parameter:

List of Names starting with the last name

Uses 1 data set for list of values and default values

Multiple Select

Steps:

Select 2 letters from the 1st parameter. This action would refresh the list of values of the 2nd parameter.

Inspect the 2nd parameter. You will notice that all values are selected.

Select another letter from the first parameter. This action would refresh the list of values of the 2nd parameter.

Inspect the 2nd parameter. You will notice that not all is selected despite the fact that the data set being used to populate the report parameter is the same as with the default values

Is the behavior of the report parameters really like this? If so, how can I make it in a way that whenever I select a new letter from the first parameter and when the 2nd parameter gets refreshed because of the depencies, all values will still be selected despite the number of times I add more values to the first parameter?

Thanks,

Joseph

Is there a resolution to this issue? How do we overcome this behavior? I am running into the same issue in my reports.

apex|||Bumping up this thread. Any resolution to this problem will be very helpful.

Problem with Dependencies and Default Values

Dear Anyone,

Im having trouble with RS2005 with regards to dependencies of report parameters and the default value. Below is my scenario:

1st parameter:

List of Letters from A to Z

Multiple Select

2nd Parameter:

List of Names starting with the last name

Uses 1 data set for list of values and default values

Multiple Select

Steps:

Select 2 letters from the 1st parameter. This action would refresh the list of values of the 2nd parameter.

Inspect the 2nd parameter. You will notice that all values are selected.

Select another letter from the first parameter. This action would refresh the list of values of the 2nd parameter.

Inspect the 2nd parameter. You will notice that not all is selected despite the fact that the data set being used to populate the report parameter is the same as with the default values

Is the behavior of the report parameters really like this? If so, how can I make it in a way that whenever I select a new letter from the first parameter and when the 2nd parameter gets refreshed because of the depencies, all values will still be selected despite the number of times I add more values to the first parameter?

Thanks,

Joseph

Is there a resolution to this issue? How do we overcome this behavior? I am running into the same issue in my reports.

apex|||Bumping up this thread. Any resolution to this problem will be very helpful.

Problem with datatypes...

Dear Friends,

I have a problem with datatypes....

The error is "Cannot convert between unicode and non-unicode..."

The column in source is nvarchar(32) and in the destination is varchar(32)... ok...

But in the DataReader Source in the SQLCommand I've converted the column into varchar(32) with

convert(varchar(32), Equities.Equities_Name) as CL_FOLDER_ID

Do you have any tip?

Thanks!

Look at the actual output column for the Source, and you will see that that is DT_WSTR, the unicode string type in SSIS. The DR source does not support non-unicode strings, everything becomes a .Net string in the ADO.Net provider world, and and then SSIS will always treat these as DT_WSTR. If you used the OLE-DB Source through, you get support for both DT_STR and DT_WSTR, mapped from nvarchar and varchar respectively.

So in summary since your source will always give you DT_WSTR, you will need to use a conversion transform inside the pipeline, see Derived Column or Data Conversion, either will do.

|||

Darren,

I used the conversion, but I i tryied to use in SQL command, but if it's not possible, OK... I will use the conversion transform...

Thanks!!