Drop Table

Support Forum for database administrators and web based access to important newsgroups related to databases
Register on Database Support Forum Edit your profileCalendarFind other Database Support forum membersFrequently Asked QuestionsSearch this forum -> 
For Database admins: Free Database-related Magazines Now Free shipping to Texas


Post New Thread










Thread
Author
VS.Net Win Forms app - cannot access SQLServer with one computer
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. FileNotFoundExceptio
n: 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(MouseEvent
Args 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\Desk
top\
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%20Se
ttings/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__b77a5c56193
4e089/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.d
ll
----------------------------------------
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__b03f5f7f11
d50a3a/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/sys
tem.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. InvalidOperationExce
ption: The ConnectionString property has not
been initialized.
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter. QuietOpen(IDbConnect
ion
connection, ConnectionState& originalState)
at System.Data.Common.DbDataAdapter. FillFromCommand(Obje
ct 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(Boolea
n
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%20Se
ttings/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__b77a5c56193
4e089/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.d
ll
----------------------------------------
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__b03f5f7f11
d50a3a/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/sys
tem.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
----------------------------------------

Report this thread to moderator Post Follow-up to this message
Old Post
dbuchanan
10-25-05 01:23 AM

Re: VS.Net Win Forms app - cannot access SQLServer with one computer
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" <dbuchanan52@hotmail.com> wrote in message
news:1130188731.313289.48790@g47g2000cwa.googlegroups.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. FileNotFoundExceptio
n: 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(MouseEvent
Args 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\Desk
top\
> 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%20Se
ttings/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__b77a5c561
934e089/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__b03f5f7f11d50a3
a/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__b03f5f7f
11d50a3a/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/s
ystem.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/sy
stem.xml.dll
> ----------------------------------------
>
>
>  ====================
================
>
> ************** Exception Text **************
> System. InvalidOperationExce
ption: The ConnectionString property has not
> been initialized.
>   at System.Data.SqlClient.SqlConnection.Open()
>   at System.Data.Common.DbDataAdapter. QuietOpen(IDbConnect
ion
> connection, ConnectionState& originalState)
>   at System.Data.Common.DbDataAdapter. FillFromCommand(Obje
ct 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(Boolea
n
> 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%20Se
ttings/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__b77a5c561
934e089/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__b03f5f7f11d50a3
a/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__b03f5f7f
11d50a3a/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/s
ystem.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/sy
stem.xml.dll
> ----------------------------------------
>

Report this thread to moderator Post Follow-up to this message
Old Post
Jerry Spivey
10-25-05 01:23 AM

Re: VS.Net Win Forms app - cannot access SQLServer with one computer
"dbuchanan" <dbuchanan52@hotmail.com> wrote in message
news:1130188731.313289.48790@g47g2000cwa.googlegroups.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. FileNotFoundExceptio
n: 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(MouseEvent
Args 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\Desk
top\
> 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%20Se
ttings/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.wi
ndows.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/microsof
t.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[co
lor=darkred]
> ----------------------------------------
> System.Xml
>     Assembly Version: 1.0.5000.0
>     Win32 Version: 1.1.4322.2032
>     CodeBase:
>[/color]
file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/syst
em.xml.dll
> ----------------------------------------
>
>
>  ====================
================
>
> ************** Exception Text **************
> System. InvalidOperationExce
ption: The ConnectionString property has not
> been initialized.
>    at System.Data.SqlClient.SqlConnection.Open()
>    at System.Data.Common.DbDataAdapter. QuietOpen(IDbConnect
ion
> connection, ConnectionState& originalState)
>    at System.Data.Common.DbDataAdapter. FillFromCommand(Obje
ct 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(Boolea
n
> 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%20Se
ttings/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.wi
ndows.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/microsof
t.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[co
lor=darkred]
> ----------------------------------------
> System.Xml
>     Assembly Version: 1.0.5000.0
>     Win32 Version: 1.1.4322.2032
>     CodeBase:
>[/color]
file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll[colo
r=darkred]
> ----------------------------------------
>[/color]

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>

Report this thread to moderator Post Follow-up to this message
Old Post
Ralph
10-25-05 01:23 AM

Re: VS.Net Win Forms app - cannot access SQLServer with one computer
Jerry,

=B7 Yes the client can see the SQL Server machine. The machine is
Windows SBS 2003 - the main server in this small network.
=B7 It has no problem accessing the any other services of that server
(Files, Exchange, etc).
=B7 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

Report this thread to moderator Post Follow-up to this message
Old Post
dbuchanan
10-27-05 12:27 PM

Re: VS.Net Win Forms app - cannot access SQLServer with one computer
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: " FileNotFoundExceptio
n" & "The ConnectionString has not
been Initialized" (see original post)

dbuchanan

Report this thread to moderator Post Follow-up to this message
Old Post
dbuchanan
10-28-05 02:23 PM

Re: VS.Net Win Forms app - cannot access SQLServer with one computer
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" <dbuchanan52@hotmail.com> wrote in message
news:1130507246.110444.55280@z14g2000cwz.googlegroups.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: " FileNotFoundExceptio
n" & "The ConnectionString has not
> been Initialized" (see original post)
>
> dbuchanan
>

Report this thread to moderator Post Follow-up to this message
Old Post
David
10-29-05 08:23 AM

Re: VS.Net Win Forms app - cannot access SQLServer with one computer
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

Report this thread to moderator Post Follow-up to this message
Old Post
dbuchanan
10-29-05 02:23 PM

Sponsored Links



Last Thread Next Thread
Post New Thread

MS SQL Server archive

Show a Printable Version Email This Page to Someone! Receive updates to this thread
Microsoft SQL Server
Access database support
PostgreSQL Replication
SQL Server ODBC
FoxPro Support
PostgreSQL pgAdmin
SQL Server Clustering
MySQL ODBC
Web Applications with dBASE
SQL Server CE
MySQL++
Sybase Database Support
MS SQL Full Text Search
PostgreSQL Administration
SQL Anywhere support
DB2 UDB Database
Paradox Database Support
Filemaker Database
Berkley DB
SQL 2000/2000i database
ASE Database
Forum Jump:
All times are GMT. The time now is 02:17 PM.

 
Mobile devices forum | Database support forum archive



Copyrights DropTable.com Database Support Forum 2004 - 2006