0

I have an issue regarding an dblink that our client ask us to do.

  1. Postgres + postgis
  2. SQL Server 2008

We will need to have an dblink on (2) that connects to (1) via dblink but the problem is with the odbc that does not support the GIS part.

Is there any other way to make this dblink ?

Thank you all

Improve this question
2
  • I'm quite surprised to hear that the ODBC link fails on the GIS portion...could you describe a bit more on the GIS over ODBC fail?..what are you doing, is there actual error text you could share? I think you might have to use a function from the PostGIS contribs to convert it into something MS can understand and then read it over ODBC from there. Commented Dec 28, 2011 at 20:13
  • Well, meanwhile i've found that possible solution. Hope that it does the job because odbc usually is not very fast and this project works with data that has to be available immediately. Thank you for your suggestion ( now i'm more sure in what to do ). Thanks Commented Dec 29, 2011 at 17:08

1 Answer 1

Reset to default
1

Check dbi-link, it can cannect to everything :)

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

Correct me if i'm wrong but your suggestion its to connect from POSTGRESL to another database? That is ok for me because i need it, but imagine that i need to connect from SQL SERVER to Postgresql ? Thank you
Yes, dbi-link works from Postgres. As for connecting from SQL Server to Postgres, I have no idea.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.