Reply to Fresh SQL Server 2005 giving problem in accessing access 97 file through Jet Ole DB Provider

Your name:

Reply:


Posted by rathi.vis on 02/19/07 14:11

Problem:Jet 4.0 Ole DB Provider stops working the momemt SQL 2005
server is installed.

Environmental steps:

1.Installed XP Sp2

2.Installed SQL 2005 Server with SP1

3.Trying to import data from an access 97 file

Actual problem:The linked server gets created but when try to read
data we get attached error
The problem displayed is following

[02/19/07 18:24:47]: Cannot initialize the data source object of OLE
DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "MGMTREPORTS".
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server
"MGMTREPORTS" returned message "Cannot open database ''. It may not
be a database that your application recognizes, or the file may be
corrupt.".




Steps to recreate
USE [master]
GO

EXEC sp_addlinkedserver
@server = 'PROLMDB',
@provider ='Microsoft.Jet.OLEDB.4.0' ,
@srvproduct ='OLE DB Provider for Jet',
@datasrc = 'c:\PRO_LM_DB.MDB'
GO

-- Set the DBF files' logins.
EXEC sp_addlinkedsrvlogin
@rmtsrvname = 'PROLMDB'
, @useself = false
, @locallogin = NULL
, @rmtuser = NULL
, @rmtpassword = NULL
GO

SELECT [TRACK_ID]
, [EQUIP_ID]
, [PROD_ID]
, [SERIAL_NO]
, [TOP_BOTTOM]
, [START_TIME]
, [END_TIME]
, [TIME_STAMP]
, [LMNC_NAME]
, [Archive]
, [PAGERID]
, [ENDTIME_STAMP]
, [PROD_NAME]
FROM PROLMDB...TRACKDATA
GO

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация