Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

String data right truncation SQL state 22001 Expand / Collapse
Author
Message
Posted Thursday, January 26, 2006 9:42 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 27, 2006 12:05 AM
Points: 1, Visits: 1

Hi,
 Am creating a DSN to a SQL server using SQL authentication. I get the following error.

SQL State 22001. SQL server error 0. Microsoft ODBC Driver String data right truncation.

It works fine when the IP address is specified but on specifying the server name this error is encountered. I have included the IP address in the host file also.

Any solution for this.

Thanks

Geeta

 

Post #253954
Posted Thursday, January 26, 2006 10:24 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, October 7, 2013 9:29 AM
Points: 409, Visits: 421

Is it pinging with server name . check your dns is configured properly or not...

 

 

Post #253958
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse