🚀 go-pugleaf

Do not set DefaultDatabase. Open() and Connected = true are the same -
choose one of them. Does your server support integrated security? If not,
use UserID and Password instead of Integrated Security=SSPI.

Try connect to your server at design-time:
Place TADOConnection on the form.
Set LoginPrompt to false.
Double-click on ConnectionString property.
Check Use Connection String.
Press Build.
Choose "Microsoft OLEDB provider for SQL Server".
Set required properties.
Check connection.
Press OK.

You should see a valid connection string that you can use in your code. Most
times you can remove some values from this string.

Press OK again.
Set Connected property of ADOConnection1 to true. If you are connected -
place Connection string into your code. It should work.

If you can not connect from this dialog - check your SQL Server settings.

Regards,
Vassiliev V.V.
http://www.oledbdirect.com

"Aris" <ashokooh@centennialpr.net> �������/�������� � �������� ���������:
news:3cc2ed68$1_2@dnews...
> Many thanks for the suggestion.  But I have done all these and it doesn't
> work   here is my code:
>
>
>
>         ADOConnection1->Connected = false;
>
>         ADOConnection1->LoginPrompt = false;
>
>         ADOConnection1->ConnectOptions = coConnectUnspecified;
>
>         ADOConnection1->ConnectionString =
AnsiString("Provider=SQLOLEDB.1;
>
>                         Integrated Security=SSPI;Persist Security
> Info=False;Initial Catalog=MyDatabase;
>
> Data Source=RXC;");
>
>         ADOConnection1->DefaultDatabase= " MyDatabase";
>
>         ADOConnection1->Open();
>
>         ADOConnection1->Connected = true;
>
>
>
> (RXC is the server name). The error message is by the SQL server
indicating
> that it cannot login to the database MYDatabase.  I am doing everything by
> the book.  Where is the error?
>
> "Aris" <ashokooh@centennialpr.net> wrote in message
news:3cc228d0_2@dnews...
> > I am having difficulty making run-time connection to MS SQL Server 7
> > (SQLOLEDB.1 provider) using ADOConnectionString in BCB5. I need concrete
> > help:  C++ statements showing clearly how to do it.  Will appreciate it
> > greatly.
> >
> > Aris
> >
> >
>
>