Database

Paul Conrad28-Nov-05 11:37

28-Nov-05 11:37

Farhan Noor Qureshi wrote:
MS Access is not designed for such a scenario and IMHO MS Access is an oxymoron to robust-fast-efficient

Yes, Access is indeed an oxymoron.

Why is it that you do not want to use MSSQL or MSDE? You may want to look at migrating from Access to either of these, or to MySQL or Firebird...

Paul

Rama Sharma28-Nov-05 16:33

Rama Sharma

28-Nov-05 16:33

Thanks for your reply.

But, will MySQL be good and efficient for such a job?

Paul Conrad28-Nov-05 19:16

28-Nov-05 19:16

Rama Sharma wrote:
will MySQL be good and efficient for such a job?

It could. Mileage can vary with alot of things. I've found MySQL to work just fine under both Linux and Windows. Firebird is something I have found interesting. I am not sure as to what your requirements are for your website/database, but I hope this can help shed some light.

S Douglas28-Nov-05 21:06

28-Nov-05 21:06

Rama Sharma wrote:
Will an Access database be robust to withstand so many records on a web-server

I don’t do any web type stuff, but I do have an app with access as its database with a few hundred thousand records. It works with no problems, the bottle neck with my app isn’t the database it’s the 4 Meg token ring network.

BTW, I would rather use SQL Server, but getting access to one in the corporation I work for is insane. Dead | X|

If data security is of importance then go with SQL Server, Access for all intense purposes has no security.

ZeePain! wrote:
This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.

thedailywtf.com[^]

-- modified at 3:09 Tuesday 29th November, 2005

Paul Conrad29-Nov-05 5:10

29-Nov-05 5:10

As a standalone application, it can work just fine, except when you start getting alot of users accessing it at the same time.

Rama is doing something along the lines of web accessed data and I would move away from Access at that point.

S Douglas29-Nov-05 5:36

29-Nov-05 5:36

computerguru92382 wrote:
As a standalone application, it can work just fine, except when you start getting alot of users accessing it at the same time.

Well I don’t know about using Access as a front end (Access is a huge memory / network hog), but an application using the Access database then you right, I have about 20 users accessing data off of the Access database. Don’t think I would want to add any more than that.

My saving grace here is I would rather scale my app up to using SQL server; sadly that’s just not an option. So with a little creativity anything’s possible. Smile | :)

ZeePain! wrote:
This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.

Paul Conrad29-Nov-05 6:34

29-Nov-05 6:34

sfdougl wrote:
My saving grace here is I would rather scale my app up to using SQL server

That is the point I am trying to get to. Don't get me wrong about Access. It's good for getting the feet wet and developing ideas, but when there is an increase of users and scalability, then some kind of database server needs to come in play.

S Douglas29-Nov-05 15:08

29-Nov-05 15:08

computerguru92382 wrote:
when there is an increase of users and scalability, then some kind of database server needs to come in play.

I was just providing my experience and not diminishing your earlier comments or a proper data warehouse. There are many sides to dealing with database issues. They (databases) are like hammers choose the right one for the job. Some times putting a tack into the wall with a sledge hammer will only get you a broken finger and a whole in the wall; try and bust out a concrete step with a tack hammer and you will never get the job done.

Smile | :)

ZeePain! wrote:
This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.

Paul Conrad30-Nov-05 4:10

30-Nov-05 4:10

sfdougl wrote:
I was just providing my experience and not diminishing your earlier comments or a proper data warehouse.

I didn't think you were. I was doing the same myself. A client of mine has a very large Access database and he's about ready to scale up to something that can handle his business demands. I like the hammer analogy, since I am doing an addition on my home, I can relate Smile | :)

House gets done wth the right tools.

Cheers,

Paul

S Douglas30-Nov-05 4:26

30-Nov-05 4:26

The hammer analogy is a good one, I happen to be one of those folks who has a hammer for each day of the week, umm well okay two weeks. For me it’s always about choosing the right tool for the job no matter what the job is.

I like doing carpentry & plumbing as much as programming. There isn’t much more satisfying as actually working for a buck.

The one great thing about plumbing is the general rule of thumb, all sh*t flows down hill.
Smile | :)

ZeePain! wrote:
This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.

Paul Conrad30-Nov-05 5:36

30-Nov-05 5:36

sfdougl wrote:
plumbing is the general rule of thumb, all sh*t flows down hill

Thank God I live on the top of a hill Laugh | :laugh:

S Douglas30-Nov-05 5:56

30-Nov-05 5:56

ZeePain! wrote:
This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.

Re: Change server name???

