Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. michaelcoleman

    ADO - Operation is not allowed when object is closed

    I'm trying to connect to SQL server: Set mvarOCN = New ADODB.Connection mvarOCN.Open "Driver={SQL SERVER};Server=" & mvarserver & ";database=" & mvardatabase & ";Trusted_Connection=yes;" Set mvarRS = mvarOCN.Execute(sqlStatement) when my sqlStatement...
  2. michaelcoleman

    multiple connections with same username

    I have more than one application that uses MS SQL Server. It seems that when I try to utilize more than one connections via different software apps, it often times out until one is complete. App 1 is an inserter....inserts test records into db. App 2..3..4 is a query tool..used to get test...
  3. michaelcoleman

    ActiveX can't create object

    I'm trying to dynamically instantiate class modules based on file input so in my project i have a class module called: myClass.cls I would like to do: dim O as object Set O = CreateObject("myProject.myClass") ...but it errors out with "ActiveX can't create object You may be...
  4. michaelcoleman

    Text Direction / Angle in a table

    Hey, I'm looking for a way to display the column names of a table at an angle. I found the command "writing-mode: tb-rl;" for a CSS which puts text in at 90 degree angle but it's at an angle that people aren't used to viewing (opposite). Is there a way to specify the angle of the...
  5. michaelcoleman

    How to make onChange event to send data to another URL

    An Exerpt of my code looks like: <form action=&quot;Exec.asp?prj=webSPC&cls=Report&quot; method=&quot;post&quot; > TesterType: <select name=&quot;testertype&quot; onChange=&quot;location='Exec.asp?prj=webSPC&cls=View2'&quot; > <option value=Chassis>Chassis</option><option...
  6. michaelcoleman

    using ado recordset and the getstring method

    Hello, I'm having trouble getting the getstring method to work in vbscript over asp. set oADOConnection = openDBConnection() Set oADORecordset = oADOConnection.Execute(buildsql(report_type)) '''call function in sqlUtility.asp and get data...
  7. michaelcoleman

    using adodb.recordset getString method

    Hello, I'm having trouble getting the getstring method to work in vbscript over asp. set oADOConnection = openDBConnection() Set oADORecordset = oADOConnection.Execute(buildsql(report_type)) '''call function in sqlUtility.asp and get data...
  8. michaelcoleman

    using adobc.recordset getstring method

    Hello, I'm having trouble getting the getstring method to work in vbscript over asp. set oADOConnection = openDBConnection() Set oADORecordset = oADOConnection.Execute(buildsql(report_type)) '''call function in sqlUtility.asp and get data...
  9. michaelcoleman

    Display of Variant hosed

    I having an interesting problem. I have sql query which gets data and one of the fields is a variant. The variant field displays fine on cyrstal reports and also on my sql client. When I publish the report on a website, the value for these fields are displayed in ascii hex format...
  10. michaelcoleman

    get html from crystal using vb6

    Hello, I'm trying to convert my report from .rpt format to html so i can post it on the web: I'm using ASP... <%@ Language=VBScript %> <% dim oInstance dim sClass, sProject dim sClassString sClass = Request.Item(&quot;cls&quot;) sProject = Request.Item(&quot;prj&quot;) sClassString =...

Part and Inventory Search

Back
Top