Re: [ODBC SQL Server Driver]Optional feature not implemented

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 10/27/04 

Date: Wed, 27 Oct 2004 16:13:31 -0500

>I have tried to change the connection string to "Provider=SQLOLEDB.1;
>Password=somepass;Persist Security Info=True;User ID=someID;Data Source=SQLSep"
> but I’ve received this error "[DBNETLIB][ConnectionOpen (Connect()).] SQL Server
>does not exist or access denied".
You should have Catalog = YourServername
in the connectionstring not "Data source"
Let the ConnectionString Wizard build your connection string
(double click on the AdoConnection component then press the build button)

>Can I use an SQLOLEDB Provider over an ODBC
No

> Data Source, defined as a system DSN using a SQL Server driver version
> 2000.80.194.00 (date 8/6/2000)?
>I think the database drivers are those that came with Delphi 7; MDAC 2.7 or 2.8.
>The same query works well with BDE but not with ADO.
If you can't use the Ole db Provender for SQL server with SQL server you have a
serious configuration problem somewhere

>And I would like to ask something else: Can I set the ODBC driver to use only one port,
> or this is possible only with socket programming?
You can configure the ODBC driver for SQL server (at least the one I have) to
use a specific Tcp/IP port. 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com
Quantcast