[dba-SQLServer] ODBC Connection error - More Info

Jim Lawrence jlawrenc1 at shaw.ca
Fri Nov 3 10:50:38 CST 2006


Hi John:

Would his password have a special character in it that is not allowed?

Jim 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John
Skolits
Sent: Friday, November 03, 2006 7:10 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] ODBC Connection error - More Info

I'm also getting the following error when trying to run a few queries.

Connection Failed:
SQL State '28000'
Sql Server Error: 18452
{Microssoft][Sql Server Driver][Sql Server]Logon Failed for user '(null)'
Reason: Not associated with a trusted cSql Server Conenction.


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John
Skolits
Sent: Friday, November 03, 2006 9:43 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] ODBC Connection error

I'm having this ODBC connection error that's driving me nuts.

The application  is written in Access 2000. The User's Pc is Access 2003.
MDAC 2.8 is his latest version.

There have been times where the application has run fine, then I make a few
changes and the user can't connect to the tables.
The only way to make it work is to go in an manually relink every table on
his PC. If I do it on my development PC, or any other PC for that matter, he
can't open the tables.

I ran a Pass thru query on his PC with a new DSN I created and a connection
string like:
ODBC;DRIVER=SQL Server;SERVER=otto;UID=User;PWD=User;DATABASE=ssa_erpdb

I then received an error message like :
ODBC error ..... ODBC;DRIVER=SQL Server;SERVER=otto;UID=reports;PWD=repo_'

Notice how it truncated the string.

So it looks like It's a problem on his PC. 

I tried a myriad of things. Is there any Service releases or anything anyone
has heard of that may fix this issue before I spend weeks trying to find a
work around.

John


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com



_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list