• Sybase Sql Anywhere Tutorial

Discuss: Sybase SQL Anywhere Studio (v. 9.0.2) - box pack - 1 user, 1 server Sign in to comment. Be respectful, keep it civil and stay on topic. We delete comments that violate our policy, which. Hi Marcis, I assume you don't already have a copy of Adaptive Server Anywhere (SQL Anywhere) 9 on your machine? If not, you should download SQL Anywhere 16 Developer Edition.Version 9 database files cannot be started directly on version 16, you will need to rebuild the database.Note you will need a username/password for the database, the default is dba/sql.

Be made using this security context.- Remote Login: DBA; Password: SQL (same as DSN)All other settings, as default, click in OK and shows no errors (aparently it creates the linked server successfully). But when i try to query the linked server with:SELECT. FROM OPENQUERY ( 'SYBASE', 'SELECT. FROM nomRobot' )And i get the following message:Msg 102, Level 15, State 1, Line 1Incorrect syntax near 'SYBASE'.Even better, if i go to the Object Explorer - Server Objects, i test the connection and it´s ok, but when i try to retrieve the catalog an error displays:TITLE: Microsoft SQL Server Management Studio-Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)For help, click:-ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch.

(Microsoft.SqlServer.ConnectionInfo)-The OLE DB provider 'ASAProv.90' for linked server 'SYBASE' reported an error. Access denied.Cannot obtain the required interface ('IIDIDBSchemaRowset') from OLE DB provider 'ASAProv.90' for linked server 'SYBASE'. (Microsoft SQL Server, Error: 7399)For help, click:So, i really don´t understand what is missing in my linked server, i tried with MDASQL (OLEDB for ODBC) but it doesn´t even completes to create the linked server.The database file is ok because, because in another server (one that doesn´t have SQL, only visual studio) i did the following:1) Installe Adaptive Server Anyhwere (Interactive Sql) 9.0.2 on the server.2) Created a DSN to the Db file, and it works fine.

(copied the db file, so is local, no remote access), exactly the same setting as i did on the sql 2005 server.3) C reated a connection in visual studio 2008 (server explorer - data connections), i can retrieve sdata.but of course the provider is.NET Framework Data Provider for ODBC and i cannot use the same connection string.Any ideas?P.S. Oops.that was an obvious mistake! But even without enclosing the linked server name it is not working, of course now i get a different error (better)Msg 7399, Level 16, State 1, Line 1The OLE DB provider 'ASAProv.90' for linked server 'LKDBNOM' reported an error. Access denied.Msg 7350, Level 16, State 2, Line 1Cannot get the column information from OLE DB provider 'ASAProv.90' for linked server 'LKDBNOM'.I think that this error and the fact that i can´t retrieve the catalog in the object explorer are related, but i really don´t get why if there is somekind of denied access when i test the connection it succeeds!!! (by the way, my linked server name is LKDBNOM, i think i wrote it wrong on my question)Thanks for the help, any more ideas would be really appreciated.

Sybase Sql Anywhere Tutorial

Hello, now i have a problem with the plug-ins for ASA andMobilink, if i want to register the plug-in for any of thistwo ASA and Mobilink i got a message telling me to upgradeSybase central to ver. 4.3.i installed the EBF in the same directory where Sql AnywhereStudio ver 9.0.0 were installed, but now, i don=b4t get whyi=b4m having a problem with the path of t his plug-inshow can i solve this problem?ThanksIf you check the short-cut in your start menu to run Sybase Central, does itpoint to the Sybase Central 4.2 or Sybase Central 4.3 directory?

If it'sstill p.Hello NG,I have a strange problem, installed both versions of PowerBuilder on thesame machine having Windows XP.under Program filesSybase9 - PB9.0 was installed.under Program filesSybase10- PB10.0 was installed,I was working on XML workspace in PB9.0 where in the library listPBDOM90.PBD was included. By mistake, I opened the same workspace in PB10.0and the application was migrated completed.Later coming back to PB9.0 and opening the same workspace, found that, inthe system tree PDB files has zero object, It is not showing anything andthe appl.For X64.Anyone know where I can find these?I installed ASA9 for X64 on my new server and tried to install the latestEBF and it won't work because it is expecting to find ver. 9.02 and I've get9.0.Thanks for any help,-Jon-In article, jsprings@jontandshe.org says. For X64.

Anyone know where I can find these? I installed ASA9 for X64 on my new server and tried to install the latest EBF and it won't work because it is expecting to find ver.