database corruption

Hi,
I just ran into a big trouble with sqlserver 2005 Express and Visual Basic
2005.
I have a database, wich is an upsize of an AccessXp database, worked until
now perfect with Vb net 2003
I upgraded to Vb2005 for learning purposes an ran into the following
trouble.
1. Opening a database connection in the server explorer and viewing the
tablestructure etc. works ok BUT...
2. Closing the connection corrupts the db!!
Reopening is impssible and the mdf and ldf files are doubled in size!
The only sollution is then complelety removing both files from the HD and
restoring a backup
All the above is also true for the db's like Pubs or Northwind. After making
a connection in server explorer and closing the IDE, the db's are corrupt
and inaccesible by whatever program.
The connection provider is the one suggested by VB2005 for sqlserver Express
: slqlient for local database
With another sqlprovider it even refuse to find the server
This all happens exclusiveli in the "server explorer", a compiled prog or
debugging from within the IDE works perfect.
If i do the same in VB2003 to the same database and server then everything
stays ok
Any suggestion will be appreciated
Thanks in advance
Jerome
When connecting to a msde server or even the local sqlexpress via the normal
sqlconnection all runs ok.
Only when connecting via the native provider for sqlexpress the database
becomes corrupt
Just wanted to add that the software runs on a dutch version of wndows XP
regards
Jerome
"Jerome" <Jommeke@.fake.com> schreef in bericht
news:xp%hf.57683$tB5.3726394@.phobos.telenet-ops.be...
> Hi,
> I just ran into a big trouble with sqlserver 2005 Express and Visual Basic
> 2005.
> I have a database, wich is an upsize of an AccessXp database, worked until
> now perfect with Vb net 2003
> I upgraded to Vb2005 for learning purposes an ran into the following
> trouble.
> 1. Opening a database connection in the server explorer and viewing the
> tablestructure etc. works ok BUT...
> 2. Closing the connection corrupts the db!!
> Reopening is impssible and the mdf and ldf files are doubled in size!
> The only sollution is then complelety removing both files from the HD and
> restoring a backup
> All the above is also true for the db's like Pubs or Northwind. After
> making a connection in server explorer and closing the IDE, the db's are
> corrupt and inaccesible by whatever program.
> The connection provider is the one suggested by VB2005 for sqlserver
> Express : slqlient for local database
> With another sqlprovider it even refuse to find the server
> This all happens exclusiveli in the "server explorer", a compiled prog or
> debugging from within the IDE works perfect.
> If i do the same in VB2003 to the same database and server then everything
> stays ok
> Any suggestion will be appreciated
> Thanks in advance
> Jerome
>
>