|
| mssql: using a linked server to hfsql instance |
| Iniciado por guest, 30,nov. 2015 22:30 - 4 respuestas |
| |
| | | |
|
| |
| Publicado el 30,noviembre 2015 - 22:30 |
Hi,
I'm trying to add a so called "linked server" connection from a MSSQL database to a HFSQL database.
Can anyone shine some light on the parameters I have to fill? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 01,diciembre 2015 - 12:02 |
use comma
192.168.1.100,1433 |
| |
| |
| | | |
|
| | |
| |
| Publicado el 01,diciembre 2015 - 13:23 |
CCC
I don't want a link to another sql-server. But one to a Hyperfile sql server.
I tried several settings and Always get an error, saying something like "there is an error".
I also tried using the OLEDB-over-ODBC provider. Which uses an ODBC link I defined using the odbc-options in Windows. This time I did get a valid connection!! I see al table names, unfortunaltely when expanding a table to see the column names another error pops up: "The provider supports the interface but returns an error on DBSCHEMA_COLUMNS"
For the moment I quit using (or trying) odbc and oledb - they seem to wacky to me :sneg: |
| |
| |
| | | |
|
| | |
| |
| Publicado el 03,diciembre 2015 - 04:52 |
Sorry Arie,
I can't get it work, I give up .
the oledb driver is working cause I can retrieve the data from MS Excel |
| |
| |
| | | |
|
| | |
| |
| Publicado el 12,febrero 2016 - 16:56 |
Arie Mars did you get this?
Arie Mars escreveu:
CCC
I don't want a link to another sql-server. But one to a Hyperfile sql server.
I tried several settings and Always get an error, saying something like "there is an error".
I also tried using the OLEDB-over-ODBC provider. Which uses an ODBC link I defined using the odbc-options in Windows. This time I did get a valid connection!! I see al table names, unfortunaltely when expanding a table to see the column names another error pops up: "The provider supports the interface but returns an error on DBSCHEMA_COLUMNS"
For the moment I quit using (or trying) odbc and oledb - they seem to wacky to me :sneg: |
| |
| |
| | | |
|
| | | | |
| | |
|