Maximum number of characters in DSN name

[Nobody]

What is the maximum number of characters in DSN name? Seems to be 33 (can't
create longer name in Control Panel) but I can't find any "official"
documentation from Microsoft about it.

 

[Rick B]

This is a Microsoft Access newsgroup. Do you have a question related to
Microsoft Access, the database application that is part of Microsoft Office
Professional?

 

[Nobody]

I am trying to create DSN in control panel to connect to MS Access database.
If this is not considered a question related to MS Access - please accept my
deepest apologies.

 

[Nobody]

[Found on Usenet]

SQL_MAX_DSN_LENGTH is defined in sql.h and, indeed, it is 32. There is no
real way to
change it (except to convince MS). Many ODBC drivers depend on it ... for
instance, they
do things like ...

char dsn[SQL_MAX_DSN_LENGTH + 1];

 

[Douglas J Steele]

Why bother with a DSN? See
http://www.accessmvp.com/djsteele/DSNLessLinks.html for an alternative.