Change server name???

papa198027-Nov-05 23:20

papa1980

27-Nov-05 23:20

hi i am real beginer in sql server so my question is how to change sarver name because my program don't work on other computer give me error with server name so my server name is "NIKOLA-I2IIHEHC" how to make the same name on other computer ???

enjoycrack28-Nov-05 11:16

enjoycrack

28-Nov-05 11:16

Hi there,

Am a bit confusing what are u asking about? D'Oh! | :doh:

papa1980 wrote:
my program don't work on other computer

What problem when the program runs on other PC?? And how do you think the user has to change the computer's name to run your application Frown | :(

<< >>

Re: Change server name???

Paul Conrad28-Nov-05 11:43

Re: Change server name???

28-Nov-05 11:43

Am a bit confusing what are u asking about?

Yes, what are you trying to accomplish with having the same server name of two different computers? That is going to cause you more confusion down the road.

S Douglas28-Nov-05 21:13

28-Nov-05 21:13

papa1980 wrote:
my program don't work on other computer give me error with server name so my server name is "NIKOLA-I2IIHEHC"

Is the problem your experiencing related the connection string? It’s of poor design to hard code the server name into your application. Store the server name in an ini file or xml file.

ZeePain! wrote:
This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.

Global Variables and allways-running-in-background functions

Blue_Skye27-Nov-05 21:25

Blue_Skye

27-Nov-05 21:25

Hi there!
Can you help me how to define global variables in MS SQL 2000 or 2005 (@@...) and create a function that auto-start when MS SQL server start. I've searched a lot in google but i still can't found the answer Frown | :(

Thanks in advance

Re: Global Variables and allways-running-in-background functions

Farhan Noor Qureshi28-Nov-05 11:03

Farhan Noor Qureshi

28-Nov-05 11:03

I cant say any thing about 2005 but there is no global variable in 2000. Use a status table instead.

Farhan Noor Qureshi

^{if (this == this) thow this;}

Re: Global Variables and allways-running-in-background functions

Blue_Skye28-Nov-05 15:04

Blue_Skye

28-Nov-05 15:04

Hi! Thanks to reply Smile | :)

The global variables that i want to define are something like @@CONNECTIONS, @@FETCH_STATUS (and anything that begins with @@).
Can you help me, please

Re: Global Variables and allways-running-in-background functions

Farhan Noor Qureshi29-Nov-05 7:44

Farhan Noor Qureshi

29-Nov-05 7:44

Like I said, I am not aware of any user defined global variables in SQL 2k. But I suggest a solution. Say, you have a table with two columns, VarName, VarValue that acts as a list of name-value pair. You could write User defined functions that read-write data for each name-value. Here is an example.

<br />
VarName    VarName<br />
-------------------<br />
City       London<br />
Country    UK<br />

Then you could write UDFs like GetCity(), SetCity(), GetCountry(), SetCountry() etc

Farhan Noor Qureshi

^{if (this == this) thow this;}

-- modified at 13:46 Tuesday 29th November, 2005

LTRIM and RTRIM don't work

Brendan Vogt27-Nov-05 20:10

Brendan Vogt

27-Nov-05 20:10

Hi!!

I have a winery name coming from the table, and I concatenated this text string with xxx to see the amount of spaces after the winery name. I did it like this:

SELECT RTRIM(Wnr_Name) + ' xxx' FROM tblWineries;

There are some wineries with spaces after it, and some not. I went to into Enterprise Manager and none of the wines had spaces. How do I remove these sapces? I've tried RTRIM and LTRIM, but none work. Some of the results:

Amani Vineyards xxx
Backsberg Cellars xxx
Beaumont Wines xxx

Can you see that some has extra spaces.

Regards

Re: LTRIM and RTRIM don't work

Paul Conrad28-Nov-05 11:40

Re: LTRIM and RTRIM don't work

28-Nov-05 11:40

ma se wrote:
SELECT RTRIM(Wnr_Name) + ' xxx' FROM tblWineries;

There is a space between the first apostrophe and the xxx...That could be why it is not working?

Paul

Brendan Vogt28-Nov-05 16:39

Brendan Vogt

28-Nov-05 16:39

There is a reason for a space between the first apostrophe and the xxx. It is there to separate the two strings. If I were to take away the space, then those with the extra space will only have one space, and the rest will look like:

ABC Wineryxxx

So I I put the space in so that it can look like:

ABC Winery xxx

And some wineries have an extra space, which makes the outcome look like:

ABC Winery xxx

Re: LTRIM and RTRIM don't work

Paul Conrad29-Nov-05 6:41