A difficult challenge - Database Discussion Boards

retZ30-Dec-02 8:33

30-Dec-02 8:33

guys..can someone explain or lead me to some good documentation
that shows that manipulating the DB from a COM component is more scalable
than accessing the DB directly from an ASP page using ADODB ?

Ofcourse, it is understood that using a component has advantages like
object/connection pooling, re-usability, cleaner design etc etc..but my concern is whether
by putting the database logic in a component, it would be able to manage a
larger user base i.e does using ADODB.dll directly from ASP have a limitation to the no of users
that it can support ??

There are no failures; there are only extended learning opportunities.

SQL Server strange error

Shah Shehpori30-Dec-02 2:13

Shah Shehpori

30-Dec-02 2:13

Friends, we are getting strange errors whenever our applications access database from SQL server. The errors we are getting are:

1)

Microsoft OLE DB Provider for SQL Server error '80004005'  <br />
 <br />
[DBMSSOCN]General network error. Check your network documentation.

2)

[MICROSOFT][ODBC][SQL SERVER DRIVER] [TCP/IP SOCKETS]ConnectionRead(recv()).

Can anyone help me getting rid of these errors. Our applications that access database are developed in VB and ASP.

Re: SQL Server strange error

Rob Graham30-Dec-02 8:46

Rob Graham

30-Dec-02 8:46

Sounds like you are having (generic) network problems. Possibly a flaky network card or switch somewhere.

Some ideas are so stupid that only an intellectual could have thought of them - George Orwell

Strange problem with Access and SQLServer

Mazdak29-Dec-02 8:35

Mazdak

29-Dec-02 8:35

I'm writing program that I use Access database and C#.And I use it in disconnected(DataSet) mode.When I run this code my dataset will be have 0 rows,and it seems it return nothing but if I only I change my connection string to SQL connection and use SQLServer instead of Access,I'll get correct result.This is my code:

OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:database     
 Password='';User ID=Admin ; Persist Security Info =False;Data Source=F:\\Visual 
Studio Projects1\\Visual C#\\Reminder Manager\\bin\\Debug\\RemindManagerDB.mdb");
//OleDbConnection conn = new OleDbConnection("Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=Test;Integrated Security=SSPI;");
oleDbConnection1.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter("select * from my table", conn);
DataSet firstjobds = new DataSet();
adapter.Fill(firstjobds);
oleDbConnection1.Close();

foreach (DataRow r in firstjobds.Tables[0].Rows)//--->firstjobds.Tables[0].Rows.Count is 0 for Access but not for SQLServer!!!!!
{
	userjobslv.Items.Add(r["JobTitle"].ToString());
}

Any idea?

Mazy

"And the carpet needs a haircut, and the spotlight looks like a prison break
And the telephone's out of cigarettes, and the balcony is on the make
And the piano has been drinking, the piano has been drinking...not me...not me-Tom Waits

Re: Strange problem with Access and SQLServer

Rob Graham29-Dec-02 8:58

Rob Graham

29-Dec-02 8:58

Don't know if it was just the formatting in your code sample, but:
1.

Jet OLEDB:database      Password=''

seems to have some garbage whitespace...
This probably should be just

password =;

anyway, rather than the jet specific one.
2.

"select * from my table"

has white space in the table name...
use:

"select * from [my table]"

Some ideas are so stupid that only an intellectual could have thought of them - George Orwell

Re: Strange problem with Access and SQLServer

Mazdak29-Dec-02 19:59

Mazdak

29-Dec-02 19:59

Thanks Rob,But problem in connection string caused unhandled error,but I don't recieve any error,and also about name of table.Those are problems when I copy paste codes here. Smile | :)

Mazy

"And the carpet needs a haircut, and the spotlight looks like a prison break
And the telephone's out of cigarettes, and the balcony is on the make
And the piano has been drinking, the piano has been drinking...not me...not me-Tom Waits

Re: newbie needs database help

Michael P Butler28-Dec-02 10:25

Michael P Butler

28-Dec-02 10:25

This may be of some use

