About g_g_99

g_g_99

I was working on the sqlanywhere 11.0.0 application and sybase central for quite a while. Suddendly after weird and long system reboot Monday, I started having trouble connecting the sybase central to the sqlanywhere database. recovery to recent wi...

g_g_99

I must be dense at the moment. I failed to see mismatch between declare holdgDetl cursor for select valuation_dt, fi_sym, Qty, lst_qot, Cost, mkt_value, xchg_rate from dba.PF_Daily_Holdg_detl and FETCH NEXT holdgDetl into @Valuation_dt, @fi...

g_g_99

I must have made a mistake somewhere in this batch sql. however I failed to find after hours of review and web search > Begin // report stock holding summary by fi_sym in local currency declare @Valuation_dt DATE set @Valuation_dt='2019-0...

g_g_99

searched the web for answer and failed to find any. also searched for recovery. backups available turned out useless. I can't unload the 2 tables - not found, cant validate - not found. in desperation, I tried to drop the two tables in that dbspace ...

g_g_99

I got architecture mismatch using odbc profile xxxx on sybase central Connection failed. [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application however I can use the use DSN xxxx 64 ...

g_g_99

I found out the problem was the jpr file content . somehow the old version with invalid path reappear. fix that, the problem went away.

g_g_99 · Chris, the link is no longer valid as of 2019-08-28

Chris, the link is no longer valid as of 2019-08-28

g_g_99

albeit quite a late but one could try microsoft odbc instead in server explorer using user of system dataset. I know it worked for for me with vs2017, 2013

g_g_99

sorry got busy on other urgent tasks. Interactive Sql version 11.01 build 3406 Sybase central 6.0.0.4773 Sql Anywhere 11 version 11.0.1.2506 apparently there is an update 11.0.1 build 3158. however I can't sign in as I don't have access to SAP Servic...

g_g_99

thank you all. Chris you are right on. however it now complain about wrong number of variable in fetch. I counted the cursor select - 7 columns and I have 7 variables in fetch. moreover I copied the column names in cursor and paste below the fetch to...

User Statistics

User Activity

Could not read manifest file when trying to register sqlanaywhere.jpr for SA 11

wrong number of variables in fetch

cursor fetch trouble: could not execute statement. Syntax error near (fetch) 'FROM)

what can I do with tables not found in dbspace

architecture mismatch for sybase central 6 connecting tosql 11 using odbc

Re: Could not read manifest file when trying to register sqlanaywhere.jpr for SA 11

Re: Is SQL Anywhere 17 available for download?

Re: Visual studio integration

Re: cursor fetch trouble: could not execute statement. Syntax error near (fetch) 'FROM)

Re: cursor fetch trouble: could not execute statement. Syntax error near (fetch) 'FROM)