ADODB vs. ADO.Net Connection

ADODB vs. ADO.Net Connection

Postby 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 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
bwenzlau
 
Posts: 1
Joined: Tue 28 Aug 2007 23:43

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for PostgreSQL