473,378 Members | 1,078 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

"Cannot find member name System.Data.SqlClient.SqlError" when calling the remote component

My webserver calls a component on another server through DCOM, the component
goes to SQL, SQL raises the exception and here is what the client gets:

"Cannot find member name System.Data.SqlClient.SqlError"

I believe the issue is related to the fact that webserver runs the framework
1.1 and the component server has the framework 1.0

There are a number of posting in the different ng on this topic, but I
cannot find a resolution.

One article mentions a security channge in 1.1 and recomends to set
typefilterlevel, but it is related to Remoting, which I don't use.

The sql simply raises an exception and the exception cannot make back to the
client...

Thanks!

-Stan
Jul 21 '05 #1
3 3481
Hi Stan,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you receive exceptions when accessing
components on a remote server. If there is any misunderstanding, please
feel free to let me know.

Generally, in this senario, we use .NET remoting. If you use DCOM, there
will be much interop in it which might hit performance and will cause many
compatibility issues. Also, using different versions of .NET framework
might cause comapatibility issues, too. So could you please also install
.NET framework 1.1 on the component server and use .NET remoting instead?

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Jul 21 '05 #2
Kevin,

Using .Net Remoting is simply not realistic in this scenario since it
requires the massive code changes. Secondly, why should I even do that if it
is a bug?

Will installing 1.1 framework on the server sovle the problem withought
recompiling dlls in 1.1?

The setup is this:

Server: 1.0 serviced components, 1.0 framework
Client: 1.1 framework, ASP.NET

Thanks,

-Stan

"Kevin Yu [MSFT]" <v-****@online.microsoft.com> wrote in message
news:6e**************@cpmsftngxa10.phx.gbl...
Hi Stan,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you receive exceptions when accessing
components on a remote server. If there is any misunderstanding, please
feel free to let me know.

Generally, in this senario, we use .NET remoting. If you use DCOM, there
will be much interop in it which might hit performance and will cause many
compatibility issues. Also, using different versions of .NET framework
might cause comapatibility issues, too. So could you please also install
NET framework 1.1 on the component server and use .NET remoting instead?

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Jul 21 '05 #3
Hi Stan,

It depends on which version of .net framework your application is build on.
Whether it will fix the problem depends on which method throws that
exception. However, I suggest you install .net framework 1.1 to have a try.
Because .NET framework can run side by side. Installing a 1.1 version will
not affect the applications on 1.0.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Jul 21 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: 21novembre | last post by:
Hi all, I made a question several days before to describe my strange trouble of mysqldump. But I still can't figour it out. Well, I just want to ask another question whether I could just backup...
1
by: RWC | last post by:
Hello, I'm getting the error "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data" when I run a report. I'm simply trying to apply the...
0
by: Mr.KisS | last post by:
Hello. I'm under Windows XP PRO SP1, IIS 5.1 ans SQL SERVER 2005 Express. When i try to open a connexion with : <connectionStrings> <add name="AppCnxStr"...
2
by: Mr.KisS | last post by:
Hello. I'm under Windows XP PRO SP1, IIS 5.1 ans SQL SERVER 2005 Express. When i try to open a connexion with : <connectionStrings> <add name="AppCnxStr"...
2
by: Chris Langston | last post by:
I have a Web Server running IIS 5 or 6 on Windows 2K and Windows 2003 Server that is experiencing strange shutdown problems. We are using ASP.NET v1.1 and our application is written in VB.NET ...
0
by: Stan | last post by:
My webserver calls a component on another server through DCOM, the component goes to SQL, SQL raises the exception and here is what the client gets: "Cannot find member name...
5
by: Kevin R | last post by:
I'm trying to update a sql database. It's modified Oledb code from an example that did work with an access database. How can I tweak my code to make it work? Thanks in advance. Kevin...
2
by: athos | last post by:
Dear All, Our project was done in SQL 2000, now we are migrating to 2005. however, there are lots of command such as: a) SELECT * FROM myTableName which, shall be b) SELECT * FROM...
5
by: Chris Botha | last post by:
There is a database table with one of the columns named "System". When creating a new Dataset for this table, the project gives a huge number of compile errors. If I change the column name to be...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.