473,320 Members | 1,804 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

SQL Connection failing on single NT machine


I have installed an application out to about 15 machines. Some NT (service
pack 6) and some Windows XP. They all work......except for one machine. It
is an NT machine. I cant work out why it wont work on this machine. The
error occurs when logging in. It complains that ExecuteReader is failing as
the Connection is closed. My connection string looks something like this:

workstation id=WSQL01;packet size=4096;data source=WSQL01;persist security
info=False;initial catalog=wmApp

I have tried replacing the machine name of the server (WSQL01) with the IP
address but this makes no diff. I have tried pointing to diff servers (i.e
my dev box etc) but no joy. The machines are all on the same network.

Any ideas?? I have logged on to the machine and setup an ODBC connection to
the server and the DB, and used EXCEL to run a query against it and that
worked fine too. I really am baffled.

Should I somehow have to specify TCP\IP in the connection string? Is this
even possible?

Thanks

Steve
Nov 22 '05 #1
3 1256
What version of MDAC do you have installed?

http://msdn.microsoft.com/data/mdac/...s/default.aspx

Don't know if that is the problem or not, but something to into.

Greg

"Steve" <St***@discussions.microsoft.com> wrote in message
news:DE**********************************@microsof t.com...

I have installed an application out to about 15 machines. Some NT
(service
pack 6) and some Windows XP. They all work......except for one machine.
It
is an NT machine. I cant work out why it wont work on this machine. The
error occurs when logging in. It complains that ExecuteReader is failing
as
the Connection is closed. My connection string looks something like this:

workstation id=WSQL01;packet size=4096;data source=WSQL01;persist security
info=False;initial catalog=wmApp

I have tried replacing the machine name of the server (WSQL01) with the IP
address but this makes no diff. I have tried pointing to diff servers
(i.e
my dev box etc) but no joy. The machines are all on the same network.

Any ideas?? I have logged on to the machine and setup an ODBC connection
to
the server and the DB, and used EXCEL to run a query against it and that
worked fine too. I really am baffled.

Should I somehow have to specify TCP\IP in the connection string? Is this
even possible?

Thanks

Steve

Nov 22 '05 #2

Sorry but.....what is MDAC? Is this installed on the clients?

"Greg Burns" wrote:
What version of MDAC do you have installed?

http://msdn.microsoft.com/data/mdac/...s/default.aspx

Don't know if that is the problem or not, but something to into.

Greg

"Steve" <St***@discussions.microsoft.com> wrote in message
news:DE**********************************@microsof t.com...

I have installed an application out to about 15 machines. Some NT
(service
pack 6) and some Windows XP. They all work......except for one machine.
It
is an NT machine. I cant work out why it wont work on this machine. The
error occurs when logging in. It complains that ExecuteReader is failing
as
the Connection is closed. My connection string looks something like this:

workstation id=WSQL01;packet size=4096;data source=WSQL01;persist security
info=False;initial catalog=wmApp

I have tried replacing the machine name of the server (WSQL01) with the IP
address but this makes no diff. I have tried pointing to diff servers
(i.e
my dev box etc) but no joy. The machines are all on the same network.

Any ideas?? I have logged on to the machine and setup an ODBC connection
to
the server and the DB, and used EXCEL to run a query against it and that
worked fine too. I really am baffled.

Should I somehow have to specify TCP\IP in the connection string? Is this
even possible?

Thanks

Steve


Nov 22 '05 #3
I'm no expert, but Windows 2000 and above comes with MDAC (Microsoft Data
Access Components?) presinstalled. I doubt if NT 4 does. Most .NET app
database stuff requires some version (2.6?) to be installed on the clients.
I really don't know if this stuff is compatible with NT or not.
"Steve" <St***@discussions.microsoft.com> wrote in message
news:97**********************************@microsof t.com...

Sorry but.....what is MDAC? Is this installed on the clients?

"Greg Burns" wrote:
What version of MDAC do you have installed?

http://msdn.microsoft.com/data/mdac/...s/default.aspx

Don't know if that is the problem or not, but something to into.

Greg

"Steve" <St***@discussions.microsoft.com> wrote in message
news:DE**********************************@microsof t.com...
>
> I have installed an application out to about 15 machines. Some NT
> (service
> pack 6) and some Windows XP. They all work......except for one
> machine.
> It
> is an NT machine. I cant work out why it wont work on this machine.
> The
> error occurs when logging in. It complains that ExecuteReader is
> failing
> as
> the Connection is closed. My connection string looks something like
> this:
>
> workstation id=WSQL01;packet size=4096;data source=WSQL01;persist
> security
> info=False;initial catalog=wmApp
>
> I have tried replacing the machine name of the server (WSQL01) with the
> IP
> address but this makes no diff. I have tried pointing to diff servers
> (i.e
> my dev box etc) but no joy. The machines are all on the same network.
>
> Any ideas?? I have logged on to the machine and setup an ODBC
> connection
> to
> the server and the DB, and used EXCEL to run a query against it and
> that
> worked fine too. I really am baffled.
>
> Should I somehow have to specify TCP\IP in the connection string? Is
> this
> even possible?
>
> Thanks
>
> Steve


Nov 22 '05 #4

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

Similar topics

12
by: Cliff Wells | last post by:
Hi, I'm writing an application that needs to know if an Internet connection is available. Basically, I want to have something similar to what a lot of email clients have, where the app can work...
6
by: Paul Robinson | last post by:
I am developing a website in ASP that connects to a Sybase database. However, when I try to open a connection to the database the page will not load. The script does not timeout, nor the...
3
by: Steve | last post by:
I have installed an application out to about 15 machines. Some NT (service pack 6) and some Windows XP. They all work......except for one machine. It is an NT machine. I cant work out why it...
10
by: Brian Conway | last post by:
I have no idea what is going on. I have a Login screen where someone types in their login information and this populates a datagrid based off of the login. Works great in debug and test through...
22
by: Kristof Thys | last post by:
Hello, I'm developing a C# - windows forms application. To get some information for my application, I'm connecting to an URL, wich gives me XML generated using php. With 90% of the users, this...
12
by: Charlie | last post by:
Hi: My host will not allow me use a trusted connection or make registry setting, so I'm stuck trying find a way to hide connection string which will be stored in web.config file. If I encrypt...
18
by: Jon Delano | last post by:
Hey all I am building a new computer. I have Windows XP Pro with SP2 and all the updates. I installed VS 2003. Then copied a project from my old computer to the new one. When I try and run...
14
by: WebMatrix | last post by:
Hello, I have developed a web application that connects to 2 different database servers. The connection strings with db username + password are stored in web.config file. After a code review,...
4
by: fran | last post by:
Hello, there are some difference in a string connection if you use '.' or '(local)? When I use '.' I have the error: "SQL server does not allow remote connections" Thanks
6
by: madGirl | last post by:
I'm testing a simple c# application with server and client both working on the same machine ,client try to connect to server using external ip but i keep getting this message "No connection could be...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.