Statalist


[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 <kcrow@stata.com>
To   statalist@hsphsun2.harvard.edu
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 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/



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