jwcolby
jwcolby at colbyconsulting.com
Fri Nov 30 13:22:06 CST 2007
Hmm... well the bulkcopy itself works fine if I remove the provider keyword. 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 Eric Barro Sent: Friday, November 30, 2007 2:13 PM To: dba-vb at databaseadvisors.com Subject: Re: [dba-VB] SQLBulkCopy error Check that the Windows account you are using has the correct security privileges. -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, November 30, 2007 10:44 AM To: dba-vb at databaseadvisors.com Subject: Re: [dba-VB] SQLBulkCopy error 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 _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.16.10/1160 - Release Date: 11/29/2007 8:32 PM _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com