Invalid escape sequence in string in PersistenceInfoProviderSingleton with SqlServerExpress

Posts   
 
    
Posts: 22
Joined: 07-Sep-2007
# Posted on: 07-Sep-2007 02:06:49   

Hello,

Using: LLBLGenPro 2.5 and SqlServerSpecific template bindings (+selfservice).

The generated class PersistenceInfoProviderSingleton (file: PersistenceInfoProvider) has path with only one "\" and is seen has bad escape sequence character in string.

The SqlServerExpress database is a file and the path is in the PersistenceInfoProviderSingleton class.

I replaced every "\" by "\" and everything has compiled perfectly.

It would be nice to correct that on a next release.

Note: Probably that the bug is also present for

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39951
Joined: 17-Aug-2003
# Posted on: 07-Sep-2007 11:26:59   

Could you try to connect to the SQLExpress db instead with .\SQLExpress as server name instead of the file name? (refresh catalog, specify that as the server name).

The problem is that the file name is used as the catalog name as there's no other info, so the queries all contain that name.

Frans Bouma | Lead developer LLBLGen Pro
Posts: 22
Joined: 07-Sep-2007
# Posted on: 07-Sep-2007 14:20:06   

That's exactly what I have done. I used "MachineName"\SqlExpress - same as - .\SqlExpress.

I changed one think that do not solved the problem... In Microsoft Sql Server Management Studio Express, I changed the name of the database from the Database path to a significative name.

I'm still having the same problem, why don't you correct the code, it would be easy and would prevent futurs errors of the same type ? No ?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39951
Joined: 17-Aug-2003
# Posted on: 07-Sep-2007 17:38:42   

Changing it could be done of course, but we never had problems with this, so it might be something else. We'll look into it, but it's been this way since a long time and we never heard anyone complain about this, so I find it a little odd that it suddenly pops up. You specified for server '.\SQLExpress', for user, you specified nothing and you connected to a normal catalog and the schema is also something not containing a '\' ? Does the catalog contain a '\' ?

Frans Bouma | Lead developer LLBLGen Pro