Paul Shearing
|
| Posted: 10/31/2005, 11:39 AM |
|
CCS 3.0.0.54. ASP + Templates. MS SQL 2000 SP4, IIS. Running on Windows XP Pro SP2 + patches in a workgroup, not a domain. Twin XEONS, 1.5GB RAM, loadsa disk space.
I can develop OK and live pages review OK in a browser using http://localhost/AppFolder syntax on the development system. Database is accessed via a string that contains the ID and password of an admin SQL user that has full rights to the DB. (i.e. SQL Authentication)
However, if I access the live site from another computer on the local intranet via a browser, giving the IP address of the development system thus: 192.168.44.10/AppFolder, all is well until I attempt to log-on to the database whereupon I get, after a timeout:
Unable to establish connection to database
Error Information:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DNETLIB]{ConnectionOpn (Connect().]SQL Server does not exists or access denied.
Other possible cause of this problem:
The database cannot be opened, most likely due to incorrect settings or insufficient security set on your database folder or file:
I would have thought that with a fixed connection string between ASP and the server, sepcifying an administrative user, I should not have any issues regarding comnnectivity with the database.
Any help would be gratefully received.
Paul Shearing
Caterham England
|
|
|
 |
Edd
Posts: 547
|
| Posted: 10/31/2005, 3:01 PM |
|
Paul,
First thing, open the Common.asp file on the server and check the database connection string, userid and password.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
 |
|
Paul Shearing
|
| Posted: 10/31/2005, 3:51 PM |
|
Hi Edd
I've has a squint at this and cannot see anything obviously wrong. The connection string contains the correct password, userID and server/instance name. Furthermore, this does work correctly when I am on the development system.
I can only think that this has something to do with connectivity rights for the guest user that is assigned to incoming http connections - but a) this is just a guess b) is probably wrong and c) I don't know how to test this hypothesis.
Kind regards
Paul
|
|
|
|
Edd
Posts: 547
|
| Posted: 10/31/2005, 5:27 PM |
|
Paul,
Are you using OLDEB for SQLServer or OLEDB for ODBC drivers.
If you are using the latter I think it requireds an ODBC setting on the Server.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
Paul Shearing
|
| Posted: 10/31/2005, 5:29 PM |
|
Edd
Just a thought. Could this have anything to do with the fact that I am interrogating a computer that is running a version of IIS that is, in turn, running under WinXP Pro rather than under Win2K Server or Win 2003 Server?
Kind regards
Paul
|
|
|
|
Paul SHearing
|
| Posted: 10/31/2005, 5:36 PM |
|
Hi Edd
I think our last two communications crossed in the ether. I'm using OLEDB. The routine in common.ASP looks like this:
Private Sub Class_Initialize()
ConnectionString = "Provider=SQLOLEDB.1;Password=HUGO998;Persist Security Info=True;User ID=HUGO_ADMIN;Initial Catalog=HUGO_DB;Data Source=HUGO-WEB-SERVER"
User = "HUGO_ADMIN"
Password = "HUGO998"
Set Converter = New clsConverter
Converter.DateFormat = Array("yyyy", "-", "mm", "-", "dd", " ", "HH", ":", "nn", ":", "ss")
Converter.BooleanFormat = Array(1, 0, Empty)
Set objConnection = Server.CreateObject("ADODB.Connection")
Set Errors = New clsErrors
End Sub
Paul
|
|
|
|
Edd
Posts: 547
|
| Posted: 10/31/2005, 5:51 PM |
|
Paul,
Hard one to call from here
Let me recap for my tiny brain.
In development you access a remote SQL sever and everything works OK.
In production the production server accesses the same SQL server and it craps out.
If that correct?
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
Paul Shearing
|
| Posted: 10/31/2005, 6:20 PM |
|
|
|
|
|
Paul Shearing
|
| Posted: 10/31/2005, 6:29 PM |
|
Not quite. The database is local. i.e. IIS and MS SQL 2000 Developer edition are on the same XP Pro computer. Other than that, yes you are correct.
The only thing that is varying is the computer that I am using to query the website. On the development system I enter http:\\localhost\AppFolder into a browser and away it goes. On a different computer on the same local network I type the IP address of the development machine\AppFolder into a browser address line and the website works ok until it tries to connect to the database.
At present, there are no server operating systems involved - it's all Win XP Pro SP2.
Paul
|
|
|
|
Edd
Posts: 547
|
| Posted: 10/31/2005, 6:35 PM |
|
So "HUGO-WEB-SERVER" is the production machine in your DNS setting?
Try changing your development environment to point to the production database and see it connectivity works.
Sorry if this sounds patronising but it is exactly what I do when this kind of crap kappens.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
Paul Shearing
|
| Posted: 10/31/2005, 6:53 PM |
|
It's not patronising at all - in situations like this any and all input is useful. However Edd, it's now your turn to help my tiny brain. "Try changing your development environment to point to the production database" - I'm not sure what you mean by this. There is at present, only one database, it's on the development system and the CCS (and ASP) connection strings are all pointing to it.
In its final incarnation, the website and SQL server will be on one big server running Win2003 Server OS. But in the mean time I need to be able to demonstrate progress by having the customer remotely VPN into my network to test the application and monitor progress from time to time. Hence my experiments.
Paul
|
|
|
|
Paul Shearing
|
| Posted: 10/31/2005, 6:55 PM |
|
Forgot to make clear that HUGO-WEB-SERVER is the development system. There is no separate production server.
|
|
|
|
Edd
Posts: 547
|
| Posted: 10/31/2005, 7:33 PM |
|
I am stumped - the only thing I can think of is IIS permissioning.
Are you running NT authentication? Try checking permissions for the IIS User Account that it can read and update the database directory.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
marcwolf
Posts: 361
|
| Posted: 10/31/2005, 7:42 PM |
|
I have sometimes had something like this , however it is when I am using MySQL and CCS Current V2
What happens is that in the Local Machine section of the registry the ODBC information looses its permission data
To fix I go in and add in users iUSR_MACHINE and IWAN_MACHINE and give them full access rights.
I know its not a solution to your issue but it might be a pointer.
Take Care
Dave
_________________
' Coding Coding Coding
Keep Those Keyboards Coding.
Raw Code!!!!!!!
|
|
|
|
Paul Shearing
|
| Posted: 11/01/2005, 2:30 AM |
|
Thanks for all your help guys. 
I'm going to assume that something is busted on HUGO-WEB-SERVER because nobody else seems to be screaming. I'll build a fresh system with Windows Server on it (later this week) and see if this issue goes away. If so, sorry to have troubled you. In any event, for completeness, I'll add another posting to this thread to let you know how I get on.
Kind regards
Paul Shearing
Software Development Services
Caterham, Lil' Ol' England
|
|
|
|
Rene
|
| Posted: 11/04/2005, 7:09 AM |
|
I had problems with SQL Server and connection in a vb app. On one computer it worked fine, the other ones did not. Updated mdac and now it works!(?) (hope it is the same because i do not know to much about it)
Rene
|
|
|
|
Paul Shearing
|
| Posted: 11/14/2005, 7:45 AM |
|
Sorry to have taken everybody's time.
Loaded database on separate server and all is well.
There are times when, if Bill Gates and his merry men were in the same room and I had a loaded Uzi 9mm ... well, let's no go there eh? 
Thanks again
Paul Shearing
Software Development Services
Leafy Surrey, England
|
|
|
|
