Search results for query: *

gee thanks let me try that on monday i gtg now.. enought of this for me

i appreciate all it man.. so waht should i do next?

yes remote connection man... wathcah u mean by double ur fun?

no it is ness coz i got an error that a ) is missing i am getting that same error Object or provider is not capable of performing requested operation.

like this Set rs = dbconn.OpenSchema(adSchemaTables, _ Array("mainttestdb", Empty, Empty, "Table"))

Object or provider is not capable of performing requested operation. Set rs = dbconn.OpenSchema(adSchemaTables, _ ->> error here

what does pub mean..let me try that exact code and see if it works thanks

yes we should make it a record. waht is the record posting anways???

Item cannot be found in the collection corresponding to the requested name or ordinal. line -> response.write(rs("table_name"))

i have it like this now response.write(rs("table_name")) but same freaking error Operation is not allowed when the object is closed. line 7 If Not rs.EOF Then -?>>>>

there is sometihn wrong with response.write(rs("[table_name]")) i am getting teh error Item cannot be found in the collection corresponding to the requested name or ordinal.

its actually If Not rs.EOF Then i have removed the password verification code thanks

line 7

The SQL runs fine. I am still getting the same error. Actually the [Table_name] worked as far as the SQL was concerned because i ran it on the reports website. The error is. ADODB.Recordset error '800a0e78' Operation is not allowed when the object is closed. strsql = "use maintestdb select...

so i was getting the same error so i commented out the if not and while stuff to see if it works anyways. so now i am getting the following error! ADODB.Recordset error '800a0cc1' Item cannot be found in the collection corresponding to the requested name or ordinal. Here is the code I am...

its not real i have bogus names :) thanks for leting me know ill work on this stuff tommorow but yeah thanks a bunch for all your help..appreciate it bro..

here is the ASP file as exact i have it .i am simply running it.. <% Set dbconn = Server.CreateObject("ADODB.Connection") dbconn.open("Provider=SQLOLEDB; Data Source=sq111.crystech.com; Initial Catalog=mydbtest; User ID=mydbtest; Password=dotheftp; network=dbmcn") strsql = "use maindbtest...

so u are telling me to create a dbconn to be where?i dont quite understand what u said :)

where are you at man?

any ideas i have wasted my entire freakin day on this thing..