What is special about 'Asynchronous Processing=true' in the connection string? - Database Discussion Boards

Re: Access 2007 - tabbed forms manage own popups

john john mackey16-Mar-10 7:37

16-Mar-10 7:37

I am doing this in MS Access 2007.

I found something about a property (Screen.ActiveForm) - this probably means that I will have to do my own Form, Parent/Child management.

Thanks for the advice on looking about a Child property. I will check into this.

project

salemmohamed10-Mar-10 22:54

salemmohamed

10-Mar-10 22:54

I have project call Managmnet information system for finace,
I use the
1- oracle database 10g
2- oracle developer 10g

I am not have anything about two this software.
I want project alreay did by to this software
or toturial

Re: project

Mycroft Holmes10-Mar-10 23:53

Mycroft Holmes

10-Mar-10 23:53

I think you are doing your boss/client a disservice!

Get hold of a book on database design, read a bunch of articles, have a wander through SQLServerCentral.com.

Depending on the size if the business you are taking on a very large project, one that will take a skilled single developer a substantial amount of time to even understand the business requirements let alone the database design, etl management, data structuring, business logic layer and delivery interface.

Good luck, you are going to need it!

Never underestimate the power of human stupidity
RAH

Re: project

R. Giskard Reventlov11-Mar-10 0:01

R. Giskard Reventlov

11-Mar-10 0:01

Here: Library of free data models[^].

Also: OraFAQ[^]

Good luck: you're plainly going to need it - does your boss know you have no idea where or how to start?

Tychotics

"The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!"
Larry Niven

Re: project

Mycroft Holmes11-Mar-10 19:07

Mycroft Holmes

11-Mar-10 19:07

What and excellent link - it could help a lot of people here.

Never underestimate the power of human stupidity
RAH

Re: project

Rob Graham14-Mar-10 6:32

Rob Graham

14-Mar-10 6:32

You mean it could let a lot of lazy idiots leverage someone else's work without understanding it?

Re: project

Mycroft Holmes14-Mar-10 14:50

Mycroft Holmes

14-Mar-10 14:50

Rob Graham wrote:
lazy idiots

So you know anush 6 threads up, hopefully they can gain something from seeing a data structure, without any understanding I doubt a canned structure is going to really help someone.

Never underestimate the power of human stupidity
RAH

What is special about 'Asynchronous Processing=true' in the connection string?

Rob Philpott10-Mar-10 6:18

Rob Philpott

10-Mar-10 6:18

This allows you to execute commands asynchronously (ADO 2) using BeginXXX and EndXXX in .NET in the traditional way.

But, if you want Async access, you could just use multiple threads for that (probably using seperate connections).

What does this entry in the connection string actually do? Is it a case of allowing more than one command to execute at a time against a single connection?

Regards,
Rob Philpott.

Re: What is special about 'Asynchronous Processing=true' in the connection string?

Mycroft Holmes10-Mar-10 23:56

Mycroft Holmes

10-Mar-10 23:56

Absolutely no idea, never used it, never looked into it, was not even aware it existed. I have not looked at a connection string for many years. I wonder if I am missing something?

Never underestimate the power of human stupidity
RAH

Re: What is special about 'Asynchronous Processing=true' in the connection string?

Eddy Vluggen11-Mar-10 1:56

Eddy Vluggen

11-Mar-10 1:56

Rob Philpott wrote:
What does this entry in the connection string actually do?

Found some good explanation (with usage scenario's) on MSDN[^];

MSDN:

In previous versions of the .NET Framework it was possible to simulate non-blocking execution by using asynchronous delegates or the ThreadPool class; however, those solutions simply blocked another thread in the background, making them far from ideal for cases where it is important to avoid blocking threads [...]

I are Troll Suspicious | :suss:

Streaming SQL table data to secondary location

bonkers12310-Mar-10 3:54

bonkers123

10-Mar-10 3:54

Hi there,

I want a way to stream data from one table in one database to the same table on a different machine.
Is there a way?

Any help would be much appreciated.

Kind regards,
Hugo

Re: Streaming SQL table data to secondary location

Tim Carmichael10-Mar-10 4:07

Tim Carmichael

10-Mar-10 4:07

Option 1: replication
Option 2: write a job to perform the bulk transfer.

Not real time

David Mujica10-Mar-10 4:18

David Mujica

10-Mar-10 4:18

If you don't need to do this in real-time, then you could consider taking a nightly backup of Server A and performing a restore on Server B.

Just a thought.

Re: Streaming SQL table data to secondary location

i.j.russell10-Mar-10 5:34

i.j.russell

10-Mar-10 5:34

If you are using Sql Server 2005 or later, you can use Service Broker.

Re: Streaming SQL table data to secondary location

Eddy Vluggen11-Mar-10 2:03

Eddy Vluggen

11-Mar-10 2:03

bonkers123 wrote:
Is there a way?

Multiple, and their applicability depends on the type of database that you're using. SQL Server for example has the option to "link" to another database. It also depends a bit on what you expect from the target-table. Does it have to be "up to date" at all times, or would it be sufficient to have access to yesterday's data?

To add to the pile of options; you could also use the Microsoft Synchronization Framework.

I are Troll Suspicious | :suss:

Re: Streaming SQL table data to secondary location

bonkers12311-Mar-10 20:29

bonkers123

11-Mar-10 20:29

It has to be up to date at ALL times... It's a sql database...

Re: Streaming SQL table data to secondary location

bonkers12311-Mar-10 20:32

bonkers123

11-Mar-10 20:32

So how do I link a table of one db, to a the same table on a different db ... ?

Re: Streaming SQL table data to secondary location

Eddy Vluggen12-Mar-10 0:23

Eddy Vluggen

12-Mar-10 0:23

From the Management Studio, expand "Server Objects", right-click on "Linked Servers" and select "New Linked Server". There's several options to specify the credentials for the remote database.

E.g., if you have Server A (with a master database) and a Server B (with AdventureWorks), then you could execute queries like this;

SQL

SELECT [name]
  FROM [master].[sys].[tables]
  
 UNION ALL
 
SELECT CAST([VersionDate] AS VARCHAR(50))
  FROM [ServerB].[AdventureWorks].[dbo].[AWBuildVersion]

More information on configuring a linked server can be found here. Hope this helps Smile | :)

I are Troll Suspicious | :suss:

Re: Streaming SQL table data to secondary location

bonkers12315-Mar-10 1:15

bonkers123

15-Mar-10 1:15

This help ! Thanks !!!!

SQL Server Compact and eVC++ [modified]

hairy_hats9-Mar-10 22:14

hairy_hats

9-Mar-10 22:14

Hi all,

I've been scouring the web for information on how to access an SQL Server Compact database under WinCE, using Embedded VC++. Does anyone know where I can find examples or pointers on how to do this please?

TIA Smile | :)

modified on Wednesday, March 10, 2010 4:39 AM

Re: SQL Server Compact and eVC++

Mycroft Holmes10-Mar-10 23:58

Mycroft Holmes

10-Mar-10 23:58

Have you looked at connectionstrings.com, that is where we point most inquiries on this subject.

Never underestimate the power of human stupidity
RAH

How SQL command queury the first character of a Name column from a MS Access database?

Curious 20099-Mar-10 5:04

Curious 2009

9-Mar-10 5:04

I have a MS Access database with a table INFO that has Name column (only contains First Name), since it contains a huge list, it will require very long time to queury all of them. I prefer to devide them by character groups (A,B,C ... Z) in order to reduce the queury time

I couldn't find the the SQL command that can queury table INFO with column Name starting with A character

Anyone know how to do it?

Thanks to any help D'Oh! | :doh:

Re: How SQL command queury the first character of a Name column from a MS Access database?

Luc Pattyn9-Mar-10 5:45

Luc Pattyn

9-Mar-10 5:45

WHERE Name LIKE 'A%' ORDER BY Name should do it as % is the wildcard character

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that.

Re: How SQL command queury the first character of a Name column from a MS Access database?

Curious 20099-Mar-10 6:40

Curious 2009

9-Mar-10 6:40

I did try 'A%' somehow it doesn't work, but if I try with 'A*' like the latter response then it work!

Anyway, thank for help just might be syntax from me Smile | :)

Re: How SQL command queury the first character of a Name column from a MS Access database?

Luc Pattyn9-Mar-10 7:01

Luc Pattyn

9-Mar-10 7:01

When I use Microsoft.Jet.OLEDB.4.0 to work with an Access database, it takes % as the wildcard character.

Confused | :confused:

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.