BorlandTalk.com

Ingo Zettl · Guest

Hi!

I'm trying to use an MS SQL Database from a C++ Builder 6/BDE
application.

I created an ODBC datasource that is working fine, I can connect
from BDE Administrator or SQL explorer by manually specifying
user name and password on login. (For some internal reasons
we're required to use SQL server authentication, not windows
authentication and as the ODBC data source can't store
user name and password it's required to specify these at logon).

How can I connect to this database from my application?
My code looks like

database = new TDatabase(0);
database->DatabaseName = "Test-MSSQL";
database->Params->Add("USER NAME=Ingo");
database->Params->Add("PASSWORD=Test");

What I get is

error info: User name or password unknown
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'Ingo'.
Alias: monitoring-mssql

It seems the user specified with "USER NAME" is ok, but
somehow the password is not passed to the ODBC driver.

(When using Windows authentication everything works fine, but
this approach is not possible).

- Does anyone know how to specify the password correctly to open
an ODBC Database?
- Can someone tell me about SQLMSS32.DLL (I suppose this should
be the native BDE driver to MS SQL server) I don't find it on
my machine (BCB6 Pro), is this dll included in BCB6 Ent or
how can I get it?

kind regards

Ingo Zettl