Does anyone know how to fix a sql anywhere database with the following error:
[Sybase][ODBC Driver][SQL Anywhere]Specified database is invalid
SQLCODE=-84
SQLSTATE=08001
Thanks
We are in the process of upgrade sql anywhere 12 to sql anywhere 16.
We use .net C#.
Instead of installing sql anywhere on user's machine, we use sql anywhere deployment package.
So, in our code, we start a new process which runs SAConnection with a...
When using dbeng12.exe, we can specify -f option to force dababase to start without transaction log; when using .net SAConnection, what is the parameter in the connection string that is corresponding to -f ?
Thanks.
I am using .Net C#. We need to copy large amount of data from SQL database to SQL Anywhere database.
In theory, I can use SABulkcopy to insert large amount of data quickly, but I find the performance of SABulkcopy.writeToServer(IDataReader) is very s...
I am using iAnywhere.Data.SQLAnywhere.v3.5
In a Microsoft .Net project, I try to connect to Sql Anywhere server by using SAConnection by passing a connection string in the SAConnection constructor.
I am having trouble open a connection that the datab...
Hi Vokler:
When I submit a question, specifying a tag is must, but I cannot create a new tag, so I randomly choose an existing tag (which I know it does not apply to my case). Thanks.
Finally the problem is solved by my colleague.
The deployment package seems to have unknown problem which I built on a Virtual machine. The fact it works for no authentication database and not work on authenticated database confused me.
So my collea...
Thanks Chris.
I created the database by using the developer version of sql anywhere 16, i.e. I used Sybase Central to create the test database, I verified that the database authentication option is set by running the following sql:
SELECT CONNECTION_...
Thanks Mark.
After bit further digging, it appears that problem exists for OEM database.
With sql anywhere 12, we can establish a connection(without specify anything to do with authentication), then immediately, we do a sql command on the connection ...
Thanks Chris:
The log file on the client shows the following :
10:15:33 Communication function i_cs_HandleSQLPresError code 4
10:15:33 Communication function StrmGetInd code 7
10:15:33 Database is running, but could not connect to it
Does anyone know...