http://www.learnasp.com/learn/dbupdate.asp[^]

Michael

Fat bottomed girls
You make the rockin' world go round -- Queen

A difficult challenge

skallestad27-Dec-02 15:06

skallestad

27-Dec-02 15:06

I have an application which stores data in a text field (sql server 2000) like the following:

1040970851Demotest me five1040970856Demothis is another thing1040970955Demothis is the n. no quotes now. that was scary.

I need to parse the data for crystal reports 8.0 so that it displays as it does in the application...

I don't have a problem parsing the data, but I do have a problem in figuring out how to implement a solution. It turns out that using Crystal 8.0 UFL dlls are limited to 255 characters or less.

Can I get the data to crystal properly using external stored procedures, or am I going to be relegated to writing an odbc driver?

GetDate() in Access

Mazdak27-Dec-02 8:40

Mazdak

27-Dec-02 8:40

Do we have something like GetDate() in Access?

Mazy

"And the carpet needs a haircut, and the spotlight looks like a prison break
And the telephone's out of cigarettes, and the balcony is on the make
And the piano has been drinking, the piano has been drinking...not me...not me-Tom Waits

Re: GetDate() in Access

Nick Parker27-Dec-02 9:05

Nick Parker

27-Dec-02 9:05

Mazdak wrote:
Do we have something like GetDate() in Access?

Oh, in VB you need to use Now(). You can also format it such as:

d = Format(Now, "mm/dd/yyyy")

Nick Parker

You see the Standards change. - Fellow co-worker

Re: GetDate() in Access

Mazdak29-Dec-02 1:16

Mazdak

29-Dec-02 1:16

Hi Nick:

I need to used GetDate() in a query that Access does not support it.I don't use VB.I use C#.

Anyway thanks. Smile | :)

Re: GetDate() in Access

Rob Graham30-Dec-02 8:59

Rob Graham

30-Dec-02 8:59

The previous CPian gave you the correct answer. The equivalent function for getDate() in MsAccess is Now(). It will work in both an isert query and as the default value for a date/time field: "INSERT INTO MyTable( Mydate) SELECT Now() AS Expr1"
or
"INSERT INTO MyTable( Mydate) Values( Now())"

Some ideas are so stupid that only an intellectual could have thought of them - George Orwell

Re: GetDate() in Access

Mazdak31-Dec-02 7:30

Mazdak

31-Dec-02 7:30

Oh,I got it. Smile | :)

Thanks.

Mazy

"And the carpet needs a haircut, and the spotlight looks like a prison break
And the telephone's out of cigarettes, and the balcony is on the make
And the piano has been drinking, the piano has been drinking...not me...not me-Tom Waits

Determining if a datarow contains a particular column

MS le Roux26-Dec-02 21:35

MS le Roux

26-Dec-02 21:35

When binding a datagrid, one of the columns calls a function to process the "Status" field. However, sometimes that field is not there - sometimes I get the exception "Status is neither a DataColumn nor a DataRelation for table ABC".

So I used an IF statement to check if that field is Nothing, but that too caused the exception to be thrown.

How do I determine if a datarow contains a particular column?

Re: Determining if a datarow contains a particular column

MS le Roux26-Dec-02 21:54

MS le Roux

26-Dec-02 21:54

Never mind. I discovered the Contains function on DataRow.Table.Columns.

Re: Determining if a datarow contains a particular column

leppie27-Dec-02 12:14

leppie

27-Dec-02 12:14

Dont you hate that. Doing sh&tloads of coding only to realize the solution is already provided Smile | :)

Especially those damned static methods in the Object Browser. Smile | :)

WebBoxes - Yet another collapsable control, but it relies on a "graphics server" for dynamic pretty rounded corners, cool arrows and unlimited font support.

How do I execute a query through an ASP page to update my fields

E Slipchenko26-Dec-02 18:29

E Slipchenko

26-Dec-02 18:29

