pgOle without MS SQL Server

  • lifeboy
  • Topic Author
  • Visitor
  • Visitor
13 years 2 months ago #811 by lifeboy
pgOle without MS SQL Server was created by lifeboy
I have a need to run SSMS, connect to a Postgresql server but without having a SQL Server database. Can this be done and how?

Please Log in or Create an account to join the conversation.

More
13 years 2 months ago #812 by Moderator
Replied by Moderator on topic Re: pgOle without MS SQL Server
Yes, it is possible. You will need to configure Linked Server in SSMS as described in the Developer Manual www.pgoledb.com/index.php?option ... wnload&cid [0]=3&Itemid=68.

Please Log in or Create an account to join the conversation.

  • lifeboy
  • Topic Author
  • Visitor
  • Visitor
13 years 2 months ago #813 by lifeboy
Replied by lifeboy on topic Re: pgOle without MS SQL Server
I have a linked server set, but I still have to connect to a MSSQL Server first in SSMS before I can refer to the linked server tables. If I want to the SSMS, but not with a SQL Server at all, how to I connect to a Postgres server using PGNP? At this stage we are still using MSSQL Server but only for the purpose of migrating to Postgres. Once complete, we want to kill the MS SQL Server and only use Postgres, but keep on using SSMS with PGNP. How can we do that?

Similarly, if we and to connect to a Postgres Server using MS Access, but without using ODBC, can we use PGNP for that and again how do we do that?

Please Log in or Create an account to join the conversation.

More
13 years 2 months ago #814 by Moderator
Replied by Moderator on topic Re: pgOle without MS SQL Server
Actually, I have realized that the linked server is working in context of a SQL Server process. It means that SSMS has to connect to a SQL Server to get access to a Postgres linked server.

I'm curious why not use PGAdmin, or a third party utilities like Navicat/ADO Query Tool.

I do not know how to import data into MSAccess via an OLEDB.

Please Log in or Create an account to join the conversation.

  • lifeboy
  • Topic Author
  • Visitor
  • Visitor
13 years 2 months ago #815 by lifeboy
Replied by lifeboy on topic Re: pgOle without MS SQL Server
Using PGAdmin III is fine for administrating the database, but not for end-users having to generate queries beyond simple SELECT queries using a graphic query editor. There is not one single tool on the market that can do what MS Access does when it comes to generating a query using a graphic query editor. Toad comes close, but it's at least 5 times more expensive than Access and much more complex to use. I have personally evaluated every tool I could lay me hands on. This is why I'm here hoping that the PGNP is the solution.

I'm trying to motivate my client to sponsor the additional development of PG Admin III to include UPDATE, INSERT and DELETE as well as nested queries and also the ability to save the layout of a graphic query and load the query back into the editor at a later stage (using an XQL file like Aqua Data Studio does. If they don't want to go that route, it looks like I'm busted.

Is there any possibility to extend the PGNP provider to work without needing a SQL Server? It would be really fantastic if one could connect to a SQL Server "dummy" server, which is actually a Postgres server exposed to SSMS via PGNP. Or some other method.

Please Log in or Create an account to join the conversation.

More
13 years 2 months ago #818 by admin
Replied by admin on topic Re: pgOle without MS SQL Server
Using SSMS for connecting to Postgres is an interesting idea. However, I believe it requires research and development beyond current scope of PGNP project.

Please Log in or Create an account to join the conversation.

Time to create page: 0.156 seconds
Powered by Kunena Forum