describe OK- select not

Hello,
I am connecting to SQLserver via an application running on linux.
Under the hood it does a describe which brings back the field types
for any table OK.
a select always fails (no data returned) however. I am troubleshooting
this remotely and have asked the MSSQL dba to run a select with the
same user id/password that I use on the client - this succeeds.
There is a firewall between client and db, but I guess this is OK cos
the describe succeeds.
Anything I can ask the dba to do or check to help diagnose the
problem? Does it follow that if userid is good for selects on MS box
it will be good for remote queries?
TIA
TonTry connecting to the DB remotely via Query Analyzer. I know you are on
Linux , so can you see if you can connect from a Windows, with the
username/password and run the SELECT . Does it return results?
--
Jack Vamvas
___________________________________
Need an IT job? http://www.ITjobfeed.com/SQL
"ton de w" <ton_de_winter@.yahoo.co.uk> wrote in message
news:1190367783.673561.160950@.22g2000hsm.googlegroups.com...
> Hello,
> I am connecting to SQLserver via an application running on linux.
> Under the hood it does a describe which brings back the field types
> for any table OK.
> a select always fails (no data returned) however. I am troubleshooting
> this remotely and have asked the MSSQL dba to run a select with the
> same user id/password that I use on the client - this succeeds.
> There is a firewall between client and db, but I guess this is OK cos
> the describe succeeds.
> Anything I can ask the dba to do or check to help diagnose the
> problem? Does it follow that if userid is good for selects on MS box
> it will be good for remote queries?
> TIA
> Ton
>|||On 21 Sep, 11:23, "Jack Vamvas" <DEL_TO_RE...@.del.com> wrote:
> Try connecting to the DB remotely via Query Analyzer. I know you are on
> Linux , so can you see if you can connect from a Windows, with the
> username/password and run the SELECT . Does it return results?
> --
> Jack Vamvas
> ___________________________________
> Need an IT job? http://www.ITjobfeed.com/SQL
> "ton de w" <ton_de_win...@.yahoo.co.uk> wrote in messagenews:1190367783.673561.160950@.22g2000hsm.googlegroups.com...
>
> > Hello,
> > I am connecting to SQLserver via an application running on linux.
> > Under the hood it does a describe which brings back the field types
> > for any table OK.
> > a select always fails (no data returned) however. I am troubleshooting
> > this remotely and have asked the MSSQL dba to run a select with the
> > same user id/password that I use on the client - this succeeds.
> > There is a firewall between client and db, but I guess this is OK cos
> > the describe succeeds.
> > Anything I can ask the dba to do or check to help diagnose the
> > problem? Does it follow that if userid is good for selects on MS box
> > it will be good for remote queries?
> > TIA
> > Ton- Hide quoted text -
> - Show quoted text -
Thanks for that Query Analyzer works well with userid/password
So does linux commandline tool tsql which allows me to pull back the
data with a "select * from tablename" - it just needs the !P port
username and password to logon.
This works fine.
However the application I am dealing with does not bring the data back
<sigh>
I am not sure how tsql gets the data without a databasename ie i would
have expected "select * from tablename" to fail and a select * from
databasename.tablename to succeed - perhaps cos of my Oracle
experience.
The application that is failing needs the database name before it will
log on OK. but "select * from tablename" generates a syntax error near
FROM - and so does a "select * from databasename.tablename"|||Ton,
sql server's specification of table in a select statement can have up to
four parts. In addition to the name itself, you can have / may need three
qualifiers:
select column_list from server_name.database_name.schema_name.table_name.
It is recommended if you are in the database where the table is located, you
use the schema_name (also know as owner) to qualify the table. If you are
not in the database where the table is, you need to add the database name
too, and then (better) specify the schema as well, which can be omitted if
it is dbo (such as mydb..mytalbe). If you are accessing a liked server, you
then also need to specify the server name.
In your case, if your default database is where the table is located, when
you establish the connection, you can directly run a select * from
tablename. But select * from databasename.tablename will never work unless
the databasename is the same as the schema name by accident, in which case
sql server considers you were doing a select * from schemaname.tablename.
hth
Quentin
"ton de w" <ton_de_winter@.yahoo.co.uk> wrote in message
news:1190390145.227481.285540@.g4g2000hsf.googlegroups.com...
> On 21 Sep, 11:23, "Jack Vamvas" <DEL_TO_RE...@.del.com> wrote:
>> Try connecting to the DB remotely via Query Analyzer. I know you are on
>> Linux , so can you see if you can connect from a Windows, with the
>> username/password and run the SELECT . Does it return results?
>> --
>> Jack Vamvas
>> ___________________________________
>> Need an IT job? http://www.ITjobfeed.com/SQL
>> "ton de w" <ton_de_win...@.yahoo.co.uk> wrote in
>> messagenews:1190367783.673561.160950@.22g2000hsm.googlegroups.com...
>>
>> > Hello,
>> > I am connecting to SQLserver via an application running on linux.
>> > Under the hood it does a describe which brings back the field types
>> > for any table OK.
>> > a select always fails (no data returned) however. I am troubleshooting
>> > this remotely and have asked the MSSQL dba to run a select with the
>> > same user id/password that I use on the client - this succeeds.
>> > There is a firewall between client and db, but I guess this is OK cos
>> > the describe succeeds.
>> > Anything I can ask the dba to do or check to help diagnose the
>> > problem? Does it follow that if userid is good for selects on MS box
>> > it will be good for remote queries?
>> > TIA
>> > Ton- Hide quoted text -
>> - Show quoted text -
> Thanks for that Query Analyzer works well with userid/password
> So does linux commandline tool tsql which allows me to pull back the
> data with a "select * from tablename" - it just needs the !P port
> username and password to logon.
> This works fine.
> However the application I am dealing with does not bring the data back
> <sigh>
> I am not sure how tsql gets the data without a databasename ie i would
> have expected "select * from tablename" to fail and a select * from
> databasename.tablename to succeed - perhaps cos of my Oracle
> experience.
> The application that is failing needs the database name before it will
> log on OK. but "select * from tablename" generates a syntax error near
> FROM - and so does a "select * from databasename.tablename"
>
>|||On 21 Sep, 17:20, "Quentin Ran" <remove_qr...@.yahoo.com> wrote:
> Ton,
> sql server's specification of table in a select statement can have up to
> four parts. In addition to the name itself, you can have / may need three
> qualifiers:
> select column_list from server_name.database_name.schema_name.table_name.
> It is recommended if you are in the database where the table is located, you
> use the schema_name (also know as owner) to qualify the table. If you are
> not in the database where the table is, you need to add the database name
> too, and then (better) specify the schema as well, which can be omitted if
> it is dbo (such as mydb..mytalbe). If you are accessing a liked server, you
> then also need to specify the server name.
> In your case, if your default database is where the table is located, when
> you establish the connection, you can directly run a select * from
> tablename. But select * from databasename.tablename will never work unless
> the databasename is the same as the schema name by accident, in which case
> sql server considers you were doing a select * from schemaname.tablename.
> hth
> Quentin
> "ton de w" <ton_de_win...@.yahoo.co.uk> wrote in messagenews:1190390145.227481.285540@.g4g2000hsf.googlegroups.com...
>
> > On 21 Sep, 11:23, "Jack Vamvas" <DEL_TO_RE...@.del.com> wrote:
> >> Try connecting to the DB remotely via Query Analyzer. I know you are on
> >> Linux , so can you see if you can connect from a Windows, with the
> >> username/password and run the SELECT . Does it return results?
> >> --
> >> Jack Vamvas
> >> ___________________________________
> >> Need an IT job? http://www.ITjobfeed.com/SQL
> >> "ton de w" <ton_de_win...@.yahoo.co.uk> wrote in
> >> messagenews:1190367783.673561.160950@.22g2000hsm.googlegroups.com...
> >> > Hello,
> >> > I am connecting to SQLserver via an application running on linux.
> >> > Under the hood it does a describe which brings back the field types
> >> > for any table OK.
> >> > a select always fails (no data returned) however. I am troubleshooting
> >> > this remotely and have asked the MSSQL dba to run a select with the
> >> > same user id/password that I use on the client - this succeeds.
> >> > There is a firewall between client and db, but I guess this is OK cos
> >> > the describe succeeds.
> >> > Anything I can ask the dba to do or check to help diagnose the
> >> > problem? Does it follow that if userid is good for selects on MS box
> >> > it will be good for remote queries?
> >> > TIA
> >> > Ton- Hide quoted text -
> >> - Show quoted text -
> > Thanks for that Query Analyzer works well with userid/password
> > So does linux commandline tool tsql which allows me to pull back the
> > data with a "select * from tablename" - it just needs the !P port
> > username and password to logon.
> > This works fine.
> > However the application I am dealing with does not bring the data back
> > <sigh>
> > I am not sure how tsql gets the data without a databasename ie i would
> > have expected "select * from tablename" to fail and a select * from
> > databasename.tablename to succeed - perhaps cos of my Oracle
> > experience.
> > The application that is failing needs the database name before it will
> > log on OK. but "select * from tablename" generates a syntax error near
> > FROM - and so does a "select * from databasename.tablename"- Hide quoted text -
> - Show quoted text -
Gosh just what I need to know - thanks very much!
I have an idea I am going to meet a few more problems along the way
tho.
Can I ask the MSSQL dba to capture incoming queries to help me with
troubleshooting BTW?|||yes, get them to run a Profiler trace - asking to then to filter just on
your DatabaseId and Database name.
--
Jack Vamvas
___________________________________
Need an IT job? http://www.ITjobfeed.com/SQL
"ton de w" <ton_de_winter@.yahoo.co.uk> wrote in message
news:1190581978.259876.259490@.d55g2000hsg.googlegroups.com...
> On 21 Sep, 17:20, "Quentin Ran" <remove_qr...@.yahoo.com> wrote:
>> Ton,
>> sql server's specification of table in a select statement can have up to
>> four parts. In addition to the name itself, you can have / may need
>> three
>> qualifiers:
>> select column_list from server_name.database_name.schema_name.table_name.
>> It is recommended if you are in the database where the table is located,
>> you
>> use the schema_name (also know as owner) to qualify the table. If you
>> are
>> not in the database where the table is, you need to add the database name
>> too, and then (better) specify the schema as well, which can be omitted
>> if
>> it is dbo (such as mydb..mytalbe). If you are accessing a liked server,
>> you
>> then also need to specify the server name.
>> In your case, if your default database is where the table is located,
>> when
>> you establish the connection, you can directly run a select * from
>> tablename. But select * from databasename.tablename will never work
>> unless
>> the databasename is the same as the schema name by accident, in which
>> case
>> sql server considers you were doing a select * from schemaname.tablename.
>> hth
>> Quentin
>> "ton de w" <ton_de_win...@.yahoo.co.uk> wrote in
>> messagenews:1190390145.227481.285540@.g4g2000hsf.googlegroups.com...
>>
>> > On 21 Sep, 11:23, "Jack Vamvas" <DEL_TO_RE...@.del.com> wrote:
>> >> Try connecting to the DB remotely via Query Analyzer. I know you are
>> >> on
>> >> Linux , so can you see if you can connect from a Windows, with the
>> >> username/password and run the SELECT . Does it return results?
>> >> --
>> >> Jack Vamvas
>> >> ___________________________________
>> >> Need an IT job? http://www.ITjobfeed.com/SQL
>> >> "ton de w" <ton_de_win...@.yahoo.co.uk> wrote in
>> >> messagenews:1190367783.673561.160950@.22g2000hsm.googlegroups.com...
>> >> > Hello,
>> >> > I am connecting to SQLserver via an application running on linux.
>> >> > Under the hood it does a describe which brings back the field types
>> >> > for any table OK.
>> >> > a select always fails (no data returned) however. I am
>> >> > troubleshooting
>> >> > this remotely and have asked the MSSQL dba to run a select with the
>> >> > same user id/password that I use on the client - this succeeds.
>> >> > There is a firewall between client and db, but I guess this is OK
>> >> > cos
>> >> > the describe succeeds.
>> >> > Anything I can ask the dba to do or check to help diagnose the
>> >> > problem? Does it follow that if userid is good for selects on MS box
>> >> > it will be good for remote queries?
>> >> > TIA
>> >> > Ton- Hide quoted text -
>> >> - Show quoted text -
>> > Thanks for that Query Analyzer works well with userid/password
>> > So does linux commandline tool tsql which allows me to pull back the
>> > data with a "select * from tablename" - it just needs the !P port
>> > username and password to logon.
>> > This works fine.
>> > However the application I am dealing with does not bring the data back
>> > <sigh>
>> > I am not sure how tsql gets the data without a databasename ie i would
>> > have expected "select * from tablename" to fail and a select * from
>> > databasename.tablename to succeed - perhaps cos of my Oracle
>> > experience.
>> > The application that is failing needs the database name before it will
>> > log on OK. but "select * from tablename" generates a syntax error near
>> > FROM - and so does a "select * from databasename.tablename"- Hide
>> > quoted text -
>> - Show quoted text -
> Gosh just what I need to know - thanks very much!
> I have an idea I am going to meet a few more problems along the way
> tho.
> Can I ask the MSSQL dba to capture incoming queries to help me with
> troubleshooting BTW?
>
>

Deriving unique rows from historical data

My application is to capture employee locations.

Whenever an employee arrives at a location (whether it is arriving for
work, or at one of the company's other sites) they scan the barcode on
their employee badge. This writes a record to the tblTSCollected table
(DDL and dummy data below).

The application needs to be able to display to staff in a control room
the CURRENT location of each employee.

>From the data I've provided, this would be:

EMPLOYEE ID LOCATION CODE
963 VB002
964 VB003
966 VB003
968 VB004
977 VB001
982 VB001

Note that, for example, Employee 963 had formerly been at VB001 but was
more recently logged in at VB002, so therefore the application is not
concerned with the earlier record.

What would also be particularly useful would be the NUMBER of staff at
each location - viz.

LOCATION CODE NUM STAFF
VB001 2
VB002 1
VB003 2
VB004 1

Can anyone help?

Many thanks in advance

Edward

NOTES ON DDL:

THE BARCODE IS CAPTURED BECAUSE THE COMPANY MAY RE-USE BARCODE NUMBERS
(WHICH IS DERIVED FROM THE EMPLOYEE PIN), SO THEREFORE THE BARCODE
CANNOT BE RELIED UPON TO BE UNIQUE.

THE COLUMN fldRuleAppliedID IS NULL BECAUSE THAT PARTICULAR ROW HAS NOT
BEEN PROCESSED. THERE ARE BUSINESS RULES CONCERNING EMPLOYEE HOURS
WHICH OPERATE ON THIS DATA. ONCE A ROW HAS BEEN PROCESSED FOR
UPLOADING TO THE PAYROLL APPLICATION, THE fldRuleAppliedID COLUMN WILL
CONTAIN A VALUE. IN THE PRODUCTION SYSTEM, THEREFORE, ANY SQL AS
REQUESTED ABOVE WILL CONTAIN IN ITS WHERE CLAUSE (fldRuleAppliedID Is
NULL)

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[tblTSCollected]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
drop table [dbo].[tblTSCollected]
GO

CREATE TABLE [dbo].[tblTSCollected] (
[fldCollectedID] [int] IDENTITY (1, 1) NOT NULL ,
[fldEmployeeID] [int] NULL ,
[fldLocationCode] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[fldTimeStamp] [datetime] NULL ,
[fldRuleAppliedID] [int] NULL ,
[fldBarCode] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

INSERT INTO dbo.tblTSCollected
(fldEmployeeID,
fldLocationCode,
fldTimeStamp,
fldBarCode)
VALUES (
963, 'VB001', '2005-10-18 11:59:27.383', 45480)
INSERT INTO dbo.tblTSCollected
(fldEmployeeID,
fldLocationCode,
fldTimeStamp,
fldBarCode)
VALUES (
963, 'VB002', '2005-10-18 12:06:17.833', 45480)
INSERT INTO dbo.tblTSCollected
(fldEmployeeID,
fldLocationCode,
fldTimeStamp,
fldBarCode)
VALUES (
964, 'VB001', '2005-10-18 12:56:20.690', 45481)
INSERT INTO dbo.tblTSCollected
(fldEmployeeID,
fldLocationCode,
fldTimeStamp,
fldBarCode)
VALUES (964, 'VB002', '2005-10-18 15:30:35.117', 45481)
INSERT INTO dbo.tblTSCollected
(fldEmployeeID,
fldLocationCode,
fldTimeStamp,
fldBarCode)
VALUES (964, 'VB003', '2005-10-18 16:05:05.880', 45481)
INSERT INTO dbo.tblTSCollected
(fldEmployeeID,
fldLocationCode,
fldTimeStamp,
fldBarCode)
VALUES (966, 'VB001', '2005-10-18 11:52:28.307', 97678)
INSERT INTO dbo.tblTSCollected
(fldEmployeeID,
fldLocationCode,
fldTimeStamp,
fldBarCode)
VALUES (966, 'VB002', '2005-10-18 13:59:34.807', 97678)
INSERT INTO dbo.tblTSCollected
(fldEmployeeID,
fldLocationCode,
fldTimeStamp,
fldBarCode)
VALUES (966, 'VB001', '2005-10-18 14:04:55.820', 97678)
INSERT INTO dbo.tblTSCollected
(fldEmployeeID,
fldLocationCode,
fldTimeStamp,
fldBarCode)
VALUES (966, 'VB003', '2005-10-18 16:10:01.943', 97678)
INSERT INTO dbo.tblTSCollected
(fldEmployeeID,
fldLocationCode,
fldTimeStamp,
fldBarCode)
VALUES (968, 'VB001', '2005-10-18 11:59:34.307', 98374)
INSERT INTO dbo.tblTSCollected
(fldEmployeeID,
fldLocationCode,
fldTimeStamp,
fldBarCode)
VALUES (968, 'VB002', '2005-10-18 12:04:56.037', 98374)
INSERT INTO dbo.tblTSCollected
(fldEmployeeID,
fldLocationCode,
fldTimeStamp,
fldBarCode)
VALUES (968, 'VB004', '2005-10-18 12:10:02.723', 98374)
INSERT INTO dbo.tblTSCollected
(fldEmployeeID,
fldLocationCode,
fldTimeStamp,
fldBarCode)
VALUES (977, 'VB001', '2005-10-18 12:05:06.630', 96879)
INSERT INTO dbo.tblTSCollected
(fldEmployeeID,
fldLocationCode,
fldTimeStamp,
fldBarCode)
VALUES (982, 'VB001', '2005-10-18 12:06:13.787', 96697)On 25 Oct 2005 02:30:17 -0700, teddysnips@.hotmail.com wrote:

>My application is to capture employee locations.
>Whenever an employee arrives at a location (whether it is arriving for
>work, or at one of the company's other sites) they scan the barcode on
>their employee badge. This writes a record to the tblTSCollected table
>(DDL and dummy data below).

Hi Edward,

Thanks for posting the DDL and the data - makes writing and testing a
sloution so much easier!!

>The application needs to be able to display to staff in a control room
>the CURRENT location of each employee.
>>From the data I've provided, this would be:
>EMPLOYEE ID LOCATION CODE
>963 VB002
>964 VB003
>966 VB003
>968 VB004
>977 VB001
>982 VB001

This query works for the data given:

SELECT a.fldEmployeeID, a.fldLocationCode
FROM tblTSCollected AS a
WHERE NOT EXISTS
(SELECT *
FROM tblTSCollected AS b
WHERE b.fldEmployeeID = a.fldEmployeeID
AND b.fldTimeStamp > a.fldTimeStamp)

Since the data in the table is checked against the data in the table
itself, execution time might explode if the table has lots of rows. That
can be controlled with proper indexing. A non-clustered index on
(fldEmployeeID, fldTimeStamp) would do wonders for this query (but be
aware that it might hurt performance in other parts of your system!)

>What would also be particularly useful would be the NUMBER of staff at
>each location - viz.
>LOCATION CODE NUM STAFF
>VB001 2
>VB002 1
>VB003 2
>VB004 1

Using the previous query as a starting point:

SELECT a.fldLocationCode, COUNT(*) AS Num_Staff
FROM tblTSCollected AS a
WHERE NOT EXISTS
(SELECT *
FROM tblTSCollected AS b
WHERE b.fldEmployeeID = a.fldEmployeeID
AND b.fldTimeStamp > a.fldTimeStamp)
GROUP BY a.fldLocationCode

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)|||Hugo Kornelis wrote:
> On 25 Oct 2005 02:30:17 -0700, teddysnips@.hotmail.com wrote:
[...]
> Best, Hugo

Many thanks, Hugo. That does the trick perfectly!

Edward|||Your DDL is wrong in almost every way possible. IDENTITY is not a key,
barcodes are fixed length and none of them are CHAR(50) -- you never
did even the minimal research!! You use the magical, "I have no
brains!!" VARCHAR(50) all over the place, TIMESTAMP is a reserved word
in SQL, etc.

Where did you get the stupid idea that you need to put "fld-" and
"tbl-" prefixes on names? In violation of both common sense and
ISO-11179? One of the major principles of RDBMS is to avoid redundance;
Do you put "noun-" in your English?

When you design a history table, you need to learn that time comes in
durations; you need a (stsrt, end). You need to think of the schema as
a whole and not a bunch disjoint files. you need to avoid havign more
NULLs than the entie payroll of Genral Motors. More like this: .

CREATE TABLE EmpLocationHistory
(emp_id INTEGER NOT NULL
REFERENCES Personnel(emp_id)
ON UPDATE CASCADE,
location_code INTEGER NOT NULL
REFERENCES Locations(location_code)
ON UPDATE CASCADE,
start_time DATETIME NOT NULL,
end_time DATETIME, -- null means current
CHECK (start_time < end_time),
PRIMARY KEY (emp_id, location_code,start_time),
etc. );

Google how to code for this schema.

Among the errors in this posting, you do not know that SQL uses
ISO-8601 format for temporal data. You might want to look at the
research on camelCase and program readability; it sucks because the eye
jumps to the uppercase letter then flicks back to the start of the
word.

I was not kidding when I said that your code is wrong in almost every
way possible.|||Wow! Where can I send you some money so you can buy your medication
and calm the fuck down?

There is a right way and a wrong way to correct people. You use the
wrong (read, asshole) way. There is no call for lines like "I have no
brains!!" or "stupid idea".

Being civil is worth so much more than posting DDL or not calling a
column a field and a row a record.

Get a grip and be nicer.

Derived Table Alternative

I have an application that has two different database backends, one is SQL Server Compact Edition and the other is SQL Server. The reason is because the application may run at home on one of our sales agent's computers or here in the office.

I have a query that uses a derived table and works just fine in SQL Server, however when I run it in the compact edtion (having the exact same table structures) it will not run. My question is...does the Compact Edtion or the Mobile Edition allow derived tables. If not is there a way to work around this? I will happily give an example if it will help.

Thank you,

Adam

Hi Adam,

a sample would be very useful, thanks.

|||

The three tables used for this are Assignment, Activity, and User. The Assignment table can have multiple Activities entered by different Users (only 1 user per activity). I need a list of all of the active assignments for a given User along with the last activity that was added to that assignment. The assignment may or may not have an activity but the assignment still needs listed. The activity returned must be one entered by the same user that the assignment belongs to.

Here is an example that works in SQL Server but not SqlCE:

select assignment.assignmentID, activityDateStamp
from assignment
left join
(
select assignment.assignmentID, max(activityDateStamp) as activityDateStamp
from activity
join assignment on assignment.assignmentID = activity.assignmentID
where assignment.userID = 40
and activity.userID = 40
and activityActive = 1
and assignmentActive = 1
group by assignment.assignmentID
) maxActivity on maxActivity.assignmentID = assignment.assignmentID
where assignment.userID = 40
and assignmentActive = 1

The output would look similar to this:

assignmentID activityDateStamp
-
123 NULL
4322 2006-06-23
423 2006-12-15
431 NULL

Thanks again for any help.

|||

Derived tables are not supported in SSCE.

|||I guess if we can provide some feedback to the team for future versions having derived/nested queries would definitely be something worth having. This limitation currently prevents us doing more than the simplest of queries.|||

Thanks Nick.

What I did not mention earlier was that support for derived tables aka nested queries would be there with the next release of Orcas!!

deployment question

I am wondering about some capacity that, I have heard, might be installed in
SqlServer 2005.
I am writting an end user application that I want to have low hardware
requirement (apart from running .NET).
I would like to use a SqlServer database for data repository, but I don't
want a server, it would be a file based data stored, only for the
application and would (absolutely) not require a previous server software to
be installed.
Something like I could do with SqlLite, except SqlServer have plenty of nice
graphical tools.
Is it possible to do something like that with SqlServer? how?
What are the licensing consideration?SQL Server 2000 MSDE:
http://www.microsoft.com/sql/MSDE/
MSDE is replaced by Express Edition in SQL Server 2005:
http://lab.msdn.microsoft.com/express/sql/
David Portas
SQL Server MVP
--|||YOu can use SQL Server 2005 Express Edition:
"First, SQL Server 2000 Desktop Edition is being retired. In its place, we
get SQL Server 2005 Express Edition. Express Edition will still be free,
embeddable, and redistributable. But unlike Desktop Edition, it will include
a graphical management tool, as well as some other goodies like a report
wizard and controls, plus support for new technologies including SQL Service
Broker and the Common Language Runtime. All in all, Express Edition should
significantly raise the bar for the use of SQL Server is low-cost
applications (and may be the death knell for the venerable Jet engine)."
(quoted from: http://www.developer.com/db/article.php/3502746)
Information anout that can be found here:
http://www.microsoft.com/sql/express/
CTP can be downloaded here:
http://www.microsoft.com/downloads/...&displaylang=en
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Lloyd Dupont" <ld@.NewsAccount.galador.net> schrieb im Newsbeitrag
news:OK9dkRhWFHA.3760@.TK2MSFTNGP15.phx.gbl...
>I am wondering about some capacity that, I have heard, might be installed
>in SqlServer 2005.
> I am writting an end user application that I want to have low hardware
> requirement (apart from running .NET).
> I would like to use a SqlServer database for data repository, but I don't
> want a server, it would be a file based data stored, only for the
> application and would (absolutely) not require a previous server software
> to be installed.
> Something like I could do with SqlLite, except SqlServer have plenty of
> nice graphical tools.
> Is it possible to do something like that with SqlServer? how?
> What are the licensing consideration?
>|||Thanks guys!
looks like Sql5 - express is going to be fine!|||Depending on the complexity of your data storage needs, MS Access or even
XML might suffice. MSDE can comsume CPU and memory.
"Lloyd Dupont" <ld@.NewsAccount.galador.net> wrote in message
news:OK9dkRhWFHA.3760@.TK2MSFTNGP15.phx.gbl...
> I am wondering about some capacity that, I have heard, might be installed
in
> SqlServer 2005.
> I am writting an end user application that I want to have low hardware
> requirement (apart from running .NET).
> I would like to use a SqlServer database for data repository, but I don't
> want a server, it would be a file based data stored, only for the
> application and would (absolutely) not require a previous server software
to
> be installed.
> Something like I could do with SqlLite, except SqlServer have plenty of
nice
> graphical tools.
> Is it possible to do something like that with SqlServer? how?
> What are the licensing consideration?
>|||hu...
I want something which don't requires additional install or program from the
user.
for instance, what if he hasn't bought access? (very likely case...)
"JT" <someone@.microsoft.com> wrote in message
news:O3FZxOiWFHA.1148@.tk2msftngp13.phx.gbl...
> Depending on the complexity of your data storage needs, MS Access or even
> XML might suffice. MSDE can comsume CPU and memory.
> "Lloyd Dupont" <ld@.NewsAccount.galador.net> wrote in message
> news:OK9dkRhWFHA.3760@.TK2MSFTNGP15.phx.gbl...
> in
> to
> nice
>|||You only need ADO to query an Access .MDB database or XML file, and ADO
comes pre-installed with Windows. However, the user will need to install
MSDE. That's why I suggested an Access database or XML over MSDE.
"Lloyd Dupont" <net.galador@.ld> wrote in message
news:OSOQIbmWFHA.1384@.TK2MSFTNGP09.phx.gbl...
> hu...
> I want something which don't requires additional install or program from
the
> user.
> for instance, what if he hasn't bought access? (very likely case...)
> "JT" <someone@.microsoft.com> wrote in message
> news:O3FZxOiWFHA.1148@.tk2msftngp13.phx.gbl...
even
installed
don't
software
>|||ho.. sounds much better then, thanks!
"JT" <someone@.microsoft.com> wrote in message
news:OKHp5PuWFHA.2740@.TK2MSFTNGP14.phx.gbl...
> You only need ADO to query an Access .MDB database or XML file, and ADO
> comes pre-installed with Windows. However, the user will need to install
> MSDE. That's why I suggested an Access database or XML over MSDE.
>
> "Lloyd Dupont" <net.galador@.ld> wrote in message
> news:OSOQIbmWFHA.1384@.TK2MSFTNGP09.phx.gbl...
> the
> even
> installed
> don't
> software
>|||MSDE / SQL Server Express Edition is feature rich and would use the same
database format as SQL Server, but the install and maintenance requirements
may exceed what you are willing to deploy in the field. Inquire in the
*msde* newsgroup about others experiences with this.
"Lloyd Dupont" <ld@.NewsAccount.galador.net> wrote in message
news:%23540LXuWFHA.2976@.TK2MSFTNGP10.phx.gbl...
> ho.. sounds much better then, thanks!
> "JT" <someone@.microsoft.com> wrote in message
> news:OKHp5PuWFHA.2740@.TK2MSFTNGP14.phx.gbl...
from
hardware
>

Deployment Problem - Unable to find the requested .Net Framework Data Provider

I am able to work fine in my development environment, however when I deploy the application to a clean machine, I get the dreaded "Unable to find the requested .Net Framework Data Provider" error.

I have included the eight dlls required by the Sql Server 2005 CE engine (per the documentation) in the deployment project.

Any help would be greatly appreciated.

(I presume that you are deploying on a desktop.)

The recommended method is to install the runtime package (through click once or otherwise). No manual intervention is needed. The data provider (i.e. System.Data.SqlServerCe.dll) is put in GAC. It is easy to update the package too.

If you do not want to use the installer for some reason, then ensure that all SSC binaries are in the executable folder.

Deployment on load balanced servers.

Hi, I'm trying to solve the problem with deploying sql code on load-balanced application server.
Normally when we put new feature\fix live we take one server out of the loop, than we put new app code, we test it and then we bring it back to the loop. But we've started to have a problem when we had to change stored procedures at the same time to run the new app code, becouse either 'test' server won't work either production application won't work. I wonder is there any good solution for this problem.

Regards
Piotr.
P.S. Sorry for the forum topic but I didn't know where to put it.

what I understand is that your stored procedure signature is still the same but its implementation is changed in such a way that only the new application code can work with it. Your configuration is mulitple application servers talking to 1 SQL Server. In that case, let us say you have 10 application servers. I will take 5 (let us call them group-A) of those out of the loop, install new app code. Note, your app is still up and running though at 1/2 the capacity. you can test your group-A with another SQL Server (say the test SQL Server that has new stored procs). Once it is done, you can take other group of app servers offline (this will cause short term unavailability of your application), change the stored proc on the production SQL Server, and then bring group-A online. Now you can do the same with other set of application servers.

|||That was very helpful, but I'm more after stored procedure versioning solution. Sometimes we need old and new code running (part of requests are hitting old and other new code). Thanks in advance.|||http://weblogs.asp.net/fmarguerie/archive/2003/02/24/2880.aspx fyi.sql

deployment of sqlserverce.dll

I registered to redistribute the runtime for SQL Server Compact edition.

I have a desktop application which uses SDF files as the database.

In VS 2008 - when I set System.Data.SqlServerCe configured to Copy Local as TRUE - sqlserverce.dll does not get inserted to my bin directory. I am assuming if I manually put the DLL file into my bin directory (and deploy it) - the DLL file will automatically be used by my app?

If you install the 3.5 redistributable/runtime with your app, you do not need any SQL Compact DLLs in your bin folder.

http://www.microsoft.com/downloads/details.aspx?FamilyID=4dd09a86-03eb-40a1-bd32-0fd8bcdf7be0&displaylang=en

|||

This defeats the purpose of packaging up the database with your deployment package. I am not the original poster of this thread but I will need a solution that does not need/want to install the Compact Edition Runtime installation with my application deployment. The installation of the runtime package requires the user to have admin rights and most of my end users will not have admin rights.

Therefore, please provide us with the steps to include the Sql Server CE provider assemblies with our application deployment package.

Thank you.

|||Maybe tutorial 1 here will be able to assist you: http://msdn2.microsoft.com/en-us/sql/bb219480.aspxsql

Deployment of Server Reports

HI,
We have Server Reports in our application deployed on the Report
Server(local host). What all steps need to be done when we make an MSI of the
project for deplying reports on the new server? Do we need to first deploy
the reports on new server and then make an MSI? Need help.
Thanks in Advance.
ParimalYou do not/cannot use MSI to deploy reports. There are three ways to deploy
reports.
1. Use the IDE to deploy reports to production server (that is what I do).
2. Copy reports to server and then use Report Manager to add reports
3. Write a script. Search Books Online under scripting, samples
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Parimal" <Parimal@.discussions.microsoft.com> wrote in message
news:FC5A0A06-B81B-4183-83F4-98C4414A1B0A@.microsoft.com...
> HI,
> We have Server Reports in our application deployed on the Report
> Server(local host). What all steps need to be done when we make an MSI of
> the
> project for deplying reports on the new server? Do we need to first
> deploy
> the reports on new server and then make an MSI? Need help.
> Thanks in Advance.
> Parimal

Deployment of analysis services on windows 2003(Very urgent Please)

I have window 2000 as my development machine. I am using visual studio 2003 and sql server 2000.
I was able to develop a web application which uses the pivot table componant.
Every thing was working fine with out any problem.

I deployed my Project to windows 2003.
I am able to see the pivot table control.
I am not able to get any data into my pivot table.

I am not sure what is going wrong.
Is there anything I need to take care in windows 2003 specifically.

I don't have microsoft office on windows 2003.
Does it make a difference?

Please help!!!

Anil

Help Please|||

If you are using MSOWC for your pivot table component and if yout new server do not have riyhrt MSOWC installled or Office instaled,then you will not be able to view the data.

|||

MSOWC is already available on that machine.
I think the webservice is not able to contact the iis properly.
I have already setup the virtual directory for olap on IIS.

Any ideas

|||

Are you using the HTTP connection to Analysis Services or are you connection directly?

If you are connecting directly, what is the version of the MSOLAP80.dll? You may have to upgrade it to a service pack for Analysis Services.

Copy the MDX Sample Application exe to the 2003 machine and see if it can connect.

David

|||

Finally we narrow down the error it is with the fieldsets for the pivot table.

The web service is working fine if we remove the accessing fieldsets code.

When ever we tried to access the fieldsets in the cube we are getting error.

The error message is "Interop.OWC10 - Unspecified error ".

We installed service pack 4 on sql server.

I reinstalled the owc10 dll again.

I gave the permissions to the user machinename_iuser....

But nothing has solved my problem.

Please help.

|||

Hello. I have some doubts about if OWC:s work with HTTP unless you write some code to make them work. OWC are ActiveX controls and they use tcp/ip.

If you disable the SSAS Olap connection and publish an excel OWC OLAP- report in a folder on your IIS machine, will this work? This is to make sure that nothing else is causing these problems.

It is not recommended to develop on an older O/S than the server O/S, but you are probably aware of that now.

Also check that you are allowed to run programs in your IIS folder on Windows 2003.

In IIS/ Win2003 you can check what web service extensions that are allowed.

Regards

Thomas Ivarsson

|||

i am not sure how to disable the SSAS Olap connection and publish an excel OWC OLAP- report in a folder on your IIS machine.

Yes I am member in administrator group. I can run programs in my IIS folder.

Webservice has extensions allowed in iis are
Active Server Pages
ASP.Net v1.1.4322
Front Page server extensions
HwsMessages HttpReceive
Windows Sharepoint Services.

Regards
Anil

|||

Hello. Build a report from SSAS2000 in Excel and publish it to a webfolder on your IIS. I see that you have Sharepoint services. Upload your Excel SSAS2000 report to Sharepoint on Win2003 server.

Regards

Thomas Ivarsson

|||

I published it on iis and I am able to see all dimension but I am not able to see the fact table values.
I don't know what else to do.

Thanks So much for your help

Anil

|||

Here is link to a kb with your keywords(http://support.microsoft.com/kb/331400)

Regards

Thomas Ivarsson

Deployment of a C# Windows Application connected to SQL Server 2005 Database

Hello all,
I need to consult you in the following problem:
I am developing a windows application in Visual C# 2005 , connected to
an SQL Server 2005 database ,
I want to make deployment for the application so that the user can
have a copy of the application and the database and use it on his
machine even if they dont install the sql server or the visual
studio , i made it using Setup Projects. It was built successfully ,
and created Setup project, when i tested it on another machine ,it
displays the installation wizard ,but it displays an error when trying
to make connection to the database .. the error is:
An error has occurred while establishing a connection to a server ,
when connecting to SQL server 2005,...Could not open a connection to
sql server 2005..
also i logically feel that it is wrong to write an sqlconnection
statement with the name of my machine as the data source , and how to
copy SQL database to the user machine ?
What shall i do? Please Reply...(compjor@.yahoo.com) writes:
> I am developing a windows application in Visual C# 2005 , connected to
> an SQL Server 2005 database ,
> I want to make deployment for the application so that the user can
> have a copy of the application and the database and use it on his
> machine even if they dont install the sql server
Eh? An SQL Server database without SQL Server installed is quite much
a useless piece of bytes.

> i made it using Setup Projects. It was built successfully ,
> and created Setup project, when i tested it on another machine ,it
> displays the installation wizard ,but it displays an error when trying
> to make connection to the database .. the error is:
> An error has occurred while establishing a connection to a server ,
> when connecting to SQL server 2005,...Could not open a connection to
> sql server 2005..
You don't connect to the database. You connect to SQL Server which
will then access the database. But if there is no database to connect to?

> also i logically feel that it is wrong to write an sqlconnection
> statement with the name of my machine as the data source , and how to
> copy SQL database to the user machine ?
There are two possible scenarios:
1) The user already has SQL Server installed on his machine, and don't
want another instance. In this case, give him the option to attach
the database to his server.
2) Bundle SQL Express with your setup, install SQL Express as part of your
setup and attach the database to it.
In both cases you would include the database file in your setup. (Actually,
I would rather use a backup, that the data files directly.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Deployment issue : COM object with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} is either not va

Hello,

I have a asp.net application that calls a DTS package. This application is running fine on my machine (where SQL Server and Web Server are running). When I moved the application to a Web Server, I am getting the following error due to the DTS package.

COM object with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} is either not valid or not registered.

In my Bin folder, I do have the reference to the Interop.DTS.dll. The web server admin tells me that the dtsffile.dll, dtspkg.dll, dtspump.dll and axscphst.dll are registered onto the web server.

I am struggling to find the reasons for this. I have tried to replicate this error onto my machine to help me finding out the cause of this problem but in vain!

Can you help please?

Thank you.

Hello,

Just an update on this issue.
Basically, I have never been able to manage to sort this one out, despite viewing many articles on the net.

However, I just want to share one option to overcome this problem.

You can invoke your DTS package through a JOB using SP_START_JOB stored proc. This SP Instructs SQL Server Agent to execute a job immediately. This would do the job of executing the package!!! Of course, you will need the right to run the job.

Hope this helps.

Deployment issue : COM object with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} is either no

Hello,

I have a asp.net application that calls a DTS package. This application is running fine on my machine (where SQL Server and Web Server are running). When I moved the application to a Web Server, I am getting the following error due to the DTS package.

COM object with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} is either not valid or not registered.

In my Bin folder, I do have the reference to the Interop.DTS.dll. The web server admin tells me that the dtsffile.dll, dtspkg.dll, dtspump.dll and axscphst.dll are registered onto the web server.

I am struggling to find the reasons for this. I have tried to replicate this error onto my machine to help me finding out the cause of this problem but in vain!

Can you help please?

Thank you.

Hello,

Just an update on this issue.
Basically, I have never been able to manage to sort this one out, despite viewing many articles on the net.

However, I just want to share one option to overcome this problem.

You can invoke your DTS package through a JOB using SP_START_JOB stored proc. This SP Instructs SQL Server Agent to execute a job immediately. This would do the job of executing the package!!! Of course, you will need the right to run the job.

Hope this helps.

Deployment Help

I'm trying to test my ASP.NET application. Everything is working to the point of getting to my login page to open. When I try to login I receive and error that the database does not exist or access is denied. I used the developer version of SQL Server to create the database and installed the MSDE on my test PC. Then I copied the mdf and ldf files to the new PC. Is there something else I should be doing? Or any suggestions?

Thank you,::Then I copied the mdf and ldf files to the new PC

did you "attach" the database ??

hth|||The test PC only has the MSDE installed. I don't know of a way to run the attach sp without query analyzer, is there a way?

Thank you,|||I tested, and I can connect the SQL Server database to a Access adp. Would this mean that I should be able to connect to my ASP.NET web pages? Could there be a problem with my connection string when I moved the app to the new PC? What is the simplest connect string to a SQL Server database, so I can test it?

Thanks you any suggestions,|||Can you install SQL Server tools (only)?
That would be easier to attach a db via Enterprise Manager (right-click DB / all tasks).|||I was trying to do this as if those tools were not available. I read that it was possible, but I cannot find the listing again.

Thank you,sql

Deployment files needed by sqlserver 2005 driver

Hello all

I built an application that connect to MS SqlServer2005 using Native driver (sqlncli.msi) I install that file from MS site, I need to deply my application to the end-user, and I would like to know what files do I need to deploy to make sure the application is gona run okay on the client PC's.

I search in the registry for the driver, and I found this "sqlncli.dll", is it enough or I need to include more files !!

Thanks and best regrdas

Waleed

SQLNCLI does not have specific dependencies, however your customers should have MDAC installed, which should be not a problem with the recent releases of Windows.

See also http://technet.microsoft.com/en-us/library/ms131334.aspx

