Data Access Pages and SQL-Server

Dear All,

I have developed a Data Access Page with Access as a project. It is
connected to a SQL-Server database. I try to edit the data in the table and
am not able to do so. I might be missing some permissions. I have changed
a number. What am I missing?

Thanks in advance.

Jeff MagouirkIf the SQL table does not have a primary index (key), your Access program
can NOT update the table. I am 90% sure this is your problem.

Oscar...

"Jeff Magouirk" <magouirkj@.njc.org> wrote in message
news:10psm909drc4ea6@.corp.supernews.com...
> Dear All,
> I have developed a Data Access Page with Access as a project. It is
> connected to a SQL-Server database. I try to edit the data in the table
and
> am not able to do so. I might be missing some permissions. I have
changed
> a number. What am I missing?
> Thanks in advance.
> Jeff Magouirk

Data Access Differences in SQL Server 2005

Hello,

We have a large set of applications that we developed and build for use with Borland InterBase (5.x-7.x). We have moved/migrated off of Borland InterBase to MS SQL Server 2005. We are find some situations where InterBase was an more elegant solution and finding it difficult to find the right way to change our applications to achieve the same result.

In InterBase, our Database Transactions allowed our user to make changes to the DB, Tables, Rows, etc, without blocking reads to the same DB, Tables, Rows, etc. We are looking for a mode in SQL Server 2005, which allows use this same functionality. We have been to a few Microsoft Conference's evaluating SQL Server 2005, and we discussed this with some Microsoft Tech repepresentatives at these conference who told use there was an roughly equivalent mode that was going to be available in 2005. Unfortunately I'm not able to remember the details of this information, does anyone know what new 'DB Modes' or Transaction Options where added that might allow InterBase-like features.

Thanks,

Wow!

The SQL Community doesn't know what SQL Conneciton/Transaction modes existing in SQL Server and how/which have changed in 2k5? Odd, I guess I came to the wrong place for help. Thanks for reading.

George

|||Moved post from SQL Server Database Engine to SQL Server Data Access Forum.|||

SQL Server 2005 supports all four SQL-99 Isolation levels, and also introduces two additional ones. MSDN article describing such. The default behavior is ReadCommitted which is usually preferable as it prevents dirty reads. You seem to desire dirty reads, so what you want is ReadUncommitted.

If you are using .Net code to access the SQL Server instance, you set this property on your SqlTransaction object. Here's the MSDN article on SQLTransaction.IsolationLevel.

You can also modify the Isolation Level using SQL by issuing the SET TRANSACTION ISOLATION LEVEL statement. Described on MSDN here.

|||

A_Bomb wrote:

SQL Server 2005 supports all four SQL-99 Isolation levels, and also introduces two additional ones. MSDN article describing such. The default behavior is ReadCommitted which is usually preferable as it prevents dirty reads. You seem to desire dirty reads, so what you want is ReadUncommitted.

No... I desire behavoir clostest to that of InterBases's defaults. Which seems (from the articles you site) to be closest matched by SNAPSHOT, or READ_COMMITED W/READ_COMMITTED_SNAPSHOT ON. Ie... reads not creating locks and writes not blocking reads because of locks (with reads getting a transaction 'consistent' version of the data).

A_Bomb wrote:

If you are using .Net code to access the SQL Server instance, you set this property on your SqlTransaction object. Here's the MSDN article on SQLTransaction.IsolationLevel.

You can also modify the Isolation Level using SQL by issuing the SET TRANSACTION ISOLATION LEVEL statement. Described on MSDN here.

This is the MSDN Article which I found my answer.

Thanks.

Data Access Differences in SQL Server 2005

Hello,

We have a large set of applications that we developed and build for use with Borland InterBase (5.x-7.x). We have moved/migrated off of Borland InterBase to MS SQL Server 2005. We are find some situations where InterBase was an more elegant solution and finding it difficult to find the right way to change our applications to achieve the same result.

In InterBase, our Database Transactions allowed our user to make changes to the DB, Tables, Rows, etc, without blocking reads to the same DB, Tables, Rows, etc. We are looking for a mode in SQL Server 2005, which allows use this same functionality. We have been to a few Microsoft Conference's evaluating SQL Server 2005, and we discussed this with some Microsoft Tech repepresentatives at these conference who told use there was an roughly equivalent mode that was going to be available in 2005. Unfortunately I'm not able to remember the details of this information, does anyone know what new 'DB Modes' or Transaction Options where added that might allow InterBase-like features.

Thanks,

Wow!

The SQL Community doesn't know what SQL Conneciton/Transaction modes existing in SQL Server and how/which have changed in 2k5? Odd, I guess I came to the wrong place for help. Thanks for reading.

George

|||Moved post from SQL Server Database Engine to SQL Server Data Access Forum.|||

SQL Server 2005 supports all four SQL-99 Isolation levels, and also introduces two additional ones. MSDN article describing such. The default behavior is ReadCommitted which is usually preferable as it prevents dirty reads. You seem to desire dirty reads, so what you want is ReadUncommitted.

If you are using .Net code to access the SQL Server instance, you set this property on your SqlTransaction object. Here's the MSDN article on SQLTransaction.IsolationLevel.

You can also modify the Isolation Level using SQL by issuing the SET TRANSACTION ISOLATION LEVEL statement. Described on MSDN here.

|||

A_Bomb wrote:

SQL Server 2005 supports all four SQL-99 Isolation levels, and also introduces two additional ones. MSDN article describing such. The default behavior is ReadCommitted which is usually preferable as it prevents dirty reads. You seem to desire dirty reads, so what you want is ReadUncommitted.

No... I desire behavoir clostest to that of InterBases's defaults. Which seems (from the articles you site) to be closest matched by SNAPSHOT, or READ_COMMITED W/READ_COMMITTED_SNAPSHOT ON. Ie... reads not creating locks and writes not blocking reads because of locks (with reads getting a transaction 'consistent' version of the data).

A_Bomb wrote:

If you are using .Net code to access the SQL Server instance, you set this property on your SqlTransaction object. Here's the MSDN article on SQLTransaction.IsolationLevel.

You can also modify the Isolation Level using SQL by issuing the SET TRANSACTION ISOLATION LEVEL statement. Described on MSDN here.

This is the MSDN Article which I found my answer.

Thanks.

Data Access components with MSSQL 2000

