ms sql server 2005 db connection?
ms sql server 2005 db connection?
hi!
my development environment
delphi 7.0 enterprise (build 8.1)
crsqlconnection (version 2.50.40)
ms sql server 2005 express beta2
i want "ms sql server 2005 db connection" .
New version features:
- Delphi 2005 support added
- Support for MS SQL Server 2005 added
- Performance improved for executing prepared SP returning cursor
- Known bugs fixed
my development environment
delphi 7.0 enterprise (build 8.1)
crsqlconnection (version 2.50.40)
ms sql server 2005 express beta2
i want "ms sql server 2005 db connection" .
New version features:
- Delphi 2005 support added
- Support for MS SQL Server 2005 added
- Performance improved for executing prepared SP returning cursor
- Known bugs fixed
i have a file SQLNCLI.DLL
thanks!Ikar wrote:You should install client for MS SQL 2005. Please search if you have SQLNCLI.DLL file.
i have a file SQLNCLI.DLL
odbc system DSN "SQL Native Client" drive Append OK.
i am not understand CRSQLConnection1 Properties Values
Ikar wrote:So you could connect to MS SQL Server 2005, couldn't you?
You can find a detailed description in the documentation.
object CRSQLConnection1: TCRSQLConnection
ConnectionName = 'SQLServerConnection'
DriverName = 'SQLServer'
GetDriverFunc = 'getSQLDriverSQLServer'
LibraryName = 'dbexpsda.dll'
LoadParamsOnConnect = True
Params.Strings = (
'BlobSize=-1'
'HostName=st10\sql2005'
'DataBase=asss'
'DriverName=SQLServer'
'User_Name=sa'
'Password=****'
'LongStrings=True'
'EnableBCD=True'
'FetchAll=True')
VendorLib = 'SQLNCLI.DLL' Left = 280
Top = 48
end
crsqlconnection1.active := true;
this error Message
Sql Server error [DBNETLIB] [ConnectionOpen(Connect())]
Sql Server Not Found or Not Access.
msseql server 2005 database connectIkar wrote:Could you establish a connection from ADO?
> VendorLib = 'SQLNCLI.DLL'
VendorLib is not needed to be modified as this parameter has no influence.
Necessary client is chosen automatically from available at the system.
my pc mdac version 2.8
i want microsoft oledb provider for sqlserver connect.
what mdac version?