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