VS.Net Win Forms app - cannot access SQLServer with one computer

D

dbuchanan

I have a Windows Forms application that accesses SQL Server 2k from a
small local network. The application has been used for weeks on other
systmes but a new install on a new machine retruns errors.

The machine is a new laptop Windows XP Pro SP2

The machine is up to date with respect to the dot net framework.
Details:
Dot Net Framework ver. 1.0.3705 is installed
Dot Net Framework ver. 1.1.4322 is installed
Dot Net Framework HotFix KB886903 is installed

The computer is connected to the network wirelessly, but then other
computers are too. This computer has an excellent connection.

The user has all the appropriate permissions to the network and the
database and otherwise has no other issues with that system.

I have installed the application more than once. All the files are
present.

Application behavior:
The menu form opens, but with the righthand side of the form missing
(about 1/4th) and the bottom of the form missing (about 1/4th). I am
able to access buttons to other forms.

The forms that don't require database access open just fine. Forms that
require access to the database fail. There are two different errors
encountered

A "FileNotFoundExection" error is returned by a form that requires a
referenced dll. The dll is installed with the application into the same
folder. (Other computer installations have no problems referencing this
file.)

A " The ConnectionString property has not been initialized" error is
returned by all other forms that require database access. The
connection string is located in the standard configuration file.
(Again, other computers have never had problems accessing the
connection string form the configuration file.

What could be the problem? where should I look next?

Thank you,
dbuchanan

Below are the exceptions.

************** Exception Text **************
System.IO.FileNotFoundException: File or assembly name
MSDNTextboxValidator, or one of its dependencies, was not found.
File name: "MSDNTextboxValidator"
at CLIP.f010Jobs.InitializeComponent()
at CLIP.f010Jobs..ctor()
at CLIP.f000Menu.btnManageJobs_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons
button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32
msg, IntPtr wparam, IntPtr lparam)

=== Pre-bind state information ===
LOG: DisplayName = MSDNTextboxValidator, Version=1.0.2066.17453,
Culture=neutral, PublicKeyToken=null
(Fully-specified)
LOG: Appbase = C:\Documents and Settings\kdylus\Desktop\
LOG: Initial PrivatePath = NULL
Calling assembly : CLIP, Version=1.1.1.20878, Culture=neutral,
PublicKeyToken=null.
===

LOG: Policy not being applied to reference at this time (private,
custom, partial, or location-based assembly bind).
LOG: Post-policy reference: MSDNTextboxValidator,
Version=1.0.2066.17453, Culture=neutral, PublicKeyToken=null
LOG: Attempting download of new URL file:///C:/Documents and
Settings/kdylus/Desktop/MSDNTextboxValidator.DLL.
LOG: Attempting download of new URL file:///C:/Documents and
Settings/kdylus/Desktop/MSDNTextboxValidator/MSDNTextboxValidator.DLL.
LOG: Attempting download of new URL file:///C:/Documents and
Settings/kdylus/Desktop/MSDNTextboxValidator.EXE.
LOG: Attempting download of new URL file:///C:/Documents and
Settings/kdylus/Desktop/MSDNTextboxValidator/MSDNTextboxValidator.EXE.



************** Loaded Assemblies **************
mscorlib
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll
----------------------------------------
CLIP
Assembly Version: 1.1.1.20878
Win32 Version: 1.1.1.20878
CodeBase:
file:///C:/Documents%20and%20Settings/kdylus/Desktop/CLIP.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll
----------------------------------------
System
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll
----------------------------------------
System.Drawing
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 7.0.5000.0
Win32 Version: 7.10.6001.4
CodeBase:
file:///c:/windows/assembly/gac/microsoft.visualbasic/7.0.5000.0__b03f5f7f11d50a3a/microsoft.visualbasic.dll
----------------------------------------
System.Data
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/assembly/gac/system.data/1.0.5000.0__b77a5c561934e089/system.data.dll
----------------------------------------
System.Xml
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll
----------------------------------------


====================================

************** Exception Text **************
System.InvalidOperationException: The ConnectionString property has not
been initialized.
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection
connection, ConnectionState& originalState)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data,
Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand
command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String
srcTable)
at CLIP.f080Stup.LoadDataSet()
at CLIP.f080Stup.Form_Load(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean
fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32
msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll
----------------------------------------
CLIP
Assembly Version: 1.1.1.20878
Win32 Version: 1.1.1.20878
CodeBase:
file:///C:/Documents%20and%20Settings/kdylus/Desktop/CLIP.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll
----------------------------------------
System
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll
----------------------------------------
System.Drawing
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 7.0.5000.0
Win32 Version: 7.10.6001.4
CodeBase:
file:///c:/windows/assembly/gac/microsoft.visualbasic/7.0.5000.0__b03f5f7f11d50a3a/microsoft.visualbasic.dll
----------------------------------------
System.Data
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/assembly/gac/system.data/1.0.5000.0__b77a5c561934e089/system.data.dll
----------------------------------------
System.Xml
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll
----------------------------------------
 
J

Jerry Spivey

Let's make it a little easier. Can the client see the SQL Server machine?
Can any client apps on the machine access the SQL Server? i.e., tables?
Can you create a DSN 'Test Connection' - does this work?

HTH

Jerry
 
R

Ralph

dbuchanan said:
I have a Windows Forms application that accesses SQL Server 2k from a
small local network. The application has been used for weeks on other
systmes but a new install on a new machine retruns errors.

The machine is a new laptop Windows XP Pro SP2

The machine is up to date with respect to the dot net framework.
Details:
Dot Net Framework ver. 1.0.3705 is installed
Dot Net Framework ver. 1.1.4322 is installed
Dot Net Framework HotFix KB886903 is installed

The computer is connected to the network wirelessly, but then other
computers are too. This computer has an excellent connection.

The user has all the appropriate permissions to the network and the
database and otherwise has no other issues with that system.

I have installed the application more than once. All the files are
present.

Application behavior:
The menu form opens, but with the righthand side of the form missing
(about 1/4th) and the bottom of the form missing (about 1/4th). I am
able to access buttons to other forms.

The forms that don't require database access open just fine. Forms that
require access to the database fail. There are two different errors
encountered

A "FileNotFoundExection" error is returned by a form that requires a
referenced dll. The dll is installed with the application into the same
folder. (Other computer installations have no problems referencing this
file.)

A " The ConnectionString property has not been initialized" error is
returned by all other forms that require database access. The
connection string is located in the standard configuration file.
(Again, other computers have never had problems accessing the
connection string form the configuration file.

What could be the problem? where should I look next?

Thank you,
dbuchanan

Below are the exceptions.

************** Exception Text **************
System.IO.FileNotFoundException: File or assembly name
MSDNTextboxValidator, or one of its dependencies, was not found.
File name: "MSDNTextboxValidator"
at CLIP.f010Jobs.InitializeComponent()
at CLIP.f010Jobs..ctor()
at CLIP.f000Menu.btnManageJobs_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons
button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32
msg, IntPtr wparam, IntPtr lparam)

=== Pre-bind state information ===
LOG: DisplayName = MSDNTextboxValidator, Version=1.0.2066.17453,
Culture=neutral, PublicKeyToken=null
(Fully-specified)
LOG: Appbase = C:\Documents and Settings\kdylus\Desktop\
LOG: Initial PrivatePath = NULL
Calling assembly : CLIP, Version=1.1.1.20878, Culture=neutral,
PublicKeyToken=null.
===

LOG: Policy not being applied to reference at this time (private,
custom, partial, or location-based assembly bind).
LOG: Post-policy reference: MSDNTextboxValidator,
Version=1.0.2066.17453, Culture=neutral, PublicKeyToken=null
LOG: Attempting download of new URL file:///C:/Documents and
Settings/kdylus/Desktop/MSDNTextboxValidator.DLL.
LOG: Attempting download of new URL file:///C:/Documents and
Settings/kdylus/Desktop/MSDNTextboxValidator/MSDNTextboxValidator.DLL.
LOG: Attempting download of new URL file:///C:/Documents and
Settings/kdylus/Desktop/MSDNTextboxValidator.EXE.
LOG: Attempting download of new URL file:///C:/Documents and
Settings/kdylus/Desktop/MSDNTextboxValidator/MSDNTextboxValidator.EXE.



************** Loaded Assemblies **************
mscorlib
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll
----------------------------------------
CLIP
Assembly Version: 1.1.1.20878
Win32 Version: 1.1.1.20878
CodeBase:
file:///C:/Documents%20and%20Settings/kdylus/Desktop/CLIP.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll
----------------------------------------
System
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll
----------------------------------------
System.Drawing
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 7.0.5000.0
Win32 Version: 7.10.6001.4
CodeBase:
file:///c:/windows/assembly/gac/microsoft.visualbasic/7.0.5000.0__b03f5f7f11d50a3a/microsoft.visualbasic.dll
----------------------------------------
System.Data
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/assembly/gac/system.data/1.0.5000.0__b77a5c561934e089/system.data.dll
----------------------------------------
System.Xml
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/syst
em.xml.dll
----------------------------------------


====================================

************** Exception Text **************
System.InvalidOperationException: The ConnectionString property has not
been initialized.
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection
connection, ConnectionState& originalState)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data,
Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand
command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String
srcTable)
at CLIP.f080Stup.LoadDataSet()
at CLIP.f080Stup.Form_Load(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean
fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32
msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll
----------------------------------------
CLIP
Assembly Version: 1.1.1.20878
Win32 Version: 1.1.1.20878
CodeBase:
file:///C:/Documents%20and%20Settings/kdylus/Desktop/CLIP.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll
----------------------------------------
System
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll
----------------------------------------
System.Drawing
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 7.0.5000.0
Win32 Version: 7.10.6001.4
CodeBase:
file:///c:/windows/assembly/gac/microsoft.visualbasic/7.0.5000.0__b03f5f7f11d50a3a/microsoft.visualbasic.dll
----------------------------------------
System.Data
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/assembly/gac/system.data/1.0.5000.0__b77a5c561934e089/system.data.dll
----------------------------------------
System.Xml
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll
Click to expand...

Interesting.

But you will more likely get an answer in a dotNet Newsgroup...

--
<response type="generic" language="VB.Net">
This newsgroup is for users of Visual Basic version 6.0
and earlier and not the misleadingly named VB.Net
or VB 200x. Solutions, and often even the questions,
for one platform will be meaningless in the other.
When VB.Net was released Microsoft created new newsgroups
devoted to the new platform so that neither group of
developers need wade through the clutter of unrelated
topics. Look for newsgroups with the words "dotnet" or
"vsnet" in their name. For the msnews.microsoft.com news
server try these:

microsoft.public.dotnet.general
microsoft.public.dotnet.languages.vb
microsoft.public.dotnet.framework.adonet
microsoft.public.dotnet.framework.windowsforms.controls
microsoft.public.dotnet.framework.windowsforms.databinding

</response>
 
D

dbuchanan

Jerry,

· Yes the client can see the SQL Server machine. The machine is
Windows SBS 2003 - the main server in this small network.
· It has no problem accessing the any other services of that server
(Files, Exchange, etc).
· I created a test app with a connection to the Nortwind database - I
can connect to SQL Server from that machine.

This seems to say that there is some kind of permission problem.
However the user belongs to two groups. One group he is a member of
grants general access and the other group is administrative granting
additional permissions.

The other issue may or may not be related, but maybe it offers some
kind of clue - the main form does not open up to full size. It is
cropped. I have no clue to that behavior.

Of all other users and all other systems I have never seen either this
connection failure or the form opening in a cropped condition.

Whatever...

What thoughts do you have?
What should I check out next?

dbuchanan
 
D

dbuchanan

Jerry,

When I login to that computer I can access SQL Server but the
application form is still incomplete. ~ Let's consider that another
issue.

Why, If the user is a member of two groups that are granted access to
the server and the database get errors that result in no access to the
server?

The errors: "FileNotFoundException" & "The ConnectionString has not
been Initialized" (see original post)

dbuchanan
 
D

David

Have you tried installing Query Analyzer on the problematic client and see
if you can connect to SQL server using Query Analyzer? If that works, its a
config issue with your winforms app, if Query Analyzer cant connect either,
its a permissions or networking issue.

-David
 
D

dbuchanan

David,

I never considered doing that. I always thought of it as a tool for
developing and managing SQL server. I'll give that a try.

Thank you for your imput

dbuchanan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hibernated and menu 2
MSMAPI, or one of its dependencies, was not found 1
Start a process with a parameter in the file name? 4
Framework Versions problem? 1
Error while writing to the registry... OpenSubKey / SetValue 2
What is a solution for below problem. 3
unhandeled execption in PrintPreview 1
Run-Time Error only in Vista 1

Top