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

[Kevin Crow <kcrow@stata.com>]

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

Christian should email tech-support@stata.com with the Access file (if 
possible), what operating system he is using, and what ODBC driver he is using.

Kevin Crow
StataCorp

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_
> Projekte\EARLINT_2_Projekt4\Patientennachbefragung\Verwaltung"
> odbc load, dialog(complete)dsn("Microsoft
> Access-Datenbank;DBQ=$server\Nachbefragung_Server.mdb")table("Kontaktprotoko
> ll")clear
>
> 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,
>
> Christian
>
>
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>
>
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com 
> Version: 8.0.173 / Virus Database: 270.8.1/1734 - Release Date: 10/20/2008 7:25 AM

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/