January 13, 2009 at 10:01 am
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 ?
January 13, 2009 at 10:21 am
Hi dbate,
Would it be possible to create a stored procedure on the Pervasive server and call that through your linked server?
January 13, 2009 at 10:22 am
Have you also tried
insert into [testdb].[testdb].[dbo].[Part Master] (PartID) values ('test');
What was the error?
January 13, 2009 at 11:09 am
Linked SQL servers tend to not like ".." you should try the post above where it is correctly specified as ".dbo."
* Noel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply