[dba-VB] SQLBulkCopy error

jwcolby jwcolby at colbyconsulting.com
Fri Nov 30 12:43:33 CST 2007


That's not it. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Friday, November 30, 2007 1:09 PM
To: dba-vb at databaseadvisors.com
Subject: Re: [dba-VB] SQLBulkCopy error

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.

/gustav

>>> 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
keyword.

Any thoughts?

John W. Colby
Colby Consulting
www.ColbyConsulting.com 



_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com


_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com




More information about the dba-VB mailing list