LIMIT problems: March 2012

Friday, March 30, 2012

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

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

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

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

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.

HTH :)

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

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

Tell us what the error msg is.

--
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/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

Link to Oracle Server

Hello.
How can I connect to Oracle from MS SQL and read/write data into Oracle's
tables?
"David Dvali" <david_dvali@.hotmail.com> wrote in message
news:%23tdGh6%23MGHA.2300@.TK2MSFTNGP15.phx.gbl...
> Hello.
> How can I connect to Oracle from MS SQL and read/write data into Oracle's
> tables?
Configuring Linked Servers
http://msdn.microsoft.com/library/de...erver_4uuq.asp
How to set up and troubleshoot a linked server to an Oracle database in SQL
Server
http://support.microsoft.com/kb/280106
David

Link to Oracle Server

Hello.
How can I connect to Oracle from MS SQL and read/write data into Oracle's
tables?"David Dvali" <david_dvali@.hotmail.com> wrote in message
news:%23tdGh6%23MGHA.2300@.TK2MSFTNGP15.phx.gbl...
> Hello.
> How can I connect to Oracle from MS SQL and read/write data into Oracle's
> tables?
Configuring Linked Servers
http://msdn.microsoft.com/library/d...>
ver_4uuq.asp
How to set up and troubleshoot a linked server to an Oracle database in SQL
Server
http://support.microsoft.com/kb/280106
David

Link to Oracle Server

Hello.
How can I connect to Oracle from MS SQL and read/write data into Oracle's
tables?"David Dvali" <david_dvali@.hotmail.com> wrote in message
news:%23tdGh6%23MGHA.2300@.TK2MSFTNGP15.phx.gbl...
> Hello.
> How can I connect to Oracle from MS SQL and read/write data into Oracle's
> tables?
Configuring Linked Servers
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_4uuq.asp
How to set up and troubleshoot a linked server to an Oracle database in SQL
Server
http://support.microsoft.com/kb/280106
David

link to oracle error

Hi
I am connecting from SQL server 2000 to oracle 9i.
I used following command and entry in tnsnames.ora file.
I am unable to run 2 select queries parallely from SQL server to oracle.
It throws me this error message.
I am amble to insert, delete. select from one connection without any errors.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: Oracle error occurred, but error message
could not be retrieved from Oracle.]
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
returned 0x80004005: ].
Links created by
sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'
Presumptively, your Oracle server is e2.
1- We/I will need to see the tnsnames.ora entry- it is possible the
parameter should be 'e2.world' or similar and not just 'e2'
2- Is your %Oracle_Home% environmental variable set
3- is the Oracle Listener looking for the 'e2' as the service name on it's
server?
Joseph R.P. Maloney, CSP,CCP,CDP
"Mangesh Deshpande" wrote:

> Hi
> I am connecting from SQL server 2000 to oracle 9i.
> I used following command and entry in tnsnames.ora file.
> I am unable to run 2 select queries parallely from SQL server to oracle.
> It throws me this error message.
> I am amble to insert, delete. select from one connection without any errors.
> --
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' reported an error.
> [OLE/DB provider returned message: Oracle error occurred, but error message
> could not be retrieved from Oracle.]
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
> returned 0x80004005: ].
> --
> Links created by
> sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
> sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'
|||Hi,
Have you had a look in the Knowledge base?
http://support.microsoft.com/default...b;en-us;280106
http://support.microsoft.com/default...b;en-us;814398
Regards
"Mangesh Deshpande" wrote:

> Hi
> I am connecting from SQL server 2000 to oracle 9i.
> I used following command and entry in tnsnames.ora file.
> I am unable to run 2 select queries parallely from SQL server to oracle.
> It throws me this error message.
> I am amble to insert, delete. select from one connection without any errors.
> --
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' reported an error.
> [OLE/DB provider returned message: Oracle error occurred, but error message
> could not be retrieved from Oracle.]
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
> returned 0x80004005: ].
> --
> Links created by
> sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
> sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'
sql

link to oracle error

