473,326 Members | 2,732 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,326 software developers and data experts.

Creating a SQL adaptor object on a remote server

I have a project on a remote server consisting of a aspx page and a class. When I try to use the fill method of a sqldataadaptor to fill a dataset I get this error - Referenced object has a value of 'Nothing'. This works fine on my local machine. Below is some code to help show what I'm trying to do. I'm thinking permissions but what I have no idea, the project is using Windows Authenitication

Login.aspx cod

Imports PTS.PVBackoffic

Public Class Logi
Inherits System.Web.UI.Pag

Private m_BO As clsBackOffic

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Loa
If Not Page.IsPostBack The
FillEmployees(
End I
End Su

Sub FillEmployees(

m_BO = New clsBackOffic

With cboEmployee
.DataSource = m_BO.GetEmployee
.DataMember = "Employees
.DataTextField = "EmpName
.DataValueField = "OperatorID
.DataBind(
End Wit
End Su

Class Backoffice code routine GetEmployee

Public Function GetEmployees() As DataSe
Dim dstEmployees As New DataSe

Tr
m_adp = New SqlDataAdapte

m_adp.SelectCommand = New SqlCommand("qryGetEmployees", g_cnnPTS

m_adp.Fill(dstEmployees, "Employees") <--- This line gives me the error on the remote server, a local server works fin

Return dstEmployee

Catch ex As Exceptio
'MessageBox.Show(ex.ToString
Finall
If g_cnnPTS.State = ConnectionState.Open The
g_cnnPTS.Close(
End I

If Not m_adp Is Nothing The
m_adp = Nothin
End I
End Tr
End Function
Nov 18 '05 #1
0 1321

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

Similar topics

0
by: Rennie deGraaf | last post by:
I want to create a long-running RMI server, which makes an object available to remote hosts, and does nothing else. However, the server consistently exists with no exception or error after >=60...
0
by: Robert | last post by:
I get these errors when creating a asp .net web application project in VS 2003 on a remote web server: "Microsoft Development Environment The Web was created successfully, but an error occurred...
4
by: Scott Smedley | last post by:
Hi all, I'm trying to write a special adaptor iterator for my program. I have *almost* succeeded, though it fails under some circumstances. See the for-loop in main(). Any pointers/help...
1
by: Tony Johansson | last post by:
Hello! I'm reading about design pattern adaptor in the GOF book and there is something that sounds strange. When you use the adaptor design pattern you have these participants. *Target -...
0
by: Tony Johansson | last post by:
Hello!! This is about the adaptor design pattern. If you use the class adaptor its easy to override. It says an object adaptor makes it harder to override Adaptee behavior. It will require...
0
by: Kent K | last post by:
I have a project on a remote server consisting of a aspx page and a class. When I try to use the fill method of a sqldataadaptor to fill a dataset I get this error - Referenced object has a value of...
1
by: Jim Bayers | last post by:
Our network nazi doesn't want us running a webserver on the server that has a connection to the campus database so we created a remote object that runs as a windows service. The windows service...
2
by: Anson | last post by:
Hello, I would like to clarify something about Remoting Object in .NET. Knowing from MSDN that in order for Remote Object to work, I need 3 components. a) RemotableType object, just like a...
2
by: Julia | last post by:
Hi, Can a Remote object be a WebService as well? i want to able to connect to a remote object either using .NET remoting and HTTP\SOAP so I wonder if I can create a singleton(statefull)...
0
by: Chris | last post by:
I am using CSS adaptors. When I use enen the most basic treeview the SelectedNodeChanged does not fire. Can anyone help, I am totally stuck. I need to use the CSS adaptors to make the site...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.