ADODB vs. ADO.Net Connection

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Posts: 1
Joined: Tue 28 Aug 2007 23:43

ADODB vs. ADO.Net Connection

Post by bwenzlau » Tue 28 Aug 2007 23:52

I am familiar with ADODB connections with vbScript and their use between SQL 2005 at text files. In order to use Postgis through Postgres, I now need to migrate data from SQL2005 to Postgres. As SSIS will not work, I would apply vbScript and Insert statements.

It is unclear to me whether will assist in building a connection string within vbScript, and if such a connection string is built through the ADODB process?

Is there an alternate connection string, and object that I call up to work with the Postgres tool.



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

Post by Alexey » Wed 29 Aug 2007 06:43

PostgreSQLDirect .NET is based upon ADO.NET technology, so you should use .NET Framework to work with it.

Post Reply