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

**Jerry Spivey** · Nov 21 '05, 11:39 PM

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@ho tmail.com> wrote in message
news:1130188731 .313289.48790@g 47g2000cwa.goog legroups.com...[color=blue]
>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 "FileNotFoundEx ection" 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 ConnectionStrin g 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.FileN otFoundExceptio n: File or assembly name
> MSDNTextboxVali dator, or one of its dependencies, was not found.
> File name: "MSDNTextboxVal idator"
> at CLIP.f010Jobs.I nitializeCompon ent()
> at CLIP.f010Jobs.. ctor()
> at CLIP.f000Menu.b tnManageJobs_Cl ick(Object sender, EventArgs e)
> at System.Windows. Forms.Control.O nClick(EventArg s e)
> at System.Windows. Forms.Button.On Click(EventArgs e)
> at System.Windows. Forms.Button.On MouseUp(MouseEv entArgs mevent)
> at System.Windows. Forms.Control.W mMouseUp(Messag e& m, MouseButtons
> button, Int32 clicks)
> at System.Windows. Forms.Control.W ndProc(Message& m)
> at System.Windows. Forms.ButtonBas e.WndProc(Messa ge& m)
> at System.Windows. Forms.Button.Wn dProc(Message& m)
> at System.Windows. Forms.ControlNa tiveWindow.OnMe ssage(Message& m)
> at System.Windows. Forms.ControlNa tiveWindow.WndP roc(Message& m)
> at System.Windows. Forms.NativeWin dow.Callback(In tPtr hWnd, Int32
> msg, IntPtr wparam, IntPtr lparam)
>
> === Pre-bind state information ===
> LOG: DisplayName = MSDNTextboxVali dator, Version=1.0.206 6.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.2 0878, 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: MSDNTextboxVali dator,
> Version=1.0.206 6.17453, Culture=neutral , PublicKeyToken= null
> LOG: Attempting download of new URL file:///C:/Documents and
> Settings/kdylus/Desktop/MSDNTextboxVali dator.DLL.
> LOG: Attempting download of new URL file:///C:/Documents and
> Settings/kdylus/Desktop/MSDNTextboxVali dator/MSDNTextboxVali dator.DLL.
> LOG: Attempting download of new URL file:///C:/Documents and
> Settings/kdylus/Desktop/MSDNTextboxVali dator.EXE.
> LOG: Attempting download of new URL file:///C:/Documents and
> Settings/kdylus/Desktop/MSDNTextboxVali dator/MSDNTextboxVali dator.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__b77 a5c561934e089/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__b77 a5c561934e089/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__b03 f5f7f11d50a3a/system.drawing. dll
> ----------------------------------------
> Microsoft.Visua lBasic
> Assembly Version: 7.0.5000.0
> Win32 Version: 7.10.6001.4
> CodeBase:
> file:///c:/windows/assembly/gac/microsoft.visua lbasic/7.0.5000.0__b03 f5f7f11d50a3a/microsoft.visua lbasic.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__b77 a5c561934e089/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__b77 a5c561934e089/system.xml.dll
> ----------------------------------------
>
>
> =============== =============== ======
>
> ************** Exception Text **************
> System.InvalidO perationExcepti on: The ConnectionStrin g property has not
> been initialized.
> at System.Data.Sql Client.SqlConne ction.Open()
> at System.Data.Com mon.DbDataAdapt er.QuietOpen(ID bConnection
> connection, ConnectionState & originalState)
> at System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data,
> Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand
> command, CommandBehavior behavior)
> at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32
> startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
> CommandBehavior behavior)
> at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String
> srcTable)
> at CLIP.f080Stup.L oadDataSet()
> at CLIP.f080Stup.F orm_Load(Object sender, EventArgs e)
> at System.EventHan dler.Invoke(Obj ect sender, EventArgs e)
> at System.Windows. Forms.Form.OnLo ad(EventArgs e)
> at System.Windows. Forms.Form.OnCr eateControl()
> at System.Windows. Forms.Control.C reateControl(Bo olean
> fIgnoreVisible)
> at System.Windows. Forms.Control.C reateControl()
> at System.Windows. Forms.Control.W mShowWindow(Mes sage& m)
> at System.Windows. Forms.Control.W ndProc(Message& m)
> at System.Windows. Forms.Scrollabl eControl.WndPro c(Message& m)
> at System.Windows. Forms.Container Control.WndProc (Message& m)
> at System.Windows. Forms.Form.WmSh owWindow(Messag e& m)
> at System.Windows. Forms.Form.WndP roc(Message& m)
> at System.Windows. Forms.ControlNa tiveWindow.OnMe ssage(Message& m)
> at System.Windows. Forms.ControlNa tiveWindow.WndP roc(Message& m)
> at System.Windows. Forms.NativeWin dow.Callback(In tPtr 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__b77 a5c561934e089/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__b77 a5c561934e089/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__b03 f5f7f11d50a3a/system.drawing. dll
> ----------------------------------------
> Microsoft.Visua lBasic
> Assembly Version: 7.0.5000.0
> Win32 Version: 7.10.6001.4
> CodeBase:
> file:///c:/windows/assembly/gac/microsoft.visua lbasic/7.0.5000.0__b03 f5f7f11d50a3a/microsoft.visua lbasic.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__b77 a5c561934e089/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__b77 a5c561934e089/system.xml.dll
> ----------------------------------------
>[/color]

**Ralph** · Nov 21 '05, 11:39 PM

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

"dbuchanan" <dbuchanan52@ho tmail.com> wrote in message
news:1130188731 .313289.48790@g 47g2000cwa.goog legroups.com...[color=blue]
> 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 "FileNotFoundEx ection" 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 ConnectionStrin g 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.FileN otFoundExceptio n: File or assembly name
> MSDNTextboxVali dator, or one of its dependencies, was not found.
> File name: "MSDNTextboxVal idator"
> at CLIP.f010Jobs.I nitializeCompon ent()
> at CLIP.f010Jobs.. ctor()
> at CLIP.f000Menu.b tnManageJobs_Cl ick(Object sender, EventArgs e)
> at System.Windows. Forms.Control.O nClick(EventArg s e)
> at System.Windows. Forms.Button.On Click(EventArgs e)
> at System.Windows. Forms.Button.On MouseUp(MouseEv entArgs mevent)
> at System.Windows. Forms.Control.W mMouseUp(Messag e& m, MouseButtons
> button, Int32 clicks)
> at System.Windows. Forms.Control.W ndProc(Message& m)
> at System.Windows. Forms.ButtonBas e.WndProc(Messa ge& m)
> at System.Windows. Forms.Button.Wn dProc(Message& m)
> at System.Windows. Forms.ControlNa tiveWindow.OnMe ssage(Message& m)
> at System.Windows. Forms.ControlNa tiveWindow.WndP roc(Message& m)
> at System.Windows. Forms.NativeWin dow.Callback(In tPtr hWnd, Int32
> msg, IntPtr wparam, IntPtr lparam)
>
> === Pre-bind state information ===
> LOG: DisplayName = MSDNTextboxVali dator, Version=1.0.206 6.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.2 0878, 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: MSDNTextboxVali dator,
> Version=1.0.206 6.17453, Culture=neutral , PublicKeyToken= null
> LOG: Attempting download of new URL file:///C:/Documents and
> Settings/kdylus/Desktop/MSDNTextboxVali dator.DLL.
> LOG: Attempting download of new URL file:///C:/Documents and
> Settings/kdylus/Desktop/MSDNTextboxVali dator/MSDNTextboxVali dator.DLL.
> LOG: Attempting download of new URL file:///C:/Documents and
> Settings/kdylus/Desktop/MSDNTextboxVali dator.EXE.
> LOG: Attempting download of new URL file:///C:/Documents and
> Settings/kdylus/Desktop/MSDNTextboxVali dator/MSDNTextboxVali dator.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:
>[/color]
file:///c:/windows/assembly/gac/system.windows. forms/1.0.5000.0__b77 a5c561934e089/system.windows. forms.dll[color=blue]
> ----------------------------------------
> System
> Assembly Version: 1.0.5000.0
> Win32 Version: 1.1.4322.2032
> CodeBase:
>[/color]
file:///c:/windows/assembly/gac/system/1.0.5000.0__b77 a5c561934e089/system.dll[color=blue]
> ----------------------------------------
> System.Drawing
> Assembly Version: 1.0.5000.0
> Win32 Version: 1.1.4322.2032
> CodeBase:
>[/color]
file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03 f5f7f11d50a3a/system.drawing. dll[color=blue]
> ----------------------------------------
> Microsoft.Visua lBasic
> Assembly Version: 7.0.5000.0
> Win32 Version: 7.10.6001.4
> CodeBase:
>[/color]
file:///c:/windows/assembly/gac/microsoft.visua lbasic/7.0.5000.0__b03 f5f7f11d50a3a/microsoft.visua lbasic.dll[color=blue]
> ----------------------------------------
> System.Data
> Assembly Version: 1.0.5000.0
> Win32 Version: 1.1.4322.2032
> CodeBase:
>[/color]
file:///c:/windows/assembly/gac/system.data/1.0.5000.0__b77 a5c561934e089/system.data.dll[color=blue]
> ----------------------------------------
> 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__b77 a5c561934e089/syst
em.xml.dll[color=blue]
> ----------------------------------------
>
>
> =============== =============== ======
>
> ************** Exception Text **************
> System.InvalidO perationExcepti on: The ConnectionStrin g property has not
> been initialized.
> at System.Data.Sql Client.SqlConne ction.Open()
> at System.Data.Com mon.DbDataAdapt er.QuietOpen(ID bConnection
> connection, ConnectionState & originalState)
> at System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data,
> Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand
> command, CommandBehavior behavior)
> at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32
> startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
> CommandBehavior behavior)
> at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String
> srcTable)
> at CLIP.f080Stup.L oadDataSet()
> at CLIP.f080Stup.F orm_Load(Object sender, EventArgs e)
> at System.EventHan dler.Invoke(Obj ect sender, EventArgs e)
> at System.Windows. Forms.Form.OnLo ad(EventArgs e)
> at System.Windows. Forms.Form.OnCr eateControl()
> at System.Windows. Forms.Control.C reateControl(Bo olean
> fIgnoreVisible)
> at System.Windows. Forms.Control.C reateControl()
> at System.Windows. Forms.Control.W mShowWindow(Mes sage& m)
> at System.Windows. Forms.Control.W ndProc(Message& m)
> at System.Windows. Forms.Scrollabl eControl.WndPro c(Message& m)
> at System.Windows. Forms.Container Control.WndProc (Message& m)
> at System.Windows. Forms.Form.WmSh owWindow(Messag e& m)
> at System.Windows. Forms.Form.WndP roc(Message& m)
> at System.Windows. Forms.ControlNa tiveWindow.OnMe ssage(Message& m)
> at System.Windows. Forms.ControlNa tiveWindow.WndP roc(Message& m)
> at System.Windows. Forms.NativeWin dow.Callback(In tPtr 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:
>[/color]
file:///c:/windows/assembly/gac/system.windows. forms/1.0.5000.0__b77 a5c561934e089/system.windows. forms.dll[color=blue]
> ----------------------------------------
> System
> Assembly Version: 1.0.5000.0
> Win32 Version: 1.1.4322.2032
> CodeBase:
>[/color]
file:///c:/windows/assembly/gac/system/1.0.5000.0__b77 a5c561934e089/system.dll[color=blue]
> ----------------------------------------
> System.Drawing
> Assembly Version: 1.0.5000.0
> Win32 Version: 1.1.4322.2032
> CodeBase:
>[/color]
file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03 f5f7f11d50a3a/system.drawing. dll[color=blue]
> ----------------------------------------
> Microsoft.Visua lBasic
> Assembly Version: 7.0.5000.0
> Win32 Version: 7.10.6001.4
> CodeBase:
>[/color]
file:///c:/windows/assembly/gac/microsoft.visua lbasic/7.0.5000.0__b03 f5f7f11d50a3a/microsoft.visua lbasic.dll[color=blue]
> ----------------------------------------
> System.Data
> Assembly Version: 1.0.5000.0
> Win32 Version: 1.1.4322.2032
> CodeBase:
>[/color]
file:///c:/windows/assembly/gac/system.data/1.0.5000.0__b77 a5c561934e089/system.data.dll[color=blue]
> ----------------------------------------
> 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__b77 a5c561934e089/system.xml.dll[color=blue]
> ----------------------------------------
>[/color]

Interesting.

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

--
<response type="generic" language="VB.Ne t">
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.microsof t.com news
server try these:

microsoft.publi c.dotnet.genera l
microsoft.publi c.dotnet.langua ges.vb
microsoft.publi c.dotnet.framew ork.adonet
microsoft.publi c.dotnet.framew ork.windowsform s.controls
microsoft.publi c.dotnet.framew ork.windowsform s.databinding

</response>

**dbuchanan** · Nov 21 '05, 11:40 PM

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

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

**dbuchanan** · Nov 21 '05, 11:41 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: "FileNotFoundEx ception" & "The ConnectionStrin g has not
been Initialized" (see original post)

dbuchanan

**David** · Nov 21 '05, 11:42 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@ho tmail.com> wrote in message
news:1130507246 .110444.55280@z 14g2000cwz.goog legroups.com...[color=blue]
> 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: "FileNotFoundEx ception" & "The ConnectionStrin g has not
> been Initialized" (see original post)
>
> dbuchanan
>[/color]

**dbuchanan** · Nov 21 '05, 11:43 PM

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

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

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

Comment

Comment

Comment

Comment

Comment

Comment