OLEDB + VFP DATABASE

Discussion in 'ASP .Net' started by Agnes, Sep 4, 2006.

  1. Agnes

    Agnes Guest

    i got two server, (data server) + application server.
    the asp.net will be stored in application server and map the vfp database
    by using network drive.

    When the database and program located in the same server, everything works
    fine.
    However, when I place the database in another server, It got an error said
    "invalid paht"
    Dim db_root As String = "u:\WTO\"
    Session("HostCompanyName") = "WTO LOGISTICS LIMITED"
    Session("ConnectionAuth") = "Provider = VfpOleDB.1;Data Source =
    " & db_root & "vfpmaster\ttsdata\tts.dbc"

    'U' is network drive.
    when i change back into 'C', eveything works fine.
    Does anyone know how to solve it ??
    thanks a lot
     
    Agnes, Sep 4, 2006
    #1
    1. Advertising

  2. On Mon, 4 Sep 2006 10:17:32 +0800, "Agnes" <> wrote:

    >i got two server, (data server) + application server.
    >the asp.net will be stored in application server and map the vfp database
    >by using network drive.
    >
    >When the database and program located in the same server, everything works
    >fine.
    >However, when I place the database in another server, It got an error said
    >"invalid paht"
    > Dim db_root As String = "u:\WTO\"
    > Session("HostCompanyName") = "WTO LOGISTICS LIMITED"
    > Session("ConnectionAuth") = "Provider = VfpOleDB.1;Data Source =
    >" & db_root & "vfpmaster\ttsdata\tts.dbc"
    >
    >'U' is network drive.
    >when i change back into 'C', eveything works fine.
    >Does anyone know how to solve it ??
    >thanks a lot
    >


    You will need to use the URN of the server and folder, not the attached drive
    letter. It should be something like this:

    \\YourServerName\WTO\

    Good luck with your project,

    Otis Mukinfus
    http://www.arltex.com
    http://www.tomchilders.com
     
    Otis Mukinfus, Sep 4, 2006
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?S2VubmV0aCBQ?=

    asp.net with vfpoledb driver and vfp database

    =?Utf-8?B?S2VubmV0aCBQ?=, Oct 27, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    667
    =?Utf-8?B?S2VubmV0aCBQ?=
    Oct 27, 2004
  2. JeffP@Laptop

    dBase VFP OleDb or ODBC Drivers

    JeffP@Laptop, Jan 25, 2006, in forum: ASP .Net
    Replies:
    0
    Views:
    2,784
    JeffP@Laptop
    Jan 25, 2006
  3. John Fabiani

    From VFP to Java trouble (newbie)

    John Fabiani, Nov 2, 2003, in forum: Java
    Replies:
    1
    Views:
    2,114
    Raymond DeCampo
    Nov 9, 2003
  4. Agnes

    oledb connect to vfp

    Agnes, Sep 7, 2006, in forum: ASP .Net
    Replies:
    0
    Views:
    367
    Agnes
    Sep 7, 2006
  5. Roy Gourgi
    Replies:
    1
    Views:
    323
    Bart van Ingen Schenau
    Jul 16, 2005
Loading...

Share This Page