SQL Server link problems

**pholtquist** · 12-13-2002, 01:21 PM

Hi everyone,

I have a problem that started this morning. I have an import of an
ACT database that imports data into a SQL Server database table. We have created a link to the ACT database on the SQL Server server. We have mapped to the server and directory where FOLLETT2 is located. We then have a stored procedure that does the acutal import of the data into SQL Server 7.0 The job has been working for months without a problem. This morning it failed with the following error:

Server: Msg 7314, Level 16, State 1, Line 15 OLE DB provider
'MSDASQL' does not contain table '`F:\`\`FOLLETT2`'.

FOLLETT2 is a DBF file and F is the drive where it is supposed to
look for the data.

What I have found so far is that
1. I can see the file in windows explorer on the server where the database is to be imported to.
2. I can see the file on windows explorer on the server where the database is to be imported from.
3. When I check the linked server in SQL 7 it shows no tables at all.

I have done nothing to this database for months. I have changed
nothing. The network group had a problem with the server where the data is
imported from on Sunday, but they say since they can see it through windows
explorer, there is nothing wrong.

Is there anything that I should check or have them check to find out
what the problem might be?

Your assistance is greatly appreciated

Thanks
Phil

**rmiao** · 12-13-2002, 02:10 PM

Try create another link to same file to see if works.

**pholtquist** · 12-13-2002, 02:26 PM

I tried creating a new link to the server and the same problem and same error still exist.

Thanks
Phil

**skhanal** · 12-13-2002, 02:29 PM

Can you create a linked server to any other ACT database?.

I am suspecting two things, one is the ACT database itself, another is OLEDB provider for DBF files.

**pholtquist** · 12-13-2002, 02:37 PM

Do you think that it could be a permission problem on the ACT Database? The reason that I ask is that I had someone try and login to the ACT database using the ACT application. They got an invalid username error when they tried to connect.
Could the database in ACT be corrupted or sonething? On the night before this all started, they lost a drive on the server containing the ACT database and had to install a new drive and restore everything from backup.
Is there a way to add a user and password to an ACT database? This problem has really been frustrating for me as I know nothing about ACT and
did not create this SQL procedure.

Thanks
Phil

**skhanal** · 12-13-2002, 03:28 PM

If you can't access it from ACT database then it must be ACT.

How did you connect linked server without knowing the password then?

**pholtquist** · 12-13-2002, 03:35 PM

We knew what the password was. We were using it for the past two years to run the import. Now when we try to use the password, ACT states that it is invalid.

**rmiao** · 12-13-2002, 04:14 PM

Anyone changed password on ACT? Should get it to work first.

Thread: SQL Server link problems

Thread Tools

Display