on 08-18-2015 2:01 PM
Hello,
I hope you can help me, I have to link my server MSSQL to my server HANA, so configure SMART DATA ACCESS on my server HANA, followed all the instructions of all tutorials and guides that I found, I worked after several tries, but only I can see the base of my MSSQL master data.
I hope you can help me.
Hola,
Espero me puedan ayudar, tengo que vincular mi servidor MSSQL a mi servidor HANA, por lo que configure SMART DATA ACCESS en mi servidor HANA, segui todas las intrucciones de todos los tutoriales y guias que encontre, me funciono despues de varios intentos, pero solo puedo visualizar la base de datos master de mi MSSQL.
Espero me puedan ayudar.
I found my mistake, odbc.ini file creation should further Agragar a line that indicates which database engine SQL I wanted to connect.
***** ****** ODBC.INI
Driver = [Route Driver]
Server = [MSSQL IP Address]
Port = 1433
Database = [my database]
Thank you for your help
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What else do you expect to see?
Does the user account that you used for SDA have the required permission on MS SQL Server-side to see the data you are looking for?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.