it just goes dead i think!
dirk
> -----Urspr=FCngliche Nachricht-----
> Von: Hari Yellina [SMTP:hyellina@k...]
> Gesendet am: Friday, September 15, 2000 8:42 AM
> An: ASP Databases
> Betreff: [asp_databases] Connection exceeding the server connections
> Wichtigkeit: Hoch
>
> 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 =3D server.createobject("adodb.connection")
> >
> >
> > connection =3D "Provider=3DMS Remote; Remote
Server=3Dsqldata.abac.com;
> Remote
> > Provider=3DSQLOLEDB;
database=3Dmydatabase;UID=3Dmyusername;PWD=3Dmypassword;"
> >
> > StrSQl =3D "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 =3D 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 =3D "DRIVER=3D{SQL
> >
>
Server};SERVER=3DSQLDATA;LANGUAGE=3Dus_english;DATABASE=3Dmydatabas;UID=3D
myuserna
> > me
> > ;PWD=3Dmypass"
> >
> >
> >
> >
>
>
View Cart
