Tuesday, March 27, 2012

addlinkedserver

hello,
can I connect to foxpro db in sql server? or good way to connect to it?
Please advice. Thanks.You can do it thru a linked server or OPENROWSET if you don't want to
set up a linked server
http://sqlservercode.blogspot.com/|||Thanks for the help.
I just found all the files I have are xx.dbf, it's MS FoxPro Table.
How to connect to these files? Please help.
"SQL" <denis.gobo@.gmail.com> wrote in message
news:1131459155.646894.287480@.g14g2000cwa.googlegroups.com...
> You can do it thru a linked server or OPENROWSET if you don't want to
> set up a linked server
> http://sqlservercode.blogspot.com/
>|||select * from openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;
SourceDB=d:\;
SourceType=DBF',
'select * from files ')
as a
http://sqlservercode.blogspot.com/|||Thanks for the help.
I got this error:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver
does not support this function]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize
returned 0x80004005: ].
"SQL" <denis.gobo@.gmail.com> wrote in message
news:1131461422.449736.269480@.f14g2000cwb.googlegroups.com...
> select * from openrowset('MSDASQL',
> 'Driver=Microsoft Visual FoxPro Driver;
> SourceDB=d:\;
> SourceType=DBF',
> 'select * from files ')
> as a
> http://sqlservercode.blogspot.com/
>

No comments:

Post a Comment