Re: How can I connect to a remote database?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Bruce,

Thanks for the help. I think we are on to something now. Our SQL database is
about a year away. I'm sure that will make life much easier.

Dave

"Bruce Barker" <brubar_nospamplease_@xxxxxxxxxx> wrote in message
news:eBQrxaUYFHA.2288@xxxxxxxxxxxxxxxxxxxxxxx
> the asp.net process does not have network permission by default, so the
> driver can not access the share. on you 2003 server, create an app pool
> with a domain account, with permissions to the share, and setup your site
> to use the app pool. on win2k, use the <identity> section in web.config to
> set a domain account
>
> -- bruce (sqlwork.com)
>
>
> "Dave F." <dflowers@xxxxxxxxx> wrote in message
> news:OMtcMjTYFHA.1204@xxxxxxxxxxxxxxxxxxxxxxx
>>I am using ODBC to connect to dBase data on a remote server. The ASP.NET
>>app will be running on Win 2k or 2003 server. I have tried to make it work
>>but all I can get is an error.
>>
>> System.Data.Odbc.OdbcException: ERROR [HY024] [Microsoft][ODBC dBase
>> Driver]
>> '(unknown)' is not a valid path. Make sure that the path name is spelled
>> correctly and that you are connected to the server on which the file
>> resides. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
>> SQLSetConnectAttr failed ERROR [HY024] [Microsoft][ODBC dBase Driver]
>> '(unknown)' is not a valid path. Make sure that the path name is spelled
>> correctly and that you are connected to the server on which the file
>> resides.
>>
>> Everything works fine if the data and the .net app are on the same
>> machine but won't work if separated.
>>
>> I'm using the DSN. The driver is Microsoft dBase driver. Any ideas
>> besides changing to OleDB?
>>
>> Thanks
>>
>
>


.

Relevant Pages

  • Re: How can I connect to a remote database?
    ... driver can not access the share. ... the app pool. ... >I am using ODBC to connect to dBase data on a remote server. ... > '' is not a valid path. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How can I connect to a remote database?
    ... The problem is that you're not trying to connect to a database server, ... > '' is not a valid path. ... The driver is Microsoft dBase driver. ...
    (microsoft.public.dotnet.framework.aspnet)
  • core install of Solaris 9 (sparc) package list can be trimmed ?
    ... This is a server that will have very specific reasons ... system SUNWadmr System & Network Administration Root ... system SUNWeu8os American English/UTF-8 L10N For OS Environment User Files ... system R SUNWfcip Sun FCIP IP/ARP over FibreChannel Device Driver ...
    (comp.unix.solaris)
  • Re: 2008 SBS no longer boots
    ... driver issue initially, the fact that it seems to happen randomly now ... weird with a hardware problem that consistently doesn't get through boot ... other customer, even a 2 week old one, the problem immediately returned. ... There was a time when a server was fired up with a specialized OS and had a battery of tests run against each component to purposefully stress it. ...
    (microsoft.public.windows.server.sbs)
  • Re: 2008 SBS no longer boots
    ... Intel raid card for Server 2003. ... install with one raid driver, or with the other raid driver. ... Any thermal issues and a lot of other hardware problems should show up ... other customer, even a 2 week old one, the problem immediately returned. ...
    (microsoft.public.windows.server.sbs)