Re: ODBC Admin

From: Mike (michael_sarkissian@meei.harvard.edu)
Date: 01/14/03 

From: "Mike" <michael_sarkissian@meei.harvard.edu>
Date: Tue, 14 Jan 2003 10:45:17 -0800

I tried all three datasources with the same result. The
database is inside the domain on a network server; my
network logon has full admin rights to the network (and I
didn't have this problem with Win2K under the exact same
conditions). I tried the file DSN suggestion but the
problem is the password doesn't stay coded in...I wish it
would; the UID does. How does one go about changing the
setting between mixed or integrated authentication mode?

Thanks,

Mike

>-----Original Message-----
>What type of datasource are you trying (User, System,
File) ?
>And, where is the SQL database (local, remote in/outside
domain) ?
>Is it configured for mixed or intergrate authentication
mode ?
>Have you considered a file DSN with the UID and PASSWORD
>parameters coded into it (not a good thing to do) ?
>
>--
>Roger
>
>"Mike" <Michael_Sarkissian@meei.harvard.edu> wrote in
message
>news:38db01c2b8b9$21deb820$cef82ecf@TK2MSFTNGXA08...
>> Hi all,
>>
>> Not sure if this is the right group...but is there any
way
>> I can force ODBC Admin to retain password information in
>> WinXP Pro? I tried to make a new connection to a SQL
>> server...was able to do that with little difficulty.
The
>> only problem is that it won't accept anything but the
SQL
>> permissions attached to the database I'm connected to,
and
>> on top of that it will only remember the username - the
>> password keeps getting dropped. So, every time I try to
>> access that particular database, I'm forced to re-enter
my
>> password - *very* annoying.
>>
>> Is this just another case of Microsoft making everything
>> better, or is there a fix for this problem? I tried
>> applying CompatWS, just in case, and that didn't solve
it.
>>
>> Thanks all for any help!
>>
>> Mike
>
>
>.
>

Relevant Pages

  • Re: Audacity and Gentoo
    ... > Oracle Black Helicopter Base in Antarctica: `Hey, we've got a database, ... available, especially from Australia's ABC national radio network, ... I don't sync it with the computers, ... There's over 5,000 games in that 15 ...
    (uk.comp.os.linux)
  • (no subject)
    ... - LDB locking which a persistent recordset connection fixes ... New format of Access 2000 MDB ... Place backend MDB on the root of the network share rather than several folders down ... Subdatasheets are a new feature in Access 2000 Therefore, you are more likely to notice this behaviour after you convert a database from an earlier version. ...
    (comp.databases.ms-access)
  • Re: Replication/Sychronization and security
    ... When put on the network it takes several seconds for those close to ... I am told that our network drives are for data storage (word/excel ... explore the possiblity of replication as a solution. ... >> database to decrease the potential for breach. ...
    (microsoft.public.access.replication)
  • Re: Remote data entry solution needed for Access 2007
    ... Users open the database remotely and use its forms to enter data. ... Why it doesn't work: network lag time. ... our network admin says our Citrix server is 2000 and ... HTML-based form working with an ASP file to send data to the database. ...
    (microsoft.public.access.externaldata)
  • Re: Database Performance Problem between 3:00PM and 4:00PM
    ... where by database becomes extremely slow between 3:00PM and 4:00PM. ... When one looks at CPU Usage, Memory Usage and Disk Usage nothing ... FRom the beginning we suspected Network to be an issue, ... Is it possible that an Oracle backup job, export, or ...
    (comp.databases.oracle.server)