How Query Analyzer works in Text Mode option ?

Hi,
I want to write a application works in same manner as SQL Query Analyzer
works in Text mode option. I studied the behavior of query analyzer and find
out that in text mode option query analyzer does not wait for the query to
get finished, for displaying the result.
It diplays the result in Text form as and when it gets the result. It works
in some different manner than Query Analyzer working in GRID option.
I also want to write a application which does not wait for all the results
of the query, just give me the records which are available right now and
then give the remaining ones also in similar chunks.
Query Analyzer must be using some API calls through which this is possible.
Can any one help me in figure out what APIs are used by query analyzer in
text mode option.
Any help is appreciated.
Thanks
PushkarTo the best of my knowledge, you cannot use ADO or ADO.NET for this. QA uses
ODBC, and I have a
feeling that it is possible using OLEDB as well. So pick up a programmers ma
nual for one of those
APIs and check for asynchronous execution. But you should carefully consider
the extra work to use
these low level APIs compared to the productivity of a higher level API.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Pushkar" <pushkartiwari@.gmail.com> wrote in message news:eSsFbyTMGHA.2704@.TK2MSFTNGP15.phx
.gbl...
> Hi,
> I want to write a application works in same manner as SQL Query Analyzer w
orks in Text mode
> option. I studied the behavior of query analyzer and find out that in text
mode option query
> analyzer does not wait for the query to get finished, for displaying the r
esult.
> It diplays the result in Text form as and when it gets the result. It work
s in some different
> manner than Query Analyzer working in GRID option.
> I also want to write a application which does not wait for all the results
of the query, just give
> me the records which are available right now and then give the remaining o
nes also in similar
> chunks.
> Query Analyzer must be using some API calls through which this is possible
.
> Can any one help me in figure out what APIs are used by query analyzer in
text mode option.
> Any help is appreciated.
> Thanks
> Pushkar
>
>|||Pushkar wrote:
> Hi,
> I want to write a application works in same manner as SQL Query Analyzer
> works in Text mode option. I studied the behavior of query analyzer and fi
nd
> out that in text mode option query analyzer does not wait for the query to
> get finished, for displaying the result.
> It diplays the result in Text form as and when it gets the result. It work
s
> in some different manner than Query Analyzer working in GRID option.
> I also want to write a application which does not wait for all the results
> of the query, just give me the records which are available right now and
> then give the remaining ones also in similar chunks.
> Query Analyzer must be using some API calls through which this is possible
.
> Can any one help me in figure out what APIs are used by query analyzer in
> text mode option.
> Any help is appreciated.
> Thanks
> Pushkar
It may help you to read:
http://www.aspfaq.com/show.asp?id=2120
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Good thinking, David. :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1139910046.905427.137570@.g43g2000cwa.googlegroups.com...
> Pushkar wrote:
> It may help you to read:
> http://www.aspfaq.com/show.asp?id=2120
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>

how much index are reasonable on a table?

I have a table with about 25 colums. In my application, we have provided an
interface through which , search can be made on different column, either
alone or with combination of different columns.
Now there are about 10 columns , upon which search can be made, either
indicidually colum, or combined colums.
Now in order to have a fast search, I have to apply index on different
columns.
Is it ok to apply index on all the 10 columns that are used in search or
what else is the solution to have a quick search. I cant change Database
schema.examnotes (SOHAIL MALIK@.discussions.microsoft.com)
writes:
> I have a table with about 25 colums. In my application, we have provided
> an interface through which , search can be made on different column,
> either alone or with combination of different columns. Now there are
> about 10 columns , upon which search can be made, either indicidually
> colum, or combined colums.
> Now in order to have a fast search, I have to apply index on different
> columns.
> Is it ok to apply index on all the 10 columns that are used in search or
> what else is the solution to have a quick search. I cant change Database
> schema.
Not all indexes might be useful. Say for instance that one column
you can search for is a gender column. If the search is for "all males",
then that index will not help anyway.
If searching for "all" is not meaningful, you may to want to constrain
users by saying "you must include one of A, B, C, D or E in the search",
where A, B, C, D and E are the column on which you have indexes.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||so it means, i should apply index on all 10 columns, that are used in search
.
"Erland Sommarskog" wrote:

> examnotes (SOHAIL MALIK@.discussions.microsoft.com)
> writes:
> Not all indexes might be useful. Say for instance that one column
> you can search for is a gender column. If the search is for "all males",
> then that index will not help anyway.
> If searching for "all" is not meaningful, you may to want to constrain
> users by saying "you must include one of A, B, C, D or E in the search",
> where A, B, C, D and E are the column on which you have indexes.
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp
>|||In addition to Erland's suggestions, look at my answer in the
"paralel-universe" post. ;)
ML|||SOHAIL MALIK (SOHAILMALIK@.discussions.microsoft.com) writes:
> so it means, i should apply index on all 10 columns, that are used in
> search.
Nah, what I tried to imply that you should investigate whether all these
indexes are meaningful, and particularly whether searching for all rows
is meaningful.
The result of this investigate could very well be that you should index
all ten columns. I don't the table, nor the data distribution, so I
cannot say.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.aspsql

how much index are reasonable on a table?

I have a table with about 25 colums. In my application, we have provided an
interface through which , search can be made on different column, either
alone or with combination of different columns.
Now there are about 10 columns , upon which search can be made, either
indicidually colum, or combined colums.
Now in order to have a fast search, I have to apply index on different
columns.
Is it ok to apply index on all the 10 columns that are used in search or
what else is the solution to have a quick search. I cant change Database
schema.Hi Malik
Changing the schema would be a better option. If you create too many indexes
it brings down the performance of the system.
Its not advisible to use too many indexes
best Regards,
Chandra
http://chanduas.blogspot.com/
http://www.SQLResource.com/
---
"SOHAIL MALIK" wrote:

> I have a table with about 25 colums. In my application, we have provided a
n
> interface through which , search can be made on different column, either
> alone or with combination of different columns.
> Now there are about 10 columns , upon which search can be made, either
> indicidually colum, or combined colums.
> Now in order to have a fast search, I have to apply index on different
> columns.
> Is it ok to apply index on all the 10 columns that are used in search or
> what else is the solution to have a quick search. I cant change Database
> schema.|||The OP sort of suggests changing the schema is not an option.
Indexes can affect performance negatively - that's true, yet in this
particular case they pretty much seem to be the only option.
Malik,
Consider using indexed views if appropriate, and/or full-text indexing (for
character-based columns) - both as an addition to existing indexes.
Of course another good option is to simply use the profiler and let the
index tuining wizard suggest appropriate indexes based on your workload.
ML|||Hi Malik,
As suggested indexed Views would be better choice. Create a unique clustered
index on the key numeric column. And add non clustered indexes on the other
columns.
Thanks,
Siva
"ML" wrote:

> The OP sort of suggests changing the schema is not an option.
> Indexes can affect performance negatively - that's true, yet in this
> particular case they pretty much seem to be the only option.
> Malik,
> Consider using indexed views if appropriate, and/or full-text indexing (fo
r
> character-based columns) - both as an addition to existing indexes.
> Of course another good option is to simply use the profiler and let the
> index tuining wizard suggest appropriate indexes based on your workload.
>
> ML

How many users for a database application?

Hi,
lately i've been faced with a dilemma of whether i should choose to have one
database user to access the database from my app and have inbuilt user
management in the app itself or if i should choose to make a database user
for every user of the application, implementing minimal user management on
the app.
Which is best to choose? what is the best practice?
reagrds,Hi,
I recommend you to have seperate users in SQL server for each application
(provide prev. based on requirement), this will allow you to
have more security.
If you have the option of using Windows Authentication to connect to sql
server then you can set
the user and password policies for each user, this enables the highest
security level.
Note:
I will not recommend you to have application level users because of security
reasons.
Thanks
Hari
MCDBA
"Kazar Kunos" <kazar@.inbox.lv> wrote in message
news:e$92kfHiEHA.704@.TK2MSFTNGP09.phx.gbl...
> Hi,
> lately i've been faced with a dilemma of whether i should choose to have
one
> database user to access the database from my app and have inbuilt user
> management in the app itself or if i should choose to make a database user
> for every user of the application, implementing minimal user management on
> the app.
> Which is best to choose? what is the best practice?
> reagrds,
>
>

