Connect to Read-Only Access database as linked server SQL 2005

Hi all,
I am trying to add an Access database as a linked server in SQL Server
2005.
For a "regular" database, everything works fine. BUT (there's a
but...) the database I'm trying to access is a "read-only" database
(i.e.: folder in which db is located is read-only). When I open it
from Access, it warns me that the db cannot be modified, bla bla bla.
I can access the data, but cannot make modifications to the structure
of the database (add queries, change tables, etc.).
So... my question is... Did I forget any parameter in the
sp_addlinkedserver procedure? Anytime I try to use the OpenQuery
method with this database I get the message
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "IVR_post"
returned message "The Microsoft Jet database engine cannot open the
file '\\CompletePathAndDatabaseName.mdb'
. It is already opened exclusively by another user, or you need
permission to view its data.".
However, like I said, the same db can be opened with access 2002 from
the same station, the same user, etc.
exec sp_addlinkedserver @.server='MyServer',
@.srvproduct='Access',
@.provider='Microsoft.Jet.OLEDB.4.0',
@.datasrc='\\CompletePathAndDatabaseName.mdb'
exec sp_addlinkedsrvlogin @.rmtsrvname='MyServer',
@.useself='false',
@.rmtuser='Admin',
@.rmtpassword=''
Regards,Hi,
I have replicated your problem and it works perfectly for me. Are you
sure that you don't have some issues with the Access lock file. If you
shut down all applications/clients/servers accessing this Access file,
does the .ldb file still show up?
Jonathan
fabien.turcotte@.fidomobile.ca wrote:
> Hi all,
> I am trying to add an Access database as a linked server in SQL Server
> 2005.
> For a "regular" database, everything works fine. BUT (there's a
> but...) the database I'm trying to access is a "read-only" database
> (i.e.: folder in which db is located is read-only). When I open it
> from Access, it warns me that the db cannot be modified, bla bla bla.
> I can access the data, but cannot make modifications to the structure
> of the database (add queries, change tables, etc.).
> So... my question is... Did I forget any parameter in the
> sp_addlinkedserver procedure? Anytime I try to use the OpenQuery
> method with this database I get the message
> OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "IVR_post"
> returned message "The Microsoft Jet database engine cannot open the
> file '\\CompletePathAndDatabaseName.mdb'
> . It is already opened exclusively by another user, or you need
> permission to view its data.".
> However, like I said, the same db can be opened with access 2002 from
> the same station, the same user, etc.
>
> exec sp_addlinkedserver @.server='MyServer',
> @.srvproduct='Access',
> @.provider='Microsoft.Jet.OLEDB.4.0',
> @.datasrc='\\CompletePathAndDatabaseName.mdb'
> exec sp_addlinkedsrvlogin @.rmtsrvname='MyServer',
> @.useself='false',
> @.rmtuser='Admin',
> @.rmtpassword=''
>
> Regards,
>sqlsql

Conncting to SQL Server 2005 database

Hi,
I have SQL Server 2000 Client installed on Windows XP and SQL Server
2005 Database on Windows 2003 which is not on domain. I want to access
SQL Server 2005 database from SQL Server2000 Client. When i am trying
to connect it, i get access denied error. Is it possible to connect...?When you say sql server client do you mean query analyser / enterprise
manager. If so no they cant connect to sql 2005.
If you are linking servers then it is possible.
If you have sql 2005 tools and are going to server that is not on the domain
you may need to enable sql authentication on the sql server and connect usin
g
a sql username and password.
Chris
"saurabh.sarode@.gmail.com" wrote:

> Hi,
> I have SQL Server 2000 Client installed on Windows XP and SQL Server
> 2005 Database on Windows 2003 which is not on domain. I want to access
> SQL Server 2005 database from SQL Server2000 Client. When i am trying
> to connect it, i get access denied error. Is it possible to connect...?
>

Confused about reporting feature

I remember reading something about some sort of new feature on SQL Server
2005 regarding adding reporting capabilities to SQL Sever 2005. I am not
sure what it was but I think it had to do with the SQL Server being able to
process a full report request and return the report all ready to print. I
think it was some sort of server reporting engine.
I also noticed that Visual Studio 2005 comes with a control that allows you
to create reports.
My question is, was I smoking crack when I read all this about SQL 2005 new
reporting capabilities? Also, anybody knows if the reporting control that
comes with Visual Studio 2005 is somewhat connected to SQL Server 005?
ThanksSearch and read about "Reporting Services".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rene" <a@.b.c> wrote in message news:uCSIzjQaGHA.508@.TK2MSFTNGP02.phx.gbl...
>I remember reading something about some sort of new feature on SQL Server 2
005 regarding adding
>reporting capabilities to SQL Sever 2005. I am not sure what it was but I t
hink it had to do with
>the SQL Server being able to process a full report request and return the r
eport all ready to
>print. I think it was some sort of server reporting engine.
> I also noticed that Visual Studio 2005 comes with a control that allows yo
u to create reports.
> My question is, was I smoking crack when I read all this about SQL 2005 ne
w reporting
> capabilities? Also, anybody knows if the reporting control that comes with
Visual Studio 2005 is
> somewhat connected to SQL Server 005?
> Thanks
>
>|||On Wed, 26 Apr 2006 03:13:02 -0500, "Rene" <a@.b.c> wrote:

>I remember reading something about some sort of new feature on SQL Server
>2005 regarding adding reporting capabilities to SQL Sever 2005. I am not
>sure what it was but I think it had to do with the SQL Server being able to
>process a full report request and return the report all ready to print. I
>think it was some sort of server reporting engine.
>I also noticed that Visual Studio 2005 comes with a control that allows you
>to create reports.
>My question is, was I smoking crack when I read all this about SQL 2005 new
>reporting capabilities? Also, anybody knows if the reporting control that
>comes with Visual Studio 2005 is somewhat connected to SQL Server 005?
>Thanks
Hi,
You're referring to SQL Server 2005 Reporting Services. Most editions
of SQL Server have some RS functionality.
See
http://www.microsoft.com/sql/prodin...e-features.mspx
for which edtions of SQL Server 2005 have what RS features.
Information about RS is available from
http://www.microsoft.com/sql/techno...ng/default.mspx
and in Books Online.
Andrew Watt [MVP]|||Hi,
look here:
http://www.microsoft.com/sql/techno...ng/default.mspx
The control is for rendering reports also in your other applications
like Windows Forms, rather than *only* in Web projects.-
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--

Configure Web syncronization using RMO or T-Sql

Hi
I have created merge publication using RMO programming on Sql Server
2005 and it will subscribe by Sql Server Mobile Edition.
Publication created successfully and wok fine but I have to Configure
Web synchronization manually instead of RMO programming. (In short
Configuring IIS for web synchronization).
So please any body have idea how to configure IIS for subscription
using RMO programming or any other way except manually follows the
step of configure web synchronization wizard.
Regards
Prakash
You can't. It involves creating a virtual directory, setting the correct
configuration for this (application pool, directory security, etc), putting
the isapi filter in place.
You can use ADSI for some of this, but not RMO or tsql.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"prakash" <patelprakashp@.gmail.com> wrote in message
news:1185804118.102611.31680@.i38g2000prf.googlegro ups.com...
> Hi
> I have created merge publication using RMO programming on Sql Server
> 2005 and it will subscribe by Sql Server Mobile Edition.
> Publication created successfully and wok fine but I have to Configure
> Web synchronization manually instead of RMO programming. (In short
> Configuring IIS for web synchronization).
> So please any body have idea how to configure IIS for subscription
> using RMO programming or any other way except manually follows the
> step of configure web synchronization wizard.
> Regards
> Prakash
>
|||On Aug 1, 5:43 pm, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:[vbcol=seagreen]
> You can't. It involves creating a virtual directory, setting the correct
> configuration for this (application pool, directory security, etc), putting
> the isapi filter in place.
> You can use ADSI for some of this, but not RMO or tsql.
> --
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com"prakash" <patelpraka...@.gmail.com> wrote in message
> news:1185804118.102611.31680@.i38g2000prf.googlegro ups.com...
>
>
Thanks a lots