Ad-Hoc Reporting

Hi,

Can i know which version of Reporting services supports Ad-hoc reporting.

Reporting Services 2005. More information on the specific functionality for the various editions can be found here: http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx

-- Robert

adding the vc express bundled sql server to odbc

Hi, I have installed a trial version of VC++ Express 2005 with the
budled SQL Server. After creating a C++ Forms prototype, with some
tables into a database file named Test1.mdb, now I want to make ODBC
available this local database.

What are the steps required to add and ODBC entry so any ODBC-capable
program may access my prototype?

I know in advance the location of the database file and log file, know
it is local (so the server is localhost or just (local) ) and also the
driver name and the port number.

What is unknown to me is the user id and password as the installlation
was done to auth with OS credentials.
Could be "sa" without password?

Thanks in advance, CarlosChuck (carlos.crosetti@.gmail.com) writes:

Quote:

Originally Posted by

Hi, I have installed a trial version of VC++ Express 2005 with the
budled SQL Server. After creating a C++ Forms prototype, with some
tables into a database file named Test1.mdb, now I want to make ODBC
available this local database.
>
What are the steps required to add and ODBC entry so any ODBC-capable
program may access my prototype?
>
I know in advance the location of the database file and log file, know
it is local (so the server is localhost or just (local) ) and also the
driver name and the port number.
>
What is unknown to me is the user id and password as the installlation
was done to auth with OS credentials.
Could be "sa" without password?

Why can't use Windows authentication? Why would the ODBC application
log in as sa?

--
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.mspxsql

Adding a version 7 DB to SQL2000

I would like to add a version 7 DB to my SQL 2000 Server. I was wondering if there was a way to add and upgrade it to version 2000 without installing version 7 on the machine? If I have to install 7, what is the best procedure with an existing install of 2000? Any help would be greatly appreciated.You can use either BACKUP/RESTORE or sp_attach_db
SQL Server 2K will automatically upgrade your database during restore or
attach process.
After you will restore or attach your database it is suggested to make
update statistic and if it is possible database re-indexation.
Regards
---
All information provided above AS IS.
"TonyHeuft" <theuft@.cha.ab.ca> wrote in message
news:2AE0F362-5E3A-496C-A0B6-D1B8237BF92C@.microsoft.com...
> I would like to add a version 7 DB to my SQL 2000 Server. I was wondering
if there was a way to add and upgrade it to version 2000 without installing
version 7 on the machine? If I have to install 7, what is the best procedure
with an existing install of 2000? Any help would be greatly appreciated.|||Hi Tony
Can you elaborate on what you mean? Do you have backups of a SQL 7 db or the
actual .mdf and .ldf files?
If you have a backup, you can restore a SQL 7 backup to a SQL 2000 server,
if you have the files, you can use sp_attach_db.
Please read about the appropriate topic RESTORE or sp_attach_db in the Books
Online.
You do not need to install SQL 7.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"TonyHeuft" <theuft@.cha.ab.ca> wrote in message
news:2AE0F362-5E3A-496C-A0B6-D1B8237BF92C@.microsoft.com...
> I would like to add a version 7 DB to my SQL 2000 Server. I was wondering
if there was a way to add and upgrade it to version 2000 without installing
version 7 on the machine? If I have to install 7, what is the best procedure
with an existing install of 2000? Any help would be greatly appreciated.|||What is it you have exactly? Is it a backup or just the detached files? In
either case it should not be a problem as the upgrade happens automatically
when you attach or restore it.
--
Andrew J. Kelly
SQL Server MVP
"TonyHeuft" <theuft@.cha.ab.ca> wrote in message
news:2AE0F362-5E3A-496C-A0B6-D1B8237BF92C@.microsoft.com...
> I would like to add a version 7 DB to my SQL 2000 Server. I was wondering
if there was a way to add and upgrade it to version 2000 without installing
version 7 on the machine? If I have to install 7, what is the best procedure
with an existing install of 2000? Any help would be greatly appreciated.

adding a version 7 DB

What would be the quickest way to add a version 7 DB to SQL Server 2000? Can I do it without installing 7? I have a server with 2000 and would like to add the 7 DB without installing 7. Can I do it and if not, what is the best method for accomplishing what I am trying to do? All help will be greatly appreciated.You can restore a SQL 7 backup onto SQL 2000 and it will automatically
upgrade the database.
"TonyH" <theuft@.cha.ab.ca> wrote in message
news:3A92562F-9C65-46EF-8F98-DFE14793F2E0@.microsoft.com...
> What would be the quickest way to add a version 7 DB to SQL Server 2000?
Can I do it without installing 7? I have a server with 2000 and would like
to add the 7 DB without installing 7. Can I do it and if not, what is the
best method for accomplishing what I am trying to do? All help will be
greatly appreciated.|||Hi Tony
You have 3 answers to the previous post in which you asked this question 30
minutes ago.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"TonyH" <theuft@.cha.ab.ca> wrote in message
news:3A92562F-9C65-46EF-8F98-DFE14793F2E0@.microsoft.com...
> What would be the quickest way to add a version 7 DB to SQL Server 2000?
Can I do it without installing 7? I have a server with 2000 and would like
to add the 7 DB without installing 7. Can I do it and if not, what is the
best method for accomplishing what I am trying to do? All help will be
greatly appreciated.