Page 1 of 1

ADODB vs. ADO.Net Connection

Posted: Tue 28 Aug 2007 23:52
by 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

Posted: Wed 29 Aug 2007 06:43
by Alexey
PostgreSQLDirect .NET is based upon ADO.NET technology, so you should use .NET Framework to work with it.