SQL server not found error
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=4733
Printed Date: 30 March 2026 at 10:10am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL server not found error
Posted By: susi_q2
Subject: SQL server not found error
Date Posted: 04 August 2003 at 9:43am
I'm very new to ASP but I'm trying to set up a login for my client to enable their customers to book reservations online. Someone else wrote the code for me, another guy again is looking after their database (since it's 600 miles away from where I am) and I'm just the one trying to make it all work! Any help you can give me would be greatly appreciated!!
The guy looking after their server says he's opened a port for me and rewritten the firewall rules to allow access by my server but this is the error message I'm getting when I try to log on:
[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found.-2147467259
ADODB.Recordset error '800a0e7d'
Operation is not allowed on an object referencing a closed or invalid connection.
|
Replies:
Posted By: michael
Date Posted: 04 August 2003 at 12:38pm
As you say he opened a port, this would not do much good as you seem to use named pipes as your protocol, if you are using a DSN to connect to SQL, go into Client Configuration and make sure that TCP/IP is selected. Then again the error you specify can have a few sources/ it would help if you post some code here...
-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker
|
Posted By: susi_q2
Date Posted: 04 August 2003 at 12:53pm
The code that refers to opening the data connection looks like this...
Sub LiveryLogin(username,password)
Set rs = Server.CreateObject("ADODB.Recordset")
sql= "SELECT CustomerID,Agent,First_Name,Last_Name,Company FROM customer Where username = '"&UserName&"' and Password='"&Password&"'"
rs.Open sql, oConn,0,1
I'm using a valid username and password and I've named the database that we're trying to access elsewhere in the routines. I'm sorry but servers and ASP are not my forte... I don't even know which bits of information are relevant to give you to help you answer my question.
|
Posted By: ljamal
Date Posted: 04 August 2003 at 1:18pm
Are you able the access the SQL server via Enterprise Manager with the information that you have?
-------------
L. Jamal Walton
http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming
|
Posted By: susi_q2
Date Posted: 04 August 2003 at 1:47pm
I don't know what a DSN is, and no, I can't access the SQL server other than through this login routine from their web page.
I program in HTML and Javascript primarily but my client bought this ASP reservation system from a third party and has left it up to me to install it. The company that sold the system to them has no concept of customer support whatsoever so they've been very little help, if any. Usually when I build my sites I just FTP them up to whatever server they're going to be hosted on and everything works fine. In this case, they've had someone else set up their back office system for them and what I'm installing is just the interface that allows their clients to make their reservations online through their existing website.
When my client's tech guy emailed me to say that he had opened the port, he said:
The port is open as described below.
ISA-Created packet filter
"secure.clientsdomain.com"
TCP
BOTH
PORT 9600
???????
|
Posted By: ljamal
Date Posted: 04 August 2003 at 2:03pm
If you don't know ASP and SQL then find someone who does. They will be able to help you much faster than we can as you will be able to give them everything and just have them fix it.
-------------
L. Jamal Walton
http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming
|
Posted By: michael
Date Posted: 04 August 2003 at 2:05pm
Also, has SQL been installed on prot 9600? If yes, you need to put that into your connection string as it would default to 1433 otherwise.
-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker
|
Posted By: susi_q2
Date Posted: 04 August 2003 at 2:17pm
Gee, thanks Jamal! Now why hadn't I thought of that?!?
Michael, good question. Maybe that's all it is. I'll check that out.
|
|