1. Home
  2. LLBLGen Pro
  3. LLBLGen Pro Runtime Framework

LLblgen designer 1.0 can't refresh database (sql 2008 R2)

Posts   
 
    
Leo Wang
User
Posts: 29
Joined: 29-Jul-2010
# Posted on: 24-May-2011 06:13:47   

llblgen version 1.0

Yesterday, our sql server has been upgraded sql 2008 R2.

Today, we use the designer, open the lgp file and try to refresh database. But get exception: ExecuteReader: CommandText property has not been initialized

Very urgent! Would you please help us resolve it?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 24-May-2011 06:43:04   

AFAIK, SQLServer2008 is supported since v2.x. Is there any change you upgrade to v.2 at least?

David Elizondo | LLBLGen Support Team
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39908
Joined: 17-Aug-2003
# Posted on: 24-May-2011 09:33:24   

The issues are mostly around checks inside the driver for the version. The pre-v3 drivers used a system where per database version different queries were used, and this was done in switch statements. The version number of 2008 R2 is not present in the driver's switch statements so it doesn't create queries for that in some occasions. If you have to stay on v1, please look into the driver's sourcecode and make sure the switch statements in schema retriever and catalog retriever (I think there are 3 or 4 or so) address a 'default' clause so they produce a query for whatever version is thrown at them. This should fix the problem.

Frans Bouma | Lead developer LLBLGen Pro
Leo Wang
User
Posts: 29
Joined: 29-Jul-2010
# Posted on: 24-May-2011 12:50:22   

Thank you for your quick response!

Is following file which we need to update and recompile? SD.LLBLGen.Pro.DBDrivers.SqlServerDBDriver.dll under c:\Program Files\Solutions Design\LLBLGen Pro\Drivers\SqlServer

Leo Wang
User
Posts: 29
Joined: 29-Jul-2010
# Posted on: 24-May-2011 13:25:14   

We don't know how to modify the drive source code.

Would you please make and attach an updated dll for us? That would be very appreciate.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39908
Joined: 17-Aug-2003
# Posted on: 24-May-2011 13:51:13   

Leo wrote:

We don't know how to modify the drive source code.

Would you please make and attach an updated dll for us? That would be very appreciate.

Just download the driver source code from the customer area (SDK) and load it onto vs.net. Remove all other driver projects, and compile. What exactly didn't work for you?

Frans Bouma | Lead developer LLBLGen Pro
Leo Wang
User
Posts: 29
Joined: 29-Jul-2010
# Posted on: 25-May-2011 06:15:38   

Thank you for your response.

I'm trying to download the source code. Is it under "Downloads for LLBLGen Pro v1.0.2005.1" page?

Can you provide me more detailed download path?

Leo Wang
User
Posts: 29
Joined: 29-Jul-2010
# Posted on: 25-May-2011 07:05:09   

Please ignore my previous request.

I have found it and downloaded it

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39908
Joined: 17-Aug-2003
# Posted on: 25-May-2011 08:56:22   

Ok. If things don't work out, let us know. simple_smile

Frans Bouma | Lead developer LLBLGen Pro
Leo Wang
User
Posts: 29
Joined: 29-Jul-2010
# Posted on: 25-May-2011 10:06:01   

Did codes as your introduction and compiled

Now it works great!

Thank you very much! smile