Hi
I am connecting from SQL server 2000 to oracle 9i.
I used following command and entry in tnsnames.ora file.
I am unable to run 2 select queries parallely from SQL server to oracle.
It throws me this error message.
I am amble to insert, delete. select from one connection without any errors.
--
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: Oracle error occurred, but error message
could not be retrieved from Oracle.]
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
returned 0x80004005: ].
--
Links created by
sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'Presumptively, your Oracle server is e2.
1- We/I will need to see the tnsnames.ora entry- it is possible the
parameter should be 'e2.world' or similar and not just 'e2'
2- Is your %Oracle_Home% environmental variable set
3- is the Oracle Listener looking for the 'e2' as the service name on it's
server?
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Mangesh Deshpande" wrote:
> Hi
> I am connecting from SQL server 2000 to oracle 9i.
> I used following command and entry in tnsnames.ora file.
> I am unable to run 2 select queries parallely from SQL server to oracle.
> It throws me this error message.
> I am amble to insert, delete. select from one connection without any errors.
> --
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' reported an error.
> [OLE/DB provider returned message: Oracle error occurred, but error message
> could not be retrieved from Oracle.]
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
> returned 0x80004005: ].
> --
> Links created by
> sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
> sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'|||Hi,
Have you had a look in the Knowledge base?
http://support.microsoft.com/default.aspx?scid=kb;en-us;280106
http://support.microsoft.com/default.aspx?scid=kb;en-us;814398
Regards
"Mangesh Deshpande" wrote:
> Hi
> I am connecting from SQL server 2000 to oracle 9i.
> I used following command and entry in tnsnames.ora file.
> I am unable to run 2 select queries parallely from SQL server to oracle.
> It throws me this error message.
> I am amble to insert, delete. select from one connection without any errors.
> --
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' reported an error.
> [OLE/DB provider returned message: Oracle error occurred, but error message
> could not be retrieved from Oracle.]
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
> returned 0x80004005: ].
> --
> Links created by
> sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
> sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'

link to oracle error

Hi
I am connecting from SQL server 2000 to oracle 9i.
I used following command and entry in tnsnames.ora file.
I am unable to run 2 select queries parallely from SQL server to oracle.
It throws me this error message.
I am amble to insert, delete. select from one connection without any errors.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: Oracle error occurred, but error mess
age
could not be retrieved from Oracle.]
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
returned 0x80004005: ].
--
Links created by
sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'Presumptively, your Oracle server is e2.
1- We/I will need to see the tnsnames.ora entry- it is possible the
parameter should be 'e2.world' or similar and not just 'e2'
2- Is your %Oracle_Home% environmental variable set
3- is the Oracle Listener looking for the 'e2' as the service name on it's
server?
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Mangesh Deshpande" wrote:

> Hi
> I am connecting from SQL server 2000 to oracle 9i.
> I used following command and entry in tnsnames.ora file.
> I am unable to run 2 select queries parallely from SQL server to oracle.
> It throws me this error message.
> I am amble to insert, delete. select from one connection without any error
s.
> --
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' reported an error.
> [OLE/DB provider returned message: Oracle error occurred, but error me
ssage
> could not be retrieved from Oracle.]
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initializ
e
> returned 0x80004005: ].
> --
> Links created by
> sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
> sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'|||Hi,
Have you had a look in the Knowledge base?
http://support.microsoft.com/defaul...kb;en-us;280106
http://support.microsoft.com/defaul...kb;en-us;814398
Regards
"Mangesh Deshpande" wrote:

> Hi
> I am connecting from SQL server 2000 to oracle 9i.
> I used following command and entry in tnsnames.ora file.
> I am unable to run 2 select queries parallely from SQL server to oracle.
> It throws me this error message.
> I am amble to insert, delete. select from one connection without any error
s.
> --
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' reported an error.
> [OLE/DB provider returned message: Oracle error occurred, but error me
ssage
> could not be retrieved from Oracle.]
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initializ
e
> returned 0x80004005: ].
> --
> Links created by
> sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
> sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'

