Long Distance ODBC Connections
Is it possible to have some sort of hyperlink or long distance odbc connection so that I can get pages on my server here to draw from a database that is at a different location? How would this be done?
View Replies
ADVERTISEMENT
Distance Search
I am working on a search which is used to search for something in cities of US.I want to add an option of "include nearby cities".When the user checks this it should bring up the cities near to that also.
so if the users enters city " LOS ANGELS " and state " California".It should bring up some results in california as well as cities near to californai.
Also i have another requirement in this search which is distance search.User will search for something with the option of with 5 or 10 or 15 or 25 etc., miles , so the same above results should occur.
My database contains two fields longitude and latitude.But i do not understand how to use this " include nearby cities" and for distance search.
Distance Calculator
I want to use something like Streetmap.co.uk's ActiveX Component on a website so that a visitor can enter a startpoint and destination and I can calculate the distance by road between those 2 points.
This is for a website I'm writing for a mate of mine who owns a Courier firm. He wants to be able to provide online quotes to potential customers. I'm going to be using Brinkster as the webhost so I won't be able to install any Server-side DLL's, etc. Is there anything available to do this?
Distance Between Two Zip Codes
I am trying to find a software that can find distance between two ZIP codes. I think most of them do it by having the longtitude and latidute of each ZIP, and substract. But this gives the air distance. Where can I find software that find the ground distance (like in Mapquest).
View Replies View RelatedFind Out Distance Calculator?
I am looking for a way create a distance calculator from city to city, zip to zip, so on so forth. I know this has been done many times. Does anyone have this around by any chance. Also does anyone know of a place I can get the db or text file I need for this? I know there are some floating about but haven't came across a decent one yet.
View Replies View RelatedAsp Zip Code Distance Search
I have a site and i have a text box for someone to type in a zip code. i nee dto know how to program, or locate a database, where the results will display my business location(s) by zipcode and display the total distance between the zip code entered by the visitor to the site, and my locations.
like Midas has on their site (www.midas.com) where you type in a zip code and it returns the store locations and how far away they are from you.
Distance Betweeen 2 Zip Codes
anyone knows what the formula is for finding a distance betweeen 2 zip codes?
View Replies View RelatedDistance From Two Tables To Insert In One
I am using this code to produce a distance from two LONg, LAT from two different tables. Can any one help me write the code so that it can pull from the correct tables and then insert into one field in on table. Code:
View Replies View RelatedFind Distance Between US Cities Using Zipcodes
I have a database having, US zipcodes, longitude and latitude. What I want to do is LIST THOSE ZIPCODES which are at a distance of given miles from a particular zip code.
For Exmaple: I want to find the zip codes which are at a distance of 15 miles from zipcode 10001 (NYC).
I have the script that uses Zipcodes, latitudes and longitudes of two cities and caculate the distance. But it calculates distance.
Know Any Freeware Zip Code Distance Program?
Any recommendations for a freeware zip code distance program? I need the client to be able to select all clients living within a certain distance of his or her zip.
View Replies View Related*Efficiently* Calculate Distance Between Two Zip Codes
Alright, in regards to my previous post of finding a DB that has all of the latitude/longitudes in a DB, I need to now filter through those based on search criteria. The search criteria available includes: Code:
View Replies View RelatedMicrosoft VBScript Runtime Error '800a000d' Type Mismatch 'Distance' Problem
I have the following code that I am trying to use to calculate distance. However I keep getting a Type Mismatch error on line 50 which is in bold. Code:
View Replies View RelatedConnections DSN Less
I have a problem with DSNless connections. I used the code below but doesnt works.
An error message appears in browser...
<%
conn = Server.CreateObject("ADODB.connection");
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:path odatabase.mdb";
conn.Open;
......
DNS-less Connections
I'm trying to make the following asp code work using a DNS-Less
connection on a windows 2000 server running IIS and ODBC 4.0 driver.
The Access database (odbc_exmp.mdb) was made using Access 2002. The
code works if I set up a DNS on the server under the ODBC drivers.
What I'm I doing wrong and what do I change the code to, to make it
work using DNS-Less connection? Code:
DSN Or DSNless Connections...
Right, which do you use? If your using DSNless, then STOP! It's SLOWING down your code and making it UGLY!!
Why? Lets look...
UGLY!
Which looks better
[vbs]
"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("./data/vote.mdb")
[/vbs]
or
[vbs]
"DSN=databaseStuff"
[/vbs]
Its also easier to manage and will cause less typing errors. Think about it, it makes sense!
SPEED
Everytime you run a DSNless connection inside an ASP page the connection string needs to be verified,but a DSN connection is only verified when it is created! Meaning the DSN connection is indeed faster.
DSN Less Connections Problem
I am not sure what is wrong with this code. I have tested it at home, used in on previous webpages, and with previous employers. But I am getting this error at my current employers server: Code:
View Replies View RelatedMultiple Connections
I've been using ASP.NET for a couple years now and I'm trying to fall back into ASP for a new position I've acquired...and I'm having a bit of trouble remembering. I'm running to a problem where the basic logic is as follows:
Query
Do While Not rs.EOF
Query based on value in rs
Another query based on value in rs
Loop
There is no explicit connection object, they all use the same connection string however. When I limit myself to one query within the Do/Loop, I don't have any problems. However, when I add another query in there, it bombs with: Operation is not allowed when the object is open.
I'm assuming it's referring to the connection string being reused, but why would it allow one additional connection, but not two. I can't really close this connection before needing to requery. Is there anyway around this, or am I missing something entirely?
Implicit Connections
i am maintaining a system that was developed using dream weaver. a lot of the asp ado code looks like this:
set sp_yellow = Server.CreateObject("ADODB.Command")
sp_yellow.ActiveConnection = MM_MHR_CONN_STR_STRING
sp_yellow.CommandText = "Sp_HPMSQ007_GetSystemConstants"
sp_yellow.CommandType = 4
sp_yellow.CommandTimeout = 0
sp_yellow.Prepared = true
sp_yellow.Parameters.Append
sp_yellow.CreateParameter("@RETURN_VALUE", 3, 4)
sp_yellow.Parameters.Append sp_yellow.CreateParameter("@P_NAME_TXT",
129, 1, 17, "MLSTN_YELLOW_DAYS")
set rst_yellow = sp_yellow.Execute
someone on another forum expressed that dreamweaver "tends to drive the programmer to creat implicit connections and their effect on performance".could someone explain this to me? a provide some better code? (we no longer are required to use dream weaver to develop code for the app).
Open To Connections
in my main page i need to retreive record set from the database as well as search for products. but the recordsets i need to retrieve are located in a different table then the products i need to search. is this possible to do ?
View Replies View RelatedActive Connections
I am programming a rather large site which will hopefully attract thousands of visits per day. I have been told by other people that MS access begins to struggle once it has about 15 active connections.
Since I am currently using MsAccess to test my scripts along with IIS 5.0 or whatever it is, I guess that at some stage I am going to have to convert all my stuff so that the data is in an SQLServer Database, and that the scripts can read and write to it. could anyone tell me what the transition is like. should I consider using SQL Server from the beginning or will I just have to change a few lines on each page.
Multiple Db Connections
On my website, I want to provide 3 pieces of statistics that will require 3 queries to my SQL database. As much as I'd like these to be live, they are part of a footer that will load each time for about 10 pages on my site. I am thinking that, although they are simple queries, it may be just too much.
What do you recommend? I could open the connection, run the query and then close it, each time. Would this be a recommend plan? Or, should I create a daily task that builds a simple text file with those query results and just pull those in each time the footer is loaded? This would not be live, but I can deal with it.
Limited Connections
I get somthing like "Max Connection limit is reached" error msg when trying to access a page. I wonder it is got to do with winxp pro sp2 patch which only limit 10 tcp connections? Running ms access as database and IIS 5.1.
View Replies View RelatedClose ALL Connections
how to close all open database connections without referring to each connection by name across an entire server?
View Replies View RelatedMultiple SQL Db Connections
I use a global.asa file to connect to SQL Databases. how would I go about connecting to multiple SQL Databases within a global.asa file?
View Replies View RelatedClosing Connections
What's the proper syntax for determining if a connection is open before closing it?
View Replies View RelatedPort In Connections
i have a connection string (this all in asp )
tCSCst = Provider=SQLOLEDB;Data Source=test02x2;Port=1444;Initial
Catalog=<cataloge>;User ID=<id>;Password=<password>
Set testCaseServerConn = Server.CreateObject("ADODB.Connection")
testCaseServerConn.Open tCSCstr
but i get the following error
An error occured:-2147467259 - Invalid connection string attribute
the problem seems to be the port itself, if i use 1433 then it works fine.
Open DB Connections
how I might go about displaying all current open db connections in ASP, either for a particular web app/page or hopefully all of IIS ? We are having a few issues with IIS hanging and we feel that it is related to db connections that were opened and not closed. I would like to be able to write an ASP page that could show me the current amount of open db connections from IIS.
I need to do this from the IIS side not the SQL Server side. I can already see the number of sessions in SQL Server but I am more interested in trying to find asp pages which have opened a connection to some db and not cleaned up properly afterwards.
Clear All Connections
Is there a way that i can force a drop of all connections to a database. My problem is Access keeps locking my database, i have multiple users using this database, at different periods of the day, and i need a way to clear all connections, i.e at set points throughout the day or at request.
I do close the connection and set all record sets to nothing not sure what else i am missing?
Maximum Access Connections
What is the maximum number of connections that will work when using ASP pages with a MS Access database. I've seen some information that leads me to believe that up to 20 simultaneous users is a practical limit?
View Replies View RelatedSetting Up Multiple DB Connections
I have a global ASA file with the following entries
application("ConnectString") = "driver=SQL Server;Server=HOLLYWOOD;uid=user2006;pwd=password2 006;database=server1"
application("ConnectString") = "driver=SQL Server;Server=HOLLYWOOD;uid=user2006;pwd=password2 006;database=server2"
What I have is two db servers that mirror eachother. What i want to do is if the first server timesout then try to connect to the second server. It there a way to set a timeout and have these switch accordingly?
Is There Any Way To Close All Existing Connections
I have a site which has extensive database activity. What I do is for each procedure I open a connection to the database and close it as and when I leave the procedure. However, in long run I find that some connection to the database is not properly closed causing the site to hang. This has become a big headache for me.
Trying to find what is going wrong I logged opening /closing of connections to the database and found that at some points the connections are not closed resulting in large no. of active connections to the database.
But if I go through the script I cannot really understand why that connection was not closed since the script ensure that the connection is closed before exiting the procedure.
Is there any way where I can check the database may be during night time and close all existing connections to the database. I repeat all my connections to the database are done at the procedure level.
Multiple MS SQL 2000 Connections
I was wondering if it was possible to have multiple server connections in one asp application. Like if one connection to the main sql server failed, it would connect to the backup sql server.
View Replies View RelatedHow Can I List ALL Open Connections
is there any ASP script that will display a list of all open connections on
a shared host
im trying to determine if my previous problem with "system resource
exceeded" can be resolved by brute force?