johnjones7071
New Member
- Joined
- Mar 11, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- MacOS
Hello everyone,
I am looking to link live charts from nba.com onto an Excel Sheet. I have downloaded OBDC and OBDC Manager but I still haven't been able to import any data. To explain further, after downloading OBDC, I went through the OBDC and added the specific nba.com link I wanted under "Actual SQL Server"(not sure if that's the correct topic to sort it under), after I link it and name it I open Excel and go through "data", "new database query", "from database" (with the little wand image next to it), and I see my labeled link for site with the chart I want to import under "System DSN".
**I don't want to delete the above text if its helpful but I think I found my problem (below)**
After I click my link that I named, it asks me for my user and password, I have tried my Excel user/password but it doesn't accept. After a failed attempt, a small screen pops up saying, [ "[Actual][SQL Server] Unknown host machine name. ] Thing is, I was never asked to make an "Actual SQL Server Login". I had to put in my computer password to download the OBDC but that's the only thing I used up until this moment. Did I somehow miss a step of creating a Username and Password for OBDC?
I am looking to link live charts from nba.com onto an Excel Sheet. I have downloaded OBDC and OBDC Manager but I still haven't been able to import any data. To explain further, after downloading OBDC, I went through the OBDC and added the specific nba.com link I wanted under "Actual SQL Server"(not sure if that's the correct topic to sort it under), after I link it and name it I open Excel and go through "data", "new database query", "from database" (with the little wand image next to it), and I see my labeled link for site with the chart I want to import under "System DSN".
**I don't want to delete the above text if its helpful but I think I found my problem (below)**
After I click my link that I named, it asks me for my user and password, I have tried my Excel user/password but it doesn't accept. After a failed attempt, a small screen pops up saying, [ "[Actual][SQL Server] Unknown host machine name. ] Thing is, I was never asked to make an "Actual SQL Server Login". I had to put in my computer password to download the OBDC but that's the only thing I used up until this moment. Did I somehow miss a step of creating a Username and Password for OBDC?