Link to Oracle database

Hi all,
I have installed Oracle client tool on the SQL server and have checked the tns file. Everythings look fine, even from the server I can run SQL Plus and connect to the Oracle database. When I create a link and try to refresh tables under linked serve, I ge
t this error: Error 7399:OLE DB provider 'MSDAORA' reported an error. I reinstalled MDAC 2.8, but I get the same error.
Any help would be appreciated.
Shahri
That's a generic error. Try turning on trace flag 7300 or
us SQL Profiler to capture the OLEDB Errors event. This
should give you to get more information about the error.
Additionally, you'll want to check the following article:
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in
SQL Server
http://support.microsoft.com/?id=280106
-Sue
On Wed, 16 Jun 2004 08:43:37 -0700, Shahri
<Shahri@.discussions.microsoft.com> wrote:

>Hi all,
>I have installed Oracle client tool on the SQL server and have checked the tns file. Everythings look fine, even from the server I can run SQL Plus and connect to the Oracle database. When I create a link and try to refresh tables under linked serve, I g
et this error: Error 7399:OLE DB provider 'MSDAORA' reported an error. I reinstalled MDAC 2.8, but I get the same error.
>Any help would be appreciated.
>Shahri

Link to Oracle database

Hi all,
I have installed Oracle client tool on the SQL server and have checked the t
ns file. Everythings look fine, even from the server I can run SQL Plus and
connect to the Oracle database. When I create a link and try to refresh tabl
es under linked serve, I ge
t this error: Error 7399:OLE DB provider 'MSDAORA' reported an error. I rein
stalled MDAC 2.8, but I get the same error.
Any help would be appreciated.
ShahriThat's a generic error. Try turning on trace flag 7300 or
us SQL Profiler to capture the OLEDB Errors event. This
should give you to get more information about the error.
Additionally, you'll want to check the following article:
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in
SQL Server
http://support.microsoft.com/?id=280106
-Sue
On Wed, 16 Jun 2004 08:43:37 -0700, Shahri
<Shahri@.discussions.microsoft.com> wrote:

>Hi all,
>I have installed Oracle client tool on the SQL server and have checked the tns file
. Everythings look fine, even from the server I can run SQL Plus and connect to the
Oracle database. When I create a link and try to refresh tables under linked serve,
I g
et this error: Error 7399:OLE DB provider 'MSDAORA' reported an error. I reinstalled MDAC 2.
8, but I get the same error.
>Any help would be appreciated.
>Shahri

Link to Oracle 9.2.0

