dbTalk Databases Forums  

Trouble Trapping SQL Server login errors

comp.database.ms-sqlserver comp.database.ms-sqlserver


Discuss Trouble Trapping SQL Server login errors in the comp.database.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
chris ciotti
 
Posts: n/a

Default Trouble Trapping SQL Server login errors - 02-11-2005 , 07:12 AM






Hi all -

I'm trying to track down why Access (ACC2000) will not throw an error when
the user does not have a login on the SQL server (SQL Server 2000). In the
Form_Load() event, I have the usual On Error GotTo ErrCheck and in ErrCheck,
I have only MsgBox Err.Number. It nevr comes up as Err.Number == 0 yet the
SQL Server has thrown an exception (Err # 18456).

Any ideas?

Thanks,

chris


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.