Thread View: borland.public.cppbuilder.database.ado
4 messages
4 total messages
Started by Glenn
Tue, 05 Jul 2005 20:46
ADO SQL Server Stored Proc problem
Author: Glenn
Date: Tue, 05 Jul 2005 20:46
Date: Tue, 05 Jul 2005 20:46
14 lines
1339 bytes
1339 bytes
I am using an ADO Stored Proc component to connect with a SQL Server Stored Procedure. The Stored Procedure uses 12 parameters - 7 inputs and 5 outputs. The variable types are integers, strings, and DateTimes. The problem is when I attempt to set the "Active" flag to "true" (either in the Editor or Programmatically), an error popup appears with the message: [Microsoft][ODBC SQL Server Driver]Optional feature not implemented Can someone tell me how I find out what "optional feature" it is talking about? Thanks.
Re: ADO SQL Server Stored Proc problem
Author: Viatcheslav V. Vassiliev
Date: Tue, 05 Jul 2005 20:51
Date: Tue, 05 Jul 2005 20:51
35 lines
2361 bytes
2361 bytes
Use native OLEDB provider for MS SQL Server, not OLEDB provider for ODBC sources. Connection string is: Provider=SQLOLEDB;Data Source=<ServerName>;Integrated Security=SSPI;Initial Catalog=<databse>; it is for Windows authentication. For SQL Server authentication, use User ID=<User>;Password=<password>; instead of Integrated Security. //------------------------------------------ Regards, Vassiliev V. V. http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + ADO.Net http://www.oledbdirect.com - The fastest way to access MS SQL Server, MS Jet (Access) and Interbase (through OLEDB) "Glenn" <glenn.lucas@bowebellhowell.com> �������/�������� � �������� ���������: news:42caf1b6$1@newsgroups.borland.com... > > I am using an ADO Stored Proc component to connect with a SQL Server > Stored Procedure. The Stored Procedure uses 12 parameters - 7 inputs and > 5 outputs. The variable types are integers, strings, and DateTimes. > > The problem is when I attempt to set the "Active" flag to "true" > (either in the Editor or Programmatically), an error popup > appears with the message: > > [Microsoft][ODBC SQL Server Driver]Optional feature not > implemented > > Can someone tell me how I find out what "optional feature" it > is talking about? > > Thanks.
Re: ADO SQL Server Stored Proc problem
Author: Glenn
Date: Tue, 05 Jul 2005 20:59
Date: Tue, 05 Jul 2005 20:59
51 lines
2630 bytes
2630 bytes
I don't see the "native OLEDB provider for MS SQL Server". I am using C++Builder 5. Can I still use this provider? Where do I find it? Also, I am using SQL Server authentication. What parameters should I have in my connect string? Thanks, Glenn "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote: >Use native OLEDB provider for MS SQL Server, not OLEDB provider for ODBC >sources. Connection string is: > >Provider=SQLOLEDB;Data Source=<ServerName>;Integrated Security=SSPI;Initial >Catalog=<databse>; > >it is for Windows authentication. For SQL Server authentication, use User >ID=<User>;Password=<password>; instead of Integrated Security. > >//------------------------------------------ >Regards, >Vassiliev V. V. >http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + >ADO.Net >http://www.oledbdirect.com - The fastest way to access MS SQL Server, >MS Jet (Access) and Interbase (through OLEDB) > >"Glenn" <glenn.lucas@bowebellhowell.com> �������/�������� � �������� >���������: news:42caf1b6$1@newsgroups.borland.com... >> >> I am using an ADO Stored Proc component to connect with a SQL Server >> Stored Procedure. The Stored Procedure uses 12 parameters - 7 inputs and >> 5 outputs. The variable types are integers, strings, and DateTimes. >> >> The problem is when I attempt to set the "Active" flag to "true" >> (either in the Editor or Programmatically), an error popup >> appears with the message: >> >> [Microsoft][ODBC SQL Server Driver]Optional feature not >> implemented >> >> Can someone tell me how I find out what "optional feature" it >> is talking about? >> >> Thanks. > >
Re: ADO SQL Server Stored Proc problem
Author: Glenn
Date: Tue, 05 Jul 2005 21:01
Date: Tue, 05 Jul 2005 21:01
51 lines
2638 bytes
2638 bytes
I don't see the "native OLEDB provider for MS SQL Server". I am using C++Builder 5. Can I still use this provider? Where do I find it? Also, I am using SQL Server authentication. What parameters should I have in my connect string? Thanks, Glenn "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote: >Use native OLEDB provider for MS SQL Server, not OLEDB provider for ODBC >sources. Connection string is: > >Provider=SQLOLEDB;Data Source=<ServerName>;Integrated Security=SSPI;Initial >Catalog=<databse>; > >it is for Windows authentication. For SQL Server authentication, use User >ID=<User>;Password=<password>; instead of Integrated Security. > >//------------------------------------------ >Regards, >Vassiliev V. V. >http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + >ADO.Net >http://www.oledbdirect.com - The fastest way to access MS SQL Server, >MS Jet (Access) and Interbase (through OLEDB) > >"Glenn" <glenn.lucas@bowebellhowell.com> �������/�������� � �������� >���������: news:42caf1b6$1@newsgroups.borland.com... >> >> I am using an ADO Stored Proc component to connect with a SQL Server >> Stored Procedure. The Stored Procedure uses 12 parameters - 7 inputs and >> 5 outputs. The variable types are integers, strings, and DateTimes. >> >> The problem is when I attempt to set the "Active" flag to "true" >> (either in the Editor or Programmatically), an error popup >> appears with the message: >> >> [Microsoft][ODBC SQL Server Driver]Optional feature not >> implemented >> >> Can someone tell me how I find out what "optional feature" it >> is talking about? >> >> Thanks. > >
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads