Database Discussion Boards

Re: Query question

Johny Ng3-Oct-05 11:35

Johny Ng

3-Oct-05 11:35

It will nerver work. Read BOL about GROUP BY first before posting.

Re: Query question

miah alom3-Oct-05 11:37

miah alom

3-Oct-05 11:37

Why dont you try it first then reply. I have already tested it and it works fine.
I think you need some lesson on Group By.

Re: Query question

Anonymous4-Oct-05 4:13

Anonymous

4-Oct-05 4:13

well the query by alam_pune looks fine to me as well..... its a nice and simple sql and works fine too.....

Re: Query question

Anonymous4-Oct-05 19:09

Anonymous

4-Oct-05 19:09

select * from [table] where ID in
(select min(ID) from [table] group by company )

Updating multiple tables in Data Set

Member 21844333-Oct-05 1:08

Member 2184433

3-Oct-05 1:08

I am having a Data Set which has multiple tables. I want the changes to be updated in the database(SqlServer 2000) which i perform in dataset.
I want to use only single DataAdapter for that. Please suggest me how to proceed regarding this.

Mansimranjit

SQL : how to change the data type of a column

Jerome Conus3-Oct-05 0:55

Jerome Conus

3-Oct-05 0:55

Hi !

My app is using SQLite as a database. I'd like to change the datatype of a column of several tables (for example changing from VARCHAR(10) to VARCHAR(50)) without loosing the existing datas.

How can I do this in SQL ? I didn't find anything ! Is it possible ?

Thanks for your help !
Jerome

Re: SQL : how to change the data type of a column

afronaut3-Oct-05 6:14

afronaut

3-Oct-05 6:14

Just use the ALTER COLUMN syntax. If I had the following table:

CREATE TABLE DContact(
CONTACTID INT IDENTITY(1,1),
CONTACT VARCHAR(50),
COMPANY VARCHAR(50),
EMAIL VARCHAR(50)
)

I could change things like so:

ALTER TABLE DContact
ALTER COLUMN Email VARCHAR(100)
GO

This is TSQL that I wrote and tested, but it should be generic enough to work with your database.

*->>Always working on my game, teach me
*->>something new.
cout << "dav1d\n";

When using localhost SQL Server does not exist ...error

Anonymous2-Oct-05 11:23

Anonymous

2-Oct-05 11:23

when i use localhost in connection string dose not connect to the server i got SQL Server does not exist or access denied but when i use computer name it work the problem that programs use localhost dose not work how to resolve this
My Configrations
1-WinXP SP2 -Firewall OFF
2-SqlServer 2000 SP4
thanks for your help

Re: When using localhost SQL Server does not exist ...error

Colin Angus Mackay2-Oct-05 12:38

Colin Angus Mackay

2-Oct-05 12:38

Use "(local)" instead of "localhost". Off the top of my head I cannot remember the reason why, but there is a difference.

My: Blog | Photos

"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

Re: When using localhost SQL Server does not exist ...error

Anonymous2-Oct-05 15:16

Anonymous

2-Oct-05 15:16

Thanks for your replay but this if you write the application or use computer name will work but what if you do not have access to the application source and can not configer connection string?
ie how to make localhost work ?

Re: When using localhost SQL Server does not exist ...error

Colin Angus Mackay2-Oct-05 20:28

Colin Angus Mackay

2-Oct-05 20:28

Then how are you managing to configure it between using localhost and the computer name?

At a guess (as I've never come across this problem) you probably need to ensure that SQL Server is set up to use TCP/IP as a communications mechanism - and you need to ensure you have a network adapter for the communications to route through (even although it will just get looped back).

My: Blog | Photos

"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

Re: When using localhost SQL Server does not exist ...error

Anonymous3-Oct-05 7:14

Anonymous

3-Oct-05 7:14

When
Colin Angus Mackay wrote:
Then how are you managing to configure it between using localhost and the computer name?

when i wrote my application using local host it dose not work when i replace it with computer name it works
the problem the application that i do not write it it give me the error and i can not change the connection string and

SQL Server is set up to use TCP/IP as a communications mechanism

ODBC Drivers

Stanciu Vlad2-Oct-05 3:40

Stanciu Vlad

2-Oct-05 3:40

How can I find out programatically all the ODBC Drivers avaliable on a system?

Hope I understand...because is a rough world out there...

Re: ODBC Drivers

miah alom3-Oct-05 7:07

miah alom

3-Oct-05 7:07

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers\(ODBC_DRIVERS_LOC_IN_REGISTRY)
contains all the drivers that are installed in the local machine.

http://www.codeproject.com/cs/database/ODBCMngr.asp

Re: ODBC Drivers

Stanciu Vlad4-Oct-05 2:25

Stanciu Vlad

4-Oct-05 2:25

Thank you

I hope you understand...because is a rough world out there...

I think a basic question about crystal Report

achrafus30-Sep-05 5:23

achrafus

30-Sep-05 5:23

Hi there,
following my last question where I inserted data coming from different tables, I displayed these data using crystal report. Up to here everything is fine. The data displayed is grouped by Appartment Code Id field.In my report, data look like this:
Appartement Code : 1737/R1
inhaitant Name: Mike Jones
|month |Amount due
|07-2005 |100
|08-2005 |100
total Due:200
Appartement Code : 1737/R2
Inhabitant Name: Emilie carter
|month |Amount due
|06-2005 |100
|07-2005 |100
total Due:200
As these are grouped by Appartement Id each time I click on the appartment Id A new page with only the group information is displayed on a separate page.
What I want to know is how can I custom this page so that It can e used as a letter to my client?
example of what I need:
Once I click on 1737/R2
I want to get in a new page:
Dear Mr/miss Emilie Carter,
I'm glad to announce you that you owe me a total of 200$ for the rent of your appartement for the unpaid periods of 06-07 2005.
compliments
Something like that!
If you can help please do!

anyOne who shows you something you ignore gave you a real tresure!he's your master.To thank him,transmit what you learned

Packaging a SQL Server database for installation as part of a custom application

Sevu30-Sep-05 4:13

Sevu

30-Sep-05 4:13

Hi all,

How to package sql server database as part of our custom application (VB application) using install shield or any software.

That setup should detect the presence of sql server. If sql server is not present in the client machine, then our set up should install the sql server and deploy our database.

If sql server is present in the client machine, then our set up should install our database alone. How to do that. Please help me.

Smile | :)

