Re: MDAC 2.8 Update Causes Problems

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Med103 (Med103_at_discussions.microsoft.com)
Date: 02/14/05 

Date: Mon, 14 Feb 2005 15:17:06 -0800

Oops I was kind of wondering about that . It doesn't work anyway, but when I
try to use the ODBC Control Panel I get the same error posted above. I also
tried changing users, but it kept giving me an error message Invalid
connection string; connection failed.. Can I just create a new database user
in the enterprise manager and see if I can change it in the connection
string?
Thanks,

"David Gugick" wrote:

> Med103 wrote:
> > I didn't create this site and the only connection string I could find
> > was in the siteserver console DSN=pl_commerce;UID=sa;PWD=dbsa;. Is
> > this the one I need to worry about?
> > Thnaks again,
> > Mike
> >
> Well, the first thing you need to do is change the password on the "sa"
> account (because you posted it to the group).
>
> Then, you should change the connection to use some other user that has
> limited, but sufficient, rights to the underlying database. Better to
> use integrated security in this case instead of SQL Security.
>
> You are using a DSN, which means you are connecting using ODBC (not the
> fastest). It's better to use the native ADO driver for SQL Server.
>
> Go to the server in question and test the ODBC connection from the ODBC
> Control Panel Applet and make sure it works. maybe someone already
> changed the password or the server name changed.
>
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
>

Relevant Pages

  • Re: Alternative to using DSN to connect to database
    ... you have to use .NET ODBC provider. ... Server is NOT optimized. ... Just because of the Admiistrator thinking DSN is easier for him to control ... > Basically my problem is that the ODBC Connection Manager in Control Panel ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Desktop server got somehow disconnected
    ... I can indeed make an ODBC connection. ... This is the output I get from the SQL server setup window after testing the ...
    (microsoft.public.sqlserver.connect)
  • Re: Reading mm datasource
    ... When in Word on my machine, I click on open datasource, pick Connect ... > do not seem to have a specific driver name for the connection string. ... But before you go much further, I hadn't realised you were taking that particular approach to making the connection, and AFAIK the consequence is likely to be that you will be opening your data source, using the "OLE DB Provider for ODBC data sources" which is an approach I know little about but will ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Restrict access to SQL database through ODBC
    ... This situation shows one of the limitations of server security in general. ... If SS is available on the network and clients know a valid account and ... who don't know to put the application name in the connection string. ... > requires access through an ODBC DSN to my SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: I cannot Create an ODBC source for SQL server 2005
    ... My fix was to use Named Pipes - this protocol is supported by default in SQL (check in Server Network Utility) and presto - all is OK. ... We were careful to cancel out of the ODBC DSN wizard, but it evidently was still enough to mess up the connection. ... ID sa and password - SQL Server Error 6: ...
    (microsoft.public.sqlserver.connect)