Error with linked server

I have a "linked server" configured in my SQL Server 2000 (SP4) server, which used to work correctly. However, I had to reinstall SQL Server (I backed up and restored the master/model/etc databases, so all my settings stayed the same). Since then, I've been getting this error when I try to use the linked server:
Invalid schema or catalog specified for provider 'MSDASQL'.
OLE DB error trace [Non-interface error: Invalid schema or catalog specified for the provider.].

The linked server is a FoxPro database, which does not use catalog or schema names. So, my select syntax looks like this:
SELECT * FROM Server...Table

SQL Server is aparently expecting something like this:
SELECT * FROM Server.Catalog.Schema.Table

Does anyone know how I can fix it so that it allows the "empty dot" method to work like it used to?'

Thanks!
JoshTry creating a new linkedserver to FP and see if it works. Also, try to update to the latest Mdac to get the latest providers.|||Yeah, I already tried to create a new linked server, and it didn't work. I checked my MDAC version, and it's the newest one (2.8 SP1).|||what foxpro driver are you using? a long time ago in a galaxy far away I had a world of trouble with fox pro linked servers until I upgraded from the 7 driver to the 8 driver.

I would drop the linked server.

install the current VFP driver. maybe reinstall MDAC.

recreate said linked server.

test the connection with OPENQUERY (but do not use it in production, pushes the processing to foxpro).

test using your empty dot method.

so glad I do not have to use fox pro anymore.|||It looks like I'm running version 6... I'll try upgrading it, thanks.

Oh yeah, I've already tried the OPENQUERY method, and it works. I could just change all of my code to use that, but that would be a lot of work.|||OPENQUERY is a pig. It will process the query in foxpro instead of sql server.|||what version of VFP are using. Be careful. Try this out in a test envrionment first because you may not be able to go back.|||Ok, so I wouldn't want to use it, even if it was easy to use. :)|||I actually don't know what version it is. We have a third-party application written in FoxPro that we pull data from to display on an intranet site. My FoxPro experience is limited to using that app, and linking SQL Server to it.

So, thanks for the warning. I'll have to do more research...|||Ok, I got it. It turns out that there is a checkbox in the linked server's Provider Options window called "Level zero only". If that is not checked, the empty-dot notation doesn't work. I checked it, and it works now.

I'm not sure why it broke, unless that option is a recent addition to the provider options - maybe someone installed some update around the same time we reinstalled SQL Server...

Anyway, thanks for the help!
Josh

Error while trying to (re)install SQL Server 2005...

I had to uninstall SQL Server 2005 and when I tried to reinstall SQL
Server 2005, I get the following error message. I have tried this
several times and seem to hit this ro
Thanks
Jagannathan Santhanam
ad block. The error message is least bit helpful. What am I missing?
Appreciate any help.
TITLE: Microsoft SQL Server 2005 Setup
--
There was an unexpected failure during the setup wizard. You may review
the setup logs and/or click the help button for more information.
For help, click:
http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=50000&EvtType=packageengine%5cinstallpackageaction.cpp%40InstallToolsAction.10%40sqls%3a%3aInstallPackageAction%3a%3aperform%400x643
--
BUTTONS:
OK
--You need to check the installation log. Please refer this URL
http://msdn2.microsoft.com/en-us/library/ms143702.aspx
Thanks & Rate the Postings.
-Ravi-
"jags_32@.yahoo.com" wrote:
> I had to uninstall SQL Server 2005 and when I tried to reinstall SQL
> Server 2005, I get the following error message. I have tried this
> several times and seem to hit this ro
> Thanks
> Jagannathan Santhanam
> ad block. The error message is least bit helpful. What am I missing?
> Appreciate any help.
> TITLE: Microsoft SQL Server 2005 Setup
> --
> There was an unexpected failure during the setup wizard. You may review
> the setup logs and/or click the help button for more information.
>
> For help, click:
> http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=50000&EvtType=packageengine%5cinstallpackageaction.cpp%40InstallToolsAction.10%40sqls%3a%3aInstallPackageAction%3a%3aperform%400x643
> --
> BUTTONS:
> OK
> --
>|||when you do a uninstall some custom files made to the server or computer
still on the registry and folders, so you need to cleanup you registry and
then also delete the remaining forlders befor you plan to install sql 2k 5
again.
when you do this remember to restart the server and start the process of
reinstalling it.
--
Santos Martinez,MCSE, MCDBA, MCTS
IT Community Staff of Puerto Rico
http://www.itcspr.org
"Ravi" wrote:
> You need to check the installation log. Please refer this URL
> http://msdn2.microsoft.com/en-us/library/ms143702.aspx
>
> --
> Thanks & Rate the Postings.
> -Ravi-
>
> "jags_32@.yahoo.com" wrote:
> > I had to uninstall SQL Server 2005 and when I tried to reinstall SQL
> > Server 2005, I get the following error message. I have tried this
> > several times and seem to hit this ro
> >
> > Thanks
> > Jagannathan Santhanam
> >
> > ad block. The error message is least bit helpful. What am I missing?
> > Appreciate any help.
> >
> > TITLE: Microsoft SQL Server 2005 Setup
> > --
> >
> > There was an unexpected failure during the setup wizard. You may review
> > the setup logs and/or click the help button for more information.
> >
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=50000&EvtType=packageengine%5cinstallpackageaction.cpp%40InstallToolsAction.10%40sqls%3a%3aInstallPackageAction%3a%3aperform%400x643
> >
> > --
> > BUTTONS:
> >
> > OK
> > --
> >
> >

Error while trying to (re)install SQL Server 2005...

I had to uninstall SQL Server 2005 and when I tried to reinstall SQL
Server 2005, I get the following error message. I have tried this
several times and seem to hit this ro
Thanks
Jagannathan Santhanam
ad block. The error message is least bit helpful. What am I missing?
Appreciate any help.
TITLE: Microsoft SQL Server 2005 Setup
--
There was an unexpected failure during the setup wizard. You may review
the setup logs and/or click the help button for more information.
For help, click:
http://go.microsoft.com/fwlink?Link...400
x643
BUTTONS:
OK
--You need to check the installation log. Please refer this URL
http://msdn2.microsoft.com/en-us/library/ms143702.aspx
Thanks & Rate the Postings.
-Ravi-
"jags_32@.yahoo.com" wrote:

> I had to uninstall SQL Server 2005 and when I tried to reinstall SQL
> Server 2005, I get the following error message. I have tried this
> several times and seem to hit this ro
> Thanks
> Jagannathan Santhanam
> ad block. The error message is least bit helpful. What am I missing?
> Appreciate any help.
> TITLE: Microsoft SQL Server 2005 Setup
> --
> There was an unexpected failure during the setup wizard. You may review
> the setup logs and/or click the help button for more information.
>
> For help, click:
> http://go.microsoft.com/fwlink?Link...4
00x643
> --
> BUTTONS:
> OK
> --
>|||when you do a uninstall some custom files made to the server or computer
still on the registry and folders, so you need to cleanup you registry and
then also delete the remaining forlders befor you plan to install sql 2k 5
again.
when you do this remember to restart the server and start the process of
reinstalling it.
Santos Martinez,MCSE, MCDBA, MCTS
IT Community Staff of Puerto Rico
http://www.itcspr.org
"Ravi" wrote:
[vbcol=seagreen]
> You need to check the installation log. Please refer this URL
> http://msdn2.microsoft.com/en-us/library/ms143702.aspx
>
> --
> Thanks & Rate the Postings.
> -Ravi-
>
> "jags_32@.yahoo.com" wrote:
>
[vbcol=seagreen]