----------------------------------- greenapplesodaex Mon Feb 21, 2005 11:37 am 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 ----------------------------------- greenapplesodaex Tue Feb 22, 2005 12:06 pm ----------------------------------- 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! ----------------------------------- Tony Tue Feb 22, 2005 1:46 pm ----------------------------------- do some field research and try out path length from something reasonable to until it stops working. And you'll have your number :wink: ----------------------------------- greenapplesodaex Tue Feb 22, 2005 1:58 pm ----------------------------------- 149, but i wonder y 149... ----------------------------------- Andy Tue Feb 22, 2005 4:03 pm ----------------------------------- from 0-149, thats 150 characters ----------------------------------- greenapplesodaex Tue Feb 22, 2005 4:31 pm ----------------------------------- 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?