Deployment / Version Questions

I'm going to write an application for a friend's business using VS .NET and
SQL Server 2000. I'm confused though as to how I can write everything on my
laptop, then copy to their server. I have an MSDN subscription and did not
realize that I cannot install the Enterprise Edition of SQL Server on XP
Pro. I can install the development edition, but am I then going to run into
problems trying to copy it over to their server?

My experience lies in Informix / DB2 and Java / JDBC, so this is new
territory for me and I appreciate the help.

Derrick LathemHi

On your the destination you will have to install a new copy of SQL that is
correctly licenced. In general I don't think your MSDN licence will not
cover their systems, although you may be able to distribute MSDE. You should
read http://www.microsoft.com/sql/techin...eskChooseEd.asp to
see which edition is most appropriate for your needs. For MSDE check out the
web site http://www.microsoft.com/sql/MSDE/

To get your database onto the destination system there are several ways, the
easiest is probably to detach/attach the database, but you could use one of
several other methods see:
http://support.microsoft.com/defaul...b;en-us;Q314546

You should also make sure that the logins are correctly set up on the
destination system.

John

"lathem" <lathem@.ns.mindspring.com> wrote in message
news:yA3Ob.11830$i4.10805@.newsread1.news.atl.earth link.net...
> I'm going to write an application for a friend's business using VS .NET
and
> SQL Server 2000. I'm confused though as to how I can write everything on
my
> laptop, then copy to their server. I have an MSDN subscription and did
not
> realize that I cannot install the Enterprise Edition of SQL Server on XP
> Pro. I can install the development edition, but am I then going to run
into
> problems trying to copy it over to their server?
> My experience lies in Informix / DB2 and Java / JDBC, so this is new
> territory for me and I appreciate the help.
> Derrick Lathem|||To add to John's response, the SQL Server Developer edition provides the
same features as the Enterprise edition but is licensed only for development
use. This is the appropriate choice for development if you are targeting a
server edition of SQL Server. It is included with MSDN Universal and
Enterprise subscriptions or can be acquired separately for about $50.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"lathem" <lathem@.ns.mindspring.com> wrote in message
news:yA3Ob.11830$i4.10805@.newsread1.news.atl.earth link.net...
> I'm going to write an application for a friend's business using VS .NET
and
> SQL Server 2000. I'm confused though as to how I can write everything on
my
> laptop, then copy to their server. I have an MSDN subscription and did
not
> realize that I cannot install the Enterprise Edition of SQL Server on XP
> Pro. I can install the development edition, but am I then going to run
into
> problems trying to copy it over to their server?
> My experience lies in Informix / DB2 and Java / JDBC, so this is new
> territory for me and I appreciate the help.
> Derrick Lathem

Deploying with sql server express

I have developed a windows mobile 5.0 application that is currently syncing with sql server 2005. I want to deploy the application with sql server express for the client. What do I need to do to make this work?

Thank you.

It depends on how you're syncing. If you're using manual implementation via SQL Client on device, that would work with properly configured SQL 2005 Express as well.

If you using SQL Mobile RDA or replication, you would have to implement manual sync using SQL Client as Express offers no RDA/Replication support.

|||I am using replication. Can you direct me to some reference material that can assist me in changing to manual sync?|||Also, to test with sql server express will I need to install it on my computer? I am running sql 2005 and visual studio 2005. Can I load express in addition to what I have installed. I do not want to un-install anything that I have currently. What is your suggestion?|||

I'm not aware of any reference materials on that. The idea is very simple - you go through all records in one db and compare them with records in another db. If they are different, you'd need to synchronize them as appropriate in your particular case. For example:

Before:

SQL Mobile SQL Express Action

1-foo 1-foo Same data, do nothing

2-bar 2-foobar Data changed, copy from Express to Mobile

2-some <nothing> Record deleted, delete from Mobile

(or is it added on device? - that's for you to track)

Before:

SQL Mobile SQL Express

1-foo 1-foo

2-foobar 2-foobar

As far as I know you can run SQL Express and SQL Server side by side, though you would need to use nonstandard port.

|||

some honest, non-politically correct advice - I wouldn't install SQL Server 2005 and SQL Express on the same machine. it can cause you a lot of difficult issues - I'm not saying it can't be made to work, but you're asking for a day of searching newsgroups to resolve the issues that this introduces. either remove SQL Server and re-run the VS2005 setup, choosing SQL Express as an optional install component, or use a separate box to run SQL Express on.

-Darren

deploying with default parameter value

I have an application with a parameter that has a single value drop down list from a query. My dataset has a union with "0","All". I set the default to non-queried, value "0". I go to preview and BI displays the label correctly as "All". When I deploy the app and view it in the web browser the default value is not displayed correctly, and it shows "Select a value". Why, why, why does it preview correctly yet deploys incorrectly, and how can I fix it
From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comYou can try deleting the earlier deployed report from Report Manager
and deploy the modified report which is previewing fine with all
default values.
Thanks
Subhash

Deploying web app, which SQL files do I upload?..

I'm working on a web application that uses SQL Server 2000. Once I'm ready to upload my website to a production server, I need to know how to upload my SQL Server database files to the server. Are there actual files that can be uploaded? I've only deployed a website that works with MySQL to a production server, and there were no files to upload... the database had to be created on the server, and then the data itself had to be exported to text files (on my computer), then imported/uploaded to the production server using SQL statements...

How do I do this?

Thanks~::I need to know how to upload my SQL Server database files to the server.

Ask your provider, systemadministrator or whoever manages this.

Our hosting operation does NOT allow uploads of sql database fiules - you are supposed to create a new database and use the copy database wizard out of SQL Server's enterprise manager.|||hi
i saw http://europe.webmatrixhosting.net, do you know that all hosts provide like this host utilities to work with SQL Server? utilities like http://www.aspenterprisemanager.com??

i'm developing an asp.net storefront that uses SQL Server Database, but i'm worry about after developing that, i want to do what?!! how to manage my database?
tahnk

Deploying vb.net english query application

Hi,
I'm attempting to distribute a vb.net english query application to a
client, however, when the client runs the application, it crahses when
it tries to create an instance of the "Mseq.Session" object.
As far as I can tell, the interop and the original dll are being
included in the setup correctly - are there any special settings (such
as com registration, system etc), or other files that I should be
including? Or are there any other prerequisits for the client's pc
before I can expect the software to run?
Cheers,
Tinium.
you are still going to need to install the EQ engine on the target
platform.. There's an awful lot of work done by the engine before the query
is shipped off the Server. EQ is a client function..
Guy
"Tinium" <tin@.ium.com> wrote in message
news:eWfltpaQFHA.132@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I'm attempting to distribute a vb.net english query application to a
> client, however, when the client runs the application, it crahses when it
> tries to create an instance of the "Mseq.Session" object.
> As far as I can tell, the interop and the original dll are being included
> in the setup correctly - are there any special settings (such as com
> registration, system etc), or other files that I should be including? Or
> are there any other prerequisits for the client's pc before I can expect
> the software to run?
> Cheers,
> Tinium.

Deploying the whole lot

Hi All,

I am adding a reporting suite to our application based upon SSRS 2005 and I am looking for a comprehensive example of how I go about deploying this.

Essentially I want to automate the entire process:

Create the DB, Create the Virtual Dirs, add my reports etc.

I have looked at the documentation and it is limited to say the least. I went down the route of attempting to script the whole thing and after 3 days of it I was still stuck on a few problems so I was hoping that someone knows of an example of how to go through all of these processes.

An example of the problems I ran into is that the "CreateVirtualDir" method on the reporting services WMI objects simply didn't work. It didn't return an error but it didn't create the Dir either!

The documentation around this method and most others is ambiguous and contains no examples.

I then went down the route of using IIS WMI to create the dirs which worked but then I was unable to update the Reporting Services configuration to pick this up without resorting to changing the config files directly - and even when I did this they didn't always seem to be picked up.

So at present instead of giving our guys in deployment a 1 click install they have a 9 page document explaining the install and set up of Reporting services from start to finish.

Any help or more thorough documentation would be greatly appreciated.

thanks,

Dhugal.

PS: Just to add I have already altered our install to install the RS module along with SQL Server so that bit is covered. I just want to script the entire configuration process.

Bump ^ ^