SQL Server connection issue

  • Thread starter Thread starter Earl
  • Start date Start date
E

Earl

Interesting connection issue to SQL Server:

I have several apps that connect to the same server, albeit different
databases. One app is VB6, the others are VB.Net (VS2003). On the
development system, and on two separate test systems at different locations,
no problem connecting to the server and the database.

However, on one of my customer's system, the VB6 app will connect, but the
only .Net app I have installed will not connect to the same server
(different database).

VB6 connection string (this works on all systems):
strCN = "Provider=sqloledb;" & _
"Data Source=" & strDBServer & ";" & _
"Initial Catalog=" & strDBName & ";" & _
"Integrated Security=SSPI"

VB.Net connection string (this works on all systems except the one
customer's):
strCN = "data source=" & strDBServer & ";" & _
"initial catalog=" & strDBName & ";integrated security=SSPI;"

I've looked at the firewall, the IP settings, reinstalled the server,
reinstalled the databases, tried both NamedPipes and IP, this app just flat
will not connect. Any ideas on what I'm overlooking? Any method of testing
for connection to a server beyond the obvious SQLDMO timeout? Is it possible
that the network is blocking me (SQL2k is installed on an XP box, not the
company server)?
 
Are you using the OleDb client or the SqlClient in your .NET app?

And which MDAC version is on the customer's machine?

Are you getting an error message? Or does it just 'wait' for a connection.
 
Not long ago I responded to a question with a checklist of what to look for
when connecting. I posted an annotated version of this response to my blog.
See www.betav.com\blog\billva


--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Thanks Bill. I will use your checklist tomorrow to do some more testing.

Sorry to hear about your Qantas flight. Hehe. I too have flown on some of
those military flights, including one memorable time when our squadron was
headed to Iceland (back in the Cold War days), and I slept on a wagon full
of netted bomb racks for our Phantoms.
 
Back
Top