How many SQL Server Liscences ?

We need to know how many SQL Server Liscences we require.

We have 2 SQL database users (user_app, user_web: one for our application and one for web access)

There will be around 4 windows logon users using the application and about 50 people using via the web.

Do we need 2 liscences, one for user_app, and user_web or more ? i hope not 54 lol!!!

Just wondering what is the cheapest set of liscencing we require for SQL Server 2000 ?

You can purchase license per user or per cpu. I would say you only need 1 CPU License for Standard it is around $5,000 - $6,000 I believe.

http://www.microsoft.com/sql/howtobuy/default.mspx

|||

The deal with Web Licences is that you will either have to name the individual users who will access the application and therefore the SQL Server (multiplexing) or buy a processor license. If only your internal employees will access the database and you already covered them with the appropiate licenses, then your your done. If you don′t know the people gaining access to your server, you will have to buy the proc license.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

How many networks does clustering need ?

I know there is a public network for all application communication and one
for hearbeat .
Are there any more ?
Does one connect the hearbeat network to like a local hub for the nodes or
to the same public network ( dont know if im stating this right) ? Whats
best practise to set up the private hearbeat ?But networks, I am assuming you mean network cards on the server. It is
recommend two; one for the Live check and one for public traffic on the node.
Thanks!
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Hassan" wrote:
> I know there is a public network for all application communication and one
> for hearbeat .
> Are there any more ?
> Does one connect the hearbeat network to like a local hub for the nodes or
> to the same public network ( dont know if im stating this right) ? Whats
> best practise to set up the private hearbeat ?
>
>
>

How many Mobile DB's can sync with one server?

Hi,

I'm in the planning stages of a new application and upper mgmt needs this question answered. I am planning to use SQL Mobile 2005 on the hand held devices and SQL Server 2005 as the server. What kind of hardware/configuration do I need that would allow 500 mobile devices to sync at roughly the same time? Any reccomendations on design issues is also welcome.

The business community is all on the same schedule and past experience shows that that do things in large groups. I need to plan for the worst case. Any input would be appreciated.

Thanks,

SQL Mobile is capable enough to handle 500 devices syncing concurrently. Many customers are using much more than thousand devices in the similar scenario. Please check out our page http://www.microsoft.com/sql/editions/sqlmobile/default.mspx. we have lot of information there. Please let us know about your specific needs or any question you have, we will be glad to address them.

Thanks

Sachin

How many Mobile DB's can sync with one server?

Hi,

I'm in the planning stages of a new application and upper mgmt needs this question answered. I am planning to use SQL Mobile 2005 on the hand held devices and SQL Server 2005 as the server. What kind of hardware/configuration do I need that would allow 500 mobile devices to sync at roughly the same time? Any reccomendations on design issues is also welcome.

The business community is all on the same schedule and past experience shows that that do things in large groups. I need to plan for the worst case. Any input would be appreciated.

Thanks,

SQL Mobile is capable enough to handle 500 devices syncing concurrently. Many customers are using much more than thousand devices in the similar scenario. Please check out our page http://www.microsoft.com/sql/editions/sqlmobile/default.mspx. we have lot of information there. Please let us know about your specific needs or any question you have, we will be glad to address them.

Thanks

Sachin

sql

How many databases/codebases?

Hi,
I have a question about SQL Server 2005.

Suppose we have a hospitals application where the patients records and all other records are the stored. The solution is a hosting one. Here are three options:

1. We have one single database for all institutions (Hospitals) then we need to keep an ID for every institution say institution ID. If we need to rollback the transactions for one institution how can we do that while not rolling back for others? Also, every institution may have slightly different business rules i.e. 80% of the rules and data is same for every institution where as 20% business rules and data may be specific to the institution e.g. if institution is located in Canada instead of US. What I meant to say, every instituion has some data this is not in the base database but we need to add this data specifically for this institution to the base database (i.e. 80% common part) What is the best way / recommendataion to resolve these issues? Another example could be taxes, i.e. tax system in Canada, US and EU is very much different. Can we handle it in the same code base?
2. The 2nd option is that we have a separate database for every institution. This will give rise to maintenace issues e.g. if a bug is fixed for one customer then the same bugfix has to be fixed for every customer, say 4000 customers. Then it will be very difficult to maintain the code base.
3. The third option could be that the base database is same for every institution and in addition to base database there is one additional database for every institution which has the 20% rules/data that vary. But this option may run into problems if the rule/data is implemented in base database already has rules for this type of transactions, there will be a conflict and we need to manage feature list for every customer and first see if you execute in the base database, if not then use the institution specific database. Again this will raise maintenence issues.

What is industry practice or recommendation and why? Is there any material on the web or on the microsoft web site that gives guidance on these / similar issues.
Your cooperation will be appreciated.
Thanks,
Paraclete

Start here:
http://msdn2.microsoft.com/en-us/library/ms151198.aspx
http://www.databaseanswers.org/data_models/index.htm

how many concurrent users for client/server app?

How many concurrent users will MSDE support in a client/server application?
I found 25 users for a website but I have an Access application that I wish
to connect to MSDE and wish to know how many users before having to upgrade
to the full blown version of SQL Server.
hi Ron,
Ron wrote:
> How many concurrent users will MSDE support in a client/server
> application? I found 25 users for a website but I have an Access
> application that I wish to connect to MSDE and wish to know how many
> users before having to upgrade to the full blown version of SQL
> Server.
25 concurrent users is just am estimate number, as it depend on the actual
project , the dataload, the data access type, the data access method and so
on...
you really have to test yourself for your actual solution..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

how make public sql connection

hi,
i want to make a sql connection for a simple application
but i want to use this same connection in the application i have 10 forms in
application so i want in all forms.
after i make setup i can i should change the server name and password.
so if this possible please tell me about this in details.
thanks.
mitesh
This connection works well for me:
Sub InsertData()
Dim oConn As Object
Dim sSQL As String
Application.ScreenUpdating = False
Set wsSheet = ActiveWorkbook.Sheets("Product Tracking")
Set oConn = CreateObject("ADODB.Connection")
oConn.Open = "Provider=sqloledb;" & _
"Data Source=xx.x.xx.xx;" & _
"Initial Catalog=xxx_xxx;" & _
"User Id=xxxx;" & _
"Password=xxxx"
sSQL = "INSERT INTO Upload_Specific " & _
"([Location], [Product Type], [Quantity], [Product Name], [Style],
[Features]) " & _
" VALUES ('" & Range("A2").Value & "', '" & Range("B2").Value & "', '" &
Range("C2").Value & "', '" & Range("D2").Value & "', '" & Range("E2").Value
& "', '" & _
Range("F2").Value & "')"
oConn.Execute sSQL
oConn.Close
Set oConn = Nothing
End Sub
HTH
"mitesh" <mitesh@.discussions.microsoft.com> wrote in message
news:F5513C08-228E-4AE5-A5CC-A8AA574DA6DB@.microsoft.com...
> hi,
> i want to make a sql connection for a simple application
> but i want to use this same connection in the application i have 10 forms
> in
> application so i want in all forms.
> after i make setup i can i should change the server name and password.
> so if this possible please tell me about this in details.
> thanks.
> mitesh

how make public sql connection

hi,
i want to make a sql connection for a simple application
but i want to use this same connection in the application i have 10 forms in
application so i want in all forms.
after i make setup i can i should change the server name and password.
so if this possible please tell me about this in details.
thanks.
miteshThis connection works well for me:
Sub InsertData()
Dim oConn As Object
Dim sSQL As String
Application.ScreenUpdating = False
Set wsSheet = ActiveWorkbook.Sheets("Product Tracking")
Set oConn = CreateObject("ADODB.Connection")
oConn.Open = "Provider=sqloledb;" & _
"Data Source=xx.x.xx.xx;" & _
"Initial Catalog=xxx_xxx;" & _
"User Id=xxxx;" & _
"Password=xxxx"
sSQL = "INSERT INTO Upload_Specific " & _
"([Location], [Product Type], [Quantity], [Product Name], &#
91;Style],
[Features]) " & _
" VALUES ('" & Range("A2").Value & "', '" & Range("B2").Value & "', '" &
Range("C2").Value & "', '" & Range("D2").Value & "', '" & Range("E2").Value
& "', '" & _
Range("F2").Value & "')"
oConn.Execute sSQL
oConn.Close
Set oConn = Nothing
End Sub
HTH
"mitesh" <mitesh@.discussions.microsoft.com> wrote in message
news:F5513C08-228E-4AE5-A5CC-A8AA574DA6DB@.microsoft.com...
> hi,
> i want to make a sql connection for a simple application
> but i want to use this same connection in the application i have 10 forms
> in
> application so i want in all forms.
> after i make setup i can i should change the server name and password.
> so if this possible please tell me about this in details.
> thanks.
> mitesh

How is it possible that inserted and deleted are both empty in trigger?

I created manage update trigger to react on one column changes. There is an application which is working with DB, so I don't have access to SQL query which changes this column. In most cases trigger works fine, but in one case when this column changes, trigger is fired and IsUpdatedColumn is true for this column, but both inserted and deleted table are empty, so I can't get new value for this column. Any idea why is it happened? Is any way around?

This column type is uniqueidentifier. Inserted and deleted tables are empty when application is changing value from NULL to not null value, but if I change it myself from Management Studio inserted table contains right values. Most like problem is in query which is changing that value.

I'm doing that on Sql Server 2005.

Triggers are also firing when no rows is affected, it is fired on a per statement basis not per row.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

How insert Arabic/urdu characters in SQL server

Hi

I am developing an application where i want to store the different language (i.e. chines,Arabic,urdu etc) character in database (SQL Server). so when i store arabic characters in SQL server , it stores the (???).

datatype of field is nvarchar.

is anybody know about the problem and solution.

Regards

Mubahsar Ghazi

The problem is called character conversion and you are getting it because you are using only NVarchar without doing column level collation for Arabic in your database. There are three collations for Arabic in SQL Server 2005. If you are using SQL Server 2000 you can still do column level collation, the links below deals with SQL Server 2005. Hope this helps.

144

binary.256

Binary

SQL_Latin1_General_1256_BIN

145

diction.256

Dictionary order, case-sensitive

SQL_Latin1_General_Cp1256_CS_AS_KI_WI

146

nocase.256

Dictionary order, case-insensitive

SQL_Latin1_General_Cp1256_CI_AS_KI_WI

http://msdn2.microsoft.com/en-us/library/ms144250(SQL.90).aspx

http://msdn2.microsoft.com/en-us/library/ms180175(SQL.90).aspx

|||

thanks for ur response

but i m still getting problems.....

i m pasting the whole code below.while executing it show the exceptionCast from string "?" to type 'Byte' is not valid.

.....................

Dim cAsString = HelpArea.Text ' HelpArea is text box where urdu/arabic characters can be writen

convertC = UniToVar(c) ' function written below

Cmd =

New SqlCommand("INSERT INTO tblCategoryDetail(FieldLang,FieldHelp)Values(' " & dpLanguage.SelectedItem.Text & " ', " & convertC(c) & ")", con)

lblMsg.Text = "Values have stored in database"

con.Open()

Cmd.ExecuteNonQuery()

CatchexAs Exception

lblMsg.Text = ex.Message

EndTry

con.Close()

Public

Function UniToVar(ByVal sTextAsString)AsObject

Try

Dim b()AsByte

b = Encoding.Unicode.GetBytes(sText)

Return b

Catch exAs Exception

lblMsg.Text = ex.Message

EndTry

EndFunction

|||

i have posted the whole function in previous message......and need the solution in very short time...... hoping early resopnse by ur side

regards

Mubashar Ghazi

|||

I want to query the database using SQL statements that contain Arabic letters... for example, this query won't return any results that start with the letter '?' even though if I try any english letters it works perfectly:

SELECT ArtistID, Name
FROM dbo.Artist
WHERE (Name LIKE '?' + '%')

I also tried switching:

SELECT ArtistID, Name
FROM dbo.Artist
WHERE (Name LIKE '%' + '?')

but it won't work.. any ideas ?

Thanks :)

|||

See if the posthttp://forums.asp.net/t/1167422.aspx can be helpful.

how i will convert MS SQL Express Edition to MS SQL 2005

hi friend

now i am using VS 2005 and MS SQL express edition as Database. i want to host the application.

at server it will not support sql express edition. how i will convert.mdf file to MS SQL server 2005

please help me friends.

AOA Manzoor,

There is no special requirement to convert MS SQL Express Database to SQL Server 2005 Database..

You can attach the SQL Express 2005 Database File (.mdf ) with the same database attachment procedure that we follow on SQL Server 2005 Database attachment ,

All you need is

1. Open the SQL Server 2005 Management Studio, Right Click onDatabase Node, ChooseAttach Menu Item

2. Attach Database Form will be open, PressAdd button to add Source .mdf file

3. After pressingAddbutton,Location Database Files Dialog box will be open, select your source.mdf file and pressOK button.

4. PrssOK button , Aftere pressing OK Database Attachment process will be start

Thats All

Thanks

Best Regards,

Muhammad Akhtar Shiekh

|||

Hello,

Can you convert the database around the other way. From MS SQL to SQL Express?

Cheers,

isopro

How I solve this ?

I get this error when i try to connect with my sql,

I created my SQL with MS SQL 2005 Workgroup,

the error is:

Server Error in '/' Application.

---

The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Configuration.Provider.ProviderException: The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.

First obvious question:

What happened when you extended the schema with ASPNET_REGSQL.EXE?

Jeff

|||I agree with Jeff. We need more details to help you. Any update?

how i can save byte array in database?

hi all
i have Byte Array like this:
dim Arr(388,8) as Byte
its working good in my application, but after i close my application all
data saved in this array is lost.
i need save all data from this array to Database (MDB or SQL), then after i
run application again i load data from Database to my Array Variable.
how i can do that?
its byte aray.
Best Regards
Tark M. Siala
Software Development
INTERNATIONAL COMPUTER CENTER (ICC.Networking)
Mobile: +218-91-3125900
E-Mail: tarksiala@.icc-libya.com
Messenger: tarksiala@.hotmail.com
Web Page: http://www.icc-libya.com
Blog: http://spaces.msn.com/tarksiala
======================================
You can save these values in a Blob field
regards
Michel Posseth [MCP]
"Tark Siala" <tarksiala@.icc-libya.com> wrote in message
news:O%23GSIoIQGHA.3872@.TK2MSFTNGP15.phx.gbl...
> hi all
> i have Byte Array like this:
> dim Arr(388,8) as Byte
> its working good in my application, but after i close my application all
> data saved in this array is lost.
> i need save all data from this array to Database (MDB or SQL), then after
> i run application again i load data from Database to my Array Variable.
> how i can do that?
> its byte aray.
> --
> Best Regards
> Tark M. Siala
> Software Development
> INTERNATIONAL COMPUTER CENTER (ICC.Networking)
> Mobile: +218-91-3125900
> E-Mail: tarksiala@.icc-libya.com
> Messenger: tarksiala@.hotmail.com
> Web Page: http://www.icc-libya.com
> Blog: http://spaces.msn.com/tarksiala
> ======================================
>
|||hi
thanks
but i know how i can working with Blob to save Pictures, but how i can
working with Blob to save (Byte Array)?
Best Regards
Tark M. Siala
Development Manager
INTERNATIONAL COMPUTER CENTER (ICC.Networking)
Mobile: +218-91-3125900
E-Mail: tarksiala@.icc-libya.com
Messenger: tarksiala@.hotmail.com
Web Page: http://www.icc-libya.com
Blog: http://spaces.msn.com/tarksiala
======================================
"m.posseth" <michelp@.nohausystems.nl> wrote in message
news:uomlDeQQGHA.2012@.TK2MSFTNGP14.phx.gbl...
> You can save these values in a Blob field
> regards
> Michel Posseth [MCP]
>
>
>
> "Tark Siala" <tarksiala@.icc-libya.com> wrote in message
> news:O%23GSIoIQGHA.3872@.TK2MSFTNGP15.phx.gbl...
>

How I can get the rdl file from one application

Hi all,
I want to do a aspx page who host the report inside of a frame. I need get
the rdl definition from the server thru of the application.
Can I get the rdl thru web services?
I don't want to do the report manager.
Thanks
Manuel JorgeUse the GetReportDefinition of the web service:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_ak_2eew.asp
--
Adrian M.
MCP
"Manuel" <Manuel@.discussions.microsoft.com> wrote in message
news:ADE6F672-0E45-474E-BBDF-F5D51810C9D3@.microsoft.com...
> Hi all,
> I want to do a aspx page who host the report inside of a frame. I need get
> the rdl definition from the server thru of the application.
> Can I get the rdl thru web services?
> I don't want to do the report manager.
> Thanks
> Manuel Jorge
>

How I can connect...

How I can connect an ASP.NET application with MSDE2000
What have you read so far? Have you done any research into ADO.NET? I
suggest picking up one of the 30 or so books on the subject or take a look
at the documentation that clearly shows how to connect from any application
to SQL Server (including MSDE).
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"gilberto Prieto" <anonymous@.discussions.microsoft.com> wrote in message
news:2d98501c469e9$2a1c7120$a301280a@.phx.gbl...
> How I can connect an ASP.NET application with MSDE2000

how i can connect to table in SQL?

hi
i working on VB6 + SQL2000
i have table called (tblBuffer)
and want do something in my application everytime table added new record
(its like trigger in SQL)
thats mean if someone add new record to this table, this table call my
application to do some event.
now i made small monitor (working every 15 second) to see if table have new
record to do something, but this idea need network and SQL Resources.
some one have best idea?
--
Best Regards
Tark M. Siala
Development Manager
INTERNATIONAL COMPUTER CENTER (ICC.Networking)
Mobile: +218-91-3125900
E-Mail: tarksiala@.icc-libya.com
Messenger: tarksiala@.hotmail.com
Web Page: http://www.icc-libya.com
Blog: http://spaces.msn.com/tarksiala
======================================In SQL Server 2005 I would recommend the dependency service but in SQL 2000
the only thing I can think of is a trigger that uses sp_OA... commands to
call a COM object you write in VB.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Tark Siala" <tarksiala@.icc-libya.com> wrote in message
news:O5QdxY8YGHA.4760@.TK2MSFTNGP03.phx.gbl...
> hi
> i working on VB6 + SQL2000
> i have table called (tblBuffer)
> and want do something in my application everytime table added new record
> (its like trigger in SQL)
> thats mean if someone add new record to this table, this table call my
> application to do some event.
> now i made small monitor (working every 15 second) to see if table have
> new record to do something, but this idea need network and SQL Resources.
> some one have best idea?
> --
> Best Regards
> Tark M. Siala
> Development Manager
> INTERNATIONAL COMPUTER CENTER (ICC.Networking)
> Mobile: +218-91-3125900
> E-Mail: tarksiala@.icc-libya.com
> Messenger: tarksiala@.hotmail.com
> Web Page: http://www.icc-libya.com
> Blog: http://spaces.msn.com/tarksiala
> ======================================
>