473,387 Members | 1,760 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,387 software developers and data experts.

ODBTP over IP

Hello all,

My company has 2 hosting sites. Site1 has the live web and DB server and Site2 has a backup (mirrored) DB box. In the event that the live DB box goes pop, we need to switch the web server to look at the DB box in Site2. The web server connects to the database using ODBTP and will happily talk to the database on the server in the same hosting centre. When we try to switch it over, we get the following error:

[08001][17][Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. [01000][53][Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())

All ports are open between all the servers on our firewalls and the boxes can ping each other. We can even telnet from the web server to port 2799 (for ODBTP) on the DB server, but it still isn't working.

Has anybody got any ideas?

Thanks

Stu
Mar 12 '08 #1
0 1582

Sign in to post your reply or Sign up for a free account.

Similar topics

18
by: David Rysdam | last post by:
What module is most recommended for accessing Sybase from Python? This one: http://www.object-craft.com.au/projects/sybase/sybase/ ? Also, is there any module that provides a generic DB API and...
3
by: Nagendra | last post by:
Hi all, I need to access an Oracle database through a python script using ODBC drivers(currently i have eval copies of Easysoft and datadirect Oracle ODBC drivers). Desired platforms are solaris,...
13
by: Roy Smith | last post by:
I've got a C library with about 50 calls in it that I want to wrap in Python. I know I could use some tool like SWIG, but that will give me a too-literal translation; I want to make some...
4
by: flupke | last post by:
Hi, at work we use a solid database and i need to develop an application that accesses it. Problem is the drivers: i only have some dll's lying around and jar. On winsdows i could get by by...
1
by: Luigi Ida' via SQLMonster.com | last post by:
Hi, I have a php application connected through odbc to a sqlserver database. When I try to execute select queries on a smalldatetime table field I receive this message: Warning: Numeric value...
11
by: ralphie | last post by:
hi all since nearly 2 days i fight with mssql and utf-8 as i need to store and retrieve arabic characters. i tried the com approach ...
6
by: dubing | last post by:
Hello, We're using PHP to query the Access DB and publish the data on the web. Query the DB: $qry = odbtp_query("SELECT end_date,title FROM projects ORDER BY end_date DESC"); Get the...
3
by: D Stocks | last post by:
Is it possible to have web page hosted by Linux/Apache retrieve data from (and insert data to) an MS Access database that resides on an (Internet-accessible) MS-based machine? Must the MS machine...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

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.