ADODB vs. ADO.Net Connection

[bwenzlau]

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 PostgreSQLDirect.net 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.

Thanks,

Bob

[Alexey]

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