[Mono-list] aspsqlprovider problem select table users

Rodrigo Cuevas bellinux at gmail.com
Sat Mar 14 12:22:43 EDT 2009


Thanks Daniel
I had version 1.2.1 with Npgsql 2.0 RTM now I'm trying the 1.2.4 version 
that comes with Npgsql 2.0.4.
When you run the example from which I get the following error:

//Operation aborted due to an exception (see Trace for details).//

ProviderException: Operation aborted due to an exception (see Trace for details).]

NauckIT.PostgreSQLProvider.PgSessionStateStoreProvider.SetAndReleaseItemExclusive(HttpContext context, String id, SessionStateStoreData item, Object lockId, Boolean newItem) in C:\Users\Daniel Nauck\Documents\Visual Studio 2008\Projects\PostgreSQLProvider\PgSessionStateStoreProvider.cs:506

System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs) +476

System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92

System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64


Any suggestions.

Daniel Nauck escribió:
> Hello,
>
> PostgreSQL is case sensitive and the user table has a upper case U.
> So try:
>
> SELECT * FROM "Users";
>
> Add double quotes around table and field names.
>
> hope that helps.
>
> Daniel
>
> Rodrigo Cuevas schrieb:
>   
>> hi,
>> use PostgreSQL ASP.NET 2.0 Membership, Role, Profile and Session-State
>> Store Provider Project
>> source
>> http://dev.nauck-it.de/aspsqlprovider/
>> <http://dev.nauck-it.de/aspsqlprovider/#WelcometoPostgreSQLASP.NET2.0MembershipRoleProfileandSession-StateStoreProviderProject>After
>> creating the schema in the database execute the search:
>> select * from users;
>> and get the error
>> /relation/ "users" /does not exist/
>> help please
>>
>>
>> _______________________________________________
>> Mono-list maillist  -  Mono-list at lists.ximian.com
>> http://lists.ximian.com/mailman/listinfo/mono-list
>>     
>
>   

-------------- next part --------------
A non-text attachment was scrubbed...
Name: bellinux.vcf
Type: text/x-vcard
Size: 177 bytes
Desc: not available
Url : http://lists.ximian.com/pipermail/mono-list/attachments/20090314/a53800d9/attachment.vcf 


More information about the Mono-list mailing list