Statalist


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

st: Problem with odbc load and long path name


From   "Christian Meyer" <chmeyer@uni-greifswald.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: Problem with odbc load and long path name
Date   Mon, 20 Oct 2008 18:22:22 +0200

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/



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