Showing posts with label sqlserver. Show all posts
Showing posts with label sqlserver. Show all posts

Thursday, March 29, 2012

Access Denied - SQLSERVER 2005 Integration Services

Hi:

I am getting access denied error "cannot connect to server" while trying to connect Integration Services. I am trying to connect from my laptop to the SQLSERVER database server.

I followed the document "Connecting to a Remove Intergration Services Server" , doc id: aa337083.

But I can connect to IS if I log remotely to the server.

Any thoughts on this ?

Thanks

-Rajesh

I am getting following errors.

===================================

Cannot connect to cvsslmdd1-vm.

===================================

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)


For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476


Program Location:

at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

===================================

Connect to SSIS Service on machine "cvsslmdd1-vm" failed:
Access is denied.
.

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String server, String& serverVersion)
at Microsoft.SqlServer.Dts.SmoEnum.DTSEnum.GetData(EnumResult erParent)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)

===================================

Connect to SSIS Service on machine "cvsslmdd1-vm" failed:
Access is denied.
.

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.GetServerInfo(String bstrMachineName, String& serverVersion)
at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String server, String& serverVersion)

Hi,

I have the same problem and I am not able to figure out why. Any help is appreciated.

Thanks.

Venu

|||Have you followed Books Online procedure:
http://msdn2.microsoft.com/en-us/library/aa337083.aspx|||Yes I did. I am a local admin on that box and it is fine for me. But it doesn't work for my colleague even though I followed the procedure.|||See this http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=22311 and I think BOL actions are incomplete.|||

SQLusert wrote:

See this http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=22311 and I think BOL actions are incomplete.

Or as blogged here:
http://www.ssistalk.com/2007/04/13/ssis-access-is-denied-when-connection-to-remote-ssis-service/sql

Access Denied - SQLSERVER 2005 Integration Services

Hi:

I am getting access denied error "cannot connect to server" while trying to connect Integration Services. I am trying to connect from my laptop to the SQLSERVER database server.

I followed the document "Connecting to a Remove Intergration Services Server" , doc id: aa337083.

But I can connect to IS if I log remotely to the server.

Any thoughts on this ?

Thanks

-Rajesh

I am getting following errors.

===================================

Cannot connect to cvsslmdd1-vm.

===================================

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)


For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476


Program Location:

at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

===================================

Connect to SSIS Service on machine "cvsslmdd1-vm" failed:
Access is denied.
.

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String server, String& serverVersion)
at Microsoft.SqlServer.Dts.SmoEnum.DTSEnum.GetData(EnumResult erParent)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)

===================================

Connect to SSIS Service on machine "cvsslmdd1-vm" failed:
Access is denied.
.

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.GetServerInfo(String bstrMachineName, String& serverVersion)
at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String server, String& serverVersion)

Hi,

I have the same problem and I am not able to figure out why. Any help is appreciated.

Thanks.

Venu

|||Have you followed Books Online procedure:
http://msdn2.microsoft.com/en-us/library/aa337083.aspx|||Yes I did. I am a local admin on that box and it is fine for me. But it doesn't work for my colleague even though I followed the procedure.|||See this http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=22311 and I think BOL actions are incomplete.|||

SQLusert wrote:

See this http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=22311 and I think BOL actions are incomplete.

Or as blogged here:
http://www.ssistalk.com/2007/04/13/ssis-access-is-denied-when-connection-to-remote-ssis-service/

Sunday, March 25, 2012

access data from another sqlserver d.b

I have two databases on the same server and would like to access data from
both. In oracle there is a 'dblink' function that allows you to do this. Wha
t
is the procedure in sqlserver ?
DonIf its the same server and the same instance you can use the epoint
notation, naming the object sas followed:
Databasename.Owner.ObjectsName
If you want to connect to a remote server you can also expand this to:
Servername.Databasename.Owner.ObjectsName
but therefore you have to configure a linked server.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"don" <don@.discussions.microsoft.com> schrieb im Newsbeitrag
news:D2D6750B-DF74-4B41-B578-864258273034@.microsoft.com...
>I have two databases on the same server and would like to access data
>from
> both. In oracle there is a 'dblink' function that allows you to do this.
> What
> is the procedure in sqlserver ?
> Don|||Assuming two databases in the same SQL Server instance: just qualify with th
e database name:
SELECT ...
FROM loctbl INNER JOIN otherdb.dbo.othertbl
...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"don" <don@.discussions.microsoft.com> wrote in message
news:D2D6750B-DF74-4B41-B578-864258273034@.microsoft.com...
>I have two databases on the same server and would like to access data fro
m
> both. In oracle there is a 'dblink' function that allows you to do this. W
hat
> is the procedure in sqlserver ?
> Don

Access Boolean to SqlServer

Hi. In Access I can set a field as Boolean ... what′s the equivalent for SqlServer?
BIT, perhaps. (0, 1, or NULL).
Or, several workarounds. CHAR(1) with 'T' or 'F', 'Y' or 'N', etc.
http://www.aspfaq.com/
(Reverse address to reply.)
"KenA" <KenA@.discussions.microsoft.com> wrote in message
news:1354FE6C-F45A-4D01-A8CA-AFFB0073A6DC@.microsoft.com...
> Hi. In Access I can set a field as Boolean ... what′s the equivalent for
SqlServer?
|||Quick suggestion from years of experience...
Don't use BIT fields - use the CHAR(1) with T or F; or with Y or N.
MS SQL with all it's connectivity potential with other tools - EXCEL, Crystal, etc - should not have "cryptic" values stored in columns. It's so much nicer to connect to a table and see a Y or N instead of a 1 or 0 (or -1 or 0 depending on what denotes t
rue from false!).
Your non-tech users will appreciate this.
"Aaron [SQL Server MVP]" wrote:

> BIT, perhaps. (0, 1, or NULL).
> Or, several workarounds. CHAR(1) with 'T' or 'F', 'Y' or 'N', etc.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "KenA" <KenA@.discussions.microsoft.com> wrote in message
> news:1354FE6C-F45A-4D01-A8CA-AFFB0073A6DC@.microsoft.com...
> SqlServer?
>
>
|||Steve,
Depends on whether you are talking about displaying information to users
or storing it in a database. A bit field is my preferred datatype for
storing booleans as they take up less space and can only accept three
values, 1, 0, NULL (if you can call NULL a value).
The front end application should translate the bit column to a Y/N, or
1/0, checked/unchecked so the user doesn't ahve to guess. That is the
function of the front-end.
You do make a good point for users that have direct access into SQL Server.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Steve Z wrote:
> Quick suggestion from years of experience...
> Don't use BIT fields - use the CHAR(1) with T or F; or with Y or N.
> MS SQL with all it's connectivity potential with other tools - EXCEL, Crystal, etc - should not have "cryptic" values stored in columns. It's so much nicer to connect to a table and see a Y or N instead of a 1 or 0 (or -1 or 0 depending on what denotes
true from false!).[vbcol=seagreen]
> Your non-tech users will appreciate this.
> "Aaron [SQL Server MVP]" wrote:
>
|||And I fall in-between Mark and Ken...
I try to decide what is the primary function for the boolean... If the
answer is for high speed searching then I'll more likely use a bit ( or even
an integer for 32 booleans). If the primary use will simply be for
reporting, then I'd probably use a char(1), so drag.drop report stuff will
be easy...
You could also use bit in the table, and provide a view which exposes the
bit value as a char(1) and get the best of both worlds.
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
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:eZQIDKAYEHA.3012@.tk2msftngp13.phx.gbl...
> Steve,
> Depends on whether you are talking about displaying information to users
> or storing it in a database. A bit field is my preferred datatype for
> storing booleans as they take up less space and can only accept three
> values, 1, 0, NULL (if you can call NULL a value).
> The front end application should translate the bit column to a Y/N, or
> 1/0, checked/unchecked so the user doesn't ahve to guess. That is the
> function of the front-end.
> You do make a good point for users that have direct access into SQL
Server.[vbcol=seagreen]
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Steve Z wrote:
Crystal, etc - should not have "cryptic" values stored in columns. It's so
much nicer to connect to a table and see a Y or N instead of a 1 or 0 (or -1
or 0 depending on what denotes true from false!).[vbcol=seagreen]
for[vbcol=seagreen]
sql

Access Boolean to SqlServer

Hi. In Access I can set a field as Boolean ... what′s the equivalent for Sq
lServer?BIT, perhaps. (0, 1, or NULL).
Or, several workarounds. CHAR(1) with 'T' or 'F', 'Y' or 'N', etc.
http://www.aspfaq.com/
(Reverse address to reply.)
"KenA" <KenA@.discussions.microsoft.com> wrote in message
news:1354FE6C-F45A-4D01-A8CA-AFFB0073A6DC@.microsoft.com...
> Hi. In Access I can set a field as Boolean ... what′s the equivalent for
SqlServer?|||Quick suggestion from years of experience...
Don't use BIT fields - use the CHAR(1) with T or F; or with Y or N.
MS SQL with all it's connectivity potential with other tools - EXCEL, Crysta
l, etc - should not have "cryptic" values stored in columns. It's so much n
icer to connect to a table and see a Y or N instead of a 1 or 0 (or -1 or 0
depending on what denotes t
rue from false!).
Your non-tech users will appreciate this.
"Aaron [SQL Server MVP]" wrote:

> BIT, perhaps. (0, 1, or NULL).
> Or, several workarounds. CHAR(1) with 'T' or 'F', 'Y' or 'N', etc.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "KenA" <KenA@.discussions.microsoft.com> wrote in message
> news:1354FE6C-F45A-4D01-A8CA-AFFB0073A6DC@.microsoft.com...
> SqlServer?
>
>|||Steve,
Depends on whether you are talking about displaying information to users
or storing it in a database. A bit field is my preferred datatype for
storing booleans as they take up less space and can only accept three
values, 1, 0, NULL (if you can call NULL a value).
The front end application should translate the bit column to a Y/N, or
1/0, checked/unchecked so the user doesn't ahve to guess. That is the
function of the front-end.
You do make a good point for users that have direct access into SQL Server.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Steve Z wrote:
> Quick suggestion from years of experience...
> Don't use BIT fields - use the CHAR(1) with T or F; or with Y or N.
> MS SQL with all it's connectivity potential with other tools - EXCEL, Crystal, etc
- should not have "cryptic" values stored in columns. It's so much nicer to connec
t to a table and see a Y or N instead of a 1 or 0 (or -1 or 0 depending on what deno
tes
true from false!).[vbcol=seagreen]
> Your non-tech users will appreciate this.
> "Aaron [SQL Server MVP]" wrote:
>|||And I fall in-between Mark and Ken...
I try to decide what is the primary function for the boolean... If the
answer is for high speed searching then I'll more likely use a bit ( or even
an integer for 32 booleans). If the primary use will simply be for
reporting, then I'd probably use a char(1), so drag.drop report stuff will
be easy...
You could also use bit in the table, and provide a view which exposes the
bit value as a char(1) and get the best of both worlds.
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
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:eZQIDKAYEHA.3012@.tk2msftngp13.phx.gbl...
> Steve,
> Depends on whether you are talking about displaying information to users
> or storing it in a database. A bit field is my preferred datatype for
> storing booleans as they take up less space and can only accept three
> values, 1, 0, NULL (if you can call NULL a value).
> The front end application should translate the bit column to a Y/N, or
> 1/0, checked/unchecked so the user doesn't ahve to guess. That is the
> function of the front-end.
> You do make a good point for users that have direct access into SQL
Server.[vbcol=seagreen]
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Steve Z wrote:
Crystal, etc - should not have "cryptic" values stored in columns. It's so
much nicer to connect to a table and see a Y or N instead of a 1 or 0 (or -1
or 0 depending on what denotes true from false!).[vbcol=seagreen]
for[vbcol=seagreen]

Access Boolean to SqlServer

Hi. In Access I can set a field as Boolean ... what´s the equivalent for SqlServer?BIT, perhaps. (0, 1, or NULL).
Or, several workarounds. CHAR(1) with 'T' or 'F', 'Y' or 'N', etc.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"KenA" <KenA@.discussions.microsoft.com> wrote in message
news:1354FE6C-F45A-4D01-A8CA-AFFB0073A6DC@.microsoft.com...
> Hi. In Access I can set a field as Boolean ... what´s the equivalent for
SqlServer?|||Quick suggestion from years of experience...
Don't use BIT fields - use the CHAR(1) with T or F; or with Y or N.
MS SQL with all it's connectivity potential with other tools - EXCEL, Crystal, etc - should not have "cryptic" values stored in columns. It's so much nicer to connect to a table and see a Y or N instead of a 1 or 0 (or -1 or 0 depending on what denotes true from false!).
Your non-tech users will appreciate this.
"Aaron [SQL Server MVP]" wrote:
> BIT, perhaps. (0, 1, or NULL).
> Or, several workarounds. CHAR(1) with 'T' or 'F', 'Y' or 'N', etc.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "KenA" <KenA@.discussions.microsoft.com> wrote in message
> news:1354FE6C-F45A-4D01-A8CA-AFFB0073A6DC@.microsoft.com...
> > Hi. In Access I can set a field as Boolean ... what�´s the equivalent for
> SqlServer?
>
>|||Steve,
Depends on whether you are talking about displaying information to users
or storing it in a database. A bit field is my preferred datatype for
storing booleans as they take up less space and can only accept three
values, 1, 0, NULL (if you can call NULL a value).
The front end application should translate the bit column to a Y/N, or
1/0, checked/unchecked so the user doesn't ahve to guess. That is the
function of the front-end.
You do make a good point for users that have direct access into SQL Server.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Steve Z wrote:
> Quick suggestion from years of experience...
> Don't use BIT fields - use the CHAR(1) with T or F; or with Y or N.
> MS SQL with all it's connectivity potential with other tools - EXCEL, Crystal, etc - should not have "cryptic" values stored in columns. It's so much nicer to connect to a table and see a Y or N instead of a 1 or 0 (or -1 or 0 depending on what denotes true from false!).
> Your non-tech users will appreciate this.
> "Aaron [SQL Server MVP]" wrote:
>
>>BIT, perhaps. (0, 1, or NULL).
>>Or, several workarounds. CHAR(1) with 'T' or 'F', 'Y' or 'N', etc.
>>--
>>http://www.aspfaq.com/
>>(Reverse address to reply.)
>>
>>
>>"KenA" <KenA@.discussions.microsoft.com> wrote in message
>>news:1354FE6C-F45A-4D01-A8CA-AFFB0073A6DC@.microsoft.com...
>>Hi. In Access I can set a field as Boolean ... what�´s the equivalent for
>>SqlServer?
>>|||And I fall in-between Mark and Ken...
I try to decide what is the primary function for the boolean... If the
answer is for high speed searching then I'll more likely use a bit ( or even
an integer for 32 booleans). If the primary use will simply be for
reporting, then I'd probably use a char(1), so drag.drop report stuff will
be easy...
You could also use bit in the table, and provide a view which exposes the
bit value as a char(1) and get the best of both worlds.
--
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
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:eZQIDKAYEHA.3012@.tk2msftngp13.phx.gbl...
> Steve,
> Depends on whether you are talking about displaying information to users
> or storing it in a database. A bit field is my preferred datatype for
> storing booleans as they take up less space and can only accept three
> values, 1, 0, NULL (if you can call NULL a value).
> The front end application should translate the bit column to a Y/N, or
> 1/0, checked/unchecked so the user doesn't ahve to guess. That is the
> function of the front-end.
> You do make a good point for users that have direct access into SQL
Server.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Steve Z wrote:
> > Quick suggestion from years of experience...
> >
> > Don't use BIT fields - use the CHAR(1) with T or F; or with Y or N.
> >
> > MS SQL with all it's connectivity potential with other tools - EXCEL,
Crystal, etc - should not have "cryptic" values stored in columns. It's so
much nicer to connect to a table and see a Y or N instead of a 1 or 0 (or -1
or 0 depending on what denotes true from false!).
> >
> > Your non-tech users will appreciate this.
> >
> > "Aaron [SQL Server MVP]" wrote:
> >
> >
> >>BIT, perhaps. (0, 1, or NULL).
> >>
> >>Or, several workarounds. CHAR(1) with 'T' or 'F', 'Y' or 'N', etc.
> >>
> >>--
> >>http://www.aspfaq.com/
> >>(Reverse address to reply.)
> >>
> >>
> >>
> >>
> >>"KenA" <KenA@.discussions.microsoft.com> wrote in message
> >>news:1354FE6C-F45A-4D01-A8CA-AFFB0073A6DC@.microsoft.com...
> >>
> >>Hi. In Access I can set a field as Boolean ... what´s the equivalent
for
> >>
> >>SqlServer?
> >>
> >>
> >>

Tuesday, March 20, 2012

Access 2007 Project - SQL Server 2005

Does anyone know whether it is possibe to create an Access 2007 Project - SQL
Server 2005 and have the ability to switch the current database within the
project?
I have multiple customer databases that need updating.
Thanks in advance.
Why don't you read the reply to your yesterday's post in the other group?
"Ed C" <Ed C@.discussions.microsoft.com> wrote in message
news:FA02AA5A-11A7-49C1-8923-E1A9C1CB8830@.microsoft.com...
> Does anyone know whether it is possibe to create an Access 2007 Project -
> SQL
> Server 2005 and have the ability to switch the current database within the
> project?
> I have multiple customer databases that need updating.
> Thanks in advance.
sql

Access 2007 Project - SQL Server 2005

Does anyone know whether it is possibe to create an Access 2007 Project - SQ
L
Server 2005 and have the ability to switch the current database within the
project?
I have multiple customer databases that need updating.
Thanks in advance.Why don't you read the reply to your yesterday's post in the other group?
"Ed C" <Ed C@.discussions.microsoft.com> wrote in message
news:FA02AA5A-11A7-49C1-8923-E1A9C1CB8830@.microsoft.com...
> Does anyone know whether it is possibe to create an Access 2007 Project -
> SQL
> Server 2005 and have the ability to switch the current database within the
> project?
> I have multiple customer databases that need updating.
> Thanks in advance.

Access 2003 and SQL Server Express

Does anybody know if there is and update for access 2003 which could make it compatible with SQLServer Express. Actually XML Field are not supported, Diagram too, and surely much more.

Any help would be appreciate.

No, the special features are actually not supported. Only the SQL Server 2k compatible features are available.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

Access 2003 and ADP AND sqlserver 2005

Is ADP dying?
Hi
It is being replaced over time by newer technology like "Microsoft Visual
Studio 2005 Tools for the Microsoft Office System"and what will be in Office
12 is not known yet.
The Access engine is really getting to the end of like, especially wit he
functionality supplied by SQL Server 2005 Express Edition.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Bruno" <info@.brusoft.be> wrote in message
news:uBGo49D6FHA.632@.TK2MSFTNGP10.phx.gbl...
> Is ADP dying?
>
>
>

Access 2003 and ADP AND sqlserver 2005

Is ADP dying?Hi
It is being replaced over time by newer technology like "Microsoft Visual
Studio 2005 Tools for the Microsoft Office System"and what will be in Office
12 is not known yet.
The Access engine is really getting to the end of like, especially wit he
functionality supplied by SQL Server 2005 Express Edition.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Bruno" <info@.brusoft.be> wrote in message
news:uBGo49D6FHA.632@.TK2MSFTNGP10.phx.gbl...
> Is ADP dying?
>
>
>

Monday, March 19, 2012

Access .Rdl from Asp.net webforms

Hi,

I am new to Sqlserver reporting.I have created few reports using vs2005 busineess intelligence projects and report designer-wizards.

I want to add/access those reports from webforms?is it possible?or do i need to deploy reports over report server.If i run the server i am able to see the report.

If i want to access from .aspx page what do i need to do?I tried adding existing item,.rdl but i do see only .xml part of .rdl .

Can anyone help me on this.

Thanks,

kar1978

Use ReportViewer control

It can be used with

// Set the processing mode for the ReportViewer to Remote

reportViewer.ProcessingMode =ProcessingMode.Remote;

or

reportViewer.ProcessingMode =ProcessingMode.Local

Sunday, March 11, 2012

Accesing information from an Informix database

Hi,

I d like to know if there is any way to access an Informix database from sqlserver 2005.

We are trying to build a data warehouse in SS2005, and I want to know If I could avoid the generation of hundreds of flats files from Informix and loading them into SS2005, directly recovering all information from SS2005 across any kind of migration or connection.

Any help would be very appreciated

Regards.We access an Informix database from SQLSVR 2000 via an ODBC connection using a driver named MERANT 3.50 32-BIT INFORMIX.|||That's the way we do it as well. ODBC connection, linked server ... start moving the data !

Gr,
Yveau

Accesing a database with password

Hello, I have a database and I need to copy and attach it in a customer SQL
server. But I don't want them to be able to see the tables structures or my
company's stored procedures. Is this possible to have the database in their
sql server and not allow them to see the data or tables. Or only with a
password be able to access the database. Like in Microsoft Access that you
can assign a password to the database and everytime I open the file it
prompts for the password.
Thanks in advance
JennyferdYou can "encrypt" the stored procedures (see BOL, Create Procedure "With
Encryption"), but there are tools out there that pretty handily defeat such
encryption. It's pretty much just enough to keep unmotivated honest people
honest. You could use Views to prevent people from accessing the underlying
tables directly, but on their box they will presumably have sa/administrator
access and will be able to view your table structures... I'm not sure of
any methods to hide that info... Although someone else here may know.
To be honest, to me it's a little counter-intuitive - I usually supply full
documentation on the database tables and structures to clients, since they
invariably try to generate reports, etc., on their own... to me it makes
more sense to give them the tools to access it the right way, set up
read-only views, etc., so they don't trash the system...
"Jennyfer J Barco" <pdwhitt@.nospam.wdsinc.com> wrote in message
news:uTp4scxLFHA.3420@.tk2msftngp13.phx.gbl...
> Hello, I have a database and I need to copy and attach it in a customer
> SQL
> server. But I don't want them to be able to see the tables structures or
> my
> company's stored procedures. Is this possible to have the database in
> their
> sql server and not allow them to see the data or tables. Or only with a
> password be able to access the database. Like in Microsoft Access that you
> can assign a password to the database and everytime I open the file it
> prompts for the password.
> Thanks in advance
> Jennyferd
>

Thursday, March 8, 2012

ABS function issue

Hi Onibuzz,
One month ago i have posted one topic on
microsoft.public.sqlserver.programming group and u have posted a reply
to it.
Your reply was a great help to me but i am stuck with another small
issue in the same query. I would greatly appreciate if you help me
in finding the solution.
My old query and ur reply is there in this same mail. I want little
modification in the query.
My new query is if the date in the table 'Expense_addl values' is
suppose '2006-05-20' (LockDt)
and i have exchangerate available for dates '2006-05-21' and
'2006-05-19' then i want the exchangerate for the previous date
i.e. '2006-05-19' i.e. if the newer or older gap is same then i want
for the older date.
i am currently using ABS function as suggested by u :-
abs(datediff(dd,ER1.ExchangeRateDate,LockDt)) asc)
but this is giving exchangerate for the new date i.e. '2006-05-21'
Could you plese help me with this ?
Thanks in advance
Regards,
Rajeev Rajput
From: Omnibuzz - view profile
Date: Thurs, Jun 22 2006 4:01 pm
Email: Omnibuzz <Omnib...@.discussions.microsoft.com>
Groups: microsoft.public.sqlserver.programming
Not yet ratedRating:
show options
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse | Find messages by this author
Hi Rajeev,
I don't know what you do that convert and nullif and all.
But I have substituted a query that will give you the exchange rate.
this update works. But no where clause for your Expense_addl.
I didn't try to figure out from your query :)
UPDATE Expense_Addl
SET HostAmt = ROUND(CONVERT(MONEY,(ISNULL(((CONVERT(FLOAT,
Expense_Addl.HostAmt))
* 100) / NULLIF(ISNULL((select top 1 ExchangeRate from ExchangeRates
ER1
where
ER1.CurrencyCd = Expense_Addl.HostCurrencyCD
order by abs(datediff(dd,ER1.ExchangeRateDate,LockDt))
asc),0),0),0))), 4)
Hope this helps.
--
-Omnibuzz (The SQL GC)
My old query - >
I have two tables Expense_Addl and ExchangeRates
These are the scripts
CREATE TABLE Expense_Addl (
FileId int,
HostAmt money,
HostCurrencyCd char(4),
LockDt smalldatetime
)
INSERT INTO Expense_addl values (1001, 500, 'USD', '2006-06-15')
INSERT INTO Expense_addl values (1001, 500, 'USD', '2006-06-19')
INSERT INTO Expense_addl values (1001, 500, 'USD', '2002-01-01')
In the above table HostCurrencycd can be any currenycode like 'USD',
'INR', YEN'
CREATE TABLE ExchangeRates
(CurrencyCd CHAR(4), ExchangeRate MONEY, ExchangeRateDate
SMALLDATETIME)
INSERT INTO ExchangeRates values ('USD', 0.45, '2006-06-21')
INSERT INTO ExchangeRates values ('USD', 0.40, '2006-06-14')
Now i have to update the HostAmt in Expense_Addl table taking
exchangerate for the hostcurrencycd from table ExchangeRates
for the nearest date like this
For e.g. HOstAmt in first row should take exchangerate as 0.40 because
lockdt 15th june is closet to 14th june
Similarly HOstAmt in second row should take exchangerate as 0.45
because lockdt 19th june is closet to 21st june
Similarly HOstAmt in third row should take exchangerate as 0.40 because
lockdt 01st jan is closet to 14th june
I am trying like below but not getting the correct results.
UPDATE EA
SET HostAmt = ROUND(CONVERT(MONEY,(ISNULL(((CONVERT(FLOAT, EA.HostAmt))
* 100) / NULLIF(ISNULL(ER1.ExchangeRate,0),0),0))), 4)
FROM Expense_Addl EA(NOLOCK)
INNER JOIN ExchangeRates ER1(NOLOCK) ON EA.HostCurrencyCd = ER1.CurrencyCd
INNER JOIN
(SELECT CurrencyCd, MAX(ExchangeRateDate) As ExchangeRateDate
FROM ExchangeRates ER ,Expense_Addl EA(NOLOCK) Where
ER.ExchangeRateDate <= EA.lockdt
GROUP BY ER.CurrencyCd
) T1
ON T1.ExchangeRateDate = ER1.ExchangeRateDate AND T1.CurrencyCd = ER1.CurrencyCdIf you desire previous dates only, then the use of ABS should be removed,
and the possible dates limited to negative values only.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Rajeev" <rajeev.rajput@.gmail.com> wrote in message
news:1155128270.682995.67550@.n13g2000cwa.googlegroups.com...
> Hi Onibuzz,
> One month ago i have posted one topic on
> microsoft.public.sqlserver.programming group and u have posted a reply
> to it.
> Your reply was a great help to me but i am stuck with another small
> issue in the same query. I would greatly appreciate if you help me
> in finding the solution.
> My old query and ur reply is there in this same mail. I want little
> modification in the query.
> My new query is if the date in the table 'Expense_addl values' is
> suppose '2006-05-20' (LockDt)
> and i have exchangerate available for dates '2006-05-21' and
> '2006-05-19' then i want the exchangerate for the previous date
> i.e. '2006-05-19' i.e. if the newer or older gap is same then i want
> for the older date.
> i am currently using ABS function as suggested by u :-
> abs(datediff(dd,ER1.ExchangeRateDate,LockDt)) asc)
> but this is giving exchangerate for the new date i.e. '2006-05-21'
> Could you plese help me with this ?
> Thanks in advance
> Regards,
> Rajeev Rajput
>
> From: Omnibuzz - view profile
> Date: Thurs, Jun 22 2006 4:01 pm
> Email: Omnibuzz <Omnib...@.discussions.microsoft.com>
> Groups: microsoft.public.sqlserver.programming
> Not yet ratedRating:
> show options
> Reply | Reply to Author | Forward | Print | Individual Message | Show
> original | Report Abuse | Find messages by this author
>
> Hi Rajeev,
> I don't know what you do that convert and nullif and all.
> But I have substituted a query that will give you the exchange rate.
> this update works. But no where clause for your Expense_addl.
> I didn't try to figure out from your query :)
> UPDATE Expense_Addl
> SET HostAmt = ROUND(CONVERT(MONEY,(ISNULL(((CONVERT(FLOAT,
> Expense_Addl.HostAmt))
> * 100) / NULLIF(ISNULL((select top 1 ExchangeRate from ExchangeRates
> ER1
> where
> ER1.CurrencyCd = Expense_Addl.HostCurrencyCD
> order by abs(datediff(dd,ER1.ExchangeRateDate,LockDt))
> asc),0),0),0))), 4)
>
> Hope this helps.
> --
> -Omnibuzz (The SQL GC)
>
> My old query - >
> I have two tables Expense_Addl and ExchangeRates
> These are the scripts
>
> CREATE TABLE Expense_Addl (
> FileId int,
> HostAmt money,
> HostCurrencyCd char(4),
> LockDt smalldatetime
> )
>
> INSERT INTO Expense_addl values (1001, 500, 'USD', '2006-06-15')
> INSERT INTO Expense_addl values (1001, 500, 'USD', '2006-06-19')
> INSERT INTO Expense_addl values (1001, 500, 'USD', '2002-01-01')
>
> In the above table HostCurrencycd can be any currenycode like 'USD',
> 'INR', YEN'
>
> CREATE TABLE ExchangeRates
> (CurrencyCd CHAR(4), ExchangeRate MONEY, ExchangeRateDate
> SMALLDATETIME)
>
> INSERT INTO ExchangeRates values ('USD', 0.45, '2006-06-21')
> INSERT INTO ExchangeRates values ('USD', 0.40, '2006-06-14')
>
> Now i have to update the HostAmt in Expense_Addl table taking
> exchangerate for the hostcurrencycd from table ExchangeRates
> for the nearest date like this
>
> For e.g. HOstAmt in first row should take exchangerate as 0.40 because
> lockdt 15th june is closet to 14th june
> Similarly HOstAmt in second row should take exchangerate as 0.45
> because lockdt 19th june is closet to 21st june
> Similarly HOstAmt in third row should take exchangerate as 0.40 because
> lockdt 01st jan is closet to 14th june
>
> I am trying like below but not getting the correct results.
>
> UPDATE EA
> SET HostAmt = ROUND(CONVERT(MONEY,(ISNULL(((CONVERT(FLOAT, EA.HostAmt))
> * 100) / NULLIF(ISNULL(ER1.ExchangeRate,0),0),0))), 4)
> FROM Expense_Addl EA(NOLOCK)
> INNER JOIN ExchangeRates ER1(NOLOCK) ON EA.HostCurrencyCd => ER1.CurrencyCd
> INNER JOIN
> (SELECT CurrencyCd, MAX(ExchangeRateDate) As ExchangeRateDate
> FROM ExchangeRates ER ,Expense_Addl EA(NOLOCK) Where
> ER.ExchangeRateDate <= EA.lockdt
> GROUP BY ER.CurrencyCd
> ) T1
> ON T1.ExchangeRateDate = ER1.ExchangeRateDate AND T1.CurrencyCd => ER1.CurrencyCd
>

ABS function issue

Hi Onibuzz,
One month ago i have posted one topic on
microsoft.public.sqlserver.programming group and u have posted a reply
to it.
Your reply was a great help to me but i am stuck with another small
issue in the same query. I would greatly appreciate if you help me
in finding the solution.
My old query and ur reply is there in this same mail. I want little
modification in the query.
My new query is if the date in the table 'Expense_addl values' is
suppose '2006-05-20' (LockDt)
and i have exchangerate available for dates '2006-05-21' and
'2006-05-19' then i want the exchangerate for the previous date
i.e. '2006-05-19' i.e. if the newer or older gap is same then i want
for the older date.
i am currently using ABS function as suggested by u :-
abs(datediff(dd,ER1.ExchangeRateDate,LockDt)) asc)
but this is giving exchangerate for the new date i.e. '2006-05-21'
Could you plese help me with this ?
Thanks in advance
Regards,
Rajeev Rajput
From: Omnibuzz - view profile
Date: Thurs, Jun 22 2006 4:01 pm
Email: Omnibuzz <Omnib...@.discussions.microsoft.com>
Groups: microsoft.public.sqlserver.programming
Not yet ratedRating:
show options
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse | Find messages by this author
Hi Rajeev,
I don't know what you do that convert and nullif and all.
But I have substituted a query that will give you the exchange rate.
this update works. But no where clause for your Expense_addl.
I didn't try to figure out from your query
UPDATE Expense_Addl
SET HostAmt = ROUND(CONVERT(MONEY,(ISNULL(((CONVERT(FL
OAT,
Expense_Addl.HostAmt))
* 100) / NULLIF(ISNULL((select top 1 ExchangeRate from ExchangeRates
ER1
where
ER1.CurrencyCd = Expense_Addl.HostCurrencyCD
order by abs(datediff(dd,ER1.ExchangeRateDate,LockDt))
asc),0),0),0))), 4)
Hope this helps.
--
-Omnibuzz (The SQL GC)
My old query - >
I have two tables Expense_Addl and ExchangeRates
These are the scripts
CREATE TABLE Expense_Addl (
FileId int,
HostAmt money,
HostCurrencyCd char(4),
LockDt smalldatetime
)
INSERT INTO Expense_addl values (1001, 500, 'USD', '2006-06-15')
INSERT INTO Expense_addl values (1001, 500, 'USD', '2006-06-19')
INSERT INTO Expense_addl values (1001, 500, 'USD', '2002-01-01')
In the above table HostCurrencycd can be any currenycode like 'USD',
'INR', YEN'
CREATE TABLE ExchangeRates
(CurrencyCd CHAR(4), ExchangeRate MONEY, ExchangeRateDate
SMALLDATETIME)
INSERT INTO ExchangeRates values ('USD', 0.45, '2006-06-21')
INSERT INTO ExchangeRates values ('USD', 0.40, '2006-06-14')
Now i have to update the HostAmt in Expense_Addl table taking
exchangerate for the hostcurrencycd from table ExchangeRates
for the nearest date like this
For e.g. HOstAmt in first row should take exchangerate as 0.40 because
lockdt 15th june is closet to 14th june
Similarly HOstAmt in second row should take exchangerate as 0.45
because lockdt 19th june is closet to 21st june
Similarly HOstAmt in third row should take exchangerate as 0.40 because
lockdt 01st jan is closet to 14th june
I am trying like below but not getting the correct results.
UPDATE EA
SET HostAmt = ROUND(CONVERT(MONEY,(ISNULL(((CONVERT(FL
OAT, EA.HostAmt))
* 100) / NULLIF(ISNULL(ER1.ExchangeRate,0),0),0))), 4)
FROM Expense_Addl EA(NOLOCK)
INNER JOIN ExchangeRates ER1(NOLOCK) ON EA.HostCurrencyCd =
ER1.CurrencyCd
INNER JOIN
(SELECT CurrencyCd, MAX(ExchangeRateDate) As ExchangeRateDate
FROM ExchangeRates ER ,Expense_Addl EA(NOLOCK) Where
ER.ExchangeRateDate <= EA.lockdt
GROUP BY ER.CurrencyCd
) T1
ON T1.ExchangeRateDate = ER1.ExchangeRateDate AND T1.CurrencyCd =
ER1.CurrencyCdIf you desire previous dates only, then the use of ABS should be removed,
and the possible dates limited to negative values only.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Rajeev" <rajeev.rajput@.gmail.com> wrote in message
news:1155128270.682995.67550@.n13g2000cwa.googlegroups.com...
> Hi Onibuzz,
> One month ago i have posted one topic on
> microsoft.public.sqlserver.programming group and u have posted a reply
> to it.
> Your reply was a great help to me but i am stuck with another small
> issue in the same query. I would greatly appreciate if you help me
> in finding the solution.
> My old query and ur reply is there in this same mail. I want little
> modification in the query.
> My new query is if the date in the table 'Expense_addl values' is
> suppose '2006-05-20' (LockDt)
> and i have exchangerate available for dates '2006-05-21' and
> '2006-05-19' then i want the exchangerate for the previous date
> i.e. '2006-05-19' i.e. if the newer or older gap is same then i want
> for the older date.
> i am currently using ABS function as suggested by u :-
> abs(datediff(dd,ER1.ExchangeRateDate,LockDt)) asc)
> but this is giving exchangerate for the new date i.e. '2006-05-21'
> Could you plese help me with this ?
> Thanks in advance
> Regards,
> Rajeev Rajput
>
> From: Omnibuzz - view profile
> Date: Thurs, Jun 22 2006 4:01 pm
> Email: Omnibuzz <Omnib...@.discussions.microsoft.com>
> Groups: microsoft.public.sqlserver.programming
> Not yet ratedRating:
> show options
> Reply | Reply to Author | Forward | Print | Individual Message | Show
> original | Report Abuse | Find messages by this author
>
> Hi Rajeev,
> I don't know what you do that convert and nullif and all.
> But I have substituted a query that will give you the exchange rate.
> this update works. But no where clause for your Expense_addl.
> I didn't try to figure out from your query
> UPDATE Expense_Addl
> SET HostAmt = ROUND(CONVERT(MONEY,(ISNULL(((CONVERT(FL
OAT,
> Expense_Addl.HostAmt))
> * 100) / NULLIF(ISNULL((select top 1 ExchangeRate from ExchangeRates
> ER1
> where
> ER1.CurrencyCd = Expense_Addl.HostCurrencyCD
> order by abs(datediff(dd,ER1.ExchangeRateDate,LockDt))
> asc),0),0),0))), 4)
>
> Hope this helps.
> --
> -Omnibuzz (The SQL GC)
>
> My old query - >
> I have two tables Expense_Addl and ExchangeRates
> These are the scripts
>
> CREATE TABLE Expense_Addl (
> FileId int,
> HostAmt money,
> HostCurrencyCd char(4),
> LockDt smalldatetime
> )
>
> INSERT INTO Expense_addl values (1001, 500, 'USD', '2006-06-15')
> INSERT INTO Expense_addl values (1001, 500, 'USD', '2006-06-19')
> INSERT INTO Expense_addl values (1001, 500, 'USD', '2002-01-01')
>
> In the above table HostCurrencycd can be any currenycode like 'USD',
> 'INR', YEN'
>
> CREATE TABLE ExchangeRates
> (CurrencyCd CHAR(4), ExchangeRate MONEY, ExchangeRateDate
> SMALLDATETIME)
>
> INSERT INTO ExchangeRates values ('USD', 0.45, '2006-06-21')
> INSERT INTO ExchangeRates values ('USD', 0.40, '2006-06-14')
>
> Now i have to update the HostAmt in Expense_Addl table taking
> exchangerate for the hostcurrencycd from table ExchangeRates
> for the nearest date like this
>
> For e.g. HOstAmt in first row should take exchangerate as 0.40 because
> lockdt 15th june is closet to 14th june
> Similarly HOstAmt in second row should take exchangerate as 0.45
> because lockdt 19th june is closet to 21st june
> Similarly HOstAmt in third row should take exchangerate as 0.40 because
> lockdt 01st jan is closet to 14th june
>
> I am trying like below but not getting the correct results.
>
> UPDATE EA
> SET HostAmt = ROUND(CONVERT(MONEY,(ISNULL(((CONVERT(FL
OAT, EA.HostAmt))
> * 100) / NULLIF(ISNULL(ER1.ExchangeRate,0),0),0))), 4)
> FROM Expense_Addl EA(NOLOCK)
> INNER JOIN ExchangeRates ER1(NOLOCK) ON EA.HostCurrencyCd =
> ER1.CurrencyCd
> INNER JOIN
> (SELECT CurrencyCd, MAX(ExchangeRateDate) As ExchangeRateDate
> FROM ExchangeRates ER ,Expense_Addl EA(NOLOCK) Where
> ER.ExchangeRateDate <= EA.lockdt
> GROUP BY ER.CurrencyCd
> ) T1
> ON T1.ExchangeRateDate = ER1.ExchangeRateDate AND T1.CurrencyCd =
> ER1.CurrencyCd
>

Saturday, February 25, 2012

Friday, February 24, 2012

About SQL Server 7.0 Developer Edition

Hi!
We're planning to run a web application as an intranet on Windows 2000
Server + IIS (ASP) + SQLServer 7.0.
We have a BackOffice 4.5 Developer Edition which includes SQLServer
7.0.
Can we use the SQLServer Developer Edition for our intranet?
Thanks.
Sam
Hi
No. You may not use Developer Edition in a production environment., It can
only be used for development.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<sam.s.kong@.gmail.com> wrote in message
news:1133286216.659677.70150@.g47g2000cwa.googlegro ups.com...
> Hi!
> We're planning to run a web application as an intranet on Windows 2000
> Server + IIS (ASP) + SQLServer 7.0.
> We have a BackOffice 4.5 Developer Edition which includes SQLServer
> 7.0.
> Can we use the SQLServer Developer Edition for our intranet?
>
> Thanks.
> Sam
>

About SQL Server 7.0 Developer Edition

Hi!
We're planning to run a web application as an intranet on Windows 2000
Server + IIS (ASP) + SQLServer 7.0.
We have a BackOffice 4.5 Developer Edition which includes SQLServer
7.0.
Can we use the SQLServer Developer Edition for our intranet?
Thanks.
SamHi
No. You may not use Developer Edition in a production environment., It can
only be used for development.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<sam.s.kong@.gmail.com> wrote in message
news:1133286216.659677.70150@.g47g2000cwa.googlegroups.com...
> Hi!
> We're planning to run a web application as an intranet on Windows 2000
> Server + IIS (ASP) + SQLServer 7.0.
> We have a BackOffice 4.5 Developer Edition which includes SQLServer
> 7.0.
> Can we use the SQLServer Developer Edition for our intranet?
>
> Thanks.
> Sam
>

About SQL Server 7.0 Developer Edition

Hi!
We're planning to run a web application as an intranet on Windows 2000
Server + IIS (ASP) + SQLServer 7.0.
We have a BackOffice 4.5 Developer Edition which includes SQLServer
7.0.
Can we use the SQLServer Developer Edition for our intranet?
Thanks.
SamHi
No. You may not use Developer Edition in a production environment., It can
only be used for development.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<sam.s.kong@.gmail.com> wrote in message
news:1133286216.659677.70150@.g47g2000cwa.googlegroups.com...
> Hi!
> We're planning to run a web application as an intranet on Windows 2000
> Server + IIS (ASP) + SQLServer 7.0.
> We have a BackOffice 4.5 Developer Edition which includes SQLServer
> 7.0.
> Can we use the SQLServer Developer Edition for our intranet?
>
> Thanks.
> Sam
>