Database

FirstPrevNext

Insert pmartike13-Jul-07 21:09 pmartike 13-Jul-07 21:09  Please tell me how to insert a string like this: SAMPLE'STRING into an SQL table? How escape special characters in MSSQL? Thank you. -------------------------------- visit: http://pmartike.deviantart.com/ Re: Insert pmartike13-Jul-07 22:17 pmartike 13-Jul-07 22:17  Problem solved -------------------------------- visit: http://pmartike.deviantart.com/ Classic ASP and MS SQL Express Edition Fayu13-Jul-07 6:06 Fayu 13-Jul-07 6:06  I have a Classic ASP website and i want to use MS SQL Express edition as the datasource. I tried the .NET Connectionstring and they do not work for the Classic ASP (ADO) site. I have tried figuring this out for the last three days. PLEASE HELP! Thanks in advance. Re: Classic ASP and MS SQL Express Edition Paul Conrad13-Jul-07 6:11 Paul Conrad 13-Jul-07 6:11  What kind of messages are you getting, if any? "Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus Re: Classic ASP and MS SQL Express Edition Fayu13-Jul-07 6:24 Fayu 13-Jul-07 6:24  Here is the connection string im using: Data Source=.\SQLEXPRESS; Integrated Security=True;AttachDbFilename=|DataDirectory|\MyDatabase.mdf;Initial Catalog=MyDatabase This is the error: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. Re: Classic ASP and MS SQL Express Edition Dave Kreskowiak13-Jul-07 6:19 Dave Kreskowiak 13-Jul-07 6:19  ConnectionString.com[^]. Look under "SQL Native Client OLE DB Provider" for your situation. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: Classic ASP and MS SQL Express Edition Fayu13-Jul-07 6:34 Fayu 13-Jul-07 6:34  Okay I changed my ConnectionString to: Provider=SQLNCLI;Server=localhost\SQLExpress;Database=data.mdf; I now get a new Error: Invalid authorization specification. I do not have a username or password on the file. Now what?? Re: Classic ASP and MS SQL Express Edition Dave Kreskowiak13-Jul-07 8:55 Dave Kreskowiak 13-Jul-07 8:55  It should be: Provider=SQLNCLI;Server=.\SQLExpress;AttachDbFilename=FullyQualifiedPathToDBFile.mdf;Database=dbname;Trusted_Connection=Yes;" This will only work for code executed server-side. It won't work for client-side code. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: Classic ASP and MS SQL Express Edition Fayu16-Jul-07 12:50 Fayu 16-Jul-07 12:50  This CS did the trick. Thanks DO NOT CROSSPOST leckey13-Jul-07 7:05 leckey 13-Jul-07 7:05  please read the forum guidelines. _____________________________________________ Flea Market! It's just like...it's just like...A MINI-MALL! Re: DO NOT CROSSPOST Paul Conrad13-Jul-07 11:46 Paul Conrad 13-Jul-07 11:46  Dang. You beat me to it. Just saw the cross post in the other forum and wondered where I saw it before. "Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus Re: DO NOT CROSSPOST Sathesh Sakthivel13-Jul-07 16:21 Sathesh Sakthivel 13-Jul-07 16:21  leckey wrote: Flea Market! It's just like...it's just like...A MINI-MALL! What happened to cats and awesome. Regards, Satips. Don't walk in front of me, I may not follow; Don't walk behind me, I may not lead; Walk beside me, and just be my friend. - Albert Camus How to create hash clustered index in oracle? Mushtaque Nizamani12-Jul-07 23:53 Mushtaque Nizamani 12-Jul-07 23:53  Hi, How can i create hash clustered index in oracle? Best Regards, Mushq Mushtaque Ahmed Nizamani Software Engineer Ultimus Pakistan "English is my second language, so please don't mind if i do some grammatical or spelling mistakes in my messages." Re: How to create hash clustered index in oracle? Paul Conrad13-Jul-07 11:49 Paul Conrad 13-Jul-07 11:49  Have you looked around in the Oracle forums? "Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus sqlerror saravanan0512-Jul-07 23:13 saravanan05 12-Jul-07 23:13  hi friends this is my stored procedure: CREATE procedure dbo.sp_ins_logo @companyname varchar(120), @country varchar(80), @url varchar(150), @category varchar(80), @description varchar(250), @picturepath varchar(80), @picturetype char(5), @status int, @ins_status varchar(10) output, @lcode varchar(10) output as set nocount on begin transaction declare @logo_rowid decimal declare @logo_code varchar(10) declare @logo_rowcount decimal declare @max_logoid decimal declare @logo_codepfix char(3) set @logo_codepfix='LGO' select @logo_rowcount= (select count(*) from dbo.tbladdlogos1) if @logo_rowcount = 0 begin select @logo_rowid = 1 select @logo_code = @logo_codepfix + convert(varchar(5),@logo_rowid) end else begin select @max_logoid = (select max(row_id) from dbo.tbladdlogos1) set @logo_rowid = @max_logoid + 1 set @logo_code = @logo_codepfix + convert(varchar(5),@logo_rowid) end declare @file_name varchar(80) set @file_name = @picturepath + @logo_code + '.' + @picturetype if not exists (select companyname from dbo.tbladdlogos1 where url = @url) begin if not exists (select companyname from dbo.tbladdlogos1 where companyname = @companyname) begin insert into dbo.tbladdlogos1 values(@logo_rowid,@logo_code,@companyname,@country,@url,@category,@description,@file_name,@status) declare @ER as int select @ER = @@error if @ER <> 0 begin set @ins_status='Failure' set @lcode=@logo_code end else begin set @ins_status='Success' set @lcode=@logo_code end end end commit GO this is my table CREATE TABLE [tbladdlogos1] ( [row_id] [int] NOT NULL , [logo_code] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [companyname ] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [country] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [url] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [category] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [description] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [picturepath] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [status] [int] NULL ) ON [PRIMARY] GO i inserted value below error is occured Invalid object name 'dbo.tbladdlogos1'. Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1. can u help me regards saravanan Re: sqlerror Mike Dimmick12-Jul-07 23:45 Mike Dimmick 12-Jul-07 23:45  First, check that you're executing the above in the right database, or that you created the table in the right database. We've all done it. Second, you've used BEGIN TRANSACTION in the above code, but you didn't tell SQL Server what you wanted to happen at the end. You should use COMMIT TRANSACTION to save the changes you've made, or ROLLBACK TRANSACTION to discard them. Generally you should check @@ERROR after every data modification statement and ROLLBACK TRANSACTION (and return) if it's not 0. Only critical errors abort the stored procedure and automatically rollback the transaction. Errors like attempting to insert a duplicate key are not considered critical; the statement will be aborted and rolled back, but execution will continue at the next statement. SQL Server does not permit transactions opened in a stored procedure to be held open after that procedure executes. That's why you get the error. If you want a transaction to span multiple procedure calls, you'll have to use a client-side transaction (e.g. a SqlTransaction object). Stability. What an interesting concept. -- Chris Maunder Re: sqlerror TomGarth15-Jul-07 9:16 TomGarth 15-Jul-07 9:16  ...and in addition to that, make sure you have granted access to the user that you are when executing the call. Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia Referring .RDL file Karuna Kumar12-Jul-07 21:28 Karuna Kumar 12-Jul-07 21:28  Hi, How to refer one .RDL file created in one project(Proj1) in another project(Proj2) in the same solution in SQLServer Reporting Service(SSRS). I am not able to refer .rdl file created in one project in another project under same solution. Karuna Re: Referring .RDL file Paul Conrad13-Jul-07 12:57 Paul Conrad 13-Jul-07 12:57  Have you tried including a reference to it in the solution? "Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus Re: Referring .RDL file Karuna Kumar15-Jul-07 21:17 Karuna Kumar 15-Jul-07 21:17  First of all Thanks for your reply. Here, thats what the problem in this SSRS Solution. we cannot include any refernce in the project as we do in normal visual studiao IDE.only we can add Data sources and .RDL files physically.But we cannot refer any .rdl file logically as we do with dlls. Thanks. Karuna Creating a new Folder Karuna Kumar12-Jul-07 21:23 Karuna Kumar 12-Jul-07 21:23  Hi, How to create a new folder in SQLServer Reporting Services(SSRS) Project? If i create an SSRS project, the solution comes with two folders 'Shared Data Sources' and 'Reports' by default. But i am not able to add a new folder under that solution. Karuna Re: Creating a new Folder Frank Kerrigan16-Jul-07 2:30 Frank Kerrigan 16-Jul-07 2:30  Check your permissions Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture) http://www.frankkerrigan.com/[^] Views with Insert Query Suryanairg12-Jul-07 18:06 Suryanairg 12-Jul-07 18:06  Hi, I am trying to clarify a doubt. Can we use Views for a insert Query? Thanks in advance, Sunil Nair Re: Views with Insert Query Krish - KP12-Jul-07 18:52 Krish - KP 12-Jul-07 18:52  Yes, inserting into a base table from a view is possible. however all not null columns to be included in the view and any columns with check constraint Regards KP assigning value to variable in stored procedure brsecu12-Jul-07 7:59 brsecu 12-Jul-07 7:59  I am trying to get info into a variable in a sql server 2000 stored procedure How can this be done. I thought i had it but it doesnt seem to work. This is what i have. Declare @var1 int Select @var1 Select max(List_ID) from table1 @var1 stays NULL What am i doing wrong?

Last Visit: 31-Dec-99 18:00     Last Update: 22-Sep-24 12:25 Refresh ᐊ Prev1...1492149314941495149614971498149915001501 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

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