I'm creating a contract database that has over 80 different calculations and formulas. I'm using one table with fields and one query for formulas. I need to run/update query through the browser. Does anyone have any idea how this should be done? I'm using this SQL statement in the query, maybe there is a better SQL statement I can use to automatically update my fields in the table? Please help!
I appreciate any help from you guys.

Re: How do I execute a query through an ASP page to update my fields

leppie27-Dec-02 12:20

leppie

27-Dec-02 12:20

I dont know about ASP as such, but SQL aloows you to make Stored Procedures that in turn aloows you to pass parameters (variables) into the statement. The .Net frameworks allows you to use this functionality.

Smile | :)

WebBoxes - Yet another collapsable control, but it relies on a "graphics server" for dynamic pretty rounded corners, cool arrows and unlimited font support.

How to send data from one application to another

Exceter25-Dec-02 17:37

Exceter

25-Dec-02 17:37

1. I have an application (SDI) which works with database
that is, retrieves data and the data are displayed in Edit Boxes and Statics
I want to send these data to another program, MS Word in my case
how to do this ?

2. Is it possible with ADO?

thank you.

Re: How to send data from one application to another

Alexander Kojevnikov26-Dec-02 6:00

Alexander Kojevnikov

26-Dec-02 6:00

You ought to use WinWord's COM API, e.g. create a new Word document, insert a table, and fill it in with the data from your database.

Alexandre Kojevnikov
MCP (SQL2K)
Leuven, Belgium

Count records / ASP

Sarvesvara (BVKS) Dasa24-Dec-02 21:02

Sarvesvara (BVKS) Dasa

24-Dec-02 21:02

I want to count the number of records.... and display it in my web-page using my ASp page. I know that the "Select count(*) from table" will give the count in the database.

How can I retrive the 'result' from that query and pass it on to my ASP page??

Any help?

I was born intelligent
Education ruined me!.

Re: Count records / ASP

Rein Hillmann24-Dec-02 23:04

Rein Hillmann

24-Dec-02 23:04

Off the top of my head it goes something like this (there might be some mistakes since I haven't tested it):

<script language=vbscript runat=server>
Dim ADOConn
Dim ADORs
Dim RecordCount

set ADOConn = CreateObject("ADODB.Connection")
ADOConn.Open(myConnectionString)
set ADORs = ADOConn.Execute("select count(*) as NumRecords from MyTable")

if not ADORs.BOF and not ADORs.EOF then
    RecordCount = ADORs.Fields("NumRecords").Value
end if

ADORs.Close
ADOConn.Close

Response.Write "# Records: " & RecordCount
</script>

Re: Count records / ASP

Tatham26-Dec-02 7:04

Tatham

26-Dec-02 7:04

The fact that you're using a <script runat="server"> tag says that you're using .NET.

Therefore:
1. Use .NET the proper way with code behinds and a literal control
2. Use .NET the proper way with ADO.NET rather than ADO and late binding

Those are where your problems lie - your using legacy code in a new environment.

If you use ADO.NET, to get your record count just go get the value of myDataset.Tables(0).Rows.Count.

Tatham Oddie (VB.NET/C#/ASP.NET/VB6/ASP/JavaScript)
tatham@e-oddie.com
+61 414 275 989

Re: Count records / ASP

Rein Hillmann26-Dec-02 17:43

Rein Hillmann

26-Dec-02 17:43

Actually, you're wrong there.

The <script runat="server"> tag was there long before .NET was developed. It's how script is run server-side in ASP.

Tatham wrote:
Those are where your problems lie - your using legacy code in a new environment.

Since the grandparent post asked for "ASP" and not "ASP.NET", I answered using VBScript which is the de-facto standard for using server side scripting in ASP.

Not everyone is using .NET yet.

Why my SQL Server is so slow?

Wenrich24-Dec-02 18:12

Wenrich

24-Dec-02 18:12

I just installed SQL Server on my machine, and found that it was
really slow! I even had to wait for quite a while when
create a table or open an empty table in the Enterrpise
Manager. Accessing it from a program is also painfully
slow. I got SQL Server SP2 installed as well, but didn't
solve the problem. Any ideas?

Thanks a lot!

Wenrich

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