[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Problem with odbc load and long path name

From   Kevin Crow <>
Subject   Re: st: Problem with odbc load and long path name
Date   Mon, 20 Oct 2008 16:12:14 -0500

Christian was getting the error "dsn() required" when using -odbc load- with a long path.

Christian should email with the Access file (if possible), what operating system he is using, and what ODBC driver he is using.

Kevin Crow

Christian Meyer wrote:
Hallo all,

I like to import data from an MSAccess database to process these data with
stata/MP 10.0 for windows. I used the following command which did not work
(error message “dsn() requiredr(198)”) :
global server "W:\alle\Projekte\EARLINT\EARLINT_
odbc load, dialog(complete)dsn("Microsoft

Everything was fine if I use a shorter path with the same number of
subdirectories or if I open a stata file with “use
"$server\T0_Patienten.dta" ,clear”. Removing the blank in the path did not
change anything.
Any comment is very welcome!

Many thanks for your help,


*   For searches and help try:


No virus found in this incoming message.
Checked by AVG - Version: 8.0.173 / Virus Database: 270.8.1/1734 - Release Date: 10/20/2008 7:25 AM

*   For searches and help try:

© Copyright 1996–2015 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index