Showing posts with label dbo. Show all posts
Showing posts with label dbo. Show all posts

Wednesday, March 7, 2012

Could not find file 'C:\WINDOWS\system32\dbo.mdb

Error message "OLE DB error: OLE DB or ODBC error: Could not find file 'C:\WINDOWS\system32\dbo.mdb'.; 3024. is reported when I try to process a cube in the SQL Server Management Studio and in the SQL Server Business Intelligence Development Studio.

What is the problem, I didn't install new software!!

Check the data source connection string. It looks like a Jet data source pointing to C:\WINDOWS\system32\dbo.mdb. Edit the data source in SQL Mgmt Studio and fix it.

|||This is not a data source connection problem, all the cubes are reporting the same error message!!|||If Analysis Services is raising this error, then this Jet connection string must be specified *somewhere*. Check the config file msmdsrv.ini (or server properties in mgmt studio). Maybe the query log or something else points to this mdb.|||

This error message do not appear when I'm connected to the network, only when I work stand alone!!!

My connection string in the data source property window:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Data\SQL2005Cubes\TBC_Europe.mdb

Friday, February 24, 2012

Could not bulk insert

Dear All,
Im trying to execute the follownf command:
(BULK INSERT LOUIS_Publication.dbo.mbbmPlanSheetCache21
FROM '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP')
from Query analyzer and I get the message:
(Server: Msg 4861, Level 16, State 1, Line 1
Could not bulk insert because
file '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP' could not be
opened. Operating system error code 5(error not found).)
what might be the problem:
Hi,
This error normally comes when you are not able to access the remote share.
The problem might be the account under which your SQL Server runs, must be
authorized to access
the share on \\Ntp\app\HARRIS .
This will not work if SQL Server runs under the local system account. So
ensure that you start your SQL server using a domain account which has
access to \\Ntp\app\HARRIS share.
Thanks
Hari
MCDBA
"HARRIS ARISTOTELOUS" <harris@.glprodata.com> wrote in message
news:187bb01c41ae7$77752530$a101280a@.phx.gbl...
> Dear All,
> Im trying to execute the follownf command:
> (BULK INSERT LOUIS_Publication.dbo.mbbmPlanSheetCache21
> FROM '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP')
>
> from Query analyzer and I get the message:
> (Server: Msg 4861, Level 16, State 1, Line 1
> Could not bulk insert because
> file '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP' could not be
> opened. Operating system error code 5(error not found).)
> what might be the problem:
>
|||1. \\server\shared is relative to the sqlserver.
2. check to see if the NT acct used to start sqlserver service has access to
network shared. LocalSystem acct will not have any access to network
resources.
-oj
http://www.rac4sql.net
"HARRIS ARISTOTELOUS" <harris@.glprodata.com> wrote in message
news:187bb01c41ae7$77752530$a101280a@.phx.gbl...
> Dear All,
> Im trying to execute the follownf command:
> (BULK INSERT LOUIS_Publication.dbo.mbbmPlanSheetCache21
> FROM '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP')
>
> from Query analyzer and I get the message:
> (Server: Msg 4861, Level 16, State 1, Line 1
> Could not bulk insert because
> file '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP' could not be
> opened. Operating system error code 5(error not found).)
> what might be the problem:
>

Could not bulk insert

Dear All,
Im trying to execute the follownf command:
(BULK INSERT LOUIS_Publication.dbo.mbbmPlanSheetCache21
FROM '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP')
from Query analyzer and I get the message:
(Server: Msg 4861, Level 16, State 1, Line 1
Could not bulk insert because
file '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP' could not be
opened. Operating system error code 5(error not found).)
what might be the problem:Hi,
This error normally comes when you are not able to access the remote share.
The problem might be the account under which your SQL Server runs, must be
authorized to access
the share on \\Ntp\app\HARRIS .
This will not work if SQL Server runs under the local system account. So
ensure that you start your SQL server using a domain account which has
access to \\Ntp\app\HARRIS share.
Thanks
Hari
MCDBA
"HARRIS ARISTOTELOUS" <harris@.glprodata.com> wrote in message
news:187bb01c41ae7$77752530$a101280a@.phx
.gbl...
> Dear All,
> Im trying to execute the follownf command:
> (BULK INSERT LOUIS_Publication.dbo.mbbmPlanSheetCache21
> FROM '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP')
>
> from Query analyzer and I get the message:
> (Server: Msg 4861, Level 16, State 1, Line 1
> Could not bulk insert because
> file '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP' could not be
> opened. Operating system error code 5(error not found).)
> what might be the problem:
>|||1. \\server\shared is relative to the sqlserver.
2. check to see if the NT acct used to start sqlserver service has access to
network shared. LocalSystem acct will not have any access to network
resources.
-oj
http://www.rac4sql.net
"HARRIS ARISTOTELOUS" <harris@.glprodata.com> wrote in message
news:187bb01c41ae7$77752530$a101280a@.phx
.gbl...
> Dear All,
> Im trying to execute the follownf command:
> (BULK INSERT LOUIS_Publication.dbo.mbbmPlanSheetCache21
> FROM '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP')
>
> from Query analyzer and I get the message:
> (Server: Msg 4861, Level 16, State 1, Line 1
> Could not bulk insert because
> file '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP' could not be
> opened. Operating system error code 5(error not found).)
> what might be the problem:
>