Database

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

6-Jul-05 0:48

I think you are confusing how the date is stored (as a binary number of 4 or 8 bytes) with how it is displayed.

disbaling identity

sianatia5-Jul-05 19:41

sianatia

5-Jul-05 19:41

hi,

i want to remove identity check for a table, i used SET IDENTITY_INSERT ON but it works just for one transaction,how can i disable identity forever
(i need the Transaction for this operation)

Re: disbaling identity

Rob Graham7-Jul-05 12:56

Rob Graham

7-Jul-05 12:56

Alter the table, change the identity field to an ordinary integer (remove the identity attribute). Of course you will then be responsible for computing the value for new inserts... You could set a Unique constraint on the field to insure that it still rejects duplicates.

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not.
Eric Hoffer

Re: Crystal Report can not show data

RajithCAlwis6-Jul-05 0:34

RajithCAlwis

6-Jul-05 0:34

do you receiving error massage?

Re: Crystal Report can not show data

rajith20056-Jul-05 3:20

rajith2005

6-Jul-05 3:20

i'v been with crystal report last 4 years ,crystal report 8.5 version still stable than crystal report 10 version,i've scene few things that crystal report can fail

1.) once you create or call a crystal report your are not allow to change the order of columns in table that you refer for crystal report,you can add columns to table but always below other columns,cant replace the order.

note :- if you done those things you have to create or call reports again

Help : i can't open a connection

SmartSDR5-Jul-05 7:37

SmartSDR

5-Jul-05 7:37

Hi for all,
I'm using vs.net 2002 + sql server 2000 desktop engine
and i created an asp.net web application project and i tried to open the connection but i received an error that i can't open the connection :

(Server Error in '/MyWebPage' Application.
Login failed for user 'SMART\ASPNET')

pls anyone know how to solve this problem ?

thanks

Michael Potter5-Jul-05 8:03

Michael Potter

5-Jul-05 8:03

Asp.Net (development or production box) does not run in the same security as you do. It most likely does not have rights to the database. Create a SQL login with the correct rights on the SQL Server and update your connection string.

SmartSDR5-Jul-05 9:32

SmartSDR

5-Jul-05 9:32

thanks for your reply,
but how can i change my logon cuz i don't have any tool for the sql server ?

its sqlserver desktop engine without a tools

thanks again for your replay

Michael Potter5-Jul-05 10:40

Michael Potter

5-Jul-05 10:40

You will have to access via TSQL if you don't have Enterprise Manager.

See:

sp_addlogin
sp_addUser
sp_grantdbaccess

on MSDN as a starting point.

SmartSDR6-Jul-05 2:26

SmartSDR

6-Jul-05 2:26

thanks alot for your info
i installed sql server 2000 enterprise edition but not the server but just the client tools like enterprise manager
cuz the enterprise edition not compatible with my platform
i received a message from the installer that is not compatible with my platform, i use windows xp sp2, and i used the enterprise manager and its a greatful tool and i resolved my problem.

tnanks again

T-SQL Problem

WDI5-Jul-05 4:52

5-Jul-05 4:52

Hi
I have 3 tables
Product(productID , productName , styleID , artistID )
, Artist(artistID , artistName )
, Style(styleID , styleName ) and relationShips :

Style 1 ---> N Product
Artist 1 ---> N Product

and this Command :

oleDbCommand = new OleDbCommand (
"select Product.productName , Artist.artistName , Style.styleName from ( Product inner join Artist on Product.artistID = Artist.artistID inner join Style on Product.styleID = Style.styleID )where productID = @productID", oleDbConnection );

But I got error :
Syntax error (missing operator) in query expression 'Product.artistID = Artist.artistID inner join Style on Product.styleID = Style.styleID'.

Colin Angus Mackay5-Jul-05 5:00

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

5-Jul-05 5:00

Try this:

SELECT Product.productName, Artist.artistName, Style.styleName 
FROM Product 
INNER JOIN Artist on Product.artistID = Artist.artistID 
INNER JOIN Style on Product.styleID = Style.styleID
WHERE productID = @productID

Note: The only difference is that I removed the brackets. With the brackets it was expecting a subquery which you don't use here.

WDI5-Jul-05 5:49

5-Jul-05 5:49

Oh i dont know what should i do

this doesnt work :

Colin Angus Mackay wrote:
oleDbCommand = new OleDbCommand ( "select Product.productID , Artist.artistName , Style.styleName from Product inner join Artist on Product.artistID = Artist.artistID inner join Style on Product.styleID = Style.styleID where productID = @productID", oleDbConnection );

oleDbCommand = new OleDbCommand ( "select Product.productID , Artist.artistName , Style.styleName from Product inner join Artist on Product.artistID = Artist.artistID inner join Style on Product.styleID = Style.styleID where productID = @productID", oleDbConnection );

But this works :

Colin Angus Mackay wrote:
oleDbCommand = new OleDbCommand ( "select Product.productID , Artist.artistName , from Product inner join Artist on Product.artistID = Artist.artistID where productID = @productID", oleDbConnection );

oleDbCommand = new OleDbCommand ( "select Product.productID , Artist.artistName , from Product inner join Artist on Product.artistID = Artist.artistID where productID = @productID", oleDbConnection );

Colin Angus Mackay5-Jul-05 5:58

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

5-Jul-05 5:58

The code you attribute to me is not my code. I always write SELECT, FROM, INNER JOIN, WHERE etc. in upper case. Also I never put a space before a comma, only after it.

The code you say that works has a syntax error in it. This is obviously not the code you are using. If you are going to take code from your application please copy and paste it properly rather than rewrite it.

Also, in what way does the first not work? The only difference between the two is that in the second the join to "Style" has been removed. Could it be that the Style table has no rows that join on to the Product table? If that is correct then, naturally, the result set will be empty.

WDI5-Jul-05 6:36

5-Jul-05 6:36

Hi First
i didnt add "Colin Angus Mackay wrote:"
and dont know how it was added to my reply and i'm sorry.

Second
i got syntax error on first command and on first not

WDI5-Jul-05 6:37

5-Jul-05 6:37

Hi First
i didnt add "Colin Angus Mackay wrote:"
and dont know how it was added to my reply and i'm sorry.

Second
i got syntax error on first command and on second not

Colin Angus Mackay5-Jul-05 6:45

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

5-Jul-05 6:45

WDI wrote:
dont know how it was added to my reply and i'm sorry.

Okay, fair enough then.

WDI wrote:
i got syntax error on first command and on second not

Hmmm.... There is an additional comma before the FROM on the second command. So I can only assume that it wasn't copied and pasted from visual studio properly.

What is the exact error? It is a bit vague saying "I got a syntax error" without actually seeing the error message. SQL Server contains almost 4000 error messages that help point to the cause of the error. This is useful information and should not be discarded while searching for a solution.

WDI5-Jul-05 6:45

5-Jul-05 6:45

i 've Pasted from code :

Has not Error

oleDbCommand = new OleDbCommand ( "select Product.productID , Artist.artistName from Product inner join Artist on Product.artistID = Artist.artistID where productID = @productID", oleDbConnection );

--------------------------------------------------------------------------------------
Has Error :

oleDbCommand = new OleDbCommand ( "select Product.productID , Artist.artistName , Style.styleName from Product inner join Artist on Product.artistID = Artist.artistID inner join Style on Product.styleID = Style.styleID where productID = @productID", oleDbConnection );

Error :
Syntax error (missing operator) in query expression 'Product.artistID = Artist.artistID inner join Style on Product.styleID = Style.styleID'.

Colin Angus Mackay5-Jul-05 7:27

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

5-Jul-05 7:27

The only thing that I can see that is different is the use of the Style table. Are you sure you have spelt all the the column names correctly?

WDI5-Jul-05 8:07