Board index » delphi » Windows 2000, SQL Server 2000 and ADO Problem?

Garry

Delphi Developer
Sun, 27 Jun 2004 07:04:54 GMT

Windows 2000, SQL Server 2000 and ADO Problem?

Hello,

We have an application dev. in Delphi 5 that operates fine in Win. 95-98
using both ADO SQL 7-2000.

However when we try to run the app in Windows 2000 using ADO SQL 2000 on
both the server and the desktop.

We get the following error message "Cannot open database requested login
fails". We think its an ADO problem?

Any ideas?

 
Alain Quesne

Delphi Developer
Sun, 27 Jun 2004 11:00:26 GMT

Re:Windows 2000, SQL Server 2000 and ADO Problem?


What kind of security are you using? (SQL Server authentication or
Integrated NT Security)

--

Alain Quesnel
cinqsanss...@compuserve.com

Quote
"Garry" <gar...@inhousepension.com> wrote in message

news:3c3b7a86_1@dnews...
Quote

> Hello,

> We have an application dev. in Delphi 5 that operates fine in Win. 95-98
> using both ADO SQL 7-2000.

> However when we try to run the app in Windows 2000 using ADO SQL 2000 on
> both the server and the desktop.

> We get the following error message "Cannot open database requested login
> fails". We think its an ADO problem?

> Any ideas?

Garr

Delphi Developer
Mon, 28 Jun 2004 01:45:52 GMT

Re:Windows 2000, SQL Server 2000 and ADO Problem?


SQL Server authentication.

Quote
"Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message

news:3c3bb29f$1_1@dnews...
Quote
> What kind of security are you using? (SQL Server authentication or
> Integrated NT Security)

> --

> Alain Quesnel
> cinqsanss...@compuserve.com

> "Garry" <gar...@inhousepension.com> wrote in message
> news:3c3b7a86_1@dnews...

> > Hello,

> > We have an application dev. in Delphi 5 that operates fine in Win. 95-98
> > using both ADO SQL 7-2000.

> > However when we try to run the app in Windows 2000 using ADO SQL 2000 on
> > both the server and the desktop.

> > We get the following error message "Cannot open database requested login
> > fails". We think its an ADO problem?

> > Any ideas?

Alain Quesne

Delphi Developer
Mon, 28 Jun 2004 01:53:13 GMT

Re:Windows 2000, SQL Server 2000 and ADO Problem?


Are you using a TADOConnection component? It is difficult to answer with the
little information you gave us. How does your application try to log on? Is
the user prompted to supply username and password?

--

Alain Quesnel
cinqsanss...@compuserve.com

Quote
"Garry" <gar...@inhousepension.com> wrote in message

news:3c3c813a_2@dnews...
Quote
> SQL Server authentication.

> "Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message
> news:3c3bb29f$1_1@dnews...
> > What kind of security are you using? (SQL Server authentication or
> > Integrated NT Security)

> > --

> > Alain Quesnel
> > cinqsanss...@compuserve.com

> > "Garry" <gar...@inhousepension.com> wrote in message
> > news:3c3b7a86_1@dnews...

> > > Hello,

> > > We have an application dev. in Delphi 5 that operates fine in Win.
95-98
> > > using both ADO SQL 7-2000.

> > > However when we try to run the app in Windows 2000 using ADO SQL 2000
on
> > > both the server and the desktop.

> > > We get the following error message "Cannot open database requested
login
> > > fails". We think its an ADO problem?

> > > Any ideas?

Garr

Delphi Developer
Mon, 28 Jun 2004 20:22:20 GMT

Re:Windows 2000, SQL Server 2000 and ADO Problem?


Thanks Alain,

We are using TADOConnection and TADODataSet components.

The following connection string was used for a database named PEN_ASSIST
and server named  PBPFRS01:

  ADOConnect.Connectionstring :=
       'Provider=SQLOLEDB.1;Persist Security Info=False;' +
       'User ID=sa;Initial Catalog=PEN_ASSIST;Data Source=PBPFRS01';

Quote
"Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message

news:3c3c83c2_2@dnews...
Quote
> Are you using a TADOConnection component? It is difficult to answer with
the
> little information you gave us. How does your application try to log on?
Is
> the user prompted to supply username and password?

