Cannot create Linked Server.

Hello.
Can you help me?
I need create Linked server for Visual Fox Pro, but I can not create it.
For DBase no problem, but for VFP, no.
May be anyone have script?
Thank you very much.Try...
exec sp_addlinkedserver
'myVFP',
'',
'MSDASQL',
null,
null,
'Driver=Microsoft Visual Foxpro Driver;
DBQ=;
SourceType=DBF;
SourceDB=x:\VFP'
exec sp_addlinkedsrvlogin 'myVFP',false,null,null,null
-oj
Rac v2.2 & QALite!
http://www.rac4sql.net
"Yuriy B. Belyaev" <jurijb@.mail.ru> wrote in message
news:%23LT5fylhDHA.2536@.TK2MSFTNGP10.phx.gbl...
> Hello.
> Can you help me?
> I need create Linked server for Visual Fox Pro, but I can not create it.
> For DBase no problem, but for VFP, no.
> May be anyone have script?
> Thank you very much.
>
>|||I try
select count(*) from myVFP...goodsfox ("goodsfox" is a table name)
this is message from SQL Server:
Server: Msg 7313, Level 16, State 1, Line 1
Invalid schema or catalog specified for provider 'MSDASQL'.
"oj" <nospam_ojngo@.home.com> wrote in message
news:O9tzICmhDHA.3276@.tk2msftngp13.phx.gbl...
> Try...
> exec sp_addlinkedserver
> 'myVFP',
> '',
> 'MSDASQL',
> null,
> null,
> 'Driver=Microsoft Visual Foxpro Driver;
> DBQ=;
> SourceType=DBF;
> SourceDB=x:\VFP'
> exec sp_addlinkedsrvlogin 'myVFP',false,null,null,null
>
> --
> -oj
> Rac v2.2 & QALite!
> http://www.rac4sql.net
>
> "Yuriy B. Belyaev" <jurijb@.mail.ru> wrote in message
> news:%23LT5fylhDHA.2536@.TK2MSFTNGP10.phx.gbl...
> > Hello.
> >
> > Can you help me?
> > I need create Linked server for Visual Fox Pro, but I can not create it.
> > For DBase no problem, but for VFP, no.
> >
> > May be anyone have script?
> > Thank you very much.
> >
> >
> >
>|||do:
select *
from openquery(myVFP,'select count(*) from goodsfox')
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net
"Yuriy B. Belyaev" <jurijb@.mail.ru> wrote in message
news:e17ZsHmhDHA.3784@.tk2msftngp13.phx.gbl...
> I try
> select count(*) from myVFP...goodsfox ("goodsfox" is a table name)
> this is message from SQL Server:
> Server: Msg 7313, Level 16, State 1, Line 1
> Invalid schema or catalog specified for provider 'MSDASQL'.
>
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:O9tzICmhDHA.3276@.tk2msftngp13.phx.gbl...
> > Try...
> >
> > exec sp_addlinkedserver
> > 'myVFP',
> > '',
> > 'MSDASQL',
> > null,
> > null,
> > 'Driver=Microsoft Visual Foxpro Driver;
> > DBQ=;
> > SourceType=DBF;
> > SourceDB=x:\VFP'
> >
> > exec sp_addlinkedsrvlogin 'myVFP',false,null,null,null
> >
> >
> > --
> > -oj
> > Rac v2.2 & QALite!
> > http://www.rac4sql.net
> >
> >
> > "Yuriy B. Belyaev" <jurijb@.mail.ru> wrote in message
> > news:%23LT5fylhDHA.2536@.TK2MSFTNGP10.phx.gbl...
> > > Hello.
> > >
> > > Can you help me?
> > > I need create Linked server for Visual Fox Pro, but I can not create
it.
> > > For DBase no problem, but for VFP, no.
> > >
> > > May be anyone have script?
> > > Thank you very much.
> > >
> > >
> > >
> >
> >
>