ms sql server 2005 db connection?

hankilit · Post by **hankilit** » Tue 22 Mar 2005 00:57

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

Ikar · Post by **Ikar** » Tue 22 Mar 2005 11:51

You should install client for MS SQL 2005. Please search if you have SQLNCLI.DLL file.

hankilit · Post by **hankilit** » Tue 22 Mar 2005 14:07

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

Ikar · Post by **Ikar** » Wed 23 Mar 2005 10:23

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.

hankilit · Post by **hankilit** » Thu 24 Mar 2005 06:25

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.

Ikar · Post by **Ikar** » Thu 24 Mar 2005 09:45

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.

Guest · Post by **Guest** » Wed 30 Mar 2005 05:15

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?

Ikar · Post by **Ikar** » Wed 30 Mar 2005 09:21

This file isn't included into MDAC yet. It is included only in distributive of MS SQL Server 2005 Beta 2.