:)
Hai everybody,

   When trying to select data in sql server 2000 I got this error. Any idea about this?

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

Thanks

HI,

This seems to be apermission related Problem. Check out the lopgin u r using to connect. Which role it belongs too? Does this Login have SELECT Permission on the table u r firing select on. I beleive that u don't have SELECT Permission on table. If u have admin login, u can correct it. If its a matter of production servers then contact ur Admin personnel.

Hope u got my point

B. Anant

Thanks for the reply

There is no problem with select permission. When I removed some fields in the query it is working fine. Problem is with two fields in the select query. These fields are varchar type.

Any Idea about this.

Ghari

Can you post the query that you used to select? Also the structure of the table.

_________________________
- Vijay G
Strive for Perfection

Hi,

I am also experiencing the same problem, Please respond if you come out with a solution.

Sanjoy

Hai,

    Here is the query I am using.

SELECT DISTINCT [Clients].[ClientID], [Clients].[Business-name], [Clients].[xPassword] FROM [Clients] INNER JOIN ([Client Contacts] INNER JOIN [Countries] ON [Countries].Code = [Client Contacts].Code) ON [Clients].[ClientID] = [Client Contacts].[ClientID] WHERE [Clients].[Business-name] LIKE '%abc%' OR [Client Contacts].[First-name] LIKE '%abc%' OR [Client Contacts].[Initials] LIKE '%abc%' OR [Client Contacts].[Surname] LIKE '%abc%' OR [Client Contacts].[Position] LIKE '%abc%' OR [Client Contacts].[Address1] LIKE '%abc%' OR [Client Contacts].[Address2] LIKE '%abc%' OR [Client Contacts].[Address3] LIKE '%abc%' OR [Client Contacts].[Code] LIKE '%abc%' OR [Client Contacts].[Email] LIKE '%abc%' OR [Client Contacts].[Telephone1] LIKE '%abc%' OR [Client Contacts].[Telephone2] LIKE '%abc%' OR [Client Contacts].[Telephone3] LIKE '%abc%' OR [Client Contacts].[Facsimile] LIKE '%abc%' OR [Countries].Country LIKE '%abc%' ORDER BY [Clients].[Business-name]

The fields [Countries].[Code],[Client Contacts].[Code] are varchar type. Is there any problem for joining varchar fields?

It is working fine locally.


Ghari

So when do you face the ACCESS_VIOLATION error? From where are you trying to execute this? What is the frontend that you use to execute this?

_________________________
- Vijay G
Strive for Perfection

   By locally I mean Intranet. When I put this in internet the error happens.

Our Database server is in UK and web server in US. Is it because of some network problem?

Thanks

Ghari

It should be due to network problem. What kind of connectivity you use between the US and UK office/datacenter. Since I am not sure how your network has been configured to access the DB in UK, it wouldn't be easy to suggest on it.

Cheers!

_________________________
- Vijay G
Strive for Perfection

We are now using DSN connection. We also tried the OLEDB Connection, but no use.

Thanks

Ghari