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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply