Prev: Array Problem
Next: Set backcolor in a StatusBar ?
From: Cor Ligthert[MVP] on 30 Dec 2009 07:15
Jeff,

In my idea you know that it is almost impossible that it can be a VB6
application.
Or it should be somebody trying to bring again the very quick withdrawn
product vb6 web class to life.

http://www.avdf.com/oct98/art_id003.html

It ended that this became actually ASP.Net in 2002

(The GridView is an Asp.Net control from Net versions later than 1.1)

I can answer this question here, but I think the OP is better of in an
ASP.Net forum or in an Asp.Net newsgroup.

Cor


"Jeff Johnson" <i.get(a)enough.spam> wrote in message
news:OA1bHdMiKHA.4912(a)TK2MSFTNGP02.phx.gbl...
> "Tony A." <TonyA(a)discussions.microsoft.com> wrote in message
> news:9312E6DA-8053-4D57-934E-9257A8464831(a)microsoft.com...
>
>> Any suggestion on why SQL Server Express works and Access does not? I
>> use
>> the Access Provider with the Access database and SQLConnection with SQL
>> Server Express.
>
> "SqlConnection"? Are you sure this is a VB6 question?
>
From: Paul Clement on 30 Dec 2009 13:48
On Tue, 29 Dec 2009 08:03:01 -0800, Tony A. <TonyA(a)discussions.microsoft.com> wrote:

� I developed an ASP application using Access as the database. I'm using a
� Gridview control to display the data. When the user selects Edit the
� dropdeownlist appears with valid options. When Update is clicked an error
� appears indicating the value for one or more columns is missing.
�
� If I use the same application with SQL Server Express as the database, there
� is no error, the update happens.
�
� Any suggestion on why SQL Server Express works and Access does not? I use
� the Access Provider with the Access database and SQLConnection with SQL
� Server Express.

I would suspect that you have columns in your Access table that are require values but are not
included in the INSERT statement or, values for columns are not being supplied in the INSERT
statement.

Since this is a .NET web app I would re-post your question (with exception message) to the following
ASP.NET forum:

http://forums.asp.net/85.aspx


Paul
~~~~
Microsoft MVP (Visual Basic)
First  |  Prev  | 
Pages: 1 2
Prev: Array Problem
Next: Set backcolor in a StatusBar ?