Strange problem with Access and SQLServer - Database Discussion Boards

Rob Graham1-Jan-03 6:12

1-Jan-03 6:12

What limitations of SQL server(Msde) are stopping you from using it? 2GB database size maximum?,no Replication? In a "Corporate" app, I wouldn't think the cost of SQL would be that big an obstacle (and would probably ony be there if you expected more than the 5 concurrent user that MSDE is tuned for).

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

Re: mySQL, what do you think?

Jassim Rahma1-Jan-03 11:10

Jassim Rahma

1-Jan-03 11:10

yes, limitation in number of users is the major problem for me. I have 8 users now and expected to 18 in few months. what is your suggesstion?

Jassim

Re: mySQL, what do you think?

David Salter4-Jan-03 1:11

David Salter

4-Jan-03 1:11

I think it depends on how database centric your application will be.

MySQL appears to be very fast and works fine with .NET (just like SQL Server does), but its lack of views, stored procedures and triggers may be the factors that stop you using it.

Dave.

AppendChunk

Dave Loeser31-Dec-02 7:51

Dave Loeser

31-Dec-02 7:51

Hi all,
I've been working on a conversion app, that is a one off application... basically reading data from one table and inserting it into a new table. I'm using AppendChunk to insert the new record into the destination table... now on to the problem.

When I append the data to the field it seems that this is being done asynchronously and when I try to free the memory I’m getting an exception that says the memory is locked. Here's the snippet of code: This code is inside a try/catch block

<br />
    ...<br />
    //Assign the Safe array  to a variant. <br />
    _variant_t varChunk;<br />
    varChunk.vt = VT_ARRAY|VT_UI1;<br />
    varChunk.parray = ChunkBlock;<br />
		<br />
    //SafeArrayLock(varChunk.parray);<br />
    pRs->Fields->Item["Data"]->AppendChunk(varChunk); <br />
    //SafeArrayUnlock(varChunk.parray);<br />
<br />
    hr = pRs->Update();<br />
    pRs->Close();<br />
    SafeArrayDestroy(varChunk.parray);<br />
    ...<br />

My questions are; is AppendChunk an asynchronous operation? And if so, is there a way to force it to be synchronous?

Thanks for any help or pointers...

Dave "Dak Lozar" Loeser
When access is allowed to a member, it said to be accessible. Otherwise, it is inaccessible. - MSDN:C# Programmer's Reference

ADODB Object Vs. COM component

retZ30-Dec-02 8:33

retZ

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!.

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