Oracle ODBC driver from Microsoft vs Oracle

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Exchange Fox
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - VFP 9: Compiling in a VFP .exe The build procedure for my app has gotten a bit more complicated, so I want to automate it. How do I get build project and build exe to execute in a VFP .exe called from the command line? I got a feature not available message when I tried. There is a full VFP system on the computer I used. I am trying to get both the build and zip done in a batch file. Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231500
  - 2
    - Any last requests? I could work with VFP for a while more if only I could read and write = UTF-8 in Sql Server without double byte translations leading to ??? = (unless somebody knows how to do this with the current VFP) What are other requests that people would still have? Robert Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231490
  - 3
    - Making a calling form invisible I have developed an Output class to handle reporting, exporting etc. This is called from scores of forms with a few parameters. After it has all been designed I have decided that I would like to make invisible whatever form calls the Output form. I can do this by: thisform.visible = .F. DO FORM <outputform> thisform.visible = .T. but I would like to avoid having to edit so many forms. Is there a way I can achieve this from the Output class without having to edit all these calling forms. I am NOT passing the calling form as an object parameter to the class. I wish now that I was! Thanks Stephen Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231475
  - 4
    - What's in the 71st byte of FXP files? We're using an utility who checks differences between FXP from different releases of a VFP software, and it uses a simple file compare logic. We cannot base that on "data and time modified" because these are unreliable, expecially after another utility recompiles all of the files. This morning we started noticing that the comparison found differences in all of the FXP even if we modified only a few, and the reason is that the 71st byte is always different from the past releases. It looks like something has changed in the output of the "compile xxx nodebug" command, starting from yesterday or today. Has anyone else had an issue as this? What could have triggered this situation? And, BTW, who knows where I can find info on the FXP file structure, of about the 71st byte of FXP's? -- Microsoft News Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231474
  - 5
    - Combine aggregate records from a UNION? Say I have 2 tables of invoices, one containing 2006 invoices and the other 2007. In a single SQL statement, I want to sum up the invoice amounts, grouped by customer number: SELECT CustNo, SUM(Amount) AS InvTotal FROM Inv2006 GROUP BY CustNo UNION ALL SELECT CustNo, SUM(Amount) AS InvTotal FROM Inv2007 GROUP BY CustNo INTO CURSOR Tmp ORDER BY CustNo If a given CustNo exists in both Inv2006 and Inv2007, the UNION will produce 2 records for this CustNo: one with the total amount for 2006 - the other the total for 2007. How can I modify my SQL statement to consolidate the results of the UNION so that I only end up with ONE record for the CustNo - with InvTotal equal to the total customer spent in 2006 plus 2007? Many thanks! -Mike Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231461
  - 6
    - missing subreport? ireponame = 'REPT_360.rpt' isubreponame = 'subtotal' SetCrRpt(thisform.olecontrol1) with Thisform.olecontrol1 .reportfilename = ireponame .datafiles(0) = fnd .connect = 'DSN=TEMP' .subreporttochange = isubreponame .datafiles(0) = fnd .connect = 'DSN=TEMP' .subreporttochange = '' .destination = outputtype .printreport() endwith I found that there is no "subreport.rpt", only a "rept_360.rpt". Is this sub-report a fake? -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231459
  - 7
    - Tableupdate failure-index does not match..... I have a parameterized view. I put a few records in it. I update the records. I issue tableupdate. If I don't update the first record in the view, the tableupdate fails, and aerror() shows me Index does not match the table..., error 114. I know for a fact that there is nothing wrong with the index, and this only happens if I don't enter a value in the first record. I've seen this before, but don't remember where or when. Anyone recognize this issue? Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231456
  - 8
    - Customzied papersize setting Hi all, I have defined a new label size for printing labels using barcode printer. It works fine in my pc when running my foxpro program. However, when it is printed from the others pc, the label size gets the other size although new label size is already set. I have tested many times by setting the default printer which refered to the new label size. It still failed. Finally, I discovered that it's the problem of papersize. My PC papersize for the new label is 134 and it works in my pc but not on the others. However, I have set the papersize to 154 and it doesn't work on my pc, but it works on one of my colleagues pc. Is there any default papersize setting that refer to customized size on window XP ? Thanks a lot! -- sze Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231455
  - 9
    - Disable Menu Items Hi, How do I disable Menu Items (Using Define Menu) when I preview a report? Thanks, Herbert Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231453
  - 10
    - How to get the form object ? Dear All, How to get the "Form Name or Form Object" in object "ytxt" ? e.g. ytxt = thisform.pgf1.page1.pgf2.page3.txtbox Thanks ! Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231441
  - 11
    - test -- Thanks ! Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231440
  - 12
    - Import UTF-8 text from Excel Is it possible to import or read texts from an Excel file that include = UTF-8 texts? Robert Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231435
  - 13
    - Intermittent Error 12 - Variable Not Found I have a situation where I am intermittently getting Error 12's trapped to my application (VFP7 based). The code path is something like the following: In my form: snparptr = 0 =gnssadd(,,,,) In gnssadd the following code is executed: =gnaddrec() REPLACE fddate WITH DATE(), ; fcsnaptime WITH TIME(), ; fnparent WITH snparptr, ; fccancel WITH vccancel, ; fctable WITH lctable, ; fcaction WITH vcaction, ; fnrecno WITH lnrecno, ; fcprompt WITH vcprompt SAVE TO MEMO fmdata ALL LIKE f* The gnaddrec either adds a new record to a table or reuses a deleted record. The error 12 error nominates the snparptr as the variable that is not found I cannot see a code path were the snparptr variable is disposed of. The problem is very intermittent and in most cases once the error has been received you can re-enter the program and execute the same function and have it work fine. Is there some resource that is being depleted that is causing this error? or any suggestions of another cause? thanks pete Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231428
  - 14
    - eReports on vfp6 untracable error Using DBX tech eReports, we have a report to pdf conversion that works fine in the IDE and locally compiled but returns a code 124 on a clients system running under terminal services. the oReports.ErrorLog seems not to be returning a string any help to resolve this would be appreciated John Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231426
  - 15
    - do work intellisense , form , with , endWith This is a multi-part message in MIME format. ------=_NextPart_000_00B0_01C76FB5.AC335F00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all i would like to have intellisense for my form, With the operator With = EndWith i would like to have my custom Method or Custom Property. With ThisForm as Form of G_RUE.SCX EndWith it's doesn't work , have you an idea ? thank's=20 Olivier ------=_NextPart_000_00B0_01C76FB5.AC335F00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.3059" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><STRONG><FONT face=3DArial color=3D#000080 size=3D2>Hi = all</FONT></STRONG></DIV> <DIV><STRONG><FONT face=3DArial color=3D#000080 = size=3D2></FONT></STRONG> </DIV> <DIV><STRONG><FONT face=3DArial color=3D#000080 size=3D2>i would like to = have=20 intellisense for my form, With the operator With = EndWith</FONT></STRONG></DIV> <DIV><STRONG><FONT face=3DArial color=3D#000080 size=3D2>i would like to = have my=20 custom Method or Custom Property.</FONT></STRONG></DIV> <DIV> <DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2><BR>With = ThisForm as Form of=20 </FONT><FONT face=3D"Courier New" size=3D2>G_RUE.SCX</FONT></DIV> <DIV> <P><FONT face=3D"Courier New" size=3D2>EndWith</FONT></P> <P><FONT face=3D"Courier New" size=3D2><STRONG><FONT face=3DArial = color=3D#000080>it's=20 doesn't work , have you an idea ?<BR><BR>thank's=20 <BR></FONT></STRONG></FONT><STRONG><FONT face=3DArial color=3D#000080=20 size=3D2>Olivier</FONT><FONT=20 face=3D"Courier New"></P></FONT></STRONG></DIV></DIV></BODY></HTML> ------=_NextPart_000_00B0_01C76FB5.AC335F00-- Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231416
  - 16
    - vfp9 speed issue group, our app has several screens with hundreds of objects. They open instantaneously in vfp6 but they take over 10 seconds in vfp9, making 9 totally useless for us. Has anyone come across this type of behavior? We use vfp9sp1. Wade Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231410
  - 17
    - Active Directory User name and Password How can I read the user name and password from Active Directory? in other words how can I authenticate a user through Active Directory? Thanks HME Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231406
  - 18
    - print dbf file How do i print dbf file Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231382
  - 19
    - Which Tags Are Used? Hello and thanks for the help. Is there any data in the CDX file that would indicate that last time an index tag was used? I have a table with a lot of tags some of which I sure are never used. I can search the code but that doesn't tell me which ones might have been created to speed up an SQL query. Is there any index tag usage data available? Thanks, Jeff Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231367
  - 20
    - Fox Programmer .... Need Jobs Sir, My name is Tommy from Thailand. With my Visual FoxPro experience more than 6 years. I need more jobs. Who have jobs for me, feel free to contact me anytime Thanks Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231366
  - 21
    - Check to see if SQL table has been updated by another user Hi... What's the quickest and simplest way to check if a row has been changed (by another user) on a remote SQL table? Obviously TABLEUPDATE returns .F. if it encounters and error but it would be better to 'test' the condition before even attempting to perform the update. Any help would be much appreciated. Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231364
  - 22
    - buffering select 0 use tablea shared select tablea cursorsetprop("buffering",4) set filter to type="A" select use tablea again shared alias tableb set filter to type="B" * 1. is the following necessary? select tableb cursorsetprop("buffering",4) ... ... show form to edit these values ... ... * 2. if I tableupdate() tablea, * will tableb be tableupdated() as well? 3. Any other things I need to remember? -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231355
  - 23
    - help, cash denomination.... hi experts, anybody can give me some example that of cash denomination, like for example, the given is 1525.75 and the output would be.... 1000 - 1 500 - 1 100 - 0 50 - 1 20 - 1 5 - 1 .50 - 1 .25 - 1 thanks in advance.... Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231353
  - 24
    - Vista and Elevation Hello all! I have been working for 2 days trying to figure out how to change my application (written in VFP9) to work with Vista. The first objective is writting to the registry. The way our application works... the first time you launch it, it asks for a Code. The user enters this code and the program saves it to the registry under HKEY_LOCAL_MACHINE. This works great under XP. This way if they change users or they are running terminal server, they all find this entry in the same location. In order to write to the HKEY_LOCAL_MACHINE on Vista, you must be elevated to Administrative level. I have read several articles on how to achieve this, but the common belief is to create a separate program that can be run from your main program. This new "separate" program should be setup to require administrative rights using a manifest file. Now the trick I needed to pull off was to be able to call this program and wait for it to close. I tried a few solutions... but the one that seemed to work best for me was to create a third program. This third program will be a COM Object accessable by Foxpro, with the sole purpose of running the "separate" program mentioned above and wait for it to close. I call the COM Object from VFP and it stops the VFP programs execution until the separate program is closed. Perfect! It seems like I found the answer.. but because I knew it had to be too good to be true I decided to test a little. I created two shortcuts on my Vista desktop. Both shortcuts run Foxpro 9, but one is flagged as "Run as Administrator" and labeled "Admin". The other shortcut runs as Standard User is titled "Standard". When I run the Standard VFP shortcut and execute the Com Object, everything is perfect. Life if great! Now I tried to run the VFP shortcut "Admin" and access the COM Object. Here is where the problem is..... Class definition x.y is not found Help! I don't know what to do next. When I run the "Admin" shortcut, Vista prompts be to "Allow / Cancel". It is elevating my instance of VFP to Admin level. But when I attempt to execute the COM Object it cannot find the class definition. Any ideas on how to get around this "little" problem? How is everyone else handling this? Thanks Dan Tallent Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231330
  - 25
    - Gefile on terminal server Hi, a client reports following situation with our Application (built on VFP9SP1): Every dialogue, where we use the putfile or the getfile function, does not appear. They had to delete the local profiles of the user on the server, because there were problems in the encryption module, and after that, the getfile() - function does not show the input form. the command is totally ignored... How can I make the dialogue appear? Thank you! Bastien Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231316
- Next
  - 1
    - Winsock and ip address changes Hi and thanks in advance for the help. This isn't strictly a Fox question but since I develop in Fox I thought I'd see if any of you have any ideas about this. I use the MS WinSock control. One of the properties is LocalIP which should be your machine's IP address. It is set by the control and not changeable in code. My application stopped working and I was looking at the LocalIP property. It said 0.1.4.0 instead of 192.168.0.33 which is my correct ip address (fixed, no dhcp involved) Once I rebooted, the LocalIP went back to 192.168.0.33 I'm curious as to how it got changed. Did I have some poorly behaved software? Did my machine need a re-boot and the funny IP Address was a symptom? Is something more evil going on? If anybody knows anything about this please tell me. Thanks, Jeff Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231310
  - 2
    - Upgrade from VFP 6 to 9 - RUN command fails I have the RUN command in a long-standing app that I am now running under VFP 9 for the first time, but even from the command window, a simple RUN cmd or RUN command both fail. I'd appreciate suggestions on what to look into next. The RUN command is an integral part of this application and we need it to work. If I do a DIR <batchfilename> from within VFP 9, the file is there, and I can edit it from a cmd window (which I just did) and save my changes, and I also just ran it from a cmd window, but this is a cmd window opened by the operating system (me clicking on the shortcut on my desktop labeled "dos box") and not from within VFP 9. Thanks in advance. -S- Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231308
  - 3
    - Problem with VFP9 report In group footer we have: in 1st line - field object with Fix relative to top option in 2nd line - field object attached to memo field in table with Fix relative to top and Stretch with overflow options in 3rd line - field object with Float option in 4th line - field object with Float option If memo field has up to 20 lines everything is ok, but if memo filed is longer than 20 lines footer continues on next page but it does not print 3rd and 4th line. Thanks in advance Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231298
  - 4
    - FoxPro with MySQL how to use Foxpro to access MySQL database ? some sample will be good. thanks! Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231297
  - 5
    - List of all Foxpro base properties? I am trying to write a program to document the custom classes I made. How could I obtain a full list of base property names of all base classes, so that I could auto-magically know the property is a custom one or a base one? -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231293
  - 6
    - Patches for VFP 9.0 I just installed VFP 9. On this page: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx The first item is SP1, and the second item says what's in it is already in SP1. What about the remaining items on the page - do I want/need them? XSource FFC VFPCOM Utility There is a brief explanation of each on the web page but I'm afraid it's a little too brief for me. TIA. -S- Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231291
  - 7
    - Delete query Can someone tell me why the following does not work? I have two tables, cps and complete. I need to delete all the records in cps that match the records in complete. Here's my query: DELETE FROM cps.DBF WHERE Cps.invoice = Complete.invoice When I run that above Foxpro tells me that 0 records were deleted. Any help would be greatly appriciated. Jim Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231286
  - 8
    - Sending report to file I have a large VFP application I inherited. There is a function I made to create a PDF from a report and email the PDF file. I send the output to a file using the command REPORT FORM MyReport NOCONSOLE TO FILE MyResultFile.ps I then use GhostScript to create a PDF. Everything works fine the FIRST time, but the next time I run the REPORT FORM command, the output is sent to the default printer and not a file. In trying to find the problem, I have used DISPLAY MEMORY TO FILE both times to compare the contents of memory. I have done the same with DISPLAY STATUS. I do not see any glaring differences that would prevent the output to a file the second time around. If I exit the application and reenter each time, the report is sent to a file successfully. It only fails if I _don't_ exit the application and it only fails after the first run. I have verified the printer is being set correctly and the SET('PRINTER', 3) is the printer with the postscript driver. This definitely seems like a bug in VFP since a file is not created and the REPORT FORM command should produce a file because of the "TO FILE". Any ideas? Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231285
  - 9
    - Question: Is VFP a Developing tool or a Database ? If you believe so, please take a look at the following link which is there since 2004: http://www.microsoft.com/usability/enrollment.htm Demetrios, Greece Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231278
  - 10
    - Project Documentation Machine What is "repair object hierarchy in progress"? -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231271
  - 11
    - VFP9: Weird Event Issue A central part of my app is the Invoicing Wizard. It gives the operator a display of Work Orders and the opportunity to select one for invoicing. Because of the nature of the business, there are many things to check before invoicing, so the form has thirty-two buttons. While this might seem to be a good entry for the Interface Hall of Shame, it does work rather well. (Yes, I have used the app as well as having written it.) There is a peculiar behaviour that I noted when working on a related matter. Each Work Order listed has a textbox next to its details. Putting a "Y" in it selects the Work Order for invoicing. The textbox has input validation for whether it will allow the Work Order to be selected for invoicing. Among the things that is checked is the Work Order Type. If it is "E", then a messagebox asks whether this is what was really intended and should the system change the type to "F". If yes is chosen, the Work Order is updated and so is the display. If not, the Work Order is not selected. If "Y" is entered into the textbox, focus is moved off it (say, with <Tab>), and then the "Generate Invoice" button is clicked, invoicing will start. However, if "Y" is entered into the textbox, but focus is not first moved off the textbox before clicking "Generate Invoice", when the Work Order Type is "E", the messagebox will appear, a yes response will result in the Work Order and the display being updated, BUT invoice generation will not start. The focus will be on the Generate Invoice button, but the button's click will not get executed. My question is why does the button's click not get executed. Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231262
  - 12
    - SQL query problem with character comparison. Hi, I have a problem in Foxpro. We have a query like Select * from Account, Bank where alltrim(account.bank_id) = alltrim(bank_bank_id) and alltrim(account.Bac) = alltrim(Bank.Bac) and alltrim(Bank.Bac) = '0000991' and not Deleted() Bank table has a column Bac which is type Charater(7). The application always inserts 7 charactes in this column. Eg. for 71 it will insert 0000071. But i have some records in the table which are marked deleted and they have bac column as 0001 i.e is less than 7 characters. The problem is above query does not return a result set even though there are records present. Moreover if i pack the table Bac, the query works fine. I also tried changing the query to Bank.Bac = '0000144'. Initially it worked fine and returned me 400 records. Then i zapped 300 records from account and executed the query. this time it agan gave me no records. By some trial and error i found that the modified query worked if there were more than 170 records. For any less it gave blank recordset. I want to find out the reason for such weird behaviour and if this some Foxpro limitation Please reply. Thank you Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231250
  - 13
    - Foxpro going open-sourced? http://www.linux.org/news/2007/03/20/0001.html -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231249
  - 14
    - Mulitiselect records on the Grid hi expert, how can i multiselect records on the grid. can you give me some example code thanks.... gechelle Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231243
  - 15
    - Microsoft is going open-source the core portions of the Visual FoxPro DBMS! I want to be between the first ones to bring this news: http://www.eweek.com/article2/0,1759,2105307,00.asp =A1Can't believe that! Best regards, Fernando D. Bozzo Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231239
  - 16
    - focus.fll and vfp9 I used focus.fll in my vfp7 application, and there are hundreds of users out there. I used 2 functions (fil_encrypt and fil_decrypt) to encrypt and decrypt personal information. (I also used fil_open and fil_create but haven't started to worry about these yet). I am in the process of moving this application to vfp9 and of course focus.fll is no more. My dilemma is how to enable users to transfer their data. I don't really want to have to supply a separate vfp7 exe with runtimes to convert the data, but can't get a response from fastwrite.com about purchasing the source code for these functions. Does anybody have any help or advice to offer? Sincerely Stephen Ibbs Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231232
  - 17
    - Foxpro 2.6a windows Install disks Anyone know how I can get access to install disks for this program? Does anyone that no longer needs their copy be willing to sell it off to me? Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231224
  - 18
    - No more Foxpro Would Micro$oft open the source codes of VFP since it's only Micro$oft that has no interest in it..... -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.10) Linux 2.6.20.3 ^ ^ 20:18:01 up 1 day 6:36 0 users load average: 1.00 1.00 1.00 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231222
  - 19
    - How to APPEND FROM XLS for Cell with formula? Good day everybody, I am using VFP8.0 and Excel 2002. I have been using VFP program to use APPEND FROM to read Excel file and fill my DBF with data. So far I have no problem with that. However due to end-user request to minimize data entry work, I replace one of the Excel column with formula VLOOKUP to get some data from Excel table in the same workbook. Now I couldn't get the result upload into DBF file. I get a black box and first letter of the result only. I will appreciate if some one can guide me to solve the problem. Thanks in advance and hope to hear from you. Best regards, Julie Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231218
  - 20
    - Variable declaration doubt why and what is the benefit of following code local oSomething as "SomeServer" over the following code local oSomething since following code works even without declaring the variable. oSomething = NEWOBJECT("SomeServer") thanks! Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231212
  - 21
    - [fw] can this routine be sped up? wait wind "Starting Excel..." nowait tmpsheet = getobject('','excel.sheet') XLApp = tmpsheet.application XLApp.WorkBooks.Add() XLSheet = XLApp.ActiveSheet t_head1 = 1 select output goto top t_loop = 1 do while !eof() t_loop = t_loop + 1 XLSheet.Cells(t_head1+t_loop,1).Value = "'"+bookno XLSheet.Cells(t_head1+t_loop,3).Value = "'"+bookname XLSheet.Cells(t_head1+t_loop,4).Value = 'BOOK' XLSheet.Cells(t_head1+t_loop,5).Value = "'"+iif(empty(output.oapprm1),'',left(dtoc(output.oapprm1),5)) XLSheet.Cells(t_head1+t_loop,6).Value = "'"+iif(empty(output.ppdate1),'',left(dtoc(output.ppdate1),5)) XLSheet.Cells(t_head1+t_loop,8).Value = "'"+iif(empty(output.pstarts1),'',left(dtoc(output.pstarts1),5)) XLSheet.Cells(t_head1+t_loop,9).Value = "'"+iif(empty(output.bstarts1),'',left(dtoc(output.bstarts1),5)) XLSheet.Cells(t_head1+t_loop,10).Value = "'"+iif(empty(output.bcd1),'',left(dtoc(output.bcd1),5)) skip enddo -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231206
  - 22
    - How to "select ..." on SQL Server 2000, Thnaks! Dear All, How to "select ... " on SQL Server 2000, Thanks! Q1: "select recno() as yrecno, * from tablename into cursor xx order by 1" Thanks! Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231199
  - 23
    - Grids In VFP6. Can you create a grid programmatically ? I can create a window on the fly and activate it, but would also like to put a grid into it with selected characteristics Thanks.. -- Tim Hobson Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231190
  - 24
    - Docking Windows Hi, When docking a window on the side and another on the bottom, the bottom window will always push the side window up. It seems when docking on the top or bottom, those windows will always dock full screen width. Is there anyway to change this so the windows docked on the side will show full screen height? Thanks Dave Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231185
  - 25
    - VFP9: How to prevent undocking of a form? Hello How to prevent undocking of a form? Thx Tag: Oracle ODBC driver from Microsoft vs Oracle Tag: 231183

Hi,

I have some applications written in VFP9 accessing Oracle databases thru
ODBC, for some unknown reason, I always install the ODBC driver provided by
Oracle, but it seems to be more heavy and time consumming to install it, so
I wonder how would it be to use the ODBC driver provided by microsoft that
is already installed on any PC, has somebody onthe forum used the microsoft
driver?

I would appreciate any advice or info about comparision and reliability of
both ODBC drivers

thanks

Oscar Taboada

Top