Discussion:
Need some help with connecting MSSQL Server Express Beta2 to Delphi v7
(too old to reply)
Guest
2004-10-29 12:38:37 UTC
Permalink
I have Delphi v7 Ent. and I wonn to connect to MS SQL Server 2005 express beta 2
Since I'm just beggining in this area I've figured that I need to register database ( in BDE Administrator or SQL Explorer ) with
MSSQL or SQL Native Client or SQL Server driver.
I definitely can't connect to MSSQL with any of these drivers.
Trying to connect over:

***MSSQL driver raises exception:
"Vendor initialization failed. Can not load an IDAPI Service library. File: NTWDBLIB.DLL"

***SQL Native Client:
"Invalid configuration parameter. BDE Error: 12550"

***SQL Server
raises same exception as SQL Native client

I must note that I don't know which user name I should use when trying to connect over any of these drivers.
Also in 'ODBC Administrator', I can't connect to any of drivers.
Exceptions are "...can't connect to SQL Server: server does not exists or access denied..." and "..client could not establish connection..."
'sqlcmd.exe' does not work with any user names I try :sa, admin, sysdba,db_sysadmin, sysadmin, db_owner and I do use same password with each one of them(One i've entered during the installation).

OS: WinXP

Please any suggestions are welcome
Thanks


User submitted from AEWNET (http://www.aewnet.com/)
Viatcheslav V. Vassiliev
2004-10-29 13:11:53 UTC
Permalink
Which components do you use?
Post by Guest
"Invalid configuration parameter. BDE Error: 12550"
Is it BDE?

Try to use ADO. Connection string is the same as for MS SQL Server 2000 but
Provider=SQLNCLI instead of Provider=SQLOLEDB. For example:

Provider=SQLNCLI;Integrated Security=SSPI;Initial catalog=master

Try to connect to master at first. Did you enabled Windows authentication
(for Integrated Security=SSPI)? If not, use user name/password. Later you
will be able to create more databases.

//------------------------------------------
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)
Post by Guest
I have Delphi v7 Ent. and I wonn to connect to MS SQL Server 2005 express beta 2
Since I'm just beggining in this area I've figured that I need to register
database ( in BDE Administrator or SQL Explorer ) with
Post by Guest
MSSQL or SQL Native Client or SQL Server driver.
I definitely can't connect to MSSQL with any of these drivers.
"Vendor initialization failed. Can not load an IDAPI Service library. File: NTWDBLIB.DLL"
"Invalid configuration parameter. BDE Error: 12550"
***SQL Server
raises same exception as SQL Native client
I must note that I don't know which user name I should use when trying to
connect over any of these drivers.
Post by Guest
Also in 'ODBC Administrator', I can't connect to any of drivers.
Exceptions are "...can't connect to SQL Server: server does not exists or
access denied..." and "..client could not establish connection..."
Post by Guest
'sqlcmd.exe' does not work with any user names I try :sa, admin,
sysdba,db_sysadmin, sysadmin, db_owner and I do use same password with each
one of them(One i've entered during the installation).
Post by Guest
OS: WinXP
Please any suggestions are welcome
Thanks
User submitted from AEWNET (http://www.aewnet.com/)
Bill Todd
2004-10-29 14:56:41 UTC
Permalink
Do not use the BDE. It is no longer being developed and the SQL Server
driver uses Microsoft's DBLIB client library which MS has not updated
since SQL Server 6.5. Use the ADO components.
--
Bill (TeamB)
TeamB cannot answer questions received via email
Euan Garden
2004-10-29 17:53:11 UTC
Permalink
In addition to Bills comment about not using DBLIB, and the other comment on
changing the connection string, see if this helps;

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

-Euan
Post by Guest
I have Delphi v7 Ent. and I wonn to connect to MS SQL Server 2005 express beta 2
Since I'm just beggining in this area I've figured that I need to register
database ( in BDE Administrator or SQL Explorer ) with
Post by Guest
MSSQL or SQL Native Client or SQL Server driver.
I definitely can't connect to MSSQL with any of these drivers.
"Vendor initialization failed. Can not load an IDAPI Service library. File: NTWDBLIB.DLL"
"Invalid configuration parameter. BDE Error: 12550"
***SQL Server
raises same exception as SQL Native client
I must note that I don't know which user name I should use when trying to
connect over any of these drivers.
Post by Guest
Also in 'ODBC Administrator', I can't connect to any of drivers.
Exceptions are "...can't connect to SQL Server: server does not exists or
access denied..." and "..client could not establish connection..."
Post by Guest
'sqlcmd.exe' does not work with any user names I try :sa, admin,
sysdba,db_sysadmin, sysadmin, db_owner and I do use same password with each
one of them(One i've entered during the installation).
Post by Guest
OS: WinXP
Please any suggestions are welcome
Thanks
User submitted from AEWNET (http://www.aewnet.com/)
Loading...