Hi,
I am working on exporting data from a remote MSSQL db using la inked server.
Both SQL server 2000.
So far I have a SELECT against a linked server with a hard coded value in
the WHERE clause and it works fine:
SELECT * FROM OPENQUERY(SERVER_NAME,'SELECT id,[date] FROM
DB_NAME.dbo.TABLE_NAME WHERE id= 111204892204688')
I try to put this exact query into a variable and run it:
declare @.tsql varchar(8000)
SELECT @.tsql='SELECT * FROM OPENQUERY(SERVER_NAME,''SELECT id,[date]FROM
DB_NAME.dbo.TABLE_NAME WHERE id= 111204892204688'')'
EXEC @.tsql
I get an error:
The name 'SELECT * FROM OPENQUERY(SERVER_NAME,'SELECT id,[date]FROM
DB_NAME.dbo.TABLE_NAME WHERE id= 111204892204688')' is not a valid identifie
r.
The query specified in the error runs just fine on its own (see my first
step).
I searched the web and tech groups for answers but can't find any
information on this error. Please help.
Thank you, A"Alexis" <Alexis@.discussions.microsoft.com> wrote in message
news:539D21E3-6961-49BD-9892-279744A3A5C9@.microsoft.com...
> EXEC @.tsql
Add some parens:
EXEC (@.tsql)
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--|||Can you try using:
...
exec (@.tsql)
AMB
"Alexis" wrote:
> Hi,
> I am working on exporting data from a remote MSSQL db using la inked serve
r.
> Both SQL server 2000.
> So far I have a SELECT against a linked server with a hard coded value in
> the WHERE clause and it works fine:
> SELECT * FROM OPENQUERY(SERVER_NAME,'SELECT id,[date] FROM
> DB_NAME.dbo.TABLE_NAME WHERE id= 111204892204688')
> I try to put this exact query into a variable and run it:
> declare @.tsql varchar(8000)
> SELECT @.tsql='SELECT * FROM OPENQUERY(SERVER_NAME,''SELECT id,[date]FROM
> DB_NAME.dbo.TABLE_NAME WHERE id= 111204892204688'')'
> EXEC @.tsql
> I get an error:
> The name 'SELECT * FROM OPENQUERY(SERVER_NAME,'SELECT id,[date]FROM
> DB_NAME.dbo.TABLE_NAME WHERE id= 111204892204688')' is not a valid identif
ier.
> The query specified in the error runs just fine on its own (see my first
> step).
> I searched the web and tech groups for answers but can't find any
> information on this error. Please help.
> Thank you, A
>
Showing posts with label mssql. Show all posts
Showing posts with label mssql. Show all posts
Monday, March 26, 2012
Monday, March 19, 2012
Linked Server Error
We had to reinstall MSSQL on one of our servers now when I set up a linked
server and try to associate a login I get the following error:
Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
An error occurred during decryption.
Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
There is no remote user 'sa' mapped to local user '(null)' from the remote
server 'TEST'.
Is there a fix for this it works from another server with the same edition
and configuration.I figured it out:
ALTER SERVICE MASTER KEY FORCE REGENERATE
"davids@.thorntonsinc.com" wrote:
> We had to reinstall MSSQL on one of our servers now when I set up a linked
> server and try to associate a login I get the following error:
> Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
> An error occurred during decryption.
> Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
> There is no remote user 'sa' mapped to local user '(null)' from the remote
> server 'TEST'.
> Is there a fix for this it works from another server with the same edition
> and configuration.
server and try to associate a login I get the following error:
Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
An error occurred during decryption.
Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
There is no remote user 'sa' mapped to local user '(null)' from the remote
server 'TEST'.
Is there a fix for this it works from another server with the same edition
and configuration.I figured it out:
ALTER SERVICE MASTER KEY FORCE REGENERATE
"davids@.thorntonsinc.com" wrote:
> We had to reinstall MSSQL on one of our servers now when I set up a linked
> server and try to associate a login I get the following error:
> Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
> An error occurred during decryption.
> Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
> There is no remote user 'sa' mapped to local user '(null)' from the remote
> server 'TEST'.
> Is there a fix for this it works from another server with the same edition
> and configuration.
Monday, March 12, 2012
Linked Server Error
We had to reinstall MSSQL on one of our servers now when I set up a linked
server and try to associate a login I get the following error:
Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
An error occurred during decryption.
Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
There is no remote user 'sa' mapped to local user '(null)' from the remote
server 'TEST'.
Is there a fix for this it works from another server with the same edition
and configuration.
I figured it out:
ALTER SERVICE MASTER KEY FORCE REGENERATE
"davids@.thorntonsinc.com" wrote:
> We had to reinstall MSSQL on one of our servers now when I set up a linked
> server and try to associate a login I get the following error:
> Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
> An error occurred during decryption.
> Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
> There is no remote user 'sa' mapped to local user '(null)' from the remote
> server 'TEST'.
> Is there a fix for this it works from another server with the same edition
> and configuration.
server and try to associate a login I get the following error:
Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
An error occurred during decryption.
Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
There is no remote user 'sa' mapped to local user '(null)' from the remote
server 'TEST'.
Is there a fix for this it works from another server with the same edition
and configuration.
I figured it out:
ALTER SERVICE MASTER KEY FORCE REGENERATE
"davids@.thorntonsinc.com" wrote:
> We had to reinstall MSSQL on one of our servers now when I set up a linked
> server and try to associate a login I get the following error:
> Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
> An error occurred during decryption.
> Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
> There is no remote user 'sa' mapped to local user '(null)' from the remote
> server 'TEST'.
> Is there a fix for this it works from another server with the same edition
> and configuration.
Linked Server Error
We had to reinstall MSSQL on one of our servers now when I set up a linked
server and try to associate a login I get the following error:
Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
An error occurred during decryption.
Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
There is no remote user 'sa' mapped to local user '(null)' from the remote
server 'TEST'.
Is there a fix for this it works from another server with the same edition
and configuration.I figured it out:
ALTER SERVICE MASTER KEY FORCE REGENERATE
"davids@.thorntonsinc.com" wrote:
> We had to reinstall MSSQL on one of our servers now when I set up a linked
> server and try to associate a login I get the following error:
> Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
> An error occurred during decryption.
> Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
> There is no remote user 'sa' mapped to local user '(null)' from the remote
> server 'TEST'.
> Is there a fix for this it works from another server with the same edition
> and configuration.
server and try to associate a login I get the following error:
Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
An error occurred during decryption.
Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
There is no remote user 'sa' mapped to local user '(null)' from the remote
server 'TEST'.
Is there a fix for this it works from another server with the same edition
and configuration.I figured it out:
ALTER SERVICE MASTER KEY FORCE REGENERATE
"davids@.thorntonsinc.com" wrote:
> We had to reinstall MSSQL on one of our servers now when I set up a linked
> server and try to associate a login I get the following error:
> Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
> An error occurred during decryption.
> Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
> There is no remote user 'sa' mapped to local user '(null)' from the remote
> server 'TEST'.
> Is there a fix for this it works from another server with the same edition
> and configuration.
Friday, March 9, 2012
Linked Server and Distributed Transactions
We have a developer that is trying to do a distributed
transaction using a View that in turn uses a Linked
Server.
The Linked server is the MSSQL 2000 server, so both
databases reside on the same server.
She is receiving the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB
provider returned message: New transaction cannot enlist
in the specified transaction coordinator.]
Has anyone see this error? Is it an Option in the OLE
DB Provider or a Linked Server Option that is the problem?
I am able to do distributed transactions inside a MSSQL
Trigger that goes out to an Oracle DB and inserts data,
without an error. So, I am not sure why MSSQL cannot
use a Linked Server for a "local" database connection?
Any help is much appreciated,
MarkHi Mark,
"Mark" <anonymous@.discussions.microsoft.com> schrieb im Newsbeitrag
news:016401c3c668$e315c8e0$a401280a@.phx.gbl...
> We have a developer that is trying to do a distributed
> transaction using a View that in turn uses a Linked
> Server.
> The Linked server is the MSSQL 2000 server, so both
> databases reside on the same server.
> She is receiving the following error:
> [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB
> provider returned message: New transaction cannot enlist
> in the specified transaction coordinator.]
> Has anyone see this error? Is it an Option in the OLE
> DB Provider or a Linked Server Option that is the problem?
> I am able to do distributed transactions inside a MSSQL
> Trigger that goes out to an Oracle DB and inserts data,
> without an error. So, I am not sure why MSSQL cannot
> use a Linked Server for a "local" database connection?
> Any help is much appreciated,
> Mark
>
Seems to be a Loopback-Situation.
See http://support.microsoft.com/?kbid=306212 and follow the Link "Loopback
Linked Servers"...
Patrick
transaction using a View that in turn uses a Linked
Server.
The Linked server is the MSSQL 2000 server, so both
databases reside on the same server.
She is receiving the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB
provider returned message: New transaction cannot enlist
in the specified transaction coordinator.]
Has anyone see this error? Is it an Option in the OLE
DB Provider or a Linked Server Option that is the problem?
I am able to do distributed transactions inside a MSSQL
Trigger that goes out to an Oracle DB and inserts data,
without an error. So, I am not sure why MSSQL cannot
use a Linked Server for a "local" database connection?
Any help is much appreciated,
MarkHi Mark,
"Mark" <anonymous@.discussions.microsoft.com> schrieb im Newsbeitrag
news:016401c3c668$e315c8e0$a401280a@.phx.gbl...
> We have a developer that is trying to do a distributed
> transaction using a View that in turn uses a Linked
> Server.
> The Linked server is the MSSQL 2000 server, so both
> databases reside on the same server.
> She is receiving the following error:
> [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB
> provider returned message: New transaction cannot enlist
> in the specified transaction coordinator.]
> Has anyone see this error? Is it an Option in the OLE
> DB Provider or a Linked Server Option that is the problem?
> I am able to do distributed transactions inside a MSSQL
> Trigger that goes out to an Oracle DB and inserts data,
> without an error. So, I am not sure why MSSQL cannot
> use a Linked Server for a "local" database connection?
> Any help is much appreciated,
> Mark
>
Seems to be a Loopback-Situation.
See http://support.microsoft.com/?kbid=306212 and follow the Link "Loopback
Linked Servers"...
Patrick
Monday, February 20, 2012
Linked server
I'm trying to connect to a DB2/400 v4r creating a linked server on the
Enterprise Manager of my MSSQL 2000 box, but i receive the following message
when i try to expand the TABLES node on the tree:
Error 7302: Could not create an instance of OLE DB Provide 'IBMDA400'.
OLE DB error trace [non-interface error: CoCreate of DSO for IBMDA400
returned 0x80040154]
The version of CA400 installed on the MSSQL box is V4R5M0.
ThanksGenerally the error is caused by the provider not being
registered on the machine or from not having the in process
option set for the provider.
For the provider options, if you go to the linked server in
enterprise manager, view the properties and select Provider
Options. Then make sure the Allow InProcess option is
selected.
-Sue
On Mon, 15 Mar 2004 10:55:36 GMT, "Fabio Benedini"
<f.benedini@.magconsulting.it> wrote:
>I'm trying to connect to a DB2/400 v4r creating a linked server on the
>Enterprise Manager of my MSSQL 2000 box, but i receive the following messag
e
>when i try to expand the TABLES node on the tree:
>
>Error 7302: Could not create an instance of OLE DB Provide 'IBMDA400'.
>OLE DB error trace [non-interface error: CoCreate of DSO for IBMDA400
>returned 0x80040154]
>The version of CA400 installed on the MSSQL box is V4R5M0.
>Thanks
>|||Thank you Sue,
I've applied your tip and now I don't get that message, but now when I try
to expand the Tables node, my Enterprise Manager seems to hang. I tried to
wait for over 20 mins but i had to close it from the Task Manager.
Could you give me an example of a working configuration of a linked server
to DB2/400?
Thanks
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:l8eb50dfufaqvf68ugecj8aagokm5pop0h@.
4ax.com...
> Generally the error is caused by the provider not being
> registered on the machine or from not having the in process
> option set for the provider.
> For the provider options, if you go to the linked server in
> enterprise manager, view the properties and select Provider
> Options. Then make sure the Allow InProcess option is
> selected.
> -Sue
> On Mon, 15 Mar 2004 10:55:36 GMT, "Fabio Benedini"
> <f.benedini@.magconsulting.it> wrote:
>
message
>|||If you install Client Access on the server, it will install
and configure the drivers and providers for the AS400 on the
SQL Server box so that you can use linked servers. You
should also make sure you have the client updated with what
whatever service pack level based on updates to the AS400.
There is a link to update this in the Client Access program
group - I think that's where it is, can't remember off the
top of my head. For data source, use the IP address of the
AS400. For provider string, you need to include the library
you are using, connect timeout setting and code page. There
is some documentation for the settings in the Client Access
help files. You'd set the provider string somewhat like:
InitCat=YourLibrary;CCSID=37;PCCodePage=
1252;
Data Source=xxx.xxx.xxx.xxx
Settings will depend on how your AS400 is configured. Again,
the Client Access help files have information on the
necessary connection string settings.
-Sue
On Mon, 15 Mar 2004 15:22:36 GMT, "Fabio Benedini"
<f.benedini@.magconsulting.it> wrote:
>Thank you Sue,
>I've applied your tip and now I don't get that message, but now when I try
>to expand the Tables node, my Enterprise Manager seems to hang. I tried to
>wait for over 20 mins but i had to close it from the Task Manager.
>Could you give me an example of a working configuration of a linked server
>to DB2/400?
>Thanks
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:l8eb50dfufaqvf68ugecj8aagokm5pop0h@.
4ax.com...
>message
>
Enterprise Manager of my MSSQL 2000 box, but i receive the following message
when i try to expand the TABLES node on the tree:
Error 7302: Could not create an instance of OLE DB Provide 'IBMDA400'.
OLE DB error trace [non-interface error: CoCreate of DSO for IBMDA400
returned 0x80040154]
The version of CA400 installed on the MSSQL box is V4R5M0.
ThanksGenerally the error is caused by the provider not being
registered on the machine or from not having the in process
option set for the provider.
For the provider options, if you go to the linked server in
enterprise manager, view the properties and select Provider
Options. Then make sure the Allow InProcess option is
selected.
-Sue
On Mon, 15 Mar 2004 10:55:36 GMT, "Fabio Benedini"
<f.benedini@.magconsulting.it> wrote:
>I'm trying to connect to a DB2/400 v4r creating a linked server on the
>Enterprise Manager of my MSSQL 2000 box, but i receive the following messag
e
>when i try to expand the TABLES node on the tree:
>
>Error 7302: Could not create an instance of OLE DB Provide 'IBMDA400'.
>OLE DB error trace [non-interface error: CoCreate of DSO for IBMDA400
>returned 0x80040154]
>The version of CA400 installed on the MSSQL box is V4R5M0.
>Thanks
>|||Thank you Sue,
I've applied your tip and now I don't get that message, but now when I try
to expand the Tables node, my Enterprise Manager seems to hang. I tried to
wait for over 20 mins but i had to close it from the Task Manager.
Could you give me an example of a working configuration of a linked server
to DB2/400?
Thanks
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:l8eb50dfufaqvf68ugecj8aagokm5pop0h@.
4ax.com...
> Generally the error is caused by the provider not being
> registered on the machine or from not having the in process
> option set for the provider.
> For the provider options, if you go to the linked server in
> enterprise manager, view the properties and select Provider
> Options. Then make sure the Allow InProcess option is
> selected.
> -Sue
> On Mon, 15 Mar 2004 10:55:36 GMT, "Fabio Benedini"
> <f.benedini@.magconsulting.it> wrote:
>
message
>|||If you install Client Access on the server, it will install
and configure the drivers and providers for the AS400 on the
SQL Server box so that you can use linked servers. You
should also make sure you have the client updated with what
whatever service pack level based on updates to the AS400.
There is a link to update this in the Client Access program
group - I think that's where it is, can't remember off the
top of my head. For data source, use the IP address of the
AS400. For provider string, you need to include the library
you are using, connect timeout setting and code page. There
is some documentation for the settings in the Client Access
help files. You'd set the provider string somewhat like:
InitCat=YourLibrary;CCSID=37;PCCodePage=
1252;
Data Source=xxx.xxx.xxx.xxx
Settings will depend on how your AS400 is configured. Again,
the Client Access help files have information on the
necessary connection string settings.
-Sue
On Mon, 15 Mar 2004 15:22:36 GMT, "Fabio Benedini"
<f.benedini@.magconsulting.it> wrote:
>Thank you Sue,
>I've applied your tip and now I don't get that message, but now when I try
>to expand the Tables node, my Enterprise Manager seems to hang. I tried to
>wait for over 20 mins but i had to close it from the Task Manager.
>Could you give me an example of a working configuration of a linked server
>to DB2/400?
>Thanks
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:l8eb50dfufaqvf68ugecj8aagokm5pop0h@.
4ax.com...
>message
>
Linked server
I linked to paradox table from MSSQL 2000 enterprise server and I saw all
the table name
but my question is how can I make a select statment to see the data?Use four part naming like
SELECT A.Col1, A.col2,A.coln
FROM LinkedServername.Database.owner.Table A
Roji. P. Thomas
SQL Server Programmer
"Admin" <admin@.admin.com> wrote in message
news:uT0Me0JREHA.2404@.TK2MSFTNGP09.phx.gbl...
> I linked to paradox table from MSSQL 2000 enterprise server and I saw all
> the table name
> but my question is how can I make a select statment to see the data?
>|||THANKS A LOT, but the linked server is paradox.
I make a ODBC connection and then I linked into linked server
mean
Select * from LinkedServername...city
is this correct? bcs I have not database name and owner name this is paradox
table
"Roji. P. Thomas" <lazydragon@.nowhere.com> wrote in message
news:#jTet4JREHA.2876@.TK2MSFTNGP09.phx.gbl...
> Use four part naming like
> SELECT A.Col1, A.col2,A.coln
> FROM LinkedServername.Database.owner.Table A
>
> --
> Roji. P. Thomas
> SQL Server Programmer
> "Admin" <admin@.admin.com> wrote in message
> news:uT0Me0JREHA.2404@.TK2MSFTNGP09.phx.gbl...
all[vbcol=seagreen]
>|||Hi,
Try
select * from openquery(linked_server_name, 'select * from table_name')
Replace the server name and table name based on ur requirement.
Thanks
Hari
MCDBA
"Admin" <admin@.admin.com> wrote in message
news:elffm9JREHA.3016@.tk2msftngp13.phx.gbl...
> THANKS A LOT, but the linked server is paradox.
> I make a ODBC connection and then I linked into linked server
> mean
> Select * from LinkedServername...city
> is this correct? bcs I have not database name and owner name this is
paradox
> table
> "Roji. P. Thomas" <lazydragon@.nowhere.com> wrote in message
> news:#jTet4JREHA.2876@.TK2MSFTNGP09.phx.gbl...
> all
>|||I do that and it's not working
Note: this is paradox file and the provider name is ODBC drivers
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:uB#BPWKREHA.2112@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Try
> select * from openquery(linked_server_name, 'select * from table_name')
> Replace the server name and table name based on ur requirement.
> Thanks
> Hari
> MCDBA
>
> "Admin" <admin@.admin.com> wrote in message
> news:elffm9JREHA.3016@.tk2msftngp13.phx.gbl...
> paradox
saw[vbcol=seagreen]
>
the table name
but my question is how can I make a select statment to see the data?Use four part naming like
SELECT A.Col1, A.col2,A.coln
FROM LinkedServername.Database.owner.Table A
Roji. P. Thomas
SQL Server Programmer
"Admin" <admin@.admin.com> wrote in message
news:uT0Me0JREHA.2404@.TK2MSFTNGP09.phx.gbl...
> I linked to paradox table from MSSQL 2000 enterprise server and I saw all
> the table name
> but my question is how can I make a select statment to see the data?
>|||THANKS A LOT, but the linked server is paradox.
I make a ODBC connection and then I linked into linked server
mean
Select * from LinkedServername...city
is this correct? bcs I have not database name and owner name this is paradox
table
"Roji. P. Thomas" <lazydragon@.nowhere.com> wrote in message
news:#jTet4JREHA.2876@.TK2MSFTNGP09.phx.gbl...
> Use four part naming like
> SELECT A.Col1, A.col2,A.coln
> FROM LinkedServername.Database.owner.Table A
>
> --
> Roji. P. Thomas
> SQL Server Programmer
> "Admin" <admin@.admin.com> wrote in message
> news:uT0Me0JREHA.2404@.TK2MSFTNGP09.phx.gbl...
all[vbcol=seagreen]
>|||Hi,
Try
select * from openquery(linked_server_name, 'select * from table_name')
Replace the server name and table name based on ur requirement.
Thanks
Hari
MCDBA
"Admin" <admin@.admin.com> wrote in message
news:elffm9JREHA.3016@.tk2msftngp13.phx.gbl...
> THANKS A LOT, but the linked server is paradox.
> I make a ODBC connection and then I linked into linked server
> mean
> Select * from LinkedServername...city
> is this correct? bcs I have not database name and owner name this is
paradox
> table
> "Roji. P. Thomas" <lazydragon@.nowhere.com> wrote in message
> news:#jTet4JREHA.2876@.TK2MSFTNGP09.phx.gbl...
> all
>|||I do that and it's not working
Note: this is paradox file and the provider name is ODBC drivers
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:uB#BPWKREHA.2112@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Try
> select * from openquery(linked_server_name, 'select * from table_name')
> Replace the server name and table name based on ur requirement.
> Thanks
> Hari
> MCDBA
>
> "Admin" <admin@.admin.com> wrote in message
> news:elffm9JREHA.3016@.tk2msftngp13.phx.gbl...
> paradox
saw[vbcol=seagreen]
>
Linked server
Guys,
I have established a linked server connection from sybase to MS SQL Server. I can run SQL from MSSQL Server and bring data across. The data sync runs as a cron job but the connections to sybase is never released after the job completes. Due to this, I run out of connections on my Sybase server. Has anyone encountered this problem? Please help......
Regards
Subhasa cron?
What does it execute?|||Are the sql statements you're executing against Sybase using the OpenQuery() method?|||No. The queries does not use an OpenQuery method. Instead, I have added a linked server and then created a stored procedure in MS SQL which accesses the data from sybase. For example -- I have used a SQL in the SP saying select customer_id from server_name.db_name.dbo.table_name. It works fine and gets the data from sybase on to MS SQL Server but does not release the user connection on the sybase side. This Stored procedure runs as a scheduled job (Cron) in MS SQL Server.
Regards
subhas
I have established a linked server connection from sybase to MS SQL Server. I can run SQL from MSSQL Server and bring data across. The data sync runs as a cron job but the connections to sybase is never released after the job completes. Due to this, I run out of connections on my Sybase server. Has anyone encountered this problem? Please help......
Regards
Subhasa cron?
What does it execute?|||Are the sql statements you're executing against Sybase using the OpenQuery() method?|||No. The queries does not use an OpenQuery method. Instead, I have added a linked server and then created a stored procedure in MS SQL which accesses the data from sybase. For example -- I have used a SQL in the SP saying select customer_id from server_name.db_name.dbo.table_name. It works fine and gets the data from sybase on to MS SQL Server but does not release the user connection on the sybase side. This Stored procedure runs as a scheduled job (Cron) in MS SQL Server.
Regards
subhas
Subscribe to:
Posts (Atom)