Newbie question on replication failiure

Hi,
Replication to a MS-access database fails last week.
It has always been working, but now I get this message:
DISTRIBUTION AGENT ERROR
Error : The process could not connect to Subscriber 'MAB-EC-NW'.
Error information: Microsoft JET Database Engine (number = -534709256)
The Microsoft Jet database engine cannot open the file
'\\Server\Ok2\MA\SQL-SERVER\MABDAT-EC.mdb'. It is already opened
exclusively by another user, or you need permission to view its data.
I am working on a single server with 1 SQL-database:
I does replication to a MS-Access dababase on the server.
The SQL-server (2000) is running on a NT-server.
It seems to me that the problem is could be caused by 2 reasons:
a lock by another user: but ik can open the file MABDAT-EC.mdb' using
MS-Access.
a problem with the permissions on the server, but what kind of permissions
and where to check.
SQL-server is new to me, and I just started my job in this company, so all
help I can get is welcome.
Thank in advance.
Johan
Hi Johan
Pls check the user permission in the sql server users tab.
Regards
Nirvan Biswas
"Johan" wrote:

> Hi,
>
> Replication to a MS-access database fails last week.
> It has always been working, but now I get this message:
>
> DISTRIBUTION AGENT ERROR
> Error : The process could not connect to Subscriber 'MAB-EC-NW'.
>
> Error information: Microsoft JET Database Engine (number = -534709256)
>
> The Microsoft Jet database engine cannot open the file
> '\\Server\Ok2\MA\SQL-SERVER\MABDAT-EC.mdb'. It is already opened
> exclusively by another user, or you need permission to view its data.
>
> I am working on a single server with 1 SQL-database:
> I does replication to a MS-Access dababase on the server.
> The SQL-server (2000) is running on a NT-server.
>
> It seems to me that the problem is could be caused by 2 reasons:
> a lock by another user: but ik can open the file MABDAT-EC.mdb' using
> MS-Access.
> a problem with the permissions on the server, but what kind of permissions
> and where to check.
>
> SQL-server is new to me, and I just started my job in this company, so all
> help I can get is welcome.
>
> Thank in advance.
> Johan
>
>
>
|||Nirvan,
Thanks for the reply,
The problem seems to be that the administrator password was changed on the
server.
When removing the password from the administrator account on the server (NT)
replication does work. When a password is set on the administrator account,
replication fails, so it seems that authentation is the problem.
After changing the administrator password on the server, SQL-server didn't
start up. So i temporary removed the administrator password to start
SQL-server and placed the password back.
Where do I have to make changes in SQL interprise manager, to solve the
problem with the administrator password?
Regards
Johan
"Nirvan Biswas" <yourdisplayname@.discussions.microsoft.com> schreef in
bericht news:642517C8-9614-4706-9256-4345DFBCA58A@.microsoft.com...[vbcol=seagreen]
> Hi Johan
>
> Pls check the user permission in the sql server users tab.
> Regards
> Nirvan Biswas
> "Johan" wrote:
permissions[vbcol=seagreen]
all[vbcol=seagreen]

newbie openquery question

How do I use openquery to create a table in an oracle database. Any sql
string that I pass thru fails as it doesn't return any rows.
Please post which query you are using and whats the error message that
comes back.
HTH, Jens Suessmeyer.
|||I'm trying to use:
select 1
from openquery(ORACLE8I,'CREATE TABLE TEST01 AS SELECT * FROM EMP')
and getting error message:
Server: Msg 7357, Level 16, State 2, Line 1
Could not process object 'CREATE TABLE TEST01 AS SELECT * FROM SCOTT.EMP'.
The OLE DB provider 'MSDAORA' indicates that the object has no columns.
OLE DB error trace [Non-interface error: OLE DB provider unable to process
object, since the object has no columnsProviderName='MSDAORA', Query=CREATE
TABLE TEST01 AS SELECT * FROM SCOTT.EMP'].
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1137227213.161298.325390@.f14g2000cwb.googlegr oups.com...
> Please post which query you are using and whats the error message that
> comes back.
> HTH, Jens Suessmeyer.
>
|||AS OpenQUERY is expecting a resultset being send back, you have to send
back even a dummy Select like "Select 1" (especially in Oracle "Select
1 from Dual"), so that should do the trick. (BTW: Do not use * in
productional systems for selecting, but I assume that you only did this
for testing, right ;-) )
select 1
from openquery(ORACLE8I,'CREATE TABLE TEST01 AS SELECT * FROM
EMP;Select 1 FROM dual;')
HTH, Jens Suessmeyer.
|||unfortunately that still didn't work. Getting:
Server: Msg 7357, Level 16, State 2, Line 1
Could not process object 'CREATE TABLE TEST01 AS SELECT * FROM EMP;Select 1
FROM dual;'. The OLE DB provider 'MSDAORA' indicates that the object has no
columns.
OLE DB error trace [Non-interface error: OLE DB provider unable to process
object, since the object has no columnsProviderName='MSDAORA', Query=CREATE
TABLE TEST01 AS SELECT * FROM EMP;Select 1 FROM dual;'].
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1137229967.162954.49310@.g14g2000cwa.googlegro ups.com...
> AS OpenQUERY is expecting a resultset being send back, you have to send
> back even a dummy Select like "Select 1" (especially in Oracle "Select
> 1 from Dual"), so that should do the trick. (BTW: Do not use * in
> productional systems for selecting, but I assume that you only did this
> for testing, right ;-) )
> select 1
> from openquery(ORACLE8I,'CREATE TABLE TEST01 AS SELECT * FROM
> EMP;Select 1 FROM dual;')
>
> HTH, Jens Suessmeyer.
>
|||ok, I think as the provider I waiting for a column description, try to
name the column which is coming back. I assume that this is expecting a
column description meta data. Once we had something similar executing a
stored procedure on a informix server. Due to the fact that the
procedure didn=B4t passed back anything, we received a smiliar error.
Adding a Select "'Procedure ready' AS result" at the end of the
procedure did the trick.
So try
select 1
from openquery(ORACLE8I,'CREATE TABLE TEST01 AS SELECT * FROM
EMP;Select 'Table created' AS ResultMessage FROM dual;')
HTH, Jens Suessmeyer.
|||I got a syntax error due to the single quotes I think. When I modified to
add extra quotes:
select 1
from openquery(ORACLE8I,'CREATE TABLE TEST01 AS SELECT * FROM EMP;Select
''Table created'' AS ResultMessage FROM dual;')
I still get the error:
Server: Msg 7357, Level 16, State 2, Line 1
Could not process object 'CREATE TABLE TEST01 AS SELECT * FROM EMP;Select
'Table created' AS ResultMessage FROM dual;'. The OLE DB provider 'MSDAORA'
indicates that the object has no columns.
OLE DB error trace [Non-interface error: OLE DB provider unable to process
object, since the object has no columnsProviderName='MSDAORA', Query=CREATE
TABLE TEST01 AS SELECT * FROM EMP;Select 'Table created' AS ResultMessage
FROM dual;'].
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1137233494.070652.28380@.f14g2000cwb.googlegro ups.com...
ok, I think as the provider I waiting for a column description, try to
name the column which is coming back. I assume that this is expecting a
column description meta data. Once we had something similar executing a
stored procedure on a informix server. Due to the fact that the
procedure didnt passed back anything, we received a smiliar error.
Adding a Select "'Procedure ready' AS result" at the end of the
procedure did the trick.
So try
select 1
from openquery(ORACLE8I,'CREATE TABLE TEST01 AS SELECT * FROM
EMP;Select 'Table created' AS ResultMessage FROM dual;')
HTH, Jens Suessmeyer.

newbie openquery question

How do I use openquery to create a table in an oracle database. Any sql
string that I pass thru fails as it doesn't return any rows.Please post which query you are using and whats the error message that
comes back.
HTH, Jens Suessmeyer.|||I'm trying to use:
select 1
from openquery(ORACLE8I,'CREATE TABLE TEST01 AS SELECT * FROM EMP')
and getting error message:
Server: Msg 7357, Level 16, State 2, Line 1
Could not process object 'CREATE TABLE TEST01 AS SELECT * FROM SCOTT.EMP'.
The OLE DB provider 'MSDAORA' indicates that the object has no columns.
OLE DB error trace [Non-interface error: OLE DB provider unable to proc
ess
object, since the object has no columnsProviderName='MSDAORA', Query=CREATE
TABLE TEST01 AS SELECT * FROM SCOTT.EMP'].
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1137227213.161298.325390@.f14g2000cwb.googlegroups.com...
> Please post which query you are using and whats the error message that
> comes back.
> HTH, Jens Suessmeyer.
>|||AS OpenQUERY is expecting a resultset being send back, you have to send
back even a dummy Select like "Select 1" (especially in Oracle "Select
1 from Dual"), so that should do the trick. (BTW: Do not use * in
productional systems for selecting, but I assume that you only did this
for testing, right ;-) )
select 1
from openquery(ORACLE8I,'CREATE TABLE TEST01 AS SELECT * FROM
EMP;Select 1 FROM dual;')
HTH, Jens Suessmeyer.|||unfortunately that still didn't work. Getting:
Server: Msg 7357, Level 16, State 2, Line 1
Could not process object 'CREATE TABLE TEST01 AS SELECT * FROM EMP;Select 1
FROM dual;'. The OLE DB provider 'MSDAORA' indicates that the object has no
columns.
OLE DB error trace [Non-interface error: OLE DB provider unable to proc
ess
object, since the object has no columnsProviderName='MSDAORA', Query=CREATE
TABLE TEST01 AS SELECT * FROM EMP;Select 1 FROM dual;'].
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1137229967.162954.49310@.g14g2000cwa.googlegroups.com...
> AS OpenQUERY is expecting a resultset being send back, you have to send
> back even a dummy Select like "Select 1" (especially in Oracle "Select
> 1 from Dual"), so that should do the trick. (BTW: Do not use * in
> productional systems for selecting, but I assume that you only did this
> for testing, right ;-) )
> select 1
> from openquery(ORACLE8I,'CREATE TABLE TEST01 AS SELECT * FROM
> EMP;Select 1 FROM dual;')
>
> HTH, Jens Suessmeyer.
>|||ok, I think as the provider I waiting for a column description, try to
name the column which is coming back. I assume that this is expecting a
column description meta data. Once we had something similar executing a
stored procedure on a informix server. Due to the fact that the
procedure didn=B4t passed back anything, we received a smiliar error.
Adding a Select "'Procedure ready' AS result" at the end of the
procedure did the trick.
So try
select 1
from openquery(ORACLE8I,'CREATE TABLE TEST01 AS SELECT * FROM
EMP;Select 'Table created' AS ResultMessage FROM dual;')
HTH, Jens Suessmeyer.|||I got a syntax error due to the single quotes I think. When I modified to
add extra quotes:
select 1
from openquery(ORACLE8I,'CREATE TABLE TEST01 AS SELECT * FROM EMP;Select
''Table created'' AS ResultMessage FROM dual;')
I still get the error:
Server: Msg 7357, Level 16, State 2, Line 1
Could not process object 'CREATE TABLE TEST01 AS SELECT * FROM EMP;Select
'Table created' AS ResultMessage FROM dual;'. The OLE DB provider 'MSDAORA'
indicates that the object has no columns.
OLE DB error trace [Non-interface error: OLE DB provider unable to proc
ess
object, since the object has no columnsProviderName='MSDAORA', Query=CREATE
TABLE TEST01 AS SELECT * FROM EMP;Select 'Table created' AS ResultMessage
FROM dual;'].
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1137233494.070652.28380@.f14g2000cwb.googlegroups.com...
ok, I think as the provider I waiting for a column description, try to
name the column which is coming back. I assume that this is expecting a
column description meta data. Once we had something similar executing a
stored procedure on a informix server. Due to the fact that the
procedure didnt passed back anything, we received a smiliar error.
Adding a Select "'Procedure ready' AS result" at the end of the
procedure did the trick.
So try
select 1
from openquery(ORACLE8I,'CREATE TABLE TEST01 AS SELECT * FROM
EMP;Select 'Table created' AS ResultMessage FROM dual;')
HTH, Jens Suessmeyer.

newbie openquery question

How do I use openquery to create a table in an oracle database. Any sql
string that I pass thru fails as it doesn't return any rows.Please post which query you are using and whats the error message that
comes back.
HTH, Jens Suessmeyer.|||I'm trying to use:
select 1
from openquery(ORACLE8I,'CREATE TABLE TEST01 AS SELECT * FROM EMP')
and getting error message:
Server: Msg 7357, Level 16, State 2, Line 1
Could not process object 'CREATE TABLE TEST01 AS SELECT * FROM SCOTT.EMP'.
The OLE DB provider 'MSDAORA' indicates that the object has no columns.
OLE DB error trace [Non-interface error: OLE DB provider unable to process
object, since the object has no columnsProviderName='MSDAORA', Query=CREATE
TABLE TEST01 AS SELECT * FROM SCOTT.EMP'].
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1137227213.161298.325390@.f14g2000cwb.googlegroups.com...
> Please post which query you are using and whats the error message that
> comes back.
> HTH, Jens Suessmeyer.
>|||AS OpenQUERY is expecting a resultset being send back, you have to send
back even a dummy Select like "Select 1" (especially in Oracle "Select
1 from Dual"), so that should do the trick. (BTW: Do not use * in
productional systems for selecting, but I assume that you only did this
for testing, right ;-) )
select 1
from openquery(ORACLE8I,'CREATE TABLE TEST01 AS SELECT * FROM
EMP;Select 1 FROM dual;')
HTH, Jens Suessmeyer.|||unfortunately that still didn't work. Getting:
Server: Msg 7357, Level 16, State 2, Line 1
Could not process object 'CREATE TABLE TEST01 AS SELECT * FROM EMP;Select 1
FROM dual;'. The OLE DB provider 'MSDAORA' indicates that the object has no
columns.
OLE DB error trace [Non-interface error: OLE DB provider unable to process
object, since the object has no columnsProviderName='MSDAORA', Query=CREATE
TABLE TEST01 AS SELECT * FROM EMP;Select 1 FROM dual;'].
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1137229967.162954.49310@.g14g2000cwa.googlegroups.com...
> AS OpenQUERY is expecting a resultset being send back, you have to send
> back even a dummy Select like "Select 1" (especially in Oracle "Select
> 1 from Dual"), so that should do the trick. (BTW: Do not use * in
> productional systems for selecting, but I assume that you only did this
> for testing, right ;-) )
> select 1
> from openquery(ORACLE8I,'CREATE TABLE TEST01 AS SELECT * FROM
> EMP;Select 1 FROM dual;')
>
> HTH, Jens Suessmeyer.
>|||ok, I think as the provider I waiting for a column description, try to
name the column which is coming back. I assume that this is expecting a
column description meta data. Once we had something similar executing a
stored procedure on a informix server. Due to the fact that the
procedure didn=B4t passed back anything, we received a smiliar error.
Adding a Select "'Procedure ready' AS result" at the end of the
procedure did the trick.
So try
select 1
from openquery(ORACLE8I,'CREATE TABLE TEST01 AS SELECT * FROM
EMP;Select 'Table created' AS ResultMessage FROM dual;')
HTH, Jens Suessmeyer.|||I got a syntax error due to the single quotes I think. When I modified to
add extra quotes:
select 1
from openquery(ORACLE8I,'CREATE TABLE TEST01 AS SELECT * FROM EMP;Select
''Table created'' AS ResultMessage FROM dual;')
I still get the error:
Server: Msg 7357, Level 16, State 2, Line 1
Could not process object 'CREATE TABLE TEST01 AS SELECT * FROM EMP;Select
'Table created' AS ResultMessage FROM dual;'. The OLE DB provider 'MSDAORA'
indicates that the object has no columns.
OLE DB error trace [Non-interface error: OLE DB provider unable to process
object, since the object has no columnsProviderName='MSDAORA', Query=CREATE
TABLE TEST01 AS SELECT * FROM EMP;Select 'Table created' AS ResultMessage
FROM dual;'].
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1137233494.070652.28380@.f14g2000cwb.googlegroups.com...
ok, I think as the provider I waiting for a column description, try to
name the column which is coming back. I assume that this is expecting a
column description meta data. Once we had something similar executing a
stored procedure on a informix server. Due to the fact that the
procedure didn´t passed back anything, we received a smiliar error.
Adding a Select "'Procedure ready' AS result" at the end of the
procedure did the trick.
So try
select 1
from openquery(ORACLE8I,'CREATE TABLE TEST01 AS SELECT * FROM
EMP;Select 'Table created' AS ResultMessage FROM dual;')
HTH, Jens Suessmeyer.

newbie openquery question

How do I use openquery to create a table in an oracle database. Any sql
string that I pass thru fails as it doesn't return any rows.Please do not crosspost, followup in microsoft.public.sqlserver.server
-Jens Suessmeyer.