Computer Science Canada

max path length for odbc databases

Author:  greenapplesodaex [ Mon Feb 21, 2005 11:37 am ]
Post subject:  max path length for odbc databases

does anyone know the max PATH (not just file name) length for a database that's included in the odbc? i think it's 254, can anyone find some doc on this? thanx

Author:  greenapplesodaex [ Tue Feb 22, 2005 12:06 pm ]
Post subject: 

um... bump? lol sorry guys, but i really cant find anything on this.
in control panel -> admin tools -> ODBC, under the user DSN tab, if you try to add an entry with super long file path (name+path), it wont add it. looks like the limit is 140 characters, but that's a weird number for the upper limit... can anyone verify this for me, please? thanx lot!

Author:  Tony [ Tue Feb 22, 2005 1:46 pm ]
Post subject: 

do some field research and try out path length from something reasonable to until it stops working. And you'll have your number Wink

Author:  greenapplesodaex [ Tue Feb 22, 2005 1:58 pm ]
Post subject: 

149, but i wonder y 149...

Author:  Andy [ Tue Feb 22, 2005 4:03 pm ]
Post subject: 

from 0-149, thats 150 characters

Author:  greenapplesodaex [ Tue Feb 22, 2005 4:31 pm ]
Post subject: 

no i mean, i copied the path, the filename, throw them in word and counted with it, 149, plus the null, 150, but y is it not 255 or something like that? y 150?


: