[dba-VB] SQLBulkCopy error

Charlotte Foust cfoust at infostatsystems.com
Fri Nov 30 12:08:38 CST 2007

Yeah, I would first remove those spaces around the equals signs. I've
run into problems there before.

Charlotte Foust 

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Friday, November 30, 2007 10:03 AM
To: dba-vb at databaseadvisors.com
Subject: Re: [dba-VB] SQLBulkCopy error

Hi John

You probably need to remove either the spaces around the equal signs or
(more likely) the complete Provider entry.


>>> jwcolby at colbyconsulting.com 30-11-2007 18:43 >>>
I have a program that has been running fine which now throws an error:

"Data Source = M90\M90;Initial Catalog = ZipPlus4;Provider =
SQLOLEDB;Integrated Security=SSPI"

claiming Keyword not supported - Provider

This is just a standard connection string, and Provider is a standard

Any thoughts?

John W. Colby
Colby Consulting

dba-VB mailing list
dba-VB at databaseadvisors.com

More information about the dba-VB mailing list