Re: Access 2003 application with MSDE backend connection error in
- From: "Alex Dybenko" <alexdyb@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 23 Apr 2005 13:34:43 +0400
Hi,
then something wrong with your ADP i think. So how do you connect to
database exactly? do you get your error in code? what code then?
--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com
"Barb" <Barb@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7630E227-C1D9-4BE9-A62E-10E181DCE2EB@xxxxxxxxxxxxxxxx
> 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?
>>
>>
>>
.
- References:
- Prev by Date: Developers submit your programs for beta testing
- Next by Date: Re: Using Word from Access
- Previous by thread: Re: Access 2003 application with MSDE backend connection error in
- Next by thread: Possible to have multiple packages that all point to one Runtime folder during setup?
- Index(es):
Relevant Pages
|
Loading