Hello!
Please, help me to link MS SQL Server 2000 Ent. edition sp3a to Oracle
9.2.0.
Thank you in advance.
IgorHi
If you are requiring to use the oracle database as a linked server then
check out sp_addlinkedserver in books online:
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\tsq
lref.chm::/ts_sp_adda_8gqa.htm
This may also help regarding what the equivalences are:
http://www.microsoft.com/technet/tr...part2/c0761.asp
http://vyaskn.tripod.com/ oracle_sq...ent
s.htm
John
"Igor" <vorgi@.hotmail.com> wrote in message
news:OAr9rqT$DHA.4060@.TK2MSFTNGP10.phx.gbl...
> Hello!
> Please, help me to link MS SQL Server 2000 Ent. edition sp3a to Oracle
> 9.2.0.
>
> Thank you in advance.
>
> Igor
>|||Please, give me an example...
Oracle Server Name: Server1.domain1.com
Oracle DB Name: TestDB1
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:nwI%b.3570$lB2.31267975@.news-text.cableinet.net...
> Hi
> If you are requiring to use the oracle database as a linked server then
> check out sp_addlinkedserver in books online:
>
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\tsq[col
or=darkred]
> lref.chm::/ts_sp_adda_8gqa.htm
> This may also help regarding what the equivalences are:
>[/color]
http://www.microsoft.com/technet/tr...part2/c0761.asp
> http://vyaskn.tripod.com/ oracle_sq...ent
s.htm
> John
> "Igor" <vorgi@.hotmail.com> wrote in message
> news:OAr9rqT$DHA.4060@.TK2MSFTNGP10.phx.gbl...
>|||There is an example in books online under the sp_addlinkeserver subject, you
will need the SQL*Net alias.
John
"Igor" <vorgi@.hotmail.com> wrote in message
news:%2351dKXU$DHA.2804@.tk2msftngp13.phx.gbl...
> Please, give me an example...
> Oracle Server Name: Server1.domain1.com
> Oracle DB Name: TestDB1
>
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:nwI%b.3570$lB2.31267975@.news-text.cableinet.net...
>
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\tsq[col
or=darkred]
>[/color]
http://www.microsoft.com/technet/tr...part2/c0761.asp
>|||Very good. What's the SQL*Net alias? Give me an example, please...
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:eRM%b.3784$DY4.33338563@.news-text.cableinet.net...
> There is an example in books online under the sp_addlinkeserver subject,
you
> will need the SQL*Net alias.
> John
> "Igor" <vorgi@.hotmail.com> wrote in message
> news:%2351dKXU$DHA.2804@.tk2msftngp13.phx.gbl...
then
>
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\tsq[col
or=darkred]
>
http://www.microsoft.com/technet/tr...part2/c0761.asp
Oracle
>|||Hi
The SQL*Net alias is whatever you set the alias to be when configuring
SQL*Net!! It will appear in the SQL*Net configuration file or you can
use the Network Configuration Utitity to view/set it.
John
"Igor" <vorgi@.hotmail.com> wrote in message news:<#a6wWj1$DHA.2072@.TK2MSFTNGP11.phx.gbl>...
> Very good. What's the SQL*Net alias? Give me an example, please...
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:eRM%b.3784$DY4.33338563@.news-text.cableinet.net...
> you
> then
> mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\
tsq
> http://www.microsoft.com/technet/tr...part2/c0761.asp
> Oracle|||Thanks to all!
The problem was that the Oracle TNS Service was not configured properly. So,
admin of Oracle works now...
Good luck!
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:3b81e6a.0403010515.25844e1b@.posting.google.com...
> Hi
> The SQL*Net alias is whatever you set the alias to be when configuring
> SQL*Net!! It will appear in the SQL*Net configuration file or you can
> use the Network Configuration Utitity to view/set it.
> John
> "Igor" <vorgi@.hotmail.com> wrote in message
news:<#a6wWj1$DHA.2072@.TK2MSFTNGP11.phx.gbl>...
subject,
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\tsq[col
or=darkred]
http://www.microsoft.com/technet/tr...part2/c0761.asp
http://vyaskn.tripod.com/ oracle_sq...ent
s.htmsql

Link to Oracel database

Hi all
I am running SQL Server 2000 Enterprise Edition and I want to create a link server to an oracle database. I have installed Oracle client on the server, but when try to test the connection using Oracle Net Configuration Assistant, I'm getting error: "TNS:listener could not resolve SERVICE_NAME given in connect description"
I have read article 280106 (troubleshooting) that didn't help
I appreciate any guidance
RayThe Net Assistant doesn't always generate correct
tnsnames.ora and listener.ora files. You most likely have
something missing in one of these files.
Make sure the Oracle home is specified correctly and that
you have a SID_LIST_LISTENER entry which specifies the sid
that the listener is listening for.
-Sue
On Wed, 9 Jun 2004 12:46:10 -0700, Ray
<anonymous@.discussions.microsoft.com> wrote:
>Hi all,
>I am running SQL Server 2000 Enterprise Edition and I want to create a link server to an oracle database. I have installed Oracle client on the server, but when try to test the connection using Oracle Net Configuration Assistant, I'm getting error: "TNS:listener could not resolve SERVICE_NAME given in connect description".
>I have read article 280106 (troubleshooting) that didn't help.
>I appreciate any guidance.
>Ray

Link to Oracel database

Hi all,
I am running SQL Server 2000 Enterprise Edition and I want to create a link server to an oracle database. I have installed Oracle client on the server, but when try to test the connection using Oracle Net Configuration Assistant, I'm getting error: "TNS:l
istener could not resolve SERVICE_NAME given in connect description".
I have read article 280106 (troubleshooting) that didn't help.
I appreciate any guidance.
Ray
The Net Assistant doesn't always generate correct
tnsnames.ora and listener.ora files. You most likely have
something missing in one of these files.
Make sure the Oracle home is specified correctly and that
you have a SID_LIST_LISTENER entry which specifies the sid
that the listener is listening for.
-Sue
On Wed, 9 Jun 2004 12:46:10 -0700, Ray
<anonymous@.discussions.microsoft.com> wrote:

>Hi all,
>I am running SQL Server 2000 Enterprise Edition and I want to create a link server to an oracle database. I have installed Oracle client on the server, but when try to test the connection using Oracle Net Configuration Assistant, I'm getting error: "TNS:
listener could not resolve SERVICE_NAME given in connect description".
>I have read article 280106 (troubleshooting) that didn't help.
>I appreciate any guidance.
>Ray

Link to Oracel database

Hi all,
I am running SQL Server 2000 Enterprise Edition and I want to create a link
server to an oracle database. I have installed Oracle client on the server,
but when try to test the connection using Oracle Net Configuration Assistant
, I'm getting error: "TNS:l
istener could not resolve SERVICE_NAME given in connect description".
I have read article 280106 (troubleshooting) that didn't help.
I appreciate any guidance.
RayThe Net Assistant doesn't always generate correct
tnsnames.ora and listener.ora files. You most likely have
something missing in one of these files.
Make sure the Oracle home is specified correctly and that
you have a SID_LIST_LISTENER entry which specifies the sid
that the listener is listening for.
-Sue
On Wed, 9 Jun 2004 12:46:10 -0700, Ray
<anonymous@.discussions.microsoft.com> wrote:

>Hi all,
>I am running SQL Server 2000 Enterprise Edition and I want to create a link server
to an oracle database. I have installed Oracle client on the server, but when try to
test the connection using Oracle Net Configuration Assistant, I'm getting error: "T
NS:
listener could not resolve SERVICE_NAME given in connect description".
>I have read article 280106 (troubleshooting) that didn't help.
>I appreciate any guidance.
>Ray

link to mysql

I tired to create a link 'MYSQL' in a SQL Server using the following code :

EXEC sp_addlinkedserver
@.server = mysql,
@.provider = 'MSDASQL',
@.provstr = 'DRIVER={MySQL ODBC 3.51 Driver};SERVER=MySQLServer;UID=root;PWD=;'

NB: I have a DB by the name of : MYSQL

There is no errors during creation ...

The link creation is OK but I am not able to see tables from SQL Server

Any Idea ?Linked server login mappings can be added using sp_addlinkedsrvlogin and refer to books online for more information.|||No it ok for the link creation but we have the following error :

Msg 7314, Niveau 16, tat 1, Ligne 1

when execution :

select * from mysql...host

any idea ?|||When setting up the linked server you need to map your local login to appropirate remote/destination server's login.|||The mapping is OK ? really, I don't inerstant the pb ?
Did you try to to this with a MYSQL DB ?|||You shoudl use OPENQUERY method to access the data.

However, the openquery() method ALWAYS worked while the suggested method of SERVER.CATALOG.OWNER.TABLE will have some issues.

Ensure you've MyODBC installed properly on SQL server.
I don't have any issues in using MySQL as LS.|||Could you please give us an example (with MySQL Server)

Could you tell us what is :

SERVER under MySQL
CATALOG under MySQL
OWNER under MySQL

Could you give us a query example with a table from the default Mysql DB.

Indeed, I successed to have a resultat when using OPENQUERY :

But it doesn't work every time (it depends of the row nb in the table I think).

So it is OK for :

SELECT * FROM OPENQUERY (mysql,'SELECT * FROM db where 1=2')

But not for :

SELECT * FROM OPENQUERY (mysql,'SELECT * FROM db)

Error : Msg 7347

Help !!!!!!!

Link to good on-line documentation

I stumble upon the Microsoft Jet SQL Reference on line, but I'm wondering if anybody know of a really good on-line reference.

TIA,
BartonIf you use SQL Query Analyzer go to Help - Transact-SQL Help

It has everything you need to knwo.

Good Luck.|||

Quote:

Originally Posted by iburyak

If you use SQL Query Analyzer go to Help - Transact-SQL Help

It has everything you need to knwo.

Good Luck.

Yes, Transact-SQL Reference looks very useful. Thanks, again.|||If you need anything, let me know.
I am pretty experienced. Have more then 10 years in Sybase, MSSQL.

Good Luck.sql

Link to Exchange

I have a SQL 2000 server I want to link to an Exchange Server. Can I used
linked servers to access the Exchange database? I do not want to have to
import my email addresses into a SQL table for updates.
Thank you,
JLFleming
You can use SQL queries via ADSI to query the AD to get the Exchange
information. This will take additional programming and there is nothing out
of the box that I know of that will facilitate this. If you don't need RT
access to it, you could build that into a nightly job.
Ryan Hanisco
MCSE, MCDBA
Flagship Integration Services
"JLFleming" <JLFleming@.discussions.microsoft.com> wrote in message
news:43FDE5A4-EF8C-4923-B6D6-BC07D25774F7@.microsoft.com...
> I have a SQL 2000 server I want to link to an Exchange Server. Can I used
> linked servers to access the Exchange database? I do not want to have to
> import my email addresses into a SQL table for updates.
> Thank you,
> JLFleming
|||I'm trying to link to Exchange as well. But I'm having difficult query the AD
after I created the link server. When I run the following query in Query
Analyzer from the SQL Server, I received the following error:
Either queries:
select * from openquery (ADSI, 'Select name, adsPath FROM
''LDAP://DC=HQMAIL1, DC=com''
WHERE objectCategory =''Person'' AND objectClass= ''user''')
SELECT * FROM Openquery(ADSI, 'SELECT givenName FROM
''LDAP://192.168.90.13/OU=AE,DC=HomeQuest,DC=Internal,DC=com'' WHERE
objectCategory
= ''person'' AND objectClass = ''user''')
Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB
provider 'ADSDSOObject'.
When I try to access the Linked Server from EM, I received this error:
Error 7301: Could not obtain a required interface from OLE DB provider
'ADSDSOObject'
Not sure what to do, any ideas?
"Ryan Hanisco" wrote:

> You can use SQL queries via ADSI to query the AD to get the Exchange
> information. This will take additional programming and there is nothing out
> of the box that I know of that will facilitate this. If you don't need RT
> access to it, you could build that into a nightly job.
> --
> Ryan Hanisco
> MCSE, MCDBA
> Flagship Integration Services
> "JLFleming" <JLFleming@.discussions.microsoft.com> wrote in message
> news:43FDE5A4-EF8C-4923-B6D6-BC07D25774F7@.microsoft.com...
>
>

Link to Exchange

I have a SQL 2000 server I want to link to an Exchange Server. Can I used
linked servers to access the Exchange database? I do not want to have to
import my email addresses into a SQL table for updates.
Thank you,
JLFlemingYou can use SQL queries via ADSI to query the AD to get the Exchange
information. This will take additional programming and there is nothing out
of the box that I know of that will facilitate this. If you don't need RT
access to it, you could build that into a nightly job.
Ryan Hanisco
MCSE, MCDBA
Flagship Integration Services
"JLFleming" <JLFleming@.discussions.microsoft.com> wrote in message
news:43FDE5A4-EF8C-4923-B6D6-BC07D25774F7@.microsoft.com...
> I have a SQL 2000 server I want to link to an Exchange Server. Can I used
> linked servers to access the Exchange database? I do not want to have to
> import my email addresses into a SQL table for updates.
> Thank you,
> JLFleming|||I'm trying to link to Exchange as well. But I'm having difficult query the A
D
after I created the link server. When I run the following query in Query
Analyzer from the SQL Server, I received the following error:
Either queries:
select * from openquery (ADSI, 'Select name, adsPath FROM
''LDAP://DC=HQMAIL1, DC=com''
WHERE objectCategory =''Person'' AND objectClass= ''user''')
SELECT * FROM Openquery(ADSI, 'SELECT givenName FROM
''LDAP://192.168.90.13/OU=AE,DC=HomeQuest,DC=Internal,DC=com'' WHERE
objectCategory
= ''person'' AND objectClass = ''user''')
Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB
provider 'ADSDSOObject'.
When I try to access the Linked Server from EM, I received this error:
Error 7301: Could not obtain a required interface from OLE DB provider
'ADSDSOObject'
Not sure what to do, any ideas?
"Ryan Hanisco" wrote:

> You can use SQL queries via ADSI to query the AD to get the Exchange
> information. This will take additional programming and there is nothing o
ut
> of the box that I know of that will facilitate this. If you don't need RT
> access to it, you could build that into a nightly job.
> --
> Ryan Hanisco
> MCSE, MCDBA
> Flagship Integration Services
> "JLFleming" <JLFleming@.discussions.microsoft.com> wrote in message
> news:43FDE5A4-EF8C-4923-B6D6-BC07D25774F7@.microsoft.com...
>
>

Link to Exchange

I have a SQL 2000 server I want to link to an Exchange Server. Can I used
linked servers to access the Exchange database? I do not want to have to
import my email addresses into a SQL table for updates.
Thank you,
JLFlemingYou can use SQL queries via ADSI to query the AD to get the Exchange
information. This will take additional programming and there is nothing out
of the box that I know of that will facilitate this. If you don't need RT
access to it, you could build that into a nightly job.
--
Ryan Hanisco
MCSE, MCDBA
Flagship Integration Services
"JLFleming" <JLFleming@.discussions.microsoft.com> wrote in message
news:43FDE5A4-EF8C-4923-B6D6-BC07D25774F7@.microsoft.com...
> I have a SQL 2000 server I want to link to an Exchange Server. Can I used
> linked servers to access the Exchange database? I do not want to have to
> import my email addresses into a SQL table for updates.
> Thank you,
> JLFleming|||I'm trying to link to Exchange as well. But I'm having difficult query the AD
after I created the link server. When I run the following query in Query
Analyzer from the SQL Server, I received the following error:
Either queries:
select * from openquery (ADSI, 'Select name, adsPath FROM
''LDAP://DC=HQMAIL1, DC=com''
WHERE objectCategory =''Person'' AND objectClass= ''user''')
SELECT * FROM Openquery(ADSI, 'SELECT givenName FROM
''LDAP://192.168.90.13/OU=AE,DC=HomeQuest,DC=Internal,DC=com'' WHERE
objectCategory
= ''person'' AND objectClass = ''user''')
Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB
provider 'ADSDSOObject'.
When I try to access the Linked Server from EM, I received this error:
Error 7301: Could not obtain a required interface from OLE DB provider
'ADSDSOObject'
Not sure what to do, any ideas?
"Ryan Hanisco" wrote:
> You can use SQL queries via ADSI to query the AD to get the Exchange
> information. This will take additional programming and there is nothing out
> of the box that I know of that will facilitate this. If you don't need RT
> access to it, you could build that into a nightly job.
> --
> Ryan Hanisco
> MCSE, MCDBA
> Flagship Integration Services
> "JLFleming" <JLFleming@.discussions.microsoft.com> wrote in message
> news:43FDE5A4-EF8C-4923-B6D6-BC07D25774F7@.microsoft.com...
> > I have a SQL 2000 server I want to link to an Exchange Server. Can I used
> > linked servers to access the Exchange database? I do not want to have to
> > import my email addresses into a SQL table for updates.
> >
> > Thank you,
> > JLFleming
>
>

Friday, March 30, 2012

Blog Archive

About Me