If my server can allow only five connections at a  time. but I had 6

connections . What will happen to the 6 th connection. 



> ----------

> From: 	Holloway, Mike[SMTP:HollowayM@E...]

> Sent: 	Thursday, September 14, 2000 6:24 PM

> To: 	ASP Databases

> Subject: 	[asp_databases] RE: SQL issue.. problems problems problems

> 

> I'll give it a shot.  You have not tied my_conn to your connection string,

> connection.

> Essentially it looks like you do not have an open connection at the time

> you

> are trying 

> to execute the SQL.  In short you must open the connection before you try

> to

> use it.  

> 

> -----Original Message-----

> From: Brad Libby [mailto:libby_brad@b...]

> Sent: Wednesday, September 13, 2000 7:11 PM

> To: ASP Databases

> Subject: [asp_databases] SQL issue.. problems problems problems

> 

> 

> I am having a problem entering data into a SQL table. This problems occurs

> whether i use recordset or the "insert" command.  And it occurs on the

> line where i execute the statement..

> 

> Here is the senerio

> 

> I grab the data to be entered from a cookie (i choose to use cookies becuz

> someone told me that session were the devil hehehehehhhe)

> 

> here is the code

> 

> set my_conn = server.createobject("adodb.connection")

> 

> 

> connection =  "Provider=MS Remote; Remote Server=sqldata.abac.com; Remote

> Provider=SQLOLEDB; database=mydatabase;UID=myusername;PWD=mypassword;"

> 

> StrSQl = "insert into users (username, password, first, last, address,

> city, state, country, gender, income, zip, age, fax, company, telephone,

> icq, email) values ('" & username & "', '" & password & "', '" & fname &

> "', '" & lname & "', '" & address & "', '" & city & "', '" & state & "',

> '" & country & "', '" & gender & "', '" & income & "', '" & zip & "', '" &

> age & "', '" & fax & "', '" & company & "', '" & telephone & "', '" & icq

> & "', '" & email & "')"

> 

> my_conn.Execute StrSql '''error occurs here'''

> 

> 

> my_conn.close

> set my_conn = nothing

> 

> I recieve the following error

> 

> Microsoft ADO/RDS error '800a1004' 

> 

> Business object cannot be created. 

> 

> /register/thanks.asp, line 42 

> 

> I have verifyed that the table name is valid and that all the columns are

> valid.. when i connect via ODBC i dont get any error and the data goes

> right in.. But once again someone told me that ODBC is the devil

> hehehehe...

> 

> Thanks

> Brad

> 

> PS this obdc connstring works

> 

> connection = "DRIVER={SQL

> Server};SERVER=SQLDATA;LANGUAGE=us_english;DATABASE=mydatabas;UID=myuserna

> me

> ;PWD=mypass"

> 

> 

> 

>