Regards,
S.Sevugan.

Re: Packaging a SQL Server database for installation as part of a custom application

Luis Alonso Ramos1-Oct-05 19:18

Luis Alonso Ramos

1-Oct-05 19:18

By license, you can't distribute SQL Server with your application. Your user has to install it manually. But you can create a database in an already-installed SQL Server.

There's actually a version of SQL Server that you can distribute. It's called MSDE, but it has certain limitations for very big databases. Search MSDN for MSDE.

-- LuisR

Luis Alonso Ramos
Intelectix - Chihuahua, Mexico

Not much here: My CP Blog!

The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005

Re: Packaging a SQL Server database for installation as part of a custom application

Anonymous3-Oct-05 1:01

Anonymous

3-Oct-05 1:01

when you get your solution plz email it to ndnzuza@gmail.com

Re: Packaging a SQL Server database for installation as part of a custom application

moonmouse3-Oct-05 1:57

moonmouse

3-Oct-05 1:57

OK, forget the bit about SQL Server being a piece of licenced software; if we assume the client already has SQL Server, what is the best way to deploy the database we've designed ? Is it a backup/restore ?

Re: Packaging a SQL Server database for installation as part of a custom application

Dinuj Nath7-Oct-05 22:50

Dinuj Nath

7-Oct-05 22:50

Create a sql script for your database and run it on the client side. I think this is the best way. You can also script any basic data that you may need populated at the start.

Connect to SQL on same machine! help

darXstar30-Sep-05 2:48

darXstar

30-Sep-05 2:48

Hi. I've this question:

I have IIS (and dot net environment) and MS SQL msde on same machine (MS Windows 2000 server).

For security reason I've switched off all network protocols of Sql.
(sql is listening on shared memory)
Is it still possible to connect to sql (not using odbc) ??
I nedd to modify my ADO.NET connection string?
Could someone showme an exemple?

thanks to anyone.

Re: Connect to SQL on same machine! help

Colin Angus Mackay30-Sep-05 12:13

Colin Angus Mackay

30-Sep-05 12:13

darXstar wrote:
Is it still possible to connect to sql (not using odbc) ??

I've never tried that configuration, but it should be possible.

darXstar wrote:
I nedd to modify my ADO.NET connection string?

darXstar wrote:
I nedd to modify my ADO.NET connection string?

I wouldn't think so, why not just try it? I've got loads of apps lying around that were just to try out something where the docs didn't give a complete explanation or I just wanted to see how something worked in isolation.

darXstar wrote:
Could someone showme an exemple?

Of what? Connecting to a SQL Server database using ADO.NET.

string connectionString = "server=(local);database=myData;uid=a;pwd=b";
SqlConnection conn = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "myStoredProcedure";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
SqlReader reader = cmd.ExecuteReader();
while(reader.Read())
{
    // Do stuff to process the information being returned from
    // the database
}

Does this help?

My: Blog | Photos

"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

Re: Connect to SQL on same machine! help

darXstar3-Oct-05 5:39

darXstar

3-Oct-05 5:39

Hi, and thanks for reply. You have right. Why don't try?
The truth is that I was almost sure this configuration was working on my test server... but today doesn't work anymore...
While I keep switched off TCP protocol of sql server, I can not access it from asp.net web applications. the result is "Server doesn't exist or access denied". I am little bit confused... I can't tell if this configuration should work or not...
About connection string I was asking someone if there are a specific one using "Shared Memory" access mode.

anyone is experienced?
thanks again

SELECTING COLLATION WHEN INSTALLING MSDE.

Bigfootguy29-Sep-05 20:28

Bigfootguy

29-Sep-05 20:28

When you install MSDE, the installation is unattended (or silent), rather than interactive.
I need to specify collation, but it does not allow me to do it, installing instead the default which is no good for me.
How can I select (or change) a collation in MSDE?
Thanks.

Best

Bigfootguy

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