RE: big problem!!!!!

IDEA: Dbf=C:\SqlAny\Demo.db

Not sure about Sybase (have not used it), but the location of the database
is most likely your issue. This gives you a couple of options:

1) Break down ASP.NET (and possibly IIS) security to allow access to this
file path location. Potential security hole?

2) Move the database to a directory your app has access to. Potential
security hole?

3) Set up an interface (non ASP.NET) to wrap the database access. If you
want to make it easy to move from machine to machine, consider a web service
(Remoting style, not ASMX) and have it serve from the database. DataSets are
highly conducive to web service serving of data (ie, SOAP).

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************


"Wilco" wrote:

> hello,
>
> we use this ODBC connectionstring:
> "Driver=Sybase SQL Anywhere 5.0;Dbf=C:\SqlAny\Demo.db;Uid=me;Pwd=me"
>
> in a windows application it works fine, but in an asp.net applicatie we get
> the next error:
>
> ERROR [08001] [Sybase][ODBC Driver]Unable to connect to database server:
> unable to start database engine ERROR [01000] [Microsoft][ODBC Driver
> Manager] The driver doesn't support the version of ODBC behavior that the
> application requested (see SQLSetEnvAttr).
>
> any ideas?
>
>
>
>
>
.

Relevant Pages

  • Re: use of application roles
    ... > creating a security hole because of the hardcoded username ... > the database. ... permissions need only be granted to the app role. ... SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • use of application roles
    ... to let my users enter data via a custom application, ... creating a security hole because of the hardcoded username ... Do the users need any rights to the database ...
    (microsoft.public.sqlserver.security)
  • Re: Marshal Obj is String or Binary?
    ... When Python displays the string representation to you, ... > He can still store the repr of the string into the database, ... security hole. ...
    (comp.lang.python)
  • Database Access Security Issue
    ... I have a simple situation where my web service wants to connect to a database, but I need to set the security settings so it can. ... This works fine, but I don't think my customers are going to go for it, since it seems like another security hole. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: WebServices and Datasets
    ... And if I call the GetChanges Method on the dataset that only the ... be shown in the dataset and to pass that to the web service, ... "Now to make sure the remote database is updated with changes should I ... client a change as occurred unless the client is constantly polling it. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)