Using dbExpress to connect to SQL 2000

[MinalMaurice]

Having set up all the parameters to link to an SQL database from either Delphi 7 or Delphi 2005 running on Windows XP Pro, I get an error message

SQL State 42000, SQL Error Code 4060.

Any ideas?

Thanks in advance

 

[lespaul]

a quick google of your error message found this site:

http://cert.uni-stuttgart.de/archive/issforum/2004/08/msg00037.html

including this information for fixing:

To fix this issue, perform the following steps:
1. Select Start->Run.
The Run window appears.
2. Type regedit in the Open box.
The Registry Editor opens.
3. Navigate to the following registry:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\
Services\issSPAppService]
4. Create a new String Value named DependOnService.
5. Give the DependOnService string the following value:
MSSQLSERVER
6. Repeat steps 4 and 5 in the following registry:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\
Services\issSPSenCtlService]


may not be your problem, but it's a place to start,

HTH

leslie

 

[MinalMaurice]

Tried that this morning - no good.

 

[lespaul]

what components are you using to connect to the database?

 

[MinalMaurice]

Delphi 7

I go into dbexpress and set up a TSQL connection that was prepared in dbxconnections, where the parameters work perfectly from ODBC linking to a remote database linked across the internet and receive an error message as below

Delphi 2005

I go into Data Explorer and attempt to set up a MSSQL Connection with the usual parameters

This time the error is titled Borland Data Provider

Either way the error is as follows

Connection Open Failed. SQL State 42000, SQL Error Code: 4060. Cannot open database requested.

From Delphi 2005 I couldn't open an Access Database from my own computer.

There must be some parameters to set up on bdpconnections.

Thanks