Hi:
I have several SQL files, and since I have little experience using MySQL I would like to read them/convert them into Stata.
My setup:
- Win 7 x64 computer
- Stata 12.1 MP
- StatTransfer v12
- installed both the 32- and 64-bit MySQL drivers (http://dev.mysql.com/downloads/connector/odbc)
My first instinct was to use StatTransfer. When I select Input File Type: ODBC Data Source. ODBC Data Source: <my name> - MySQL ODBC 5.3 ANSI Driver, I was unable to see how I could actually select one of my SQL files. I contacted StatTransfer and they were not at all helpful.
I next tried Stata but am not having any luck. I saw these two helpful posts but I was not able to get their instructions to work:
http://www.andrewdyck.com/connect-to...e-using-stata/
http://statadaily.ikonomiya.com/2011...rst-encounter/
For example using the first source I get:
. local db "DRIVER={MySQL ODBC 5.3 ANSI Driver};SERVER=localhost
invalid syntax
r(198);
I am pretty sure that I am doing something wrong with configuring the ODBC connection. I followed the instructions here:
https://www.youtube.com/watch?v=K3GZidOwGmM
When I am at the Administrative Tools > ODBC Data source > Add Data source step of the video (around 1:46 of the video). When I hit test I get the error listed in my attachment:

If anyone has any suggestions for what I am doing wrong please let me know. I apologize this is probably a very basic question but I have been struggling with this all day with no luck.
Thanks,
Josh
I have several SQL files, and since I have little experience using MySQL I would like to read them/convert them into Stata.
My setup:
- Win 7 x64 computer
- Stata 12.1 MP
- StatTransfer v12
- installed both the 32- and 64-bit MySQL drivers (http://dev.mysql.com/downloads/connector/odbc)
My first instinct was to use StatTransfer. When I select Input File Type: ODBC Data Source. ODBC Data Source: <my name> - MySQL ODBC 5.3 ANSI Driver, I was unable to see how I could actually select one of my SQL files. I contacted StatTransfer and they were not at all helpful.
I next tried Stata but am not having any luck. I saw these two helpful posts but I was not able to get their instructions to work:
http://www.andrewdyck.com/connect-to...e-using-stata/
http://statadaily.ikonomiya.com/2011...rst-encounter/
For example using the first source I get:
. local db "DRIVER={MySQL ODBC 5.3 ANSI Driver};SERVER=localhost
invalid syntax
r(198);
I am pretty sure that I am doing something wrong with configuring the ODBC connection. I followed the instructions here:
https://www.youtube.com/watch?v=K3GZidOwGmM
When I am at the Administrative Tools > ODBC Data source > Add Data source step of the video (around 1:46 of the video). When I hit test I get the error listed in my attachment:
If anyone has any suggestions for what I am doing wrong please let me know. I apologize this is probably a very basic question but I have been struggling with this all day with no luck.
Thanks,
Josh
Comment