DSN Connections

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Paul S
Posts: 5
Joined: Sat 22 Apr 2006 16:18

DSN Connections

Post by Paul S » Thu 04 May 2006 18:11

Hello,

I have installed the "PostgreSQLDirect .NET Data Provider ver 2.5" and have tested the sample applications that are available. I would also like to test some DSN connections (through the ODBC Data Source Administrator) to Postgres with Microsoft Access and other tools like SQL Server "Linked Servers" that use DSN.

I do not see the PostgreSQLDirect option in the DSN window. Do I need to reference it with some special command to use it?

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 05 May 2006 06:58

PostgreSQLDirect .NET is not ODBC provider. Your intentions are unclear for us. Please specify.

Paul S
Posts: 5
Joined: Sat 22 Apr 2006 16:18

Post by Paul S » Fri 05 May 2006 12:17

I would like to created a SQL Server "Linked Server" by using your "PostgreSQLDirect .NET Data Provider". Is there a way to do that? I would like to connect SQL Server to my Postgres Machine so that I can transfer data between the two. I can use ODBC to do that currently but would like to know if I can use your product to do that instead for increased performance.

My initial thought was to integrate your product through the ODBC settings to get it to work but it might not work that way (from reading your previous reply.)

How can I accomplish this?

Thanks...

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Sat 06 May 2006 09:33

MySQLDirect .NET is a ADO .NET provider. We do not support ODBC.
But we are planning to support Integration Services in the next release.

Post Reply