Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc

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
    - [ALT] key cannot open menu while running in EXE I have designed a menu 'MAINMENU' and define the ALT key in [keypress] in menu designer. This menu will be called from a form 'MAIN', The ALT key works while in the design time, after that, I compile it to build an exe file, the ALT key doesn't work. Inside the initial main.prg, I have several environment settings and at last, there is as do form MAIN read events and in the INIT event of form MAIN, the content is do mainmenu.mpr with thisform, .t. Below are some setting of the form MAIN ShowWindow - 2-As Top-Level Form WindowType - 0-Modeless MDI Form - .f. Please, can anyone give me a hand on this issue. thanks lot Edward Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189215
  - 2
    - How : Create remote view programmically? I try the folllowing code to create the odbc connection and remote view. However, those code didn't work . Canyone give me a hand ? OPEN DATABASE u:\sample\data\tradelink SET DATABASE TO "tradelink" IF INDBC("itts_connection","CONNECTION") = .F. Create connection itts_connection ; connstring; 'Driver={Microsoft Visual FoxPro Driver};'+; 'DBQ="u:\sample\data\tradelink" ;' CREATE VIEW itts_chl CONNECTION itts_connection AS SELECT * FROM CHL -- Thanks For Your kind Attention. From Agnes Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189208
  - 3
    - Promatrix Spam! Just for those of you who don't take kindly to spam (I've never made any approach to Promatrix): Return-Path: <promatrixnews@promatrix.com> Delivered-To: astechsystems@iinet.net.au Received: from unknown (HELO ms-smtp-03.tampabay.rr.com) (65.32.5.133) by mail.iinet.net.au with SMTP; 2 Feb 2004 23:29:03 -0000 Received: from EMACH1 (653220hfc53.tampabay.rr.com [65.32.20.53]) by ms-smtp-03.tampabay.rr.com (8.12.10/8.12.7) with ESMTP id i12NSD1H027087 for <astechsystems@iinet.net.au>; Mon, 2 Feb 2004 18:28:58 -0500 (EST) Message-ID: <4149-22004212232748359@EMACH1> Organization: ProMatrix Corp. From: "ProMatrix" <promatrixnews@promatrix.com> To: astechsystems@iinet.net.au Subject: Professional Visual FoxPro Framework Only $49.95! Date: Mon, 2 Feb 2004 18:27:48 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_84815C5ABAF209EF376268C8" X-Virus-Scanned: Symantec AntiVirus Scan Engine X-Spam-Status: No, hits=3.6 required=5.0 tests=EXCUSE_3,FOR_JUST_SOME_AMT,HTML_40_50,HTML_FONT_BIG, HTML_FONT_COLOR_BLUE,HTML_SHOUTING3, HTML_TABLE_THICK_BORDER,MAILTO_TO_REMOVE, MIME_BOUND_NEXTPART,RCVD_IN_RFCI version=2.55 X-Spam-Level: *** X-Spam-Checker-Version: SpamAssassin 2.55 (1.174.2.19-2003-05-19-exp) ------=_NextPart_84815C5ABAF209EF376268C8 Content-type: text/plain; charset=US-ASCII VPM Standard Only $49.95. Go to: http://www.promatrix.com/mall/vpms01.asp VPM Enterprise 8.1 Now With Multilingual Toolkit and Source Control. Go to: http://www.promatrix.com/vpme/vpme01.htm ------=_NextPart_84815C5ABAF209EF376268C8 Content-Type: text/html; charset=US-ASCII <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>Spotlight on  VPM 7</title> </head> <body topmargin="0" leftmargin="0" bgcolor="#FFFFFF"> <div align="center"> <center> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%"> <tr> <td width="100%" align="center"> <table border="1" width="615" style="border-collapse: collapse" bordercolor="#000080" cellpadding="0" cellspacing="0" bgcolor="#000080"> <tr> <td width="26%" bgcolor="#000080"> <img border="0" src="http://promatrix.com/email/pweb_banner_navy.gif" width="195" height="60"></td> <td width="74%" bgcolor="#000080"> <p align="center"><b><i><font face="Arial" size="7" color="#FFFFFF"> Breaking News</font></i></b></td> </tr> </table> <table border="0" width="615" bgcolor="#000080" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#111111"> <tr> <td width="100%" bgcolor="#000080"> <hr> </td> </tr> </table> <table border="3" width="615" bgcolor="#FFFFFF" cellpadding="3" cellspacing="0" style="border-collapse: collapse" bordercolor="#000080"> <tr> <td> <table border="0" width="100%" cellspacing="3" cellpadding="2" style="border-collapse: collapse" bordercolor="#111111"> <tr> <td width="83%" align="center"> <b><font face="Arial" size="4" color="#000080">News Topics</font></b></td> </tr> <tr> <td width="83%" align="center"> <ul> <li> <b><font face="Arial" size="4" color="#0000FF"> <a href="#Get VPM Standard For Only $49.95">VPM Standard Only $49.95</a></font></b></li> <li> <b><font face="Arial" size="4" color="#0000FF"> <a href="#VPM Standard Multilingual Toolkit Now Only $49.95">VPM Standard Multilingual Toolkit Only $49.95</a></font></b></li> <li><b><font face="Arial" size="4" color="#0000FF"> <a href="#VPM Enterprise 8.1 - Multilingual & Source Control">Introducing VPM Enterprise 8.1</a></font></b></li> <li><b><font face="Arial" size="4" color="#0000FF"> <a href="#VPM Enterprise 8.1 Demo Now Available">VPM Enterprise 8.1 Demo Now Available</a></font></b></li> </ul> </td> </tr> </table> </td> </tr> <tr> <td height="29" bgcolor="#000080" bordercolor="#000080"> <p align="center"> <b> <font face="Arial" size="5" color="#FFFFFF"> <a name="Get VPM Standard For Only $49.95">Get VPM Standard For Only $49.95</a>!</font></b></td> </tr> <tr> <td height="29"> <table border="0" cellpadding="2" cellspacing="3" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2"> <tr> <td width="100%"> <p align="center"><b><font face="Arial" color="#0000FF">A regards - anthony shipley look, ma - no .sig Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189206
  - 4
    - My grid´s rightclick event is lost Hi all! I have to close and reopen a view to populate a grid (designed in VFP7) in VFP8. This probably because of lack of backcompatibility VFP8 to VFP7. I do this with the code below. SELECT vwRelscomp USE USE vwRelscomp IN 0 SELECT vwRelscomp Requery('vwRelsComp') This.Grid1.RecordSource = 'vwRelscomp' This.Grid1.Column1.Text1.ControlSource = 'vwRelsComp.relname' This.Grid1.Column1.Width = lnCol1Width && saved before closing the view Now the grid is populated again even in VFP8 but the Grid1.Column1's capacity to fire it's rightclick event becomes lost. How can I get the rightclick event (a shorcutmenu designed i the menubuilder) back to work? Regards Christina Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189205
  - 5
    - VFP running Access Query/Macro Hi Do you know of a way to run an Access query/macro from within VFP. No ODBC Similar to usin loXL = getobject('','Excel.Application' loWB2 = loXL.Workbooks.open('c:\earnedvalue\module\earned_value_data_shell.xls' loWB2.Application.Run('earned_value_data_shell.xls!import_data' to run an Excel macro Thanks Ga Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189203
  - 6
    - micration tool What is the best migration tool for VFP 6.0 ? -- George Malekkos ________ --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.572 / Virus Database: 362 - Release Date: 27/1/2004 -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189191
  - 7
    - Printing statements to Adobe files I would like to print statements to individual adobe print files for emailing. I have developed a process that runs the statement report for each customer. When I change the printer to Adode it asks the name of the file. I would like to send the name of the file for Adobe to use so I don't have to type it in for each customer. I am not finding an approach to send the name to Adobde. Any ideas? Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189189
  - 8
    - How Add a CommandButton on 1 Activex Dear All, I wants to add a CommandButton (Setup impression) on 1 Activex (CRviewer of CrystalREport). This AcTivex is on a Form. There is not method "Addobject" for this Activex. I use the addobject of Form but as you suspect it the button comes to be placed below the activex and is thus not visible. The method Zorder(X) does not arrange anything . It would be necessary to be able to say to the button "Always One Top"...... thank you in advance for the assistance brought. Bernhart Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189183
  - 9
    - Hardware Control via Printer-port ? Hi All, I've bought an "On-Off" relay control board with source code written by "VB" and "C++", actually I don't know the above 2 languages, can someone tell me VFP can do the same thing ? Thanks ! Regards Sammy Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189182
  - 10
    - Sending faxes using foxpro and windows 2003 sbs Dear All I am having problems with mapi sending faxes with Outlook 2000 sp3, xp and 2003. Early version are ok. I am getting to a point where I think it may be a security issue. Sending a normal fax is ok, but if I attach a *.tif file it comes up undeliverable with the message The Microsoft Fax transport failed to deliver the message to the recipient. Not all attachments can be rendered. Here is my code, I have changed the fax number. objSession = CreateObject("Mapi.Session") objSession.Logon () MESSAGEBOX("CDO version installed is "+trans(objSession.Version)) objMessage = objSession.Outbox.Messages.Add objMessage.Subject = "Test" objMessage.Text = "This is a test with an attachment" objRecipient = objMessage.Recipients.Add objRecipient.Name = "[FAX:5555555555]" objRecipient.Type = 1 objRecipient.Resolve () objAttachment = objMessage.Attachments.Add() objAttachment.Position = 0 objAttachment.Type = 1 objAttachment.ReadFromFile("C:\B.TIF") objAttachment.Source = "C:\B.TIF" objAttachment.Name = "B.TIF" objMessage.Send () objSession.Logoff Thank you for any help David Anagram Systems Limited work email: david@anagram-sys.co.uk Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189181
  - 11
    - System Clock Hi Is it possible for VFP to hide the system clock so that no one ca change the time of the computer Thanks Abe Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189179
  - 12
    - Incorrect page footer information problem env: O/S 2000 sp4 vfp7 sp1 on report designer, 1.data grouping is set, new page when group change 2.fields on group footer band is set "Stretch with overflow" If fields stretch with overflow on group footer and it overflow to next page, it affect the result of field on page footer on current group and next group. Steps to Reproduce: Create table by following code: create table table1 (f1 c(10),f2 m) insert into table1 (f1,f2) value ('A','') insert into table1 (f1,f2) value ('B',repl('X'+ chr (13),200)) && overflow to next page insert into table1 (f1,f2) value ('C','') create report testbug add data grouping expression "f1" : set "Reset page number to 1 for each group" add report variables "vf1" with Expression : f1 on page header band : add a field Expression : f1 on detail band : add a field Expression : f1 on "group footer : f1" band : add a field Expression : f2, set "Stretch with overflow". on page footer band : add a field Expression : f1 Save report do a command : report form testbug preview Or report form testbug to print result : Assume Group A is printed on page1, Group B is printed on page2 and 3 because for group footer overflow to next page, Group C is printed on page4 on page footer band when f1 group B : field "f1" display C && incorrent field "vf1" display B && corrent on page footer band when f1 group C : field "f1" display C && correct field "vf1" display B && incorrent Is it a bug? thanks. Ray Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189178
  - 13
    - Foxpro 6 Tutorial Hi All, I am the very beginner of Foxpro. Currently, I have Foxpro 6.0 installed in my computer(windows ME 2000). I would be very appreciated if some one can tell me the websites which contain the Foxpro 6 Tutorial. Have a nice weekend! Best Regards Richard Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189175
  - 14
    - Graphical editing of a class Hi all, If I define a class in a program (not is the class designer), how could I edit it in the class designer? Thanks Hutch Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189173
  - 15
    - not insert to table Dear All, I have 2 tables, sales and salesdetail here is my source: sales set to buffering-3 salesdetail set to buffering-5 begin transaction insert into sales(...blah blah blah) insert into salesdetail(...blah blah blah) if (tableupdate(0, .f., "sales") and tableupdate(1, .f., "salesdetail")) end transaction strange thing is, I got salesdetail updated but sales always got nothing. no error message pop out. Can't figure what's wrong. Many thanks. Regards, Wandy Tang Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189170
  - 16
    - change page per group on report vfp.6 start each group on a new page reprint group headers are on design mode of a report can i have it on a variable with a choice of a user on the same report ? -- Thanks George Malekkos --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.572 / Virus Database: 362 - Release Date: 27/1/2004 -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189159
  - 17
    - Ask for method for copying file from one folder to another Dear all, I would like to ask is there any method for Foxpro 6.0 to copy file from one folder to another? Thanks a lot, Ray Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189150
  - 18
    - Mailmerge Wolfgang, Thanks for your kind response. I changed DFC() and got past the error but I got a message from WORD: Error in mailmergeword8(69): OLE IDispatch exception code 0 from Microsoft Word: Word was unable to open the data source. I am wondering if the message prior (Unable to find FoxPro File ODBCDriver) is the cause? I have tried putting the ODBC drivers I could find in the Windows and Windows32 folders but it didn't help. Do you know the proper name of the driver and where it should be located? I found this code in mailmergeword8 and it seems to be wanting the driver. Why would it be needing the ODBC driver and connection string when the data source is a local view? *- attach data file oDoc.MailMerge.OpenDataSource(THIS.cDataSrc,0,0,0,0,0,"","",0,"","",m.cODBCSource,; THIS.csqlstmt, THIS.csqlstmt2) Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189146
  - 19
    - SEEKING LIST OF COMMON WORDS I'm seeking a list of words one would find in an english dictionary (ie 'bank', 'cat', 'symphony', etc.) All I need is a comprehensive list of these common words. If anyone can send to me or direct me to a such a list I WOULD BE VERY GREATFULL !!! Thx Mike Farnesi San Diego Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189141
  - 20
    - simple procedure question Hi, I'm new to Foxpro, and I'm trying to create a stored procedure that returns a set of records. The following does not return records: procedure GetRecords select * from customer endproc Do I need to create a cursor or something? If so, what does that look like? tia, John Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189138
  - 21
    - CHECKBOX QUESTION I have a form that has three buttons 1. File Check 2. Run Program 3. Exit File check does what it says, looks to see if files are present. If they are present, it updates the chkbox/label with a CHECK. I then want to run the program in accordance with which boxes are checked. I tried you thisform.check.value but it doesn't work. Is there an easy to do this. I am getting I need to pass a value at some point? Thanks in advance. Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189133
  - 22
    - Trying to force Outlook msg window to foreground I have an e-mail address field on a form whose right-click event will open up a new Outlook message to that recipient. The automation part of it works like a charm. However, there are times when the new Untitled message window will flash in the taskbar and not be the foreground window and other times when the new message will indeed get the foreground (which is the desired result). Using both the mail item's Display() and Activate() methods produces the same results. Is there a way to make sure that the new message window always hits the foreground and has focus? I'm assuming that the WinAPI has to come into play for this.. Jon Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189125
  - 23
    - XML in Visual FoxPro 6.0, is it possible Is it possible to read and write from XML files from Visual FoxPro 6.0? Thanks Peace in Christ Marco Napoli http://www.ourlovingmother.org Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189121
  - 24
    - .memo I need some help. I am a programer but not FoxPro Pro. I can't handle .mem file, can't change. Do I have to create a new one and how? I read about this file in the Book but .. Thanks, Maria Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189120
  - 25
    - 1a and eof?? So accordingly to what was mentioned in this forum I could found a lot of 1a marks in the header of the dbf. What I would like to know is how to repair a dbf if it is broken using an hexadecimal editor? Which is the 1a mark I have to take into account??? Does anybody experience a broken table and has to repair??? Thanks in advance, Mariano Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189110
- Next
  - 1
    - OLE-Drag'nDrop in COM-Object Hello In my application I use OLE-Drag&Drop. It's working ok. But one part of my app ist a COM-Object, also written in VFP8, using the same classes as the rest of the app. This COM-Object shows controls in a top-level-form. In this form OLE-Drag&Drop doesn't work. It's not starting, no matter, if I let VFP do the work (OLDEDragMode = 1 (Automatic)) or if I start it myself with OLEDrag (.t.) in MouseDown-Event. As soon, as I press the left mouse button, the control is in editing mode, means if I move the mouse with left button pressed, I mark text under the mouse. It's not entering the OLEDrag&Drop-mode. Some ideas? I've written a litte test application, which shows my problem. You can download it from www.ksoft.ch/download/oletest.zip. It's only 17k. Unzip it and build an exe in order to register the COM-Class. If you start the exe, you will see 2 Forms. Both are the same top-level-form, but one is opened from within the exe using do form, the other is shown from a COM-Object. In the form opened with do from OLEDrag&Drop is working, in the other form it is not. Funny, isn't it? Thank's a lot for every help I can get. Kurt ------------------------------------------- K-Soft Informatik Kurt Kleindienst Rietwisstr. 32 CH-9100 Herisau Telefon: +41 (0)71 / 351 78 80 Fax: +41 (0)71 / 351 78 81 Mobil: +41 (0)79 / 377 31 40 E-Mail: info@ksoft.ch Internet: http://www.ksoft.ch ------------------------------------------- Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189109
  - 2
    - Resize MonthView? Is it possible to resize MonthView? Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189107
  - 3
    - grid content gone Dear All, I have make a menu on a parent form, two command on the menu, each command trigger one child form, each child form have a grid on it, one grid show customer information, the other grid show salesman information. But now, whenever the second grid show up, the content of the first grid will all gone. i have been using the .recordsource to set up the sql statement, no cursor name is duplicate for testing purpose. no relation between two form. am i doing somthing silly? Many thanks. Regards, Wandy Tang Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189106
  - 4
    - decimal val n int val hi all, currently working on a project tat was done by someone else, n now having a problem. when i first init a form, i haf a txtbox called txtqty. if i try to enter a decimal val, say 2.23, it works perfectly well... however, on d same form, i haf a grid tat retrieves vals fr a database table. when i select a row from d grid, the afterrowcolchange() method of d grid will change d val of txtqty to d database val, for example 1. the problem is i cannot change d val 1 to a decimal say 2.23, but i can change it to int vals say 5 or 6. can anyone give me any solutions on wat may b causing this? the database field type is of n(6,3) and i haf chked all d valid() n refresh methods to c if they prevent any decimal input but found none. Pls help!! Thanx Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189105
  - 5
    - Ask for the method for moving file to other directory again Hi, I would like to ask how to move all the file in one directory to another directory using Foxpro 6.0? I have already tried to use dos command "run move e:\test1\*.* e:\test" and also "run copy e:\test1\*.* e:\test", but they are both not ok. Only can use command "run del e:\test\*.*" but I would like to move the file. Is there any method in Foxpro 6.0 that can be used? Thanks a lot, Ray Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189101
  - 6
    - automation server This is a multi-part message in MIME format. ------=_NextPart_000_000D_01C3E692.5EA60C60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable what is the automation server name for paintbrush application which i = can use with create object () command? Thanks sp ------=_NextPart_000_000D_01C3E692.5EA60C60 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.2800.1276" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>what is the automation server name for = paintbrush=20 application which i can use with create object () command?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>sp</FONT></DIV></BODY></HTML> ------=_NextPart_000_000D_01C3E692.5EA60C60-- Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189099
  - 7
    - SQL processing If I issue an SQL query and there is no index based on the key item to the query but other indexes should narrow down the search (and I call that info to help it), but the process is taking about 1 minute to come up with the results. The actual query process is only about 10 seconds, but bring up the query meter is taking forever. Any suggestions? Rusty Gallo OGES Systems ogallo@columbus.rr.com Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189094
  - 8
    - Printing on a form 8.5 x 5.5 problems I have an application that prints on 8.5 x 5.5 forms. After I issue the print job to a single order or any odd number of orders to print, the dot matrix printer ejects a second form. I have tried setting the form length on the printer and that does not work. I don't see how to set the form length for (example Okidata ML320 printer) 5.5 through the windows printer set up. Rusty OGES Systems ogallo@columbus.rr.com Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189093
  - 9
    - 'Executing' code in PRG files. When editing a 'prg' file one can hightlight 1 or more rows, then right-click and select 'execute selection' - thats great. But is there a short-cut w/out having to right-click? THX Mike Farnesi Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189092
  - 10
    - Moving from VFP7/SP1 to VFP8/SP1 Hi all! I have a view which works just fine in VFP7. But VFP8 complains "View definition has been changed". The view is of the type; Select ... join ... join ... where &lcWhereExpr1 union all Select ... join ... join ... where &lcWhereExpr2 My app has many views of this very flexible type and all except one works fine i VFP8 too. The view is added to a form´s DE with no data on load. The view´s requery command is in a page's activate. If I close and open the view before the requery it works in VFP8 too but then there occures other undesired things. Enginbehavior is set to 70. What´s this about? Is there somebody who has experienced something similar? I want a solution without having to close and reopen teh view. Any help would be very apprecitated. Regards Christina Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189090
  - 11
    - What new will be in VFP9? Where to learn (find out)? Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189071
  - 12
    - Windows form design guide - where? Isn't there a document (I think by Microsoft) that discusses guidelines to be followed when designing forms? Some sort of windows design guidelines? We have a person that likes to change the default colors of controls, and he sometimes comes up with some nasty color combinations. I believe that default colors should be left alone, and the document I'm looking for discusses the rationale behind this a well as other standards to follow when designing forms. Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189063
  - 13
    - Foxpro and Open Files and Backup and Win 2000 Server Hello - I have a client who has problems with backup because files from my VFP application remain open even after users exit the application. He has made sure that all workstations have exited my application and yet the server still shows that files are open. He is blaming my application. I say it is the responsibility of the server or workstation to properly close out files when users exit my application. I have noticed that when a workstation is accidentally reset or when it freezes some servers will keep files open (like phantom files). Why doesn't the server close these files? I have heard there is a setting in Win 2000 that may be applied so that if a workstation is reset or logs off - all related files are closed. This specific client has Win 2000 server sp4 and win 2000 workstations. All ideas appreciated. Thanks, Mike Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189061
  - 14
    - VFP6 on XP & WinServer 2003 Anybody know if there are any compatibility issues with VFP6 on XP or WinServer 2003? We're still deploying VFP6 (mostly because of the fact that we don't want to lose the built in install set creation tool) and are concerned that we'll eventually run into a wall with one of these OS's. Thanks for any input you can provide. -- tom c Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189048
  - 15
    - ODBC Date format Hello, another ODBC question; can I change the date format for queries via ODBC? In fox itself I'd use DATE=BRITISH in the config.fpw or SET DATE BRITISH in code. Can I do anything similar via ODBC? In fact, is there a good resource/document on using ODBC with fox? I'm using the VFP ODBC driver that came with MDAC 2.6 on FPW2.6 tables. -- TIA Andrew Howell Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189047
  - 16
    - Printer error to a HP PSC 950 from FPw 2.6 application on 98 I keep getting an error when trying to print from a FPW 2.6 application to a HP PSC 950. This printer is an inkjet printer and I'm sending a 100 page document. I'm 99% sure it is error #125, printer not ready. The machine is running Windows 98. Any ideas about what to do here. Also, it is working OK from MS Word. TIA. Boyd Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189044
  - 17
    - Reindex, Pack pukuzen@bih.net.ba Will Microsoft ever remove FoxPro commands such as Reindex and Pack? Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189037
  - 18
    - moving file Dear All, Can I moving file from one directory to another by source? if file("backupdb.arj") move to backup directory endif How to write up properly? Many thanks. Regards Wandy Tang Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189032
  - 19
    - how to move a file from a directory to another directory Dear all, I would like to ask how can I use Foxpro 6.0 to move a file from a directory to another directory? I have tried the dos command "run move e:\test\*.* e:\test1", but it is not ok in foxpro. Please help. Thanks a lot, Ray Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189031
  - 20
    - SQL join count field MS SQL 2000, VFP 8 2 tables 1.parent: employee_id first_name last_name etc. 2.child: child_id employee_id checked (L) etc. I'd like to get remote view all records from parent table (left outer join) columns: first_name,last_name,(count total related records in child),(count related records in child where not checked) How to do this? Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189030
  - 21
    - Mailmerge in VFP8 Hello all Iâ??m having a problem using mailmerge from VFP8 trying to use a view as the source Using a table works fine but the fields I need are in different tables. The code Iâ??m using is from the samples in the solution database SELECT (cTable WITH THISFORM.mailmerge .cAppTitle = "DPRS" && application name, used in Alerts .nWordProc = 1 && word processor (1 = Word 6+; 2 = CommaDelim; or user- defined(see below); default = 1 .nNewDoc = 2 && is it a new doc (1 = new, 2 = existing; default = 1 .cDocName = "c:\mailtest.doc .nTemplate = 1 && type of main document (Word only, 1 = form letter; 2 = label; 3 = envelope; 4 = catalog; default = 1 ---------> .cAlias = "roster" && alias of source table or view ****************** .cDBCTable = DBF() && table name if table is part of a DB .cDBCName = DBC() && DBC name if source table is part of a DB ACOPY(gaTemp, .aAutoFields) && fill in array of field names to be use .MakeOutput() && do the merg ENDWIT cTable is set earlier in the code and contains â??rosterâ??. (without the apostrophes. The error I get is Error #1562 in getsqlst(13); cannot find object c:\docume~1\Richard\local~1\temp\FXI4002X.tmp in the databas I also get a message when using the tables that work that FoxPro Files ODBC driver canâ??t be found. I have OBDC32.dll and VFPODBC.dll in the Windows directory Can views be used with Word? Is rthere code somewhere showing how views can be used Any help would be appreciated TIA - Richar Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189023
  - 22
    - Application Launcher Hi, Currently my vfp application has about 15 users and exe and database is on network. Now I would like to install exe on each work station for better performance. But how do I update changes automatically on each workstation which I make time to time. I know this topic has been discussed many times but could not find it. It will be helpfull if someone can give me the link on the issue. Thanks. Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189020
  - 23
    - Microsoft Access and Remote Access Views Hello - I'm trying to read an Access database into VFP so that I can convert it to VFP. I start by specifying the connection as Microsoft Access and enter the database name. I'm leaving the UserID and Password blank. From the project manager I then click the New button for a new remote view and select the connection I created. It then asks me to select a database name. I'm not sure why it asks me this since I already specified the database name in the connection. Then it shows me the tables in the database and when I select one I get the error: Connectivity Error: Microsoft ODBC Microsoft Access Driver Record(s) annote be read; no read permission on 'Current' All help appreciated, Thanks. Mike Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189010
  - 24
    - Are Report Commands Modal? Thanks in advance for any replies. Is the REPORT command modal when it is issued without NOWAIT modal? What I mean is if I have the following code: 1. SELECT CLIENTS 2. SCAN 3. SELECT * FROM INVOICES WHERE CLIENTNUM = CLIENTS.CLIENTNUM INTO CURSOR CLIENTINVOICES 4. SELECT CLIENTINVOICES 5. REPORT FORM INVOICEREPORT TO PRINTER NOCONSOLE 6. SELECT CLIENTS 7. ENDSCAN Does the report finish processing before line 6 is executed? This seems to me to be a basic and obvious question but I have some code that is essentially the same as the code above and sometimes the first report is failing with a "Variable Not Found" error for a variable that is in the query. The other reports are printing correctly. Previously I had this code being called from a form with a private data session and the error occurred every time. I was advised to change the form to use the default data session. At first I thought this had solved the problem but what I've discovered is that the problem still occurs but only about 1 in 10 times instead of every time. Also the code is contained in a PRG that is being called from a menu. When I ran the code with the debugger on it never failed. Also when I ran the code from a button on the form instead of from a menu on the form it didn't fail. If anyone has any clues as to what is going on here I'd appreciate hearing about it. Thanks, Jeff Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189001
  - 25
    - Returning array from control back to form through property Is it possible to return an array to a form from a custom control? I have an array i need to pass back to the parent form of the control that created it... thanks Tag: Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc Tag: 189000

I create the connection and view programmically.
However, there is an error. Please give me a hand

OPEN DATABASE d:\data\account.dbc
SET DATABASE TO "account"
IF INDBC("acct1","CONNECTION") = .F.

Create connection acct1 ;
connstring;
'Driver={Microsoft Visual Foxpro Driver};DBQ=d:\data\account.dbc';

CREATE sql VIEW arinvtest REMOTE CONNECTION acct1 AS SELECT * FROM
arinvheader

endif

--
Thanks For Your kind Attention.

Best Regards,

Miss. Agnes Cheng
Dynamic Tech Consultants Ltd.
T:2264-5583 F:2264-5584
mail : agnes@dynamictech.com.hk

Top