program return blank set

Hi NGs,
I have a program connecting to SQL Server as the back-
end, recently, our company change to use FDDI instead of
128K network line; this causes the program return blank
Set from the SQL Server. We don't modify the program, the
only change is the networking situation. From 128k line
to FDDI; the program worked fine for about 1 month before
we made the change; FDDI also works great except this
program. Do you have any idea?
TIA.Are you able to make a connection to the SQL Server outside of the
application using tools SQL Query Analyser or OSQL.
HTH
Ryan Waight, MCDBA, MCSE
"Matt" <spam@.spam.com> wrote in message
news:079801c3ae80$22a1ecb0$a301280a@.phx.gbl...
> Hi NGs,
> I have a program connecting to SQL Server as the back-
> end, recently, our company change to use FDDI instead of
> 128K network line; this causes the program return blank
> Set from the SQL Server. We don't modify the program, the
> only change is the networking situation. From 128k line
> to FDDI; the program worked fine for about 1 month before
> we made the change; FDDI also works great except this
> program. Do you have any idea?
> TIA.
>
>
>|||thanks, currently I don't know, I will try it, if it
connects successfully, how do I process in next step?
>--Original Message--
>Are you able to make a connection to the SQL Server
outside of the
>application using tools SQL Query Analyser or OSQL.
>
>--
>HTH
>Ryan Waight, MCDBA, MCSE
>"Matt" <spam@.spam.com> wrote in message
>news:079801c3ae80$22a1ecb0$a301280a@.phx.gbl...
>> Hi NGs,
>> I have a program connecting to SQL Server as the back-
>> end, recently, our company change to use FDDI instead
of
>> 128K network line; this causes the program return blank
>> Set from the SQL Server. We don't modify the program,
the
>> only change is the networking situation. From 128k line
>> to FDDI; the program worked fine for about 1 month
before
>> we made the change; FDDI also works great except this
>> program. Do you have any idea?
>> TIA.
>>
>>
>>
>
>.
>|||Hi Matt,
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
your issue.
I am a little confused about the statement "blank set" you mentioned, it
will be more helpful if you could provide more specific description about
it. I assume that your application cannot get any data from the SQL Server
through the network of your company that used to work well. From the
information you provided, the only change that happened in you application
environment is the FDDI network took place of the formal 128K network,
right? If I have misunderstood, please feel free to let me know.
From my experience, you should confirm the connectivity of your computer
and the remote SQL Server first. You'd better use the Query Analyzer on
your computer and execute a simple query statement to see if the Query
Analyzer could retrieve any data from the remote SQL Server. This will be
helpful to confirm that both the remote SQL Server and the communication
between you computer and the remote SQL Server are working well.
Please let me know if the Query Analyzer could get data from the remote SQL
Server and I will provide further support based on the information you
provided. Looking forward to your response
Sincerely Yours
Baisong, Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
--
| Content-Class: urn:content-classes:message
| From: "Matt" <spam@.spam.com>
| Sender: "Matt" <spam@.spam.com>
| Subject: program return blank set
| Date: Wed, 19 Nov 2003 01:33:05 -0800
| Lines: 18
| Message-ID: <079801c3ae80$22a1ecb0$a301280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcOugCKhWxDbVERgQq6h62CYlPL2YA==| Newsgroups: microsoft.public.sqlserver.server
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:317195
| NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hi NGs,
|
| I have a program connecting to SQL Server as the back-
| end, recently, our company change to use FDDI instead of
| 128K network line; this causes the program return blank
| Set from the SQL Server. We don't modify the program, the
| only change is the networking situation. From 128k line
| to FDDI; the program worked fine for about 1 month before
| we made the change; FDDI also works great except this
| program. Do you have any idea?
|
| TIA.
|
|
|
|
|
|
|