Can I use an application developed with DAO, ADO or RDO with MSSQL 2000?
(I'm migrating the server)
Are there compatibility issues?
Greetings,Yes, you can access SQL Server 2000 using ADO, so an application that can
reference ADO can access SQL Server 2000. That's typically what ADO is used
for. ADO superceeds RDO and DAO, but I believe they can still use the SQL
Server 2000 provider.
"MedioYMedio" <MedioYMedio@.discussions.microsoft.com> wrote in message
news:72CBE14D-5F52-45C9-8CDA-D702B62DA444@.microsoft.com...
> Can I use an application developed with DAO, ADO or RDO with MSSQL 2000?
> (I'm migrating the server)
> Are there compatibility issues?
> Greetings,

Dashboard Guage type graph?

Hi,
I am on RS sp1, I have developed several reports bases on Analysis Services
cubes. I use in the reports several pie, bar, etc charts. I would like to
know if there is a Dashboard type Guage chart ( sort of like a speedometer
in the dashboard of one's car) in the RS graphicas library, maybe not built
in but can be added to the RS existing Graphics library, where I can use it
seemlesly as if it wa part of the product. If an addition exists, how do I
get it and what is the procedure to add it in.
Thank you in advance for your help.
--
Message posted via http://www.sqlmonster.comwould't that be nice. The extensions RS are very expensive. Every executive
now wants some sort of analog guage to display the overall aggregates of
their metrics at different levels of the enterprise.
--
Message posted via http://www.sqlmonster.com|||Here is an idea:
You could try creating a background image that gives the appearance of
the dashboard, then use a pie-chart with 2 values to act as the guage.
If you place it just right, you may be able to simulate the "Guage"
appearance you want.
Good luck!
~Lance Hunt
http://weblogs.asp.net/lhunt/

CustomReportItem in Local Mode

Iâ've developed a CustomReportItem using VS 2005 RC and SQL Sept CTP. All work
great if I use a Report project in Server Mode i.e. I can drag & drop the
control onto a report and test it.
Sadly, when I try to create a report in LOCAL mode, Iâ'm unable to drag &
drop the control onto the report. Is this behavior by design or what?
Thanks in advance.
GabrielAre you doing this in a .rdl file, in a .rdlc file or both?
Andrew Watt
MVP - InfoPath
On Wed, 12 Oct 2005 05:51:10 -0700, "Ing. Gabriel Fogante"
<IngGabrielFogante@.discussions.microsoft.com> wrote:
>I?ve developed a CustomReportItem using VS 2005 RC and SQL Sept CTP. All work
>great if I use a Report project in Server Mode i.e. I can drag & drop the
>control onto a report and test it.
>Sadly, when I try to create a report in LOCAL mode, I?m unable to drag &
>drop the control onto the report. Is this behavior by design or what?
>Thanks in advance.
>Gabriel|||Andrew,
My control works great with .rdl files i.e. in Server Mode.
If I use it in .rdlc files i.e. in Local Mode, then the control is "ignored"
when I show it with Report Viewer controls.
Regards,
Gabriel
"Andrew Watt [MVP - InfoPath]" wrote:
> Are you doing this in a .rdl file, in a .rdlc file or both?
> Andrew Watt
> MVP - InfoPath
> On Wed, 12 Oct 2005 05:51:10 -0700, "Ing. Gabriel Fogante"
> <IngGabrielFogante@.discussions.microsoft.com> wrote:
> >Iâ've developed a CustomReportItem using VS 2005 RC and SQL Sept CTP. All work
> >great if I use a Report project in Server Mode i.e. I can drag & drop the
> >control onto a report and test it.
> >Sadly, when I try to create a report in LOCAL mode, Iâ'm unable to drag &
> >drop the control onto the report. Is this behavior by design or what?
> >
> >Thanks in advance.
> >
> >Gabriel
>|||Sorry, CustomReportItems are not supported in local mode. They are only
supported for report designer preview and report server.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ing. Gabriel Fogante" <IngGabrielFogante@.discussions.microsoft.com> wrote
in message news:48D77694-BAC3-4425-84AF-B5CDA5B525B3@.microsoft.com...
> Andrew,
> My control works great with .rdl files i.e. in Server Mode.
> If I use it in .rdlc files i.e. in Local Mode, then the control is
> "ignored"
> when I show it with Report Viewer controls.
> Regards,
> Gabriel
> "Andrew Watt [MVP - InfoPath]" wrote:
>> Are you doing this in a .rdl file, in a .rdlc file or both?
>> Andrew Watt
>> MVP - InfoPath
>> On Wed, 12 Oct 2005 05:51:10 -0700, "Ing. Gabriel Fogante"
>> <IngGabrielFogante@.discussions.microsoft.com> wrote:
>> >I've developed a CustomReportItem using VS 2005 RC and SQL Sept CTP. All
>> >work
>> >great if I use a Report project in Server Mode i.e. I can drag & drop
>> >the
>> >control onto a report and test it.
>> >Sadly, when I try to create a report in LOCAL mode, I'm unable to drag &
>> >drop the control onto the report. Is this behavior by design or what?
>> >
>> >Thanks in advance.
>> >
>> >Gabriel
>>

CustomQueryDesigner Problem: React to "Resize" Event of QueryDesigner Window

Hello everybody!

I am currently developing a CustomQueryDesigner which is based on a Windows.Form that I have already developed.

Currently the QueryDesigner Class contains two UserControls: the ToolBar and the class that wrapps my own QueryDesigner.

So what I want to do now, is to resize my Windows.Form which is encapsulated in the second UserControl whenever the size of the window, that contains these two UserControls, is modified.

I already tried to use the "Parent" property and the "FindForm()" method but both just return "null".

--> I do not unterstand how I can access these informations!

Please help me out!

help!!!!