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!

  • Congratulations TouchToneTommy 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: *

  • Users: kakmouth
  • Content: Threads
  • Order by date
  1. kakmouth

    Linked Server SQLSetConnectAttr Failed (Security Issue)

    Hi, i'm having an issue with linked servers on a Server 2003 box running sql server 2005... the linked server uses an odbc connection into a foxpro database on the network... I can access the linked server (and the data it connects to) from enterprise manager as a windows authenticated user yet...
  2. kakmouth

    Linked Server SqlSetConnectAttr Error

    Hi, i'm having an issue with linked servers on a Server 2003 box running sql server 2005... the linked server uses an odbc connection into a foxpro database on the network... I can access the linked server (and the data it connects to) from enterprise manager as a windows authenticated user yet...
  3. kakmouth

    Difference between Terminal Server Mode & RD for administration?

    To avoid licensing, i'm trying to determine if i could just have my remote offices connect remotely as "administrators" thru the RD for administration as opposed to coming in as clients thru the Terminal Server Mode? what are the major differences between the 2 modes? Is there a downside to...
  4. kakmouth

    Multiple join conditions on indexed fields VERY slow...

    hi, i'm attempting to join 2 fairly large tables (200,000 recs each) on multiple fields via: select b.* from detail d join barcodes b on d.po_num = b.po_num and d.style = b.style where d.wo_num = 123456 into cursor csrBcodes d.wo_num, d.po_num, d.style, b.po_num & b.style are all indexed, yet...
  5. kakmouth

    is it possible to close recordsets within a procedure??

    hi. just wanted to see if it was possible to close a recordset from within the procedure that created it to avoid returning unneeded recordsets??? say for instance i create a recordset merely to see if a record exists for a given filter but would no longer need that recordset, is it possible to...
  6. kakmouth

    are macro substitutions possible in javascript??

    hi. just wondering if it is possible to do a macro substitution in javascript... for example if i define a string variable as: << var lsText = &quot;document.Form1.txt_PONum&quot; >> where document.Form1.txt_PONum is a textbox on Form1, would i then be able to substitute that text/variable...
  7. kakmouth

    looking for a list of equivalent visual fox / javascript commands...

    hi. a while ago i had found a &quot;foxpro/visual basic concordance&quot; list of equivalent foxpro & VB commands/functions that was very helpful... i just wondered if such a thing existed for foxpro and javascript -- just a list of foxpro commands and their javascript equivalents??? has anyone...
  8. kakmouth

    How to delete a cursor after return from procedure??

    hi. within a stored procedure, i created a cursor &quot;Cursor1&quot; but never deallocated that cursor before returning from the procedure. now if i attempt to execute that procedure again, i am told that &quot;Cursor1&quot; cannot be created because it already exists (in that database??). yet...
  9. kakmouth

    VFP ODBC driver into SQL server -- unupported command??

    I'm attempting to run a program (.prg) via an insert trigger in visual foxpro by inserting into that table from SQL server which is connected to the vfp table by linked server. The problem is that running a .prg from the trigger procedure returns an &quot;unsupported command&quot; error. In fact...
  10. kakmouth

    visual foxpro ODBC driver -- unsupported commands??

    I'm attempting to run a program (.prg) via an insert trigger in visual foxpro by inserting into that table from SQL server which is connected to the vfp table by linked server. The problem is that running a .prg from the trigger procedure returns an &quot;unsupported command&quot; error. In fact...
  11. kakmouth

    VFP ODBC driver -- turn off SET ANSI default??

    using a VFP ODBC driver with SQL server, i realized that the SET ANSI option is defaulted to ON which causes the shorter of 2 comparison strings to be padded, as to create 2 strings of equal length. is there any way to turn this option off, either within the SELECT statement or elsewhere??? any...
  12. kakmouth

    visual foxpro vs. interdev for web development??

    can anyone tell me how visual foxpro would compare with visual interdev as web designing tools?? how exactly would i use foxpro to design a website -- would i use asp pages as the front end with foxpro in the back end?? does fox provide ability to create asp pages??

Part and Inventory Search

Back
Top