details on Linked server?

Hi,
Any one know about Linked server setup in sql server.
I want to know more detail on setting up a sqlserver to connect it directly
to an oracle server. So that I can directly access data's from Oracle using
Stored procedure.
Regards,
Sasikumar Balasubramanian
Hi
See reply to later post..
John
"sasikumar" wrote:

> Hi,
> Any one know about Linked server setup in sql server.
> I want to know more detail on setting up a sqlserver to connect it directly
> to an oracle server. So that I can directly access data's from Oracle using
> Stored procedure.
>
> Regards,
> Sasikumar Balasubramanian
>
>

details on Linked server?

Hi,
Any one know about Linked server setup in sql server.
I want to know more detail on setting up a sqlserver to connect it directly
to an oracle server. So that I can directly access data's from Oracle using
Stored procedure.
Regards,
Sasikumar BalasubramanianHi
See reply to later post..
John
"sasikumar" wrote:
> Hi,
> Any one know about Linked server setup in sql server.
> I want to know more detail on setting up a sqlserver to connect it directly
> to an oracle server. So that I can directly access data's from Oracle using
> Stored procedure.
>
> Regards,
> Sasikumar Balasubramanian
>
>

details on Linked server?

Hi,
Any one know about Linked server setup in sql server.
I want to know more detail on setting up a sqlserver to connect it directly
to an oracle server. So that I can directly access data's from Oracle using
Stored procedure.
Regards,
Sasikumar BalasubramanianHi
See reply to later post..
John
"sasikumar" wrote:

> Hi,
> Any one know about Linked server setup in sql server.
> I want to know more detail on setting up a sqlserver to connect it directl
y
> to an oracle server. So that I can directly access data's from Oracle usin
g
> Stored procedure.
>
> Regards,
> Sasikumar Balasubramanian
>
>

details on Linked server setup

Hi,
Any one know about Linked server setup in sql server.
I want to know more detail on setting up a sqlserver to connect it directly
to an oracle server. So that I can directly access data's from Oracle using
Stored procedure.
Regards,
Sasikumar Balasubramanian
Hi
There is an example using the Microsoft Driver in sp_addlinked server
http://msdn.microsoft.com/library/de...adda_8gqa.asp.
Depending on the driver you are using you may also need to install SQL*NET
etc..
This article gives the steps required:
http://support.microsoft.com/default...b;en-us;280106
Oracle OLEDB drivers can be found at
http://www.oracle.com/technology/sof..._db/index.html
John
"sasikumar" wrote:

> Hi,
> Any one know about Linked server setup in sql server.
> I want to know more detail on setting up a sqlserver to connect it directly
> to an oracle server. So that I can directly access data's from Oracle using
> Stored procedure.
>
> Regards,
> Sasikumar Balasubramanian
>
>

details on Linked server setup

Hi,
Any one know about Linked server setup in sql server.
I want to know more detail on setting up a sqlserver to connect it directly
to an oracle server. So that I can directly access data's from Oracle using
Stored procedure.
Regards,
Sasikumar BalasubramanianHi
There is an example using the Microsoft Driver in sp_addlinked server
a_8gqa.asp." target="_blank">http://msdn.microsoft.com/library/d.../>
a_8gqa.asp.
Depending on the driver you are using you may also need to install SQL*NET
etc..
This article gives the steps required:
http://support.microsoft.com/defaul...kb;en-us;280106
Oracle OLEDB drivers can be found at
http://www.oracle.com/technology/so...e_db/index.html
John
"sasikumar" wrote:

> Hi,
> Any one know about Linked server setup in sql server.
> I want to know more detail on setting up a sqlserver to connect it directl
y
> to an oracle server. So that I can directly access data's from Oracle usin
g
> Stored procedure.
>
> Regards,
> Sasikumar Balasubramanian
>
>

details on Linked server setup

Hi,
Any one know about Linked server setup in sql server.
I want to know more detail on setting up a sqlserver to connect it directly
to an oracle server. So that I can directly access data's from Oracle using
Stored procedure.
Regards,
Sasikumar BalasubramanianHi
There is an example using the Microsoft Driver in sp_addlinked server
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_8gqa.asp.
Depending on the driver you are using you may also need to install SQL*NET
etc..
This article gives the steps required:
http://support.microsoft.com/default.aspx?scid=kb;en-us;280106
Oracle OLEDB drivers can be found at
http://www.oracle.com/technology/software/tech/windows/ole_db/index.html
John
"sasikumar" wrote:
> Hi,
> Any one know about Linked server setup in sql server.
> I want to know more detail on setting up a sqlserver to connect it directly
> to an oracle server. So that I can directly access data's from Oracle using
> Stored procedure.
>
> Regards,
> Sasikumar Balasubramanian
>
>

Details on Linked server

Hi,
Any one know about Linked server setup in sql server.
I want to know more detail on setting up a sqlserver to connect it directly
to an oracle server. So that I can directly access data's from Oracle using
Stored procedure.
Regards,
Sasikumar Balasubramanianhttp://msdn.microsoft.com/library/d... />
a_8gqa.asp
There's an example there on how to create a link to an Oracle server.
ML
http://milambda.blogspot.com/

DetachDB problems - DMO

I have the following code:
Set oServer = New SQLDMO.SQLServer
oServer.Connect (Servername), ServerID, ServerPwd
Call oServer.DetachDB(DBName, True)
oServer.Close
however, I continue getting the following error:
"Cannot detach the database 'Northwind' because it is currently in use"
Doing a detach with Enterprise manager works just fine on the same
server/db - - it's just that, with coding it, I get the error - -
what might I be doing wrong?hi,
Appears that there is a connection string live with the Northwind database
when you are dettaching the Northwind DB. Verify the same by putting a
breakpoint just before oServer.DetachDB(DBName, True) and then connect to
master DB from queryanalyzer and fire sp_who.
Ideally while using DMO you should connect explicitly to master db and then
try to dettach any other db.
Let us know if it solves ur issue...
cheers,
siaj
"Elmo Watson" wrote:

> I have the following code:
> Set oServer = New SQLDMO.SQLServer
> oServer.Connect (Servername), ServerID, ServerPwd
> Call oServer.DetachDB(DBName, True)
> oServer.Close
> however, I continue getting the following error:
> "Cannot detach the database 'Northwind' because it is currently in use"
> Doing a detach with Enterprise manager works just fine on the same
> server/db - - it's just that, with coding it, I get the error - -
> what might I be doing wrong?
>
>|||I see 16 entries when I do what you ask - most say background or
sleeping - - one says runnable - - I'm afraid I really don't know what this
gives me...
how can I close all connections before doing this?
"siaj" <siaj@.discussions.microsoft.com> wrote in message
news:6185D09E-6052-4CA8-8AE1-60EBE323149B@.microsoft.com...
> hi,
> Appears that there is a connection string live with the Northwind database
> when you are dettaching the Northwind DB. Verify the same by putting a
> breakpoint just before oServer.DetachDB(DBName, True) and then connect to
> master DB from queryanalyzer and fire sp_who.
> Ideally while using DMO you should connect explicitly to master db and
then
> try to dettach any other db.
> Let us know if it solves ur issue...
> cheers,
> siaj
>
> "Elmo Watson" wrote:
>|||Hi,
1.How many process show as the DBname as Northwind ... ideally they should
be none.
2. Which is the default database in ur SQL server. Verify that it should be
master in ur case. If not u can set it through sp_defaultDB in QA
3. While connecting through SQL-DMO make sure no users are connected to the
said DB(including urself/ QA)
4.In oServer.Connect (Servername), ServerID, ServerPwd also specify the
dbname property as "master"
5. Verify now thru sp_who how many connections are there to Northwind
..ideally there should be none.
6. Now try to dettach the DB
Let us know if u have any success...
cheers,
siaj
Which is your default database in the SQL Server....
"Elmo Watson" wrote:

> I see 16 entries when I do what you ask - most say background or
> sleeping - - one says runnable - - I'm afraid I really don't know what thi
s
> gives me...
> how can I close all connections before doing this?
>
>
> "siaj" <siaj@.discussions.microsoft.com> wrote in message
> news:6185D09E-6052-4CA8-8AE1-60EBE323149B@.microsoft.com...
> then
>
>|||Only one connection shows as Northwind - its host is the computer name - -
However, this can happen when I reboot and start fresh - that's the way it
comes up - I haven't run any program I know that hits the database.
I added a line :
oDataBase=oServer("master") - to make sure it hits the master when it
connects...
I also changed the default database to master
No matter what - it seems like there is always a connection to the Northwind
database (or any others also, for that server - - )
I just don't understand how this is happening and how to get around it...
"siaj" <siaj@.discussions.microsoft.com> wrote in message
news:34D5FCE9-C469-4B7A-AFA7-E9731EECF209@.microsoft.com...
> Hi,
> 1.How many process show as the DBname as Northwind ... ideally they
should
> be none.
> 2. Which is the default database in ur SQL server. Verify that it should
be
> master in ur case. If not u can set it through sp_defaultDB in QA
> 3. While connecting through SQL-DMO make sure no users are connected to
the
> said DB(including urself/ QA)
> 4.In oServer.Connect (Servername), ServerID, ServerPwd also specify the
> dbname property as "master"
> 5. Verify now thru sp_who how many connections are there to Northwind
> ..ideally there should be none.
> 6. Now try to dettach the DB
> Let us know if u have any success...
> cheers,
> siaj
>
> Which is your default database in the SQL Server....
> "Elmo Watson" wrote:
>
this
database
to
use"|||Use Profiler to know which application is opening a connection to the
Northwind Database.
siaj
"Elmo Watson" wrote:

> Only one connection shows as Northwind - its host is the computer name - -
> However, this can happen when I reboot and start fresh - that's the way it
> comes up - I haven't run any program I know that hits the database.
> I added a line :
> oDataBase=oServer("master") - to make sure it hits the master when it
> connects...
> I also changed the default database to master
> No matter what - it seems like there is always a connection to the Northwi
nd
> database (or any others also, for that server - - )
> I just don't understand how this is happening and how to get around it...
>
> "siaj" <siaj@.discussions.microsoft.com> wrote in message
> news:34D5FCE9-C469-4B7A-AFA7-E9731EECF209@.microsoft.com...
> should
> be
> the
> this
> database
> to
> use"
>
>

desktop sql2ksp3 pubs

I was trying some of the examples in VS. However, I can't seem to be able to connect to the pubs database. As you know from the title, I use a sql2ksp3 on a win2k machine. I've searched the MSDE, and they said something about dropping the localized ver
sion to the US version with an isql command, which doesn't seem to work in this case for the fact that isql command doesn't exist.
Can anyone help me?
Thanks in advance. ^_^
You can get pubs and Northind here
http://www.microsoft.com/downloads/d...displaylang=en
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Spenze" <anonymous@.discussions.microsoft.com> wrote in message
news:80C956E0-A3A6-4003-91C1-273B0045AD75@.microsoft.com...
> I was trying some of the examples in VS. However, I can't seem to be able
to connect to the pubs database. As you know from the title, I use a
sql2ksp3 on a win2k machine. I've searched the MSDE, and they said
something about dropping the localized version to the US version with an
isql command, which doesn't seem to work in this case for the fact that isql
command doesn't exist.
> Can anyone help me?
> Thanks in advance. ^_^

desktop sql2ksp3 pubs

I was trying some of the examples in VS. However, I can't seem to be able t
o connect to the pubs database. As you know from the title, I use a sql2ksp
3 on a win2k machine. I've searched the MSDE, and they said something about
dropping the localized ver
sion to the US version with an isql command, which doesn't seem to work in t
his case for the fact that isql command doesn't exist.
Can anyone help me?
Thanks in advance. ^_^You can get pubs and Northind here
EBC53A68034&displaylang=en" target="_blank">http://www.microsoft.com/downloads/...&displaylang=en
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Spenze" <anonymous@.discussions.microsoft.com> wrote in message
news:80C956E0-A3A6-4003-91C1-273B0045AD75@.microsoft.com...
> I was trying some of the examples in VS. However, I can't seem to be able
to connect to the pubs database. As you know from the title, I use a
sql2ksp3 on a win2k machine. I've searched the MSDE, and they said
something about dropping the localized version to the US version with an
isql command, which doesn't seem to work in this case for the fact that isql
command doesn't exist.
> Can anyone help me?
> Thanks in advance. ^_^

Designate database in login

Is there a way to tell SQL Server 2000 which database you
want to connect to at the time of login? I have two
different database on my server and there are times I want
to log into the other database instead of the default
database. Can do this at login time?Hi
isqlw -S servername -E -d northwind
this way i can go to northwind database instead of default one( use -U -P
for sql authentication)
well with odbc u can do it your own way with connection string
Regards,
Mayur
"John Abate" <abatej@.noralnm.com> wrote in message
news:d34401c3ef37$98826cf0$a001280a@.phx.gbl...
> Is there a way to tell SQL Server 2000 which database you
> want to connect to at the time of login? I have two
> different database on my server and there are times I want
> to log into the other database instead of the default
> database. Can do this at login time?|||Thanks!

>--Original Message--
>Hi
>isqlw -S servername -E -d northwind
>this way i can go to northwind database instead of
default one( use -U -P
>for sql authentication)
>well with odbc u can do it your own way with connection
string
>Regards,
>Mayur
>
>"John Abate" <abatej@.noralnm.com> wrote in message
>news:d34401c3ef37$98826cf0$a001280a@.phx.gbl...
you
want
>
>.
>

Design Pages on Report Server

Hi every body

I have developed an reporting solution for a customer with reporting services and using report builder.

When he connect to http://localhost/reports , he see the page like

http://img215.imageshack.us/img215/583/folderhl1.jpg

But i would to custom design of my default page, and other maybe. Where i can do it ?

Thanks all

Regards

Erwan Sarcelet, France

Hi.

There's not much you can do to change the look of report manager. However, if you have purchased Visual Studio 2005, you can build a customized front end for your reports. I have a feeling that is what you are asking for.

|||

Yes, that is what i wanted to know. So i cant modify the Folder.aspx file ?

Thank you Greg.

Erwan

|||

I'm not sure. Try to open it in Visual Studio and see what you can do to it.

However, I'm not really sure I would recommend doing that. I would think that you could potentially cause damage to report manager. That sounds too much like a hack to me.

I would recommend creating your own front end.