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(MouseEventAr gs 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(M essage& 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(IDbConn ection
connection, ConnectionState& originalState)
at System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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(Mes sage& m)
at System.Windows.Forms.ContainerControl.WndProc(Mess age& 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(M essage& 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
---------------------------------------- 6 2497
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
"dbuchanan" <db*********@hotmail.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com... 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(MouseEventAr gs 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(M essage& 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(IDbConn ection connection, ConnectionState& originalState) at System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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(Mes sage& m) at System.Windows.Forms.ContainerControl.WndProc(Mess age& 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(M essage& 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 ----------------------------------------
"dbuchanan" <db*********@hotmail.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com... 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(MouseEventAr gs 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(M essage& 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(IDbConn ection connection, ConnectionState& originalState) at System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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(Mes sage& m) at System.Windows.Forms.ContainerControl.WndProc(Mess age& 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(M essage& 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 ----------------------------------------
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.con trols
microsoft.public.dotnet.framework.windowsforms.dat abinding
</response>
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
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
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
"dbuchanan" <db*********@hotmail.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com... 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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Nick |
last post by:
I am working a new application...well actually a series of applications for
my company. They want internal users to be able to go to a site and
everything regarding security is transparent,...
|
by: James Fortune |
last post by:
I have a lot of respect for David Fenton and Allen Browne, but I don't
understand why people who know how to write code to completely replace
a front end do not write something that will automate...
|
by: Roy Gourgi |
last post by:
Hi,
I need to store and retrieve information from a database. It looks as though
there is a lot more support for SQLServer than there is for Access, correct
me if I am wrong.
What do I have...
|
by: James |
last post by:
I have a VB windows forms application that accesses a Microsoft Access
database that has been secured using user-level security. The
application is being deployed using No-Touch deployment. The...
|
by: Steve_Black |
last post by:
Hello,
I'm toying with the idea of loading a MenuStrip (VB.Net 2005)
dynamically based on who is logged into my system. Every user has
different security settings and I want to customize the...
|
by: abprules |
last post by:
Is there any way to copy only the forms from one .mdb file to another?
|
by: Elton Cohen |
last post by:
Hi newsgroup!
Can anyone tell me where I should put a simple Access database file in
order to be accessible for every computer in the network (same
workgroup)? There does not need to be any...
|
by: kkrizl |
last post by:
I've tried to research this problem, and I haven't been able to find
any references to it. Probably because I shouldn't be doing it, but it
was working, and now it's not.
I'm trying to develop a...
|
by: raylopez99 |
last post by:
Keywords: scope resolution, passing classes between parent and child
forms, parameter constructor method, normal constructor, default
constructor, forward reference, sharing classes between forms....
|
by: Rina0 |
last post by:
Cybersecurity engineering is a specialized field that focuses on the design, development, and implementation of systems, processes, and technologies that protect against cyber threats and...
|
by: erikbower65 |
last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps:
1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal.
2. Connect to...
|
by: linyimin |
last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
|
by: kcodez |
last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
|
by: Taofi |
last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same
This are my field names
ID, Budgeted, Actual, Status and Differences
...
|
by: Rina0 |
last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
|
by: lllomh |
last post by:
Define the method first
this.state = {
buttonBackgroundColor: 'green',
isBlinking: false, // A new status is added to identify whether the button is blinking or not
}
autoStart=()=>{
|
by: lllomh |
last post by:
How does React native implement an English player?
|
by: Mushico |
last post by:
How to calculate date of retirement from date of birth
| |