Right here goes, I am using SQL Server 2000 and Pro-iv 5.5
Basically what I have got is a main database and a remote database on another server. I have a table in the remote database which I need to access via the main database, I have created a link in the main database using the commands in query analyzer.
sp_addlinkedserver 'remote server'
sp_addlinkedsrvlogin 'remote server','false',NULL,'sa','pwd'
Then if I create a View in the main database, I can query this view or add data to it no problem in SQL Query analyzer, but if I then create a proiv function to read this file, I get a record lock however I try to access it.
I then tried to access the table in the remote database directly using a command similar to below.
SELECT * FROM remote server.database.dbo.table
Again this work perfectly in query analyzer. So I then amended the alternate file def in Pro-iv to access the file directly with the alternate against the file similar to below.
this time the record lock has gone but I get an 366 SQL error msg
Cannot specify an index or locking hint for a remote data source
ireddyMember Since 19 Dec 2006
Offline Last Active Mar 08 2007 05:52 PM
- Group Members
- Active Posts 3
- Profile Views 1,350
- Member Title Newbie
- Age Age Unknown
- Birthday Birthday Unknown
Year Started ProIV
Highest ProIV Version Used
- Website URL http://
ireddy hasn't added any friends yet.
02 Jan 2008 - 04:51