Re: Access 2003 application with MSDE backend connection error in
- From: "Barb" <Barb@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 22 Apr 2005 07:08:03 -0700
Hi Alex,
I created a UDL file and it works on the other computer with two different
user accounts. So that would mean user permissions aren't an issue. The
other computer is also using the same SPs and MDAC as on my dev machine so
that's not an issue either. The connection only seems to be an issue when
I'm trying to create a connection using my deployed application.
I'd welcome any other ideas you have.
Thanks,
Barb
"Alex Dybenko" wrote:
> Hi,
> not sure that runtime is issue, i guess something with user rights. first
> make sure you have same ADO version on both PCs. then try to make udl file
> and test connection there:
>
> create new file test.udl
> open it, define connection settings
> test connection there
>
> HTH
> --
> Alex Dybenko (MVP)
> http://Alex.Dybenko.com
> http://www.PointLtd.com
>
>
> "Barb" <Barb@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:13197CAB-8C39-49D7-BCD2-884369706601@xxxxxxxxxxxxxxxx
> > Hi there,
> >
> > I've posted a number of places over the past week and haven't gotten a
> > reply
> > so I'll try here.
> >
> > I have an Access 2003 application that uses an MSDE backend. The
> > application
> > works from my developer machine i.e. I can connect to the remote machine
> > on
> > our internal network where the MSDE database is installed. I'm using
> > integrated security. I've created a global SQL group in our domain and
> > added
> > the necessary user accounts to it. I've created a local SQL group on the
> > database machine and the global group to it and granted that local group
> > SQL
> > login rights. I can connect directly to the database using the accounts
> > in
> > the group via a database management tool. I cannot connect to the
> > database
> > using the Access 2003 runtime version from a machine that doesn't have
> > Access
> > 2003 installed (Access 2000 is installed ... would that make a difference
> > if
> > my installation package specifies using Access 2003 runtime?). I'm
> > getting
> > an invalid connection string attribute error when I try to establish a
> > connection to the database using the runtime application. This happens
> > consistently with my own account (which works in the dev environment) and
> > with other accounts that are in the appropriate group.
> >
> > Client OS is Windows XP, database machine is Windows 2000 Server with
> > MSDE2KSP3.
> >
> > Any thoughts?
>
>
>
.
- Follow-Ups:
- Re: Access 2003 application with MSDE backend connection error in
- From: Alex Dybenko
- Re: Access 2003 application with MSDE backend connection error in
- References:
- Prev by Date: Possible to have multiple packages that all point to one Runtime folder during setup?
- Next by Date: Developers submit your programs for beta testing
- Previous by thread: Re: Access 2003 application with MSDE backend connection error in runt
- Next by thread: Re: Access 2003 application with MSDE backend connection error in
- Index(es):
Relevant Pages
|
