OPENROWSET using Visual FoxPro Provider error 'Cou

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

OPENROWSET using Visual FoxPro Provider error 'Cou

Author

Topic

quintesv
Starting Member

3 Posts

Posted - 2006-06-20 : 10:15:05

Hi,
I have 2 separate clients experiencing this problem,
Both systems are
1. Win 2000 Server with Small Business Server 2000 (SP4)
2. SQL Server 2000 (SP2 upgraded to SP4, SP4)
3. Exchange
4. IIS etc

We use SQL Server to connect to FoxPro 2.6 Tables.

We are using OPENROWSET as follows:
Select * from openrowset('VFPOLEDB.1','C:\Client Data';;,'Select * from cm')

We are now getting this error:
Server: Msg 7330, Level 16, State 2, Line 1 Could not fetch a row from OLE DB provider 'vfpoleDB.1'. OLE DB error trace [OLE/DB Provider 'vfpoleDB.1' IRowset::GetNextRows returned 0x80040155].

The statement worked up until around 20 days ago, which made us think that it may be windows updates/sps/hotfixes, but i have installed the above on a test machine and installed all windows updates and the test machine works AOK.

Has anybody seen this error?

Thanks in advance
Q

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-06-20 : 12:53:51

Syntax error in
Select * from openrowset('VFPOLEDB.1','C:\Client Data';;,'Select * from cm')

no ";" allowed.

Peter Larsson
Helsingborg, Sweden

quintesv
Starting Member

3 Posts

Posted - 2006-06-21 : 03:07:10

The syntax is correct, it works on any other machine. The ; is used to specify username and password respectively, both of which are blank.

The syntax is definitely not a problem.

quintesv
Starting Member

3 Posts

Posted - 2006-06-21 : 03:08:15

oh yeah, as in my original post, it worked fine up until about 20 days ago.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources