Trouble connecting to Database

Results 1 to 2 of 2

Thread: Trouble connecting to Database

  1. #1
    Join Date
    Dec 1969

    Default Trouble connecting to Database

    Part of Database connection string in global.asa file:<BR>Driver={Microsoft Visual FoxPro Driver};UID=;SourceDB=d:INetPubWWWRootStudentsData Files;SourceType=DBF;Exclusive=No;BackgroundFetch= Yes;Collate=Machine;Null=Yes;Deleted=Yes;"";Locale Identifier=1033;<BR>The problem is I can connect to this file on my computer, but it won&#039t on the internet. I&#039ve tried several suggestions on changing the path. Maybe I&#039m implementing them wrong.<BR>What would be the correct relative path so I can access DB on server?<BR>Thanks<BR>P.S. error returned is always:<BR>ADODB.Connection error &#039 800a0e7a&#039 <BR><BR>ADO could not find the specified provider. <BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Trouble connecting to Database

    May want to look into using the Server.MapPath Function.<BR><BR>e.g.<BR><BR><BR>SourceDB=" & server.mappath() & "DataFiles..."<BR><BR>I am not 100% sure on the syntax right now, but I know it&#039s close.<BR><BR>Jerry<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts