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.
do u have experience in using browsers (IE or Firefox) control hardwares like barcode printer or com port before? can it be done? if yes is it using ActiveX to achieve it?
View Replies View Relatedhow to open port 80 so that I can access my website from other computers?I am using Xp professional.
View Replies View Relatedi use a dll (ASP) that uses the serial port to connect to a out of date disk reader
that work fine if the disk reader is hook up to the servers serial port
is there any way to hook up the disk reader to a CLIENTS computer let im navigate to my web page(ASP) and use it trought web
what technologies are involved
i am running iis and apache both.now i want to change the port of iis to e.g 70.how can i change it?
View Replies View RelatedI've got an asp app that needs to use SSL only for certain pages. Is there a way to shut off port 80 for certain pages (HTTS pages), but have it open for other pages? Can this be done in IIS? OR is this something we can do testing server variables in the asp classic vb script code? OR, do we set up another web site that has port 443 closed and only have the secure pages on that web site with port 80 closed?
View Replies View Relatedi set up iis 5.0 on my local machine(win2kpro) (on a pvt LAN) at the default port. when i try to access asp it gives http 500 error. i have been able to configure cgi scripts but asp still doesnt work.
View Replies View Relatedi know how to find the available server names, how can i find the ports?
View Replies View RelatedIs asp/asp.net able to interface with the PC's I/O ports? I'm currently doing a program on VB using the SDK from the vendor to interface my biometric scanner to my PC using usb port. Can this same thing be done using asp?
View Replies View RelatedI need a asp script which can open port on a server. I have ads running in a server. Since there r too many http requests, server is hanging.
The server load is 100%. I plan to switch from http to port technology. I need help to write a script in asp which can open port on a server, so that there can be free flow of data.
I'm trying to use Enterprise Manager to manage my remote SQL database, but I can't seem
to get a connection. I think my cable ISP Comcast may be blocking the port EM uses.
What port does Enterprise Manager use to communicate with SQL?
I have to setup a point-of-sale system for a friend. He has a PC, barcode scanner, receipt printer and cashdrawer.
The receipt printer connects to the serial port.
The cashdrawer connects to the printer.
The barcode scanner has a keyboard wedge.
Do I need to setup the receipt printer as a windows printer?
OR can I send output directly to the serial port using ASP?
The salesman told us that there is an epson escape sequence that you append to the end of the sales receipt information, which will kick the cashdrawer open, so that sounds simple enough. Just not sure on how the printer should be setup/configured so I can send the escape sequences to open the cashdrawer.
How do I get the client Ip and Port in an ASP page. I know about server.variables (REMOTEHOST) for the ip address, but how do I get the port of the remotehost (client).
View Replies View Relatedi have a server and client game that uses a port for ppl to connect to. so they can play
port : 7234
i want to create a asp page that tells you how many connections are currently connected to the port (ie users playing)does anyone know the code to do that. ive spent all day looking for some code but cant find any.
I am trying to find out how to connect to a different SMTP port
in ASP.
My default SMTP Port 25 which has been setup for SSL authentication
and works fine.
From ASP pages, I do not want to do SSL and therefore, need to send mail
through a different SMTP port (997). How can I do this?
Here is my ASP Code:
Set Mailer = Server.CreateObject("TCPObj.SMTP")
Mailer.FromName = "my company."
Mailer.FromAddress = "info@mycompnay.com"
Mailer.To = Email
Mailer.SMTPServer = "mail.mycompany.com"
Mailer.Subject = "test email!"
We are planning to change the port that SQL Server is listening on at our Web Hosting company(TELUS).
Our SQL Server is being attacked. There are thousands of unauthorized attempts to login.
Is it possible to specify port number
in ASP code?
here is my cn:
PROVIDER=SQLOLEDB.1;DATA SOURCE=MachineName;INITIAL CATALOG=DatabaseName;USER ID=iserid;PASSWORD=password;
How should it look like if let's say our SQL port is 32566?
i have a connection string (this all in asp )
tCSCst = Provider=SQLOLEDB;Data Source=<bd>;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
I need to develop a web application in asp.net which can detect a USB device and capture its
events...
For example when a person access the web page and connects the device to his machine he shld be
able to detect the device and shld be able to read or write into it.
I wrote a java program using jusb and called that in an applet..though it worked it needed lot
of client side configurations.
My requirement is that there should not be any configurations in client side and things shld
work smoothly.
I know some one had done this in asp and javascript. but i don't know how its done.
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;
......
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:
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.
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 RelatedI'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?
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).
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 RelatedI 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.
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.
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 Relatedhow to close all open database connections without referring to each connection by name across an entire server?
View Replies View RelatedI 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 RelatedWhat's the proper syntax for determining if a connection is open before closing it?
View Replies View Relatedhow 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.
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?