Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    Beaumont, TX
    Posts
    18

    Unanswered: LINKSERVER3.DBCLN3.Schema.table3

    Hi,
    I've to retrieve information from MS SQL Server linked server table(from Pervasive SQL). I found this query "select * from LINKSERVER3.DBCLN3.Schema.table3" what's Schema in the query? How do you find it? Thanks for your time,

    Jay.

  2. #2
    Join Date
    Aug 2002
    Location
    Beaumont, TX
    Posts
    18

    Solution

    Well found the solution myself. I read in another forum that I can leave the Schema part blank and it worked.
    LINKSERVER.DBCLN..cdtbl1

    However my data retrieval is very slow bcoz of some other reasons. My pervasive sql database is on Netware server and my MS SQL Server 2000 is on a windows 2000 server. I'm connecting pervasive sql through linked server in MS SQL Server. when I try to open any table it's very slow. Any ideas?

    Jay.

Posting Permissions

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