Results 1 to 4 of 4

Thread: Linked server

  1. #1
    Join Date
    Apr 2003
    Posts
    54

    Unanswered: 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

    Subhas

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    a cron?

    What does it execute?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Sep 2003
    Posts
    364
    Are the sql statements you're executing against Sybase using the OpenQuery() method?

  4. #4
    Join Date
    Apr 2003
    Posts
    54
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •