wboevink..
>>1. Usualy you create an instance of the activeX and then make calls to it. If you make 5 calls to it there'll still be 1 instance.
Each session will create a new instance of the active-x object, i.e If 5 different people open the same page,an instance of the object is created for each of the sessions.
2. Yes you can hold multiple connection to databases. But if you are using SQL Server,you can have simply one connection object to a default database.In case you need to access other databases,you can simply use a query like
sql = "select * from DatabaseName.dbo.tableName
sql = "select * from DatabaseName..tableName"
It doesnt matter which database, the connection object is folding reference to.
Regards
KC
Main Topics
Browse All Topics
by: wboevinkPosted on 2002-07-12 at 00:10:07ID: 7148442
1. Usualy you create an instance of the activeX and then make calls to it. If you make 5 calls to it there'll still be 1 instance.
2. Create multiple connection objects if you want open open more databases at the same time, reuse your connection object if you connect to one database at the time but need to access multiple.
Response.redirect to that file.
Read the file through an ADO binarystream and write the file to client using response.binarywrite ado.readstream. There are a lot of good samples around in this forum.
It's better to ask 3 seperate questions.