> --

> Alain Quesnel
> cinqsanss...@compuserve.com

> "Garry" <gar...@inhousepension.com> wrote in message
> news:3c3c813a_2@dnews...
> > SQL Server authentication.

> > "Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message
> > news:3c3bb29f$1_1@dnews...
> > > What kind of security are you using? (SQL Server authentication or
> > > Integrated NT Security)

> > > --

> > > Alain Quesnel
> > > cinqsanss...@compuserve.com

> > > "Garry" <gar...@inhousepension.com> wrote in message
> > > news:3c3b7a86_1@dnews...

> > > > Hello,

> > > > We have an application dev. in Delphi 5 that operates fine in Win.
> 95-98
> > > > using both ADO SQL 7-2000.

> > > > However when we try to run the app in Windows 2000 using ADO SQL
2000
> on
> > > > both the server and the desktop.

> > > > We get the following error message "Cannot open database requested
> login
> > > > fails". We think its an ADO problem?

> > > > Any ideas?

Alain Quesne

Delphi Developer
Mon, 28 Jun 2004 23:41:58 GMT

Re:Windows 2000, SQL Server 2000 and ADO Problem?


I see in your connection string that you are using "sa" as a user. For a
"final" release, I would suggest getting rid of that. Also, your server name
(" DAta Source") and database name ("Initial Catalog") are hard coded into
the connection string. You might want to make those variables, in case you
change the location and/or name of your database at a client location (the
name of the server is likely to change).

Is TADOConnection.LoginPrompt set to False?

--

Alain Quesnel
cinqsanss...@compuserve.com

Quote
"Garry" <gar...@inhousepension.com> wrote in message

news:3c3d86e5$1_1@dnews...
Quote
> Thanks Alain,

> We are using TADOConnection and TADODataSet components.

> The following connection string was used for a database named PEN_ASSIST
> and server named  PBPFRS01:

>   ADOConnect.Connectionstring :=
>        'Provider=SQLOLEDB.1;Persist Security Info=False;' +
>        'User ID=sa;Initial Catalog=PEN_ASSIST;Data Source=PBPFRS01';

> "Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message
> news:3c3c83c2_2@dnews...
> > Are you using a TADOConnection component? It is difficult to answer with
> the
> > little information you gave us. How does your application try to log on?
> Is
> > the user prompted to supply username and password?

> > --

> > Alain Quesnel
> > cinqsanss...@compuserve.com

> > "Garry" <gar...@inhousepension.com> wrote in message
> > news:3c3c813a_2@dnews...
> > > SQL Server authentication.

> > > "Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message
> > > news:3c3bb29f$1_1@dnews...
> > > > What kind of security are you using? (SQL Server authentication or
> > > > Integrated NT Security)

> > > > --

> > > > Alain Quesnel
> > > > cinqsanss...@compuserve.com

> > > > "Garry" <gar...@inhousepension.com> wrote in message
> > > > news:3c3b7a86_1@dnews...

> > > > > Hello,

> > > > > We have an application dev. in Delphi 5 that operates fine in Win.
> > 95-98
> > > > > using both ADO SQL 7-2000.

> > > > > However when we try to run the app in Windows 2000 using ADO SQL
> 2000
> > on
> > > > > both the server and the desktop.

> > > > > We get the following error message "Cannot open database requested
> > login
> > > > > fails". We think its an ADO problem?

> > > > > Any ideas?

Other Threads

1. ADO Refresh with Ado Table and ADO Query on a network application with SQL Server 2000

2. Controlling of Cache with SQL Server 7 and Delphi on Windows 2000 server

3. windows 2000 server to connect SQL server 6.5

4. Upgrade from Access 2000 to SQL Server 2000 - table values are padded with spaces

5. SQL server 2000 SQL problem - TOP doesn't work

6. ADO + SQL SERVER 2000

7. Error with Win2000, SQL Server 2000 and ADO

8. Delphi 5 - ADO - MS SQL Server 2000

9. ADO connection to SQL Server 2000

10. SQL SERVER 2000 + triggers + ADO = ????