June 11, 2014 at 6:25 am
I have data in my SQL Server which I want to export into STATA. I am able to view my database in STATA when I use odbc list command but when I click my database is giving me an error. I guess this error is coming about because I have a password for this database. How should I get the data from SQL Server into STATA?
June 11, 2014 at 6:27 am
What is the error?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 11, 2014 at 6:34 am
This is the error I am getting in STATA:
. odbc query "ADJusT"
The ODBC driver reported the following diagnostics
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''.
SQLSTATE=28000
r(682);
June 11, 2014 at 12:12 pm
I have never worked with STATA before, but is there a place somewhere where you can specify credentials?
Or maybe you can specify those in the ODBC connection itself when you define it?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 12, 2014 at 2:22 am
Thanks for your enthusiasm to see this problem solved. I have consulted a colleague who will assist in the next twenty minutes time. I will give you the feedback once its resolved.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy