Search results for query: *

I would like to create a diagram from an Oracle DDL file. I do not have access to the database but have the ddl. Can I do this? Thanks

I do use a connection string and I use integrated security so I don't have to have the password hardcoded.

I am trying to write an ASP.NET application. I want to access a SQL server database. The way I did this in the old asp was to change the anonymous user account from iusr_machine to a domain userid/service account. I then give this account access to the sql server database. How can I tell my...

Thanks. I'll give it a try. I noticed you have port 8000 redirected with no-ip.com. I just got an error when I went to your web site. - Paul

I can access the web page by typing localhost in the server's browser. http://localhost. I can also type the servers IP in the browser on another machine on my local network and the web page comes up (http://192.168.1.20) I'm not sure if MSN blocks port 80. If so I guess I need to forward a...

I have MSN DSL (Dynamic IP). I have a Cisco 675, linksys befsr41 router (firmware 1.40.1). I have DHCP enabled on the router. I have another win2k pro machine that is networked to my win2k pro machine I want to be the web server. I have unbound TCP/IP from network neighborhood. I pulled up the...

I have a SQL server 2000 database. I understand that I cannot use NT authentication to connect to a database in CR. I thought I could open a recordset and set the report database to the recordset. Has anybody done this? Thanks, Paul

I'm pretty sure that <%=Request.form(&quot;lstItems&quot;)%> will give me the contents of the Value, not the text displayed to the user. i.e. 1 instead of First

In the following select list, using response.form, how do I get the display value from the list? response.Form(&quot;lstItems&quot;) gives me 1, or 2. I want First or Second. <select 'lstItems'> <option value='1'>First</option> <option value='2'>second</option> </select>

I currently have a CR that is called from an ASP page that uses a DSN. Here is the code: set objTable = Session(&quot;oRpt&quot;).database.tables.item(1) objTable.setlogoninfo &quot;DSNName&quot;,&quot;DBName&quot;,&quot;userid&quot;,&quot;password&quot; This works fine, but I would like to...

Shouldn't this work: Alter Procedure [dbo].getTests @SampleID int = 167, @Status varchar(10) = '1, 2, 3' As SELECT * FROM tblTests WHERE SampleID = @SampleID and Status in (@Status) It give me the following error: Syntax error converting the varchar value '1, 2, 3' to a column of data...

I tried in in SQL Query Analyzer and it doesn't work.

I would just like to turn the identity property off. Would I use this statement in SQL: SET IDENTITY_INSERT dbo.tblUser OFF

I would like to run a .SQL script to drop the identity attribute of a column on 10 tables. Does anybody know how I would do this? Thanks Paul

The list of number is comma delimited. The reason I con't want to use an exec statement is the whole query is about 200 lines long and it would make it hard to maintain. Thank, Paul

I would like to used a stored procedure to pass in a list of numbers (Status codes). I have tried: @Status varchar(10) As select distinct status from tblTable where status in (@Status) I have tried changing status from an integer to a 1 char field. Using an exec statement is not an option...

I do group by this field and it is in the header. It still shows duplicates. How do I tell it to supress duplicates?

I have a date field in my group header. I specified supress if duplicated and it still shows duplicate dates. Anyone know how to suppress duplicate dates? Thanks Paul

Thanks for the reply. I am grouping on one field and displaying a date field. The big issue is supressing the time from the date. Paul

I have a group in my report. It is on a numeric id. I would like to display the date instead of the id. I checked customize Group name field and pick the date fields I want to display. I would like to get rid of the time portion of the date. It always displays 1/2/01 12:00:00AM Thanks Paul