I'm working on a project where I need to pull data from an Open Database Connectivity interface for the first time.
I have run into an unfamiliar problem while using odbc load.
If I open Stata and immediately run a do-file that uses this command, I get the error message r(198) / dsn() or connectionstring() required.
However, if I open Stata and use the drop down menus to do a single import "by hand" and THEN run exactly the same do-file, I don't get the error message.
Somehow I am sending some information (I guess about the dsn or connectionstring!) that isn't there in my do-file, even though as far as I can tell the commands are identical - I copied and pasted a command that appeared after I used the drop menus into my do-file.
Does anyone have any idea what might be going on? I'm guessing the fix is to further specify the odbc command?
I have run into an unfamiliar problem while using odbc load.
If I open Stata and immediately run a do-file that uses this command, I get the error message r(198) / dsn() or connectionstring() required.
However, if I open Stata and use the drop down menus to do a single import "by hand" and THEN run exactly the same do-file, I don't get the error message.
Somehow I am sending some information (I guess about the dsn or connectionstring!) that isn't there in my do-file, even though as far as I can tell the commands are identical - I copied and pasted a command that appeared after I used the drop menus into my do-file.
Does anyone have any idea what might be going on? I'm guessing the fix is to further specify the odbc command?
