|
[VIEWED 13736
TIMES]
|
SAVE! for ease of future access.
|
|
|
|
magorkhe1
Please log in to subscribe to magorkhe1's postings.
Posted on 06-06-16 6:24
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0 
? 
|
| |
We taking a excel- DAX class and files are on dbase. I need to go through query. It could not connect. I think I need a active server.
I have window 7 with 2010 office and trial copy 2016 for DAX (does not run on Mac).
I just looked at the youtube and it showed how to create New Data Source?
ODBC - dBASE files _ added MS odbc for Oracal or I can choose different driver ? driver to microsof dBASE ?
It shows c:\WINDOWS\system\msorcl32.dll not fund when I added Oracle on.
Any suggestion to download and try again? Last edited: 06-Jun-16 08:03 PM
|
| |
|
|
|
|
kanchaa11
Please log in to subscribe to kanchaa11's postings.
Posted on 06-06-16 7:28
PM [Snapshot: 48]
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
Did you try to connect from Excel? If not, here's what I will do based on the info you provided- Open Excel>Data>From Other Sources>From SQL Server and then fill out servername- User Name- Password-
|
| |
|
|
magorkhe1
Please log in to subscribe to magorkhe1's postings.
Posted on 06-06-16 8:13
PM [Snapshot: 86]
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
Couple years ago I used to log on SAP gui . This computer is part of learning project as we do on old cars. I tried to connect as asked on course "msedxeus.database.windows.net" it gives warning "the user was not authorized."
The network location cannot be reached. For information about network troubleshooting, see Windows Help ---------------------------- A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---------------------------- Failed to connect to the server. Reason: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
कमिलालाई मुतको पैरो झैँ भयो है |
Last edited: 06-Jun-16 08:32 PM
Last edited: 06-Jun-16 08:56 PM
|
| |
|
|
mikel
Please log in to subscribe to mikel's postings.
Posted on 06-06-16 10:28
PM [Snapshot: 154]
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
From your computer where you have installed SQL server, Lets do this, 1. Go to sql server configuration manager 2. Sql server network configuration 3. Protocols for MSSQLSERVER there you will see three options, 1. Shared memory 2. Named Pipes 3. TCP IP check if they are disabled, if Named PIPED disabled, enable them, do same thing on SQL Native client 11.0 configuration---Client protocols--- you will see same options as above. Enable Named pipe . ( this is important since you are connecting through ODBC or any external connections. )
|
| |
|
|
magorkhe1
Please log in to subscribe to magorkhe1's postings.
Posted on 06-07-16 5:59
AM [Snapshot: 208]
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
Hi MIkel: can you give me step by step process so I can follow it.
|
| |
|
|
mikal
Please log in to subscribe to mikal's postings.
Posted on 06-07-16 10:25
AM [Snapshot: 291]
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
I just did. Follow above instruction. Where do you have your Database? I means you are trying to connect to the database ( Sql server) where do you have your sql server? On your PC/Laptop? or remotely somewhere ? You need to log in to that machine where you have sql server installed and than follow the steps. Sql server configuration manager will be found if you go on the start menu and search .
|
| |
|
|
A_GuY.
Please log in to subscribe to A_GuY's postings.
Posted on 06-08-16 1:23
PM [Snapshot: 415]
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
good explanation.... we need IT forum too...dont we?
|
| |
|
|
magorkhe1
Please log in to subscribe to magorkhe1's postings.
Posted on 06-08-16 1:40
PM [Snapshot: 423]
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
I re-installed window software to Factory setting on one of the old HP laptop. It has Norton and it is trying to upload it's software but it gives same message" We are unable to communicate with one of our servers. Would you like to attempt to correct this problem by releasing and renewing your IP settings?"
It does not let me query on excel : asking explorer 9 or higher needed. May be it needed Service Pack which is not available on MS site anymore.
Last edited: 08-Jun-16 02:11 PM
|
| |
|
|
mikal
Please log in to subscribe to mikal's postings.
Posted on 06-08-16 2:41
PM [Snapshot: 473]
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
So you are trying to connect to Oracle Database ? I think I lost you. MS SQL database or Oracle Database ?
|
| |
|
|
gone12
Please log in to subscribe to gone12's postings.
Posted on 06-08-16 3:14
PM [Snapshot: 493]
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
how come har chees ko ustad gorkhe leay yeuta SQL db connect garna najaneko ? SAP dekho Nursing, Car dekhi Tax ,housing dekhi Sex har chees ma suggesion diraheko huncha ta Gorkhe lay, acchama lagyo malai la.. Gorkhe lay najaneko kura pani rahecha yo sansar ma :)
|
| |
|
|
magorkhe1
Please log in to subscribe to magorkhe1's postings.
Posted on 06-08-16 4:54
PM [Snapshot: 530]
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
आफ्नो दाजुभाइ लाइ दिने सल्लाह भए पो दश चोटी सोच्नु | गफै त हो नि जति दिए पनि भयो हैन र ?
कम्पुटरमा माउस चलाए पछि अरु केर्ही गर्ने परेन ? Took BASIC and Excel class long time ago in Nepal. Took one C++ class, I did okay but did not continue. I was am happy with accounting but turnover is very high due to outsourcing.
IT तिर लागिएन , दुख को कुरा तेही छ |
Last edited: 08-Jun-16 08:48 PM
|
| |
|
|
magorkhe1
Please log in to subscribe to magorkhe1's postings.
Posted on 06-08-16 8:32
PM [Snapshot: 584]
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
मैले खोजेको कुरा यो हो |
Any youtube I can watch ?
Last edited: 08-Jun-16 08:34 PM
|
| |
|
|
randomguy
Please log in to subscribe to randomguy's postings.
Posted on 06-10-16 5:48
PM [Snapshot: 683]
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
Although I have never used DAX, looking at the screenshot, seems like you are attempting to use your windows credential to connect to windows rather than database as I see windows selected on the left pane. Also with that option selected, unless you are on the same domain as host, not sure if it is going to work with your windows credential. Were you give any username and password? If so, you might want to select Database on left side pane and try the username/password you were given.
|
| |
|
|
magorkhe1
Please log in to subscribe to magorkhe1's postings.
Posted on 06-11-16 7:22
AM [Snapshot: 762]
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
Thank you all. Checking to DataBase and with this Username: ExcelLogin Password: P@ssw0rd Able to retireve the data.
|
| |
|
|
