Use SQL Server to insert data in Pervasive database

• dbate

  SSC Enthusiast

  Points: 129

  More actions

  January 13, 2009 at 10:01 am

  #199989

  I want to be able to use a linked server to insert Sql Server data to a table in a linked Pervasive database. The Pervasive database has no security on it at all. The problem is that the Pervasive table name has a space in it and renaming the table is not an option. Within Sql Server I can read data from the linked Pervasive table with no problem, such as: select PartID from testdb.testdb.."Part Master"; but I can not do an insert to the same table such as: insert into testdb.testdb.."Part Master" (PartID) values ('test'); - it fails. I tried everything I can think of for 'Part Master' such as combinations of using square brackets, extra quotes, double quotes, single quotes, etc, but nothing seems to work.

  I can do an insert into a different Pervasive table that does not contain a space in the tablename and it works fine, such as: insert into testdb.testdb.."Buyers" (BUYID) values ('test'); Any ideas on how to fix the space in the linked tablename problem ?

• Maxim Picard

  SSCrazy

  Points: 2052

  More actions

  January 13, 2009 at 10:21 am

  #926059

  Hi dbate,

  Would it be possible to create a stored procedure on the Pervasive server and call that through your linked server?

• gyessql

  Ten Centuries

  Points: 1097

  More actions

  January 13, 2009 at 10:22 am

  #926061

  Have you also tried

  insert into [testdb].[testdb].[dbo].[Part Master] (PartID) values ('test');

  What was the error?

• noeld

  SSC Guru

  Points: 96590

  More actions

  January 13, 2009 at 11:09 am

  #926105

  Linked SQL servers tend to not like ".." you should try the post above where it is correctly specified as ".dbo."

  
  * Noel