LINK WITH SQL SERVER

Hi, I'm doing a proyect with Visual Basic where I have to use a
database that I've already made on SQL SERVER. In my computer I had to
install WINDOWS 2000 family server, to be able to install SQL SERVER
as server not as a client, I can see perfectly and totally the
database from VB.

The problem is that now I have a laptop, and I want to continue
developing on it, I already installed everything like in the other
one, but I can't see SQL SERVER as a provider when I want to make the
connection. So I don't know if I have to do something special in order
to see it from Visual Basic.

I don't want to make a network, I just want to keep with the proyect
from the laptop.

Please somebody help me.Gloria (gloriarr2001@.yahoo.com.mx) writes:
> Hi, I'm doing a proyect with Visual Basic where I have to use a
> database that I've already made on SQL SERVER. In my computer I had to
> install WINDOWS 2000 family server, to be able to install SQL SERVER
> as server not as a client, I can see perfectly and totally the
> database from VB.
> The problem is that now I have a laptop, and I want to continue
> developing on it, I already installed everything like in the other
> one, but I can't see SQL SERVER as a provider when I want to make the
> connection. So I don't know if I have to do something special in order
> to see it from Visual Basic.

I'm not really sure what you mean with that you cannot see SQL Server as
provider. Do you run your program, and you fail to connect? Or is it
somehow missing in the developement environment? In the latter case,
you may be better off asking in a Visual Basic newsgroup.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||The fact is that when I try to make a connection from Visual Basic, I
have to specified the provider of OLE DB, so I use Microsoft OLE DB
Provider for SQL Sever, and when I try to check the connection there's
an error, there is no problem with Visual Basic, so I think that I do
something wrong with the SQL SERVER installation.

Is there anything that you suggest I can do?|||Gloria (gloriarr2001@.yahoo.com.mx) writes:
> The fact is that when I try to make a connection from Visual Basic, I
> have to specified the provider of OLE DB, so I use Microsoft OLE DB
> Provider for SQL Sever, and when I try to check the connection there's
> an error, there is no problem with Visual Basic, so I think that I do
> something wrong with the SQL SERVER installation.
> Is there anything that you suggest I can do?

Could you post the relevant piece of code?

There are a numbe of possibilities, but not having to access to your
machine, I'm in the dark.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||gloriarr2001@.yahoo.com.mx (Gloria) wrote in message news:<334b61a7.0404282149.1839acf1@.posting.google.com>...
> The fact is that when I try to make a connection from Visual Basic, I
> have to specified the provider of OLE DB, so I use Microsoft OLE DB
> Provider for SQL Sever, and when I try to check the connection there's
> an error, there is no problem with Visual Basic, so I think that I do
> something wrong with the SQL SERVER installation.
> Is there anything that you suggest I can do?

Have you installed the SQL Server client on your laptop?|||Not quite sure what you mean by "see SQL Server as a provider".

1. You need to have the SQL Server Client Tools installed on your
laptop.

2. Your laptop needs to be able to see the server in Network.

3. You need to "register" your database in the EnterpriseManager on
your laptop.

Alternatively, if you mean you can't create a UDL, the steps are:
A. In Windows Explorer, select File | New | text file.
B. Rename the resulting textfile to have .udl as its extension,
e.g. MyDatabase.udl. You will get a warning about changing the file
extension, ignore it.
C. Open the udl. Here's the stupid part -- when you open it, it
will be on the SECOND page of the wizard, which is only for ODBC
connections. You have to go to the FIRST page to find the SQL Server
OLE DB provider.
D. Now you can define your connection string like
Dim MyDB As Connection
Set MyDB = New Connection
MyDB.ConnectionString = "file name=c:\MyDatabase.udl"

HTH :)

On 28 Apr 2004 12:34:47 -0700, gloriarr2001@.yahoo.com.mx (Gloria)
wrote:

>Hi, I'm doing a proyect with Visual Basic where I have to use a
>database that I've already made on SQL SERVER. In my computer I had to
>install WINDOWS 2000 family server, to be able to install SQL SERVER
>as server not as a client, I can see perfectly and totally the
>database from VB.
>The problem is that now I have a laptop, and I want to continue
>developing on it, I already installed everything like in the other
>one, but I can't see SQL SERVER as a provider when I want to make the
>connection. So I don't know if I have to do something special in order
>to see it from Visual Basic.
>I don't want to make a network, I just want to keep with the proyect
>from the laptop.
>Please somebody help me.

LINK WITH SQL SERVER

Hi, I'm doing a proyect with Visual Basic where I have to use a
database that I've already made on SQL SERVER. In my computer I had to
install WINDOWS 2000 family server, to be able to install SQL SERVER
as server not as a client, I can see perfectly and totally the
database from VB.

The problem is that now I have a laptop, and I want to continue
developing on it, I already installed everything like in the other
one, but I can't see SQL SERVER as a provider when I want to make the
connection. So I don't know if I have to do something special in order
to see it from Visual Basic.

I don't want to make a network, I just want to keep with the proyect
from the laptop.

Please somebody help me.Gloria (gloriarr2001@.yahoo.com.mx) writes:
> Hi, I'm doing a proyect with Visual Basic where I have to use a
> database that I've already made on SQL SERVER. In my computer I had to
> install WINDOWS 2000 family server, to be able to install SQL SERVER
> as server not as a client, I can see perfectly and totally the
> database from VB.
> The problem is that now I have a laptop, and I want to continue
> developing on it, I already installed everything like in the other
> one, but I can't see SQL SERVER as a provider when I want to make the
> connection. So I don't know if I have to do something special in order
> to see it from Visual Basic.

I'm not really sure what you mean with that you cannot see SQL Server as
provider. Do you run your program, and you fail to connect? Or is it
somehow missing in the developement environment? In the latter case,
you may be better off asking in a Visual Basic newsgroup.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||The fact is that when I try to make a connection from Visual Basic, I
have to specified the provider of OLE DB, so I use Microsoft OLE DB
Provider for SQL Sever, and when I try to check the connection there's
an error, there is no problem with Visual Basic, so I think that I do
something wrong with the SQL SERVER installation.

Is there anything that you suggest I can do?|||Gloria (gloriarr2001@.yahoo.com.mx) writes:
> The fact is that when I try to make a connection from Visual Basic, I
> have to specified the provider of OLE DB, so I use Microsoft OLE DB
> Provider for SQL Sever, and when I try to check the connection there's
> an error, there is no problem with Visual Basic, so I think that I do
> something wrong with the SQL SERVER installation.
> Is there anything that you suggest I can do?

Could you post the relevant piece of code?

There are a numbe of possibilities, but not having to access to your
machine, I'm in the dark.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||gloriarr2001@.yahoo.com.mx (Gloria) wrote in message news:<334b61a7.0404282149.1839acf1@.posting.google.com>...
> The fact is that when I try to make a connection from Visual Basic, I
> have to specified the provider of OLE DB, so I use Microsoft OLE DB
> Provider for SQL Sever, and when I try to check the connection there's
> an error, there is no problem with Visual Basic, so I think that I do
> something wrong with the SQL SERVER installation.
> Is there anything that you suggest I can do?

Have you installed the SQL Server client on your laptop?|||Not quite sure what you mean by "see SQL Server as a provider".

1. You need to have the SQL Server Client Tools installed on your
laptop.

2. Your laptop needs to be able to see the server in Network.

3. You need to "register" your database in the EnterpriseManager on
your laptop.

Alternatively, if you mean you can't create a UDL, the steps are:
A. In Windows Explorer, select File | New | text file.
B. Rename the resulting textfile to have .udl as its extension,
e.g. MyDatabase.udl. You will get a warning about changing the file
extension, ignore it.
C. Open the udl. Here's the stupid part -- when you open it, it
will be on the SECOND page of the wizard, which is only for ODBC
connections. You have to go to the FIRST page to find the SQL Server
OLE DB provider.
D. Now you can define your connection string like
Dim MyDB As Connection
Set MyDB = New Connection
MyDB.ConnectionString = "file name=c:\MyDatabase.udl"

HTH :)

On 28 Apr 2004 12:34:47 -0700, gloriarr2001@.yahoo.com.mx (Gloria)
wrote:

>Hi, I'm doing a proyect with Visual Basic where I have to use a
>database that I've already made on SQL SERVER. In my computer I had to
>install WINDOWS 2000 family server, to be able to install SQL SERVER
>as server not as a client, I can see perfectly and totally the
>database from VB.
>The problem is that now I have a laptop, and I want to continue
>developing on it, I already installed everything like in the other
>one, but I can't see SQL SERVER as a provider when I want to make the
>connection. So I don't know if I have to do something special in order
>to see it from Visual Basic.
>I don't want to make a network, I just want to keep with the proyect
>from the laptop.
>Please somebody help me.|||Well, I don't want to make a network, so there's no need to install
SQL as client on my laptop, I just want to develop on it, and the
problem appears when I creat the UDL, during I try to choose the
database, and an error about the provider appears (that it can be
use).

What do you think I can do?|||>Well, I don't want to make a network, so there's no need to install
>SQL as client on my laptop, I just want to develop on it, and the
>problem appears when I creat the UDL, during I try to choose the
>database, and an error about the provider appears (that it can be
>use).
>What do you think I can do?

Tell us what the error msg is.

Randy
http://members.aol.com/rsmeiner|||Gloria (gloriarr2001@.yahoo.com.mx) writes:
> Well, I don't want to make a network, so there's no need to install
> SQL as client on my laptop, I just want to develop on it, and the
> problem appears when I creat the UDL, during I try to choose the
> database, and an error about the provider appears (that it can be
> use).

I don't understand what you mean by "make a network", but since you
gooc have good use for having Query Analyzer and friends on the
machine while developing, I suggest that you install the client
part of SQL Server. You are not making a network that way anyway.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||How do you expect to talk to the database on the other box if the
laptop isn't connected to it?

On 4 May 2004 11:37:22 -0700, gloriarr2001@.yahoo.com.mx (Gloria)
wrote:

>Well, I don't want to make a network, so there's no need to install
>SQL as client on my laptop, I just want to develop on it, and the
>problem appears when I creat the UDL, during I try to choose the
>database, and an error about the provider appears (that it can be
>use).
>What do you think I can do?|||Well, I don't want to make a network, so there's no need to install
SQL as client on my laptop, I just want to develop on it, and the
problem appears when I creat the UDL, during I try to choose the
database, and an error about the provider appears (that it can be
use).

What do you think I can do?|||>Well, I don't want to make a network, so there's no need to install
>SQL as client on my laptop, I just want to develop on it, and the
>problem appears when I creat the UDL, during I try to choose the
>database, and an error about the provider appears (that it can be
>use).
>What do you think I can do?

Tell us what the error msg is.

Randy
http://members.aol.com/rsmeiner|||Gloria (gloriarr2001@.yahoo.com.mx) writes:
> Well, I don't want to make a network, so there's no need to install
> SQL as client on my laptop, I just want to develop on it, and the
> problem appears when I creat the UDL, during I try to choose the
> database, and an error about the provider appears (that it can be
> use).

I don't understand what you mean by "make a network", but since you
gooc have good use for having Query Analyzer and friends on the
machine while developing, I suggest that you install the client
part of SQL Server. You are not making a network that way anyway.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||How do you expect to talk to the database on the other box if the
laptop isn't connected to it?

On 4 May 2004 11:37:22 -0700, gloriarr2001@.yahoo.com.mx (Gloria)
wrote:

>Well, I don't want to make a network, so there's no need to install
>SQL as client on my laptop, I just want to develop on it, and the
>problem appears when I creat the UDL, during I try to choose the
>database, and an error about the provider appears (that it can be
>use).
>What do you think I can do?|||Ellen K. <72322.enno.esspeeayem.1016@.compuserve.com> wrote in message news:<nguh90duagqp6p85vqmg6664n8babe7r8d@.4ax.com>...
> How do you expect to talk to the database on the other box if the
> laptop isn't connected to it?
Well, wath I want to do is have the database in the laptop, I already
created there, I can use the query analyzer, but in the UDL
construction, there's an error after I dropdown on the databases box.sql

Link with parameters

Hi,
is it possible to start a Report via Link (from Desktop) with start
parameter like an
ASP-Script
For example:
...report.rdl?Year=2007&Month=6...
Thank you
HansThat's what URL access in RS is for.
Amarnath
"Hans" wrote:
> Hi,
> is it possible to start a Report via Link (from Desktop) with start
> parameter like an
> ASP-Script
> For example:
>
> ...report.rdl?Year=2007&Month=6...
>
> Thank you
> Hans
>|||That what I mean ist to start the report from Desktop inclusive
parameters.
Hans|||ok,
so this is a sample you can use to see how it works if you have implemented
the samples and hosted the reports on localserver. copy this url from
desktop.. also you can write asp.net to mask this url and give just a
hyperlink from the page.. see the parameters also passed.
http://server/reportserver?/Sales/Northwest/Employee Sales
Report&rs:Command=Render&EmployeeID=1234
Amarnath
"Hans" wrote:
> That what I mean ist to start the report from Desktop inclusive
> parameters.
> Hans
>|||I tried this, but it doesn=B4t work. The report opens, but there=B4s not
selected parameter value.
Thanks,
Hans|||Hans,
Have you pasted my sample link as a whole URL because it is wraped in the
post.
Incase you have done this pl ignore, you said there is no parameter value,
so I thought you have not pasted the whole URL.
Amarnath, MCTS
"Hans" wrote:
> I tried this, but it doesn´t work. The report opens, but there´s not
> selected parameter value.
>
> Thanks,
> Hans
>

Link with encryption example for 2005

Is there any link where I can see how the new security model wrt
keys/certificates work ? I am looking for examples. to play around with.See my blog - a link to is in my signature.
Thanks
Laurentiu Cristofor [MSFT]
Software Development Engineer
SQL Server Engine
http://blogs.msdn.com/lcris/
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hassan" <Hassan@.hotmail.com> wrote in message
news:etpA4MdPHHA.3268@.TK2MSFTNGP03.phx.gbl...
> Is there any link where I can see how the new security model wrt
> keys/certificates work ? I am looking for examples. to play around with.
>

Link two tables using partial word match

Hi All,

I need to link two tables using partial word match.

How can I write a SQL statement to do so? (I am using MS-Access.)

Table One: [Table Name: tblStreet] [Field Name: Street]
123 ABC Street
124 ABC Street
125 ABC Street
1 XYZ AVE
2 XYZ AVE
3 XYZ AVE
10 CBS Street
11 CBS Street
12 CBS Street
100 Apple Road
101 Apple Road
102 Apple Road

Table Two: [Table Name: tblWord] [Field Name: Word]
ABC
CBS

The output should be:

123 ABC Street
124 ABC Street
125 ABC Street
10 CBS Street
11 CBS Street
12 CBS Street

Could this be done?

Thank you in advanced.

- Grasshopper -SQL Learner wrote:

Quote:

Originally Posted by

Hi All,
>
I need to link two tables using partial word match.
>
How can I write a SQL statement to do so? (I am using MS-Access.)
>
Table One: [Table Name: tblStreet] [Field Name: Street]
123 ABC Street
124 ABC Street
125 ABC Street
1 XYZ AVE
2 XYZ AVE
3 XYZ AVE
10 CBS Street
11 CBS Street
12 CBS Street
100 Apple Road
101 Apple Road
102 Apple Road
>
Table Two: [Table Name: tblWord] [Field Name: Word]
ABC
CBS
>
The output should be:
>
123 ABC Street
124 ABC Street
125 ABC Street
10 CBS Street
11 CBS Street
12 CBS Street
>
Could this be done?
>
Thank you in advanced.
>
- Grasshopper -

SELECT t.* FROM tblStreet t WHERE EXISTS(SELECT 1 FROM tblWord w WHERE
t.Street LIKE '%'+Word+'%')

--------
Alex Kuznetsov
http://sqlserver-tips.blogspot.com/
http://sqlserver-puzzles.blogspot.com/|||Thank you so much Alex! It works. The only thing is that I replaced
the "%" with "*" since this is Transact SQL in Access. : )

By the way, is there any good book that I can use to learn SQL of this
kind?

- Grasshopper -

Link two tables in UPDATE - ERR:single-row subquery returns more than one row

1 UPDATE PM_ASSIGNMENTS
2 SET PM_ASSIGNMENTS.JOB_TYPE_CODE = (SELECT PM_TASK_DETAILS.JOB_TYPE_CODE
3 FROM PM_ASSIGNMENTS, PM_TASK_DETAILS
4 WHERE ((PM_ASSIGNMENTS.TASK_NUMBER) = (PM_TASK_DETAILS.TASK_NUMBER))
5* AND (PM_ASSIGNMENTS.TASK_NUMBER = '1000'))
SQL> /
SET PM_ASSIGNMENTS.JOB_TYPE_CODE = (SELECT PM_TASK_DETAILS.JOB_TYPE_CODE
*
ERROR at line 2:
ORA-01427: single-row subquery returns more than one rowthe sub-query is returning more than one row for the given condition.

either group-by them, or give all user-key conditions.

regards,
Raghu.sql

Link Two tables

Hi All,
I want link two tables from two different database located on different server. they both are not have unique reference.
Table1 from db1 is one field(Emp_id) is auto increment number And another one is table2 from db2(Newly created table). I need some fields from table1.db1 to table2 db2. When all are user modified table1.db1 then automatically update table2.db2

thanksI think you recieved answer to your question.

http://www.msdner.com/forum/thread586326.html

Not sure what else you are looking for.

Link two server

Dear community
I have two SQL Server 7.0 one on Win2000 second on NT SP6
I would like to link them in order to use information from both of them for
reports.
To have same stored procedures on both servers I would like to name links
same way on both servers.
At the begin servers were able to see each other only using IP address. I
created corresponding to IP names and windows server names records into
LMHOSTS and then was able to use server names to create links.
Then I tried to create entries into HOSTS file where actual IP addresses
are refers to names I would like to have ( names are completely different to
name of any server into the network and have only alphabetic characters).
The strange thing is on WIN2000 I can create a link with name as defined
into HOSTS file but on NT4 that did not work . I cleared IP cache after any
change into LMHOSTS or HOSTS on both sites and I can ping with no problem
WIN2000 server from NT4 server site with any name I pointed into HOSTS.
Can somebody give an idea how to make that work ?
I was thinking about restarting NT4 server, but network administrator
doesn't want even hear about that.
Any ideas will be very much appreciated
With best regards
VitoYou can create a true linked server that will allow you to execute a =select statement like the following:
SELECT * FROM SomeServer.pubs.dbo.authors
Where SomeServer is the name of the linked server that you defined.
The easiest way to create a linked server is to do so within Enterprise =Manager. Open up the security tab, right-click on linked servers, =choose new linked server, hit the 'SQL Server' radio button, type in the =name of the server, set the security options and you are done. You =should be able to select from the linked server. If you want to give =the linked server a different name from the name of the SQL Server that =you are linking to you can do so by typing whatever name you want to =give your linked server within the text box and make sure that you =specify Microsoft OLE DB Provider for SQL Server within the Provider =name list box.
-- Keith
"VS" <nospam@.please.thanks> wrote in message =news:WEdoc.49795$wY.17731@.nwrdny03.gnilink.net...
> Dear community
> I have two SQL Server 7.0 one on Win2000 second on NT SP6
> > I would like to link them in order to use information from both of =them for
> reports.
> To have same stored procedures on both servers I would like to name =links
> same way on both servers.
> > At the begin servers were able to see each other only using IP =address. I
> created corresponding to IP names and windows server names records =into
> LMHOSTS and then was able to use server names to create links.
> Then I tried to create entries into HOSTS file where actual IP =addresses
> are refers to names I would like to have ( names are completely =different to
> name of any server into the network and have only alphabetic =characters).
> The strange thing is on WIN2000 I can create a link with name as =defined
> into HOSTS file but on NT4 that did not work . I cleared IP cache =after any
> change into LMHOSTS or HOSTS on both sites and I can ping with no =problem
> WIN2000 server from NT4 server site with any name I pointed into =HOSTS.
> > Can somebody give an idea how to make that work ?
> I was thinking about restarting NT4 server, but network administrator
> doesn't want even hear about that.
> > Any ideas will be very much appreciated
> > With best regards
> Vito
> >

Link two server

Dear community
I have two SQL Server 7.0 one on Win2000 second on NT SP6
I would like to link them in order to use information from both of them for
reports.
To have same stored procedures on both servers I would like to name links
same way on both servers.
At the begin servers were able to see each other only using IP address. I
created corresponding to IP names and windows server names records into
LMHOSTS and then was able to use server names to create links.
Then I tried to create entries into HOSTS file where actual IP addresses
are refers to names I would like to have ( names are completely different to
name of any server into the network and have only alphabetic characters).
The strange thing is on WIN2000 I can create a link with name as defined
into HOSTS file but on NT4 that did not work . I cleared IP cache after any
change into LMHOSTS or HOSTS on both sites and I can ping with no problem
WIN2000 server from NT4 server site with any name I pointed into HOSTS.
Can somebody give an idea how to make that work ?
I was thinking about restarting NT4 server, but network administrator
doesn't want even hear about that.
Any ideas will be very much appreciated
With best regards
VitoYou can create a true linked server that will allow you to execute a =
select statement like the following:
SELECT * FROM SomeServer.pubs.dbo.authors
Where SomeServer is the name of the linked server that you defined.
The easiest way to create a linked server is to do so within Enterprise =
Manager. Open up the security tab, right-click on linked servers, =
choose new linked server, hit the 'SQL Server' radio button, type in the =
name of the server, set the security options and you are done. You =
should be able to select from the linked server. If you want to give =
the linked server a different name from the name of the SQL Server that =
you are linking to you can do so by typing whatever name you want to =
give your linked server within the text box and make sure that you =
specify Microsoft OLE DB Provider for SQL Server within the Provider =
name list box.
--=20
Keith
"VS" <nospam@.please.thanks> wrote in message =
news:WEdoc.49795$wY.17731@.nwrdny03.gnilink.net...
> Dear community
> I have two SQL Server 7.0 one on Win2000 second on NT SP6
>=20
> I would like to link them in order to use information from both of =
them for
> reports.
> To have same stored procedures on both servers I would like to name =
links
> same way on both servers.
>=20
> At the begin servers were able to see each other only using IP =
address. I
> created corresponding to IP names and windows server names records =
into
> LMHOSTS and then was able to use server names to create links.
> Then I tried to create entries into HOSTS file where actual IP =
addresses
> are refers to names I would like to have ( names are completely =
different to
> name of any server into the network and have only alphabetic =
characters).
> The strange thing is on WIN2000 I can create a link with name as =
defined
> into HOSTS file but on NT4 that did not work . I cleared IP cache =
after any
> change into LMHOSTS or HOSTS on both sites and I can ping with no =
problem
> WIN2000 server from NT4 server site with any name I pointed into =
HOSTS.
>=20
> Can somebody give an idea how to make that work ?
> I was thinking about restarting NT4 server, but network administrator
> doesn't want even hear about that.
>=20
> Any ideas will be very much appreciated
>=20
> With best regards
> Vito
>=20
>

Link two server

Dear community
I have two SQL Server 7.0 one on Win2000 second on NT SP6
I would like to link them in order to use information from both of them for
reports.
To have same stored procedures on both servers I would like to name links
same way on both servers.
At the begin servers were able to see each other only using IP address. I
created corresponding to IP names and windows server names records into
LMHOSTS and then was able to use server names to create links.
Then I tried to create entries into HOSTS file where actual IP addresses
are refers to names I would like to have ( names are completely different to
name of any server into the network and have only alphabetic characters).
The strange thing is on WIN2000 I can create a link with name as defined
into HOSTS file but on NT4 that did not work . I cleared IP cache after any
change into LMHOSTS or HOSTS on both sites and I can ping with no problem
WIN2000 server from NT4 server site with any name I pointed into HOSTS.
Can somebody give an idea how to make that work ?
I was thinking about restarting NT4 server, but network administrator
doesn't want even hear about that.
Any ideas will be very much appreciated
With best regards
Vito
You can create a true linked server that will allow you to execute a =
select statement like the following:
SELECT * FROM SomeServer.pubs.dbo.authors
Where SomeServer is the name of the linked server that you defined.
The easiest way to create a linked server is to do so within Enterprise =
Manager. Open up the security tab, right-click on linked servers, =
choose new linked server, hit the 'SQL Server' radio button, type in the =
name of the server, set the security options and you are done. You =
should be able to select from the linked server. If you want to give =
the linked server a different name from the name of the SQL Server that =
you are linking to you can do so by typing whatever name you want to =
give your linked server within the text box and make sure that you =
specify Microsoft OLE DB Provider for SQL Server within the Provider =
name list box.
--=20
Keith
"VS" <nospam@.please.thanks> wrote in message =
news:WEdoc.49795$wY.17731@.nwrdny03.gnilink.net...
> Dear community
> I have two SQL Server 7.0 one on Win2000 second on NT SP6
>=20
> I would like to link them in order to use information from both of =
them for
> reports.
> To have same stored procedures on both servers I would like to name =
links
> same way on both servers.
>=20
> At the begin servers were able to see each other only using IP =
address. I
> created corresponding to IP names and windows server names records =
into
> LMHOSTS and then was able to use server names to create links.
> Then I tried to create entries into HOSTS file where actual IP =
addresses
> are refers to names I would like to have ( names are completely =
different to
> name of any server into the network and have only alphabetic =
characters).
> The strange thing is on WIN2000 I can create a link with name as =
defined
> into HOSTS file but on NT4 that did not work . I cleared IP cache =
after any
> change into LMHOSTS or HOSTS on both sites and I can ping with no =
problem
> WIN2000 server from NT4 server site with any name I pointed into =
HOSTS.
>=20
> Can somebody give an idea how to make that work ?
> I was thinking about restarting NT4 server, but network administrator
> doesn't want even hear about that.
>=20
> Any ideas will be very much appreciated
>=20
> With best regards
> Vito
>=20
>
sql

Link two internal sql-servers

Hi!
I have a network with two sql-servers.
One which we can call LOCAL1 is a sql-server with a non public ip-adress.
Another one which we can call PUBLIC1 which is a sql-server with a
public ip-adress.
I have setup one account on each server for connection to the pubs-database.
I add linked server with sp_addlinkedserver on booth servers and also
adds logins with sp_addlinkedsrvlogin.
Evrything seems fine.
When I login with my account that I just setup on the local server with
QA and the query like this
select * from PUBLIC1.pubs.dbo.authors
everything is fine and it works perfect.
But when I login with my account on the public server with QA and query
like this
select * from LOCAL1.pubs.dbo.authors
I get this response after 21 seconds:
Server: Msg 17, Level 16, State 1, Line 1
SQL Server does not exist or access denied.
I am using booth named pipes and TCP/IP on booth the client and the server.
I have tried to add the local server to the public servers hosts file.
But it didnt help.
Any suggestions?
Thanks!Start here:
Potential causes of the "SQL Server Does Not Exist or Access Denied" error
message
http://support.microsoft.com/defaul...kb;en-us;328306
Firewall in between maybe?
HTH
Dylan
"dotNet" <dotnet@.brimba.nu> wrote in message
news:eqmmDXbXEHA.4032@.TK2MSFTNGP11.phx.gbl...
> Hi!
> I have a network with two sql-servers.
> One which we can call LOCAL1 is a sql-server with a non public ip-adress.
> Another one which we can call PUBLIC1 which is a sql-server with a
> public ip-adress.
> I have setup one account on each server for connection to the
pubs-database.
> I add linked server with sp_addlinkedserver on booth servers and also
> adds logins with sp_addlinkedsrvlogin.
> Evrything seems fine.
> When I login with my account that I just setup on the local server with
> QA and the query like this
> select * from PUBLIC1.pubs.dbo.authors
> everything is fine and it works perfect.
> But when I login with my account on the public server with QA and query
> like this
> select * from LOCAL1.pubs.dbo.authors
> I get this response after 21 seconds:
> Server: Msg 17, Level 16, State 1, Line 1
> SQL Server does not exist or access denied.
> I am using booth named pipes and TCP/IP on booth the client and the
server.
> I have tried to add the local server to the public servers hosts file.
> But it didnt help.
> Any suggestions?
> Thanks!|||Hi!
I have looked there.
I found that I cannot even telnet from the local1 to localhost
telnet localhost 1433
this works perfect on the public server...
I can ping localhost and the local ip as well.
But I can connect with QA to local1 and run queries...
What can this be?
I dont have any firewall on the local1-server.
Thanks
Dylan Kruger[MS] wrote:

> Start here:
> Potential causes of the "SQL Server Does Not Exist or Access Denied" error
> message
> http://support.microsoft.com/defaul...kb;en-us;328306
> Firewall in between maybe?
> HTH
> Dylan
> "dotNet" <dotnet@.brimba.nu> wrote in message
> news:eqmmDXbXEHA.4032@.TK2MSFTNGP11.phx.gbl...
>
> pubs-database.
>
> server.
>
>
>

Link two internal sql-servers

Hi!
I have a network with two sql-servers.
One which we can call LOCAL1 is a sql-server with a non public ip-adress.
Another one which we can call PUBLIC1 which is a sql-server with a
public ip-adress.
I have setup one account on each server for connection to the pubs-database.
I add linked server with sp_addlinkedserver on booth servers and also
adds logins with sp_addlinkedsrvlogin.
Evrything seems fine.
When I login with my account that I just setup on the local server with
QA and the query like this
select * from PUBLIC1.pubs.dbo.authors
everything is fine and it works perfect.
But when I login with my account on the public server with QA and query
like this
select * from LOCAL1.pubs.dbo.authors
I get this response after 21 seconds:
Server: Msg 17, Level 16, State 1, Line 1
SQL Server does not exist or access denied.
I am using booth named pipes and TCP/IP on booth the client and the server.
I have tried to add the local server to the public servers hosts file.
But it didnt help.
Any suggestions?
Thanks!Start here:
Potential causes of the "SQL Server Does Not Exist or Access Denied" error
message
http://support.microsoft.com/default.aspx?scid=kb;en-us;328306
Firewall in between maybe?
HTH
Dylan
"dotNet" <dotnet@.brimba.nu> wrote in message
news:eqmmDXbXEHA.4032@.TK2MSFTNGP11.phx.gbl...
> Hi!
> I have a network with two sql-servers.
> One which we can call LOCAL1 is a sql-server with a non public ip-adress.
> Another one which we can call PUBLIC1 which is a sql-server with a
> public ip-adress.
> I have setup one account on each server for connection to the
pubs-database.
> I add linked server with sp_addlinkedserver on booth servers and also
> adds logins with sp_addlinkedsrvlogin.
> Evrything seems fine.
> When I login with my account that I just setup on the local server with
> QA and the query like this
> select * from PUBLIC1.pubs.dbo.authors
> everything is fine and it works perfect.
> But when I login with my account on the public server with QA and query
> like this
> select * from LOCAL1.pubs.dbo.authors
> I get this response after 21 seconds:
> Server: Msg 17, Level 16, State 1, Line 1
> SQL Server does not exist or access denied.
> I am using booth named pipes and TCP/IP on booth the client and the
server.
> I have tried to add the local server to the public servers hosts file.
> But it didnt help.
> Any suggestions?
> Thanks!|||Hi!
I have looked there.
I found that I cannot even telnet from the local1 to localhost
telnet localhost 1433
this works perfect on the public server...
I can ping localhost and the local ip as well.
But I can connect with QA to local1 and run queries...
What can this be?
I dont have any firewall on the local1-server.
Thanks
Dylan Kruger[MS] wrote:
> Start here:
> Potential causes of the "SQL Server Does Not Exist or Access Denied" error
> message
> http://support.microsoft.com/default.aspx?scid=kb;en-us;328306
> Firewall in between maybe?
> HTH
> Dylan
> "dotNet" <dotnet@.brimba.nu> wrote in message
> news:eqmmDXbXEHA.4032@.TK2MSFTNGP11.phx.gbl...
>>Hi!
>>I have a network with two sql-servers.
>>One which we can call LOCAL1 is a sql-server with a non public ip-adress.
>>Another one which we can call PUBLIC1 which is a sql-server with a
>>public ip-adress.
>>I have setup one account on each server for connection to the
> pubs-database.
>>I add linked server with sp_addlinkedserver on booth servers and also
>>adds logins with sp_addlinkedsrvlogin.
>>Evrything seems fine.
>>When I login with my account that I just setup on the local server with
>>QA and the query like this
>>select * from PUBLIC1.pubs.dbo.authors
>>everything is fine and it works perfect.
>>But when I login with my account on the public server with QA and query
>>like this
>>select * from LOCAL1.pubs.dbo.authors
>>I get this response after 21 seconds:
>>Server: Msg 17, Level 16, State 1, Line 1
>>SQL Server does not exist or access denied.
>>I am using booth named pipes and TCP/IP on booth the client and the
> server.
>>I have tried to add the local server to the public servers hosts file.
>>But it didnt help.
>>Any suggestions?
>>Thanks!
>
>

Link two internal sql-servers

Hi!
I have a network with two sql-servers.
One which we can call LOCAL1 is a sql-server with a non public ip-adress.
Another one which we can call PUBLIC1 which is a sql-server with a
public ip-adress.
I have setup one account on each server for connection to the pubs-database.
I add linked server with sp_addlinkedserver on booth servers and also
adds logins with sp_addlinkedsrvlogin.
Evrything seems fine.
When I login with my account that I just setup on the local server with
QA and the query like this
select * from PUBLIC1.pubs.dbo.authors
everything is fine and it works perfect.
But when I login with my account on the public server with QA and query
like this
select * from LOCAL1.pubs.dbo.authors
I get this response after 21 seconds:
Server: Msg 17, Level 16, State 1, Line 1
SQL Server does not exist or access denied.
I am using booth named pipes and TCP/IP on booth the client and the server.
I have tried to add the local server to the public servers hosts file.
But it didnt help.
Any suggestions?
Thanks!
Start here:
Potential causes of the "SQL Server Does Not Exist or Access Denied" error
message
http://support.microsoft.com/default...b;en-us;328306
Firewall in between maybe?
HTH
Dylan
"dotNet" <dotnet@.brimba.nu> wrote in message
news:eqmmDXbXEHA.4032@.TK2MSFTNGP11.phx.gbl...
> Hi!
> I have a network with two sql-servers.
> One which we can call LOCAL1 is a sql-server with a non public ip-adress.
> Another one which we can call PUBLIC1 which is a sql-server with a
> public ip-adress.
> I have setup one account on each server for connection to the
pubs-database.
> I add linked server with sp_addlinkedserver on booth servers and also
> adds logins with sp_addlinkedsrvlogin.
> Evrything seems fine.
> When I login with my account that I just setup on the local server with
> QA and the query like this
> select * from PUBLIC1.pubs.dbo.authors
> everything is fine and it works perfect.
> But when I login with my account on the public server with QA and query
> like this
> select * from LOCAL1.pubs.dbo.authors
> I get this response after 21 seconds:
> Server: Msg 17, Level 16, State 1, Line 1
> SQL Server does not exist or access denied.
> I am using booth named pipes and TCP/IP on booth the client and the
server.
> I have tried to add the local server to the public servers hosts file.
> But it didnt help.
> Any suggestions?
> Thanks!
|||Start here:
Potential causes of the "SQL Server Does Not Exist or Access Denied" error
message
http://support.microsoft.com/default...b;en-us;328306
Firewall in between maybe?
HTH
Dylan
"dotNet" <dotnet@.brimba.nu> wrote in message
news:eqmmDXbXEHA.4032@.TK2MSFTNGP11.phx.gbl...
> Hi!
> I have a network with two sql-servers.
> One which we can call LOCAL1 is a sql-server with a non public ip-adress.
> Another one which we can call PUBLIC1 which is a sql-server with a
> public ip-adress.
> I have setup one account on each server for connection to the
pubs-database.
> I add linked server with sp_addlinkedserver on booth servers and also
> adds logins with sp_addlinkedsrvlogin.
> Evrything seems fine.
> When I login with my account that I just setup on the local server with
> QA and the query like this
> select * from PUBLIC1.pubs.dbo.authors
> everything is fine and it works perfect.
> But when I login with my account on the public server with QA and query
> like this
> select * from LOCAL1.pubs.dbo.authors
> I get this response after 21 seconds:
> Server: Msg 17, Level 16, State 1, Line 1
> SQL Server does not exist or access denied.
> I am using booth named pipes and TCP/IP on booth the client and the
server.
> I have tried to add the local server to the public servers hosts file.
> But it didnt help.
> Any suggestions?
> Thanks!
|||Hi!
I have looked there.
I found that I cannot even telnet from the local1 to localhost
telnet localhost 1433
this works perfect on the public server...
I can ping localhost and the local ip as well.
But I can connect with QA to local1 and run queries...
What can this be?
I dont have any firewall on the local1-server.
Thanks
Dylan Kruger[MS] wrote:

> Start here:
> Potential causes of the "SQL Server Does Not Exist or Access Denied" error
> message
> http://support.microsoft.com/default...b;en-us;328306
> Firewall in between maybe?
> HTH
> Dylan
> "dotNet" <dotnet@.brimba.nu> wrote in message
> news:eqmmDXbXEHA.4032@.TK2MSFTNGP11.phx.gbl...
>
> pubs-database.
>
> server.
>
>
|||Hi!
I have looked there.
I found that I cannot even telnet from the local1 to localhost
telnet localhost 1433
this works perfect on the public server...
I can ping localhost and the local ip as well.
But I can connect with QA to local1 and run queries...
What can this be?
I dont have any firewall on the local1-server.
Thanks
Dylan Kruger[MS] wrote:

> Start here:
> Potential causes of the "SQL Server Does Not Exist or Access Denied" error
> message
> http://support.microsoft.com/default...b;en-us;328306
> Firewall in between maybe?
> HTH
> Dylan
> "dotNet" <dotnet@.brimba.nu> wrote in message
> news:eqmmDXbXEHA.4032@.TK2MSFTNGP11.phx.gbl...
>
> pubs-database.
>
> server.
>
>

Link two dataSet in the same report

Hi !
I use ms sql server 2005, and I have a problem
I have a dataBase where I have a lot of data, I have a webServices which calculate indicator for a time period and an id indicator. The time period must be specific and choose by the user, so I can't dto automatically by integrating the data from my webService in a dataBase (with IntegrationServices).
So I create a report with 2 dataset, one which recover the indicator value for each equipment (the webService send a list of {<idEquipment> and <value>}) , and I want to link the idEquipment with the IdEquipement in my dataBase, it would allow me to know other informations about the equipment :
equipement ID | Indicator value (from webServices) | equipment name | eq number | cumul of event duration for this eq....
All in the same grid...
Does it possible ?
If it is possible with the report designer, does it possible with report builder, as report builder need a model, how can i do to make a model from 2 dataSource...
thank you for your answer...

You may want to explore using SSIS as a data source or a custom object, or connect to the web service from SQL Server passing the parameters to it.

I was once able to use hash tables in custom code to store the data, with hidden fields for setting the values, but I'm not sure if that is feasable anymore as I could not replicate it.

cheers,

Andrew

|||Hi Andrew, and thank you for your answer.
As i explain, it is not possible to us to integrate our data with SSIS because our webService need parameter define by user, if we pass our own parameter, there will have too much data and user cannot change them after.
So I need to call my web Service methode in my report, because it is at this moment that the user can and have to choose his param. So I have already doing a dataSet which recover the data from the web Service.
Now I need to know if it possible to do like a 'inner join' between two dataSet (one from my web Service, and the other from my olap cube) ?
I already use BIRT (Java) and it is possible to do it, but I didn't see this 'option' in Reporting Services. Maybe there is an easy way or another way to do that... I hope so.

Thank you to read...
|||

Hi Alineo,

It's not possible to join two different datasets inside the report itself.

Hope you can find alternate means. You should be able to pass parameters to a web service by using SSIS or SQL Server.

cheers,

Andrew

|||excuse me, but I don't understand how, to do.
I need just this information when the user run the report... so it isn't possible to use integrating services, because (it is what I understand) the integration will generate automatically and before... So the user cannot give it param to it, just the developper can do it, and as I told you, the developper cannot do all the possibility in parameter.
The parameter in a time period (from ... to ...) so ....
Ok so it is not possible !!
thank you for your answer....
|||

Here's how to use a parameter from SSIS if you want to go down this road.

http://blogs.msdn.com/bimusings/archive/2006/07/19/using-a-parameterized-ssis-package-as-a-data-source-for-sql-reporting-services.aspx

Integration services runs when the report runs.

cheers,

Andrew

link to the need to setup a development and test environment

Is there any link out there on the need to setup an environment ? I know its
needed, just looking to find some official link
Also how do you sync up production databases to these environments ? Do you
do it daily ? backup and restore ?
You do not need to restore the database daily or too often. It depends on
how updated data the developers require. Be careful if you have done schema
changes to the development database and you restore a new copy.
Use the backups that you do on the production environment. That will help
you to test your backup and recovery strategy.
Ben Nevarez, MCDBA, OCP
"Hassan" <hassan@.hotmail.com> wrote in message
news:e7L7BAi%23FHA.504@.TK2MSFTNGP09.phx.gbl...
> Is there any link out there on the need to setup an environment ? I know
> its needed, just looking to find some official link
> Also how do you sync up production databases to these environments ? Do
> you do it daily ? backup and restore ?
>
sql

link to the need to setup a development and test environment

Is there any link out there on the need to setup an environment ? I know its
needed, just looking to find some official link
Also how do you sync up production databases to these environments ? Do you
do it daily ? backup and restore ?You do not need to restore the database daily or too often. It depends on
how updated data the developers require. Be careful if you have done schema
changes to the development database and you restore a new copy.
Use the backups that you do on the production environment. That will help
you to test your backup and recovery strategy.
Ben Nevarez, MCDBA, OCP
"Hassan" <hassan@.hotmail.com> wrote in message
news:e7L7BAi%23FHA.504@.TK2MSFTNGP09.phx.gbl...
> Is there any link out there on the need to setup an environment ? I know
> its needed, just looking to find some official link
> Also how do you sync up production databases to these environments ? Do
> you do it daily ? backup and restore ?
>

link to the need to setup a development and test environment

Is there any link out there on the need to setup an environment ? I know its
needed, just looking to find some official link
Also how do you sync up production databases to these environments ? Do you
do it daily ? backup and restore ?You do not need to restore the database daily or too often. It depends on
how updated data the developers require. Be careful if you have done schema
changes to the development database and you restore a new copy.
Use the backups that you do on the production environment. That will help
you to test your backup and recovery strategy.
Ben Nevarez, MCDBA, OCP
"Hassan" <hassan@.hotmail.com> wrote in message
news:e7L7BAi%23FHA.504@.TK2MSFTNGP09.phx.gbl...
> Is there any link out there on the need to setup an environment ? I know
> its needed, just looking to find some official link
> Also how do you sync up production databases to these environments ? Do
> you do it daily ? backup and restore ?
>

link to SQL Server Express from Access 2000

i'm trying to set a data source in Access 2000 to link to SQL Server express..I have mixed mode set..what user/password do I put in? I tried sa, but get error server does not exist, or access denied..
thanks!

Did you make SQL Server available for remote connections ?

http://www.datamasker.com/SSE2005_NetworkCfg.htm

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Link to Server via Windows Authentication

Well, then everyone who used the linked server will be
using the new account created. I want people to only use
what thier domain account has permissions to do.
Any way to do this?
>--Original Message--
>You'll need to create a domain account that has login
>permissions to SQL Server "A" and the appropriate
database
>permissions as well. Use this account for the user login
>credentials when you create the link.
>Steve
>.
>You can use delegation to accomplish this. You can find
information on this in books online under the topic:
Security Account Delegation
-Sue
On Mon, 1 Mar 2004 06:57:34 -0800, "Linda"
<anonymous@.discussions.microsoft.com> wrote:
>Well, then everyone who used the linked server will be
>using the new account created. I want people to only use
>what thier domain account has permissions to do.
>Any way to do this?
>database

link to picture

Hello,
I have to add a picture to a report. The picture changes sometimes and for that I want to make something like a link or replace the picture is this possible?
Regards
HansjrgYes, if you're using Crystal XI
Look up images, dynamic in the help.

Otherwise I think the picture needs to be in the database.|||Thank you for your help. I use Crystal Reports 10 :-((

Regards
Hansjrgsql