Error when trying to populate database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Error when trying to populate database

Author

Topic

skiabox
Posting Yak Master

169 Posts

Posted - 2008-03-06 : 07:05:04

I have created a database named 'CHA2' that is being used in the book 'sql server 2000 bible'.
When trying to populate it according to the author directions I get an error.
Here is the start of the script :

-----------------------------------------------------------
-- SQL Server 2000 Bible
-- Hungry Minds
-- Paul Nielsen

-- Cape Hatteras Advntures v.2 sample database - Populate

-- this script will populate the CHA2 database
-- from CHA1_Customers.mdb Access file
-- and CHA1_Schedule.xls Excel Spreadsheet
-- using distributed queries

-- This script mirrors the CHA_Convert DTS package

-----------------------------------------------------------
-----------------------------------------------------------

USE CHA2

-- establish Access Linked Server
EXEC sp_DropServer @server = 'CHA1_Customers'
go
EXEC sp_addlinkedserver
'CHA1_Customers',
'Access 2000',
'Microsoft.Jet.OLEDB.4.0',
'C:\SQLServerBible\CHA1_Customers.mdb'
go

-- establish Excel Linked Server
EXEC sp_DropServer @server = 'CHA1_Schedule'
go
Execute sp_addlinkedserver
'CHA1_Schedule',
'Excel',
'Microsoft.Jet.OLEDB.4.0',
'C:\SQLServerBible\CHA1_Schedule.xls',
NULL,
'Excel 5.0'
go

-----------------------------------------------------------------------------------
And here is the error that I receive :

Server: Msg 7399, Level 16, State 1, Line 16
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication failed.
[OLE/DB provider returned message: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.]

Any ideas on how to solve this problem?
Thank you!

Jeff Moden
Aged Yak Warrior

652 Posts

Posted - 2008-03-06 : 10:15:56

CHA1_Schedule.xls must already exist. Did you create it? Also, can the server actually see the path to the file?

--Jeff Moden

skiabox
Posting Yak Master

169 Posts

Posted - 2008-03-07 : 03:57:47

The file already exists and it is in the right folder.

skiabox
Posting Yak Master

169 Posts

Posted - 2008-03-07 : 04:18:38

I believe it has to do with datasource creation.

Jeff Moden
Aged Yak Warrior

652 Posts

Posted - 2008-03-07 : 18:59:13

Please post the result of the following code... it'll let us know if your server can see the file...

EXEC master..xp_fileexist 'C:\SQLServerBible\CHA1_Schedule.xls'

--Jeff Moden

skiabox
Posting Yak Master

169 Posts

Posted - 2008-03-11 : 06:19:45

File Exists File is a Directory Parent Directory Exists
----------- ------------------- -----------------------
1 0 1

(1 row(s) affected)

I managed to run the script but it doesn't populate the CHA2 database properly.
I have many data missing from the database tables.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources