Page 1 of 1
ms sql server 2005 db connection?
Posted: Tue 22 Mar 2005 00:57
by hankilit
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
Posted: Tue 22 Mar 2005 11:51
by Ikar
You should install client for MS SQL 2005. Please search if you have SQLNCLI.DLL file.
i have a file SQLNCLI.DLL
Posted: Tue 22 Mar 2005 14:07
by hankilit
Ikar wrote:You should install client for MS SQL 2005. Please search if you have SQLNCLI.DLL file.
thanks!
i have a file SQLNCLI.DLL
odbc system DSN "SQL Native Client" drive Append OK.
i am not understand CRSQLConnection1 Properties Values
Posted: Wed 23 Mar 2005 10:23
by Ikar
So you could connect to MS SQL Server 2005, couldn't you?
> i am not understand CRSQLConnection1 Properties Values
You can find a detailed description in the documentation.
Posted: Thu 24 Mar 2005 06:25
by hankilit
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.
Posted: Thu 24 Mar 2005 09:45
by Ikar
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.
Posted: Wed 30 Mar 2005 05:15
by Guest
Ikar 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.
msseql server 2005 database connect
my pc mdac version 2.8
i want microsoft oledb provider for sqlserver connect.
what mdac version?
Posted: Wed 30 Mar 2005 09:21
by Ikar
This file isn't included into MDAC yet. It is included only in distributive of MS SQL Server 2005 Beta 2.