473,320 Members | 1,868 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.

strange sql connection prob

Already posted to sql server group but maybe some help here....

If I run my application, I get a 'database does not exist'. If I then go
onto the machine with the database on (different machine) and log in to
query analyser, I can then go back to the web browser, it connects fine.

Three machines involved...
My PC
web server
db server

Order of events is...
go onto my PC, try and connect to web server via HTTP... fails with unknown
DB
do a remote connection to db server, log in
go back to my PC, try and connect to web server via HTTP... works fine.

It seems strange, like logging into the DB starts it polling itself as alive
or something.

Can someone please help? Would putting in the IP address be better than the
server name?

Nov 18 '05 #1
2 1265
show your conn string

--
Curt Christianson
Owner/Lead Developer, DF-Software
www.Darkfalz.com
"Tim Almond" <timdotalmondatlibermensdotcomspamtrap> wrote in message
news:Od**************@TK2MSFTNGP09.phx.gbl...
Already posted to sql server group but maybe some help here....

If I run my application, I get a 'database does not exist'. If I then go
onto the machine with the database on (different machine) and log in to
query analyser, I can then go back to the web browser, it connects fine.

Three machines involved...
My PC
web server
db server

Order of events is...
go onto my PC, try and connect to web server via HTTP... fails with unknown DB
do a remote connection to db server, log in
go back to my PC, try and connect to web server via HTTP... works fine.

It seems strange, like logging into the DB starts it polling itself as alive or something.

Can someone please help? Would putting in the IP address be better than the server name?

Nov 18 '05 #2
Hi Curt,

The SQL Connection string is
server=1.1.1.1;database=dname;uid=****;password=** ******* with the names
changed to protect the guilty.

It's intermittent. Sometimes it's fine, sometimes not, and I'm wondering if
it's the network as the test network is OK.


"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:OH**************@TK2MSFTNGP11.phx.gbl...
show your conn string

--
Curt Christianson
Owner/Lead Developer, DF-Software
www.Darkfalz.com
"Tim Almond" <timdotalmondatlibermensdotcomspamtrap> wrote in message
news:Od**************@TK2MSFTNGP09.phx.gbl...
Already posted to sql server group but maybe some help here....

If I run my application, I get a 'database does not exist'. If I then go
onto the machine with the database on (different machine) and log in to
query analyser, I can then go back to the web browser, it connects fine.

Three machines involved...
My PC
web server
db server

Order of events is...
go onto my PC, try and connect to web server via HTTP... fails with

unknown
DB
do a remote connection to db server, log in
go back to my PC, try and connect to web server via HTTP... works fine.

It seems strange, like logging into the DB starts it polling itself as

alive
or something.

Can someone please help? Would putting in the IP address be better than

the
server name?


Nov 18 '05 #3

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

Similar topics

0
by: Steve Barker | last post by:
Hi guys, I've written an application in C# that connects to a Paradox table via ODBC. My code has always worked fine, but now I've moved my application to another machine, it's stopped working!...
3
by: Chad Richardson | last post by:
Yes, it should be easy.... I have a single box hosing IIS and SQL Server 2000. In my ASP script I've tried using the following connection strings to attempt to connect to no avail: ...
9
by: Wescotte | last post by:
Here is a small sample program I wrote in PHP to help illustrates problem I'm having. The data base is using DB2 V5R3M0. The client is WinXP machine using the iSeries Client Access Driver ver...
2
by: Tim Almond | last post by:
Already posted to sql server group but maybe some help here.... If I run my application, I get a 'database does not exist'. If I then go onto the machine with the database on (different machine)...
2
by: Buddy Ackerman | last post by:
I have a web app that I have setup on numerous web servers. I've set one up for a new client at their hosting facility and cannot get it to connect to their database. I get a "SQL Server does not...
2
by: Diffident | last post by:
Hello All, I am trying to redirect users to a standby webpage in case our application is down due to database server failure. To facilitate this I am opening a test connection within a try/catch...
0
by: ivb | last post by:
Hi all, I am using DB2 8.1.11.1 on NT with ASP.NET 1.1 When application make connection to database (via ADO.NET), it set "Connection timeout" parameter to 30 seconds. After, when my webpage...
7
by: galico | last post by:
Hi All, We are having a very strange problem with the above. We have designed an application in ASP.NET 2.0 that uses the enterprise library data application blocks amongst others. We seem to be...
0
by: mayurshah28 | last post by:
Hi everyone, im developing one application for banking. there i have stucked wit one prob. now prob is tat im not able to access multiple tables at a time through vb. my coding is as below Dim...
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
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...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.