Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GoodDay
Starting Member
3 Posts |
 Posted - 2010-12-07 : 13:09:12
|
Hello!We have code and its work fine on SQL 2000 more 3 yearsselect * from openrowset( 'MSDASQL','DRIVER={Microsoft Visual FoxPro Driver}; SourceDB=d:\;SourceType=DBF', 'select * from dbFile)We move our application and databases on MS SQL2005, installed VFPODBC.msi and got a problem with the similar code (it uses in several procedures)sometimes it work fine, but sometimes it is not carried out and suspends a server. Server is hang up . After server reboot entirely problem procedure (with similar code) starts to work , but other procedure with OpenRowset can cause lag How to make a code efficient and why problem happens Thank you very much and sorry for poor english! |
|
|
GoodDay
Starting Member
3 Posts |
Posted - 2010-12-07 : 13:42:41
|
| [code]select @@version Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft CorporationStandard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)[/code] |
 |
|
|
GoodDay
Starting Member
3 Posts |
Posted - 2010-12-09 : 02:42:00
|
| I changed driver on VFPOLEDB and all works fine |
|
|
|
|
|
|
Openrowset problem