Re: foxpro view

stephanie (stephanie@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
> In the foxpro table, the 'cprodname' is C(30) and contain chinese
> characters and the view is
> SELECT c_type, portfolio, cprodname, prodname, dept, rptseq, expocat
> FROM OPENQUERY(ORS, 'select * from product')
>
> Any advise to solve it? Thanks in advance

Since I don't know Foxpro, I cannot give a complete answer. But I think
I understand what the message means. When SQL Server retrieves the metadata
for the table, it gets an answer of 30 characters, but when at run-time
there are 60 characters coming across the wires, it does not like that.

This may be a problem with the MSDASQL provider, or the FoxPro ODBC
driver. I would try Cindy's suggestion to use the Foxpro OLE DB Provider
instead.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: foxpro view
    ... I haven't worked with non-Latin characters but Chinese characters will be ... Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP ... > SELECT c_type, portfolio, cprodname, prodname, dept, rptseq, expocat ...
    (microsoft.public.data.oledb)
  • Re: probably a codepage problem
    ... > knowing that I have "default" tables compiled in my exe with codepage ... Foxpro can be made to automatically translate characters for tables that you ... automatic translation of characters across code pages. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: data provider
    ... using the foxpro OLEDB route does the end user have to have Sql Express ... There are two ways to procede to get VFP data into SQL Server Compact ... these are the OleDb data providers: ...
    (microsoft.public.sqlserver.ce)
  • Re: data provider
    ... provider that your Foxpro app will use. ... When I talk about a sdf file in my mind its a SQL Server Compact edition ...
    (microsoft.public.sqlserver.ce)
  • Re: data provider
    ... provider that your Foxpro app will use. ... When I talk about a sdf file in my mind its a SQL Server Compact edition ... create a SSCE database that contains all of my tables ...
    (microsoft.public.sqlserver.ce)
Loading