I have a strange issue with Sql server 6.5. I have an
applicaiton running in VB updates the tables. Recently I
have dropped and re-created few tables with column
changes. Now I am able to update the table through ISQL
but not through the VB app.
SQL Server Developer >> Column update
What does "able" mean? Do you get an error message? If so, what is it?
What does your UPDATE query look like? Is it *identical* in both ISQL and
the VB app?
> Hi,
>
> I have a strange issue with Sql server 6.5. I have an
> applicaiton running in VB updates the tables. Recently I
> have dropped and re-created few tables with column
> changes. Now I am able to update the table through ISQL
> but not through the VB app.
>
> Can someone please shed light on this issue.
>
> I would appreicate.
>
> Ravi
SQL Server Developer >> Column update
Verify that the VB login has the required permissions.
update/insert/select etc.
Tim S
> Hi,
>
> I have a strange issue with Sql server 6.5. I have an
> applicaiton running in VB updates the tables. Recently I
> have dropped and re-created few tables with column
> changes. Now I am able to update the table through ISQL
> but not through the VB app.
>
> Can someone please shed light on this issue.
>
> I would appreicate.
>
> Ravi