Search results for query: *

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...

UPDATE: If the foxpro data the dsn is accessing is local to the machine, there are no issues.... The problem is accessing data across the network. Thanks again!

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...

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...

ed, what differences are there between coming in as an administrator (to do remote administration) or as a client? am i able to simply allow my clients (remote offices really) come in as administrators to avoid licensing? mike

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...

one more question.... what if that query statement has to be dynamic within this procedure -- so that normally what i would do is create a string variable holding the text of the statement... and then EXECUTE() that statement: ******* SET @lsSQL = " select * from customers where name =...

yeah, you both helped quite a bit... very good suggestions. thanks.

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...

spewn, thanks for the response... the problem that i am having is that i need to create the string variable holding the name of the form's object dynamically... for instance, >> lsText = "document.Form1.But"+lcNum where lcNum is a charcter parameter ("1" thru...

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...

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...

yeah, i know to close and deallocate within the sp, it just turns out that i was doing some error checking and returned from the sp before doing the deallocation of the cursor. that cursor now exists somewhere, so i am unable to create a cursor with that name again. where would this cursor...

jhall, now that i have returned from the stored procedure and CLOSED MY CONNECTION, SQL does not see that cursor any longer??? if i try to &quot;CLOSE <cursorname>&quot; it just tells me that it does not exist. yet if i try to create another cursor with the same name, the error message says...

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...

hey, thanks for the response. if i issue an &quot;insert into&quot; command from SQL Server, the insert trigger is run within my fox database. i am able to do this error-free when the trigger procedure simply accesses various tables (within or outside the current database) or runs other...

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...

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...

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...

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??