Hi,

I would like to thank you for your great effort to support SYBASE DB Best Wishes for LLBLGEN PROJECT

Thanks alot

Thanks! I'm glad you like it

Yes, thanks! Just in time for a project that may need Sybase connectivity __

We will be developing a WinApp in VS2005 C#. I am told that the database is Sybase 12.5.1 running on Unix (I am not certain of the version or the flavor of Unix however). Is there anything else you need to know to be able to tell me if LLBLGen will run against this DB? Are there any particular drivers I will need? Thanks, Frank.

You need the .NET ado provider from Sybase installed on the developer system where you run the designer and also where you use the generated code, which is installed with the tools for the Sybase database used (this is ASE? or ASA?). It then should work.

Is that something I would download from the Sybase website? Also, how would I know if it is ASA or ASE (what is the difference)? I am not a Sybase person, I have always been Oracle.

polytrade wrote:

Is that something I would download from the Sybase website? Also, how would I know if it is ASA or ASE (what is the difference)? I am not a Sybase person, I have always been Oracle.

ASA is Sybase iAnywhere, ASE is Sybase Adaptive Server Enterprise. As iAnywhere is currently in v10, you're working with ASE.

The .net provider is in the client install IMHO. You should be able to download the client tools from sybase, and they're also shipped with the full db install if I'm not mistaken. Sybase has, as oracle, a customer only website. We work with dev editions so I've never been there, but the client tools should contain the .net provider.

As v12 is an older version than the current v15, it might be that your version has the client but not the .net provider. In that case please download the latest v15 client from sybase (you might have to download the dev edition of v15 for that, or contact sybase for the location) and install these client tools so you have the latest client with the .net provider and can connect to the db. The driver and DQE for sybase of LLBLGen Pro are build against v1.15.50 of Sybase' ado.net provider for ASE, if you download a later version, you've to add an assembly redirect to the newer version to the llblgenpro.exe.config file.

While our DBA figures out which version we actaully have, could you please clarify:

In your previous message you mention we need v1.15.50 of Sybase' ado.net provider for ASE

On you Demo download page under requirements, you say I need Sybase .NET provider for ASE v1.1.5

Which of these is correct?

Thanks, Frank.

v1.15.50 is the version.

Sybase's current ADO.NET provider, v1.15.186, has a serious bug which doesn't return a row when you execute a datareader with 'SingleRow' as the command behavior, which LLBLGen Pro uses. This means that single entity fetches aren't possible using this provider version. This has been reported to Sybase, it's up to them to fix this.

I'll update the version number on the webpage

Current Sybase ADO.NET driver version is now 1.15.192.0 (dated 31/10, released 05/11?). Unfortunately this bug is still present - but they now know about it..

(edit) btw. to check Sybase Server version details, run the following query:

select @@VERSION

As far as ADO.NET versions go, in an ideal world you should be able to run any version equal to or later than a version referenced by LLBLGen. Unfortunately this is not the case in the example above, where the bug surfaced in a later version..

I need to buy the LLBLGen Pro, but, before that.... I need to know about sybase database and llblgen intregration.

On my company, We have the sybase 7.0, 8.0, 9.0 and 10.0 versions. So, I obtain to use the llblgen with all these versions database. Is it possible?

We need to develop news systems on C# (ASP.NET/Web Services SOA) and We want to use llblgen Pro to generate all data layers of our systems.

Thanks!

Best regards,

André R. Raucci. raucci2000@hotmail.com andre.raucci@poyry.com

You have posted this question 3 times, next time please post your question only once and in a new thread. Also please check the following guidelines before posting: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=7719

I'll only keep the following thread opened and I'll close the rest, so we can follow up in one place. http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=12150