| Any Articles on Record Locking ? (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Does anyone have tips for implementing record locking for SQL server and OLEDB. Many feel that record locking will slow down things and easier to have a field indicating active user and active time (used for timeout) |
|
| Formatting data in DataColumn (4 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Tony Stark IronMan@aspelite.com Hi there I hope I'm posting this in the right place! What I'm trying to do is this: I'm importing SQL into various tables in a DataSet from a SQL2K Database, creating nested relations, and then ouputting XML via a XmlDataDocument. The problem is that all my date values (which are correctly formatted in the SQL DB) are en... |
|
| MSDE dD: DOT.NET connection works but not ASP connection string! (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Copied from [aspngsec] to [ngfx sqlclient] by Bob Levittan blevittan@hotmail.com I'm running MSDE, Server is "(local)" machine name assume "machinename" and I'm connecting to IBuyStore Portal Database. This connection works in .NET work SqlConnection("server localhost;Trusted Connection true;database Portal" ) This same string doesn't work in ASP3.0 'cn.Open "server localhost;Trusted Connection tr... |
|
| why would this function return a blank page when the same code worked when in a page load method. (2 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| why would this routine return a blank page when the same code worked when in a page load method. now that it is in a function it runs but does not show any datalist items on the page?? Is it because I am using a collection and need to import a namespace? %@ Import Namespace "System" % %@ Import Namespace "System.Data" % %@ Import Namespace "System.Data.SqlClient" % %@ Import Namespace "System.Web"... |
|
| ASP.Net & SQLServer (9 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngibuyspy] to [ngfx sqlclient] by Bob Levittan blevittan@hotmail.com I have had my ASP.Net app and SQLServer working on the same machine with Windows Authentication No Problem. I am now working on moving the SQLServer to a separate machine. In my asp.net web.config file I have had the connection string spec as follows: add key "ConnectionString" value "server (local);Trusted Connect... |
|
| CURSOR CLOSE ON COMMIT Problem (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| I'm working on some code that fails to fetch from a cursor when it commits a transaction after the cursor is opened, but before the fetch. I've tried to make this work with "SET CURSOR CLOSE ON COMMIT OFF" for the connection, but it doesn't seem to do the trick. I can only make it work by moving the commit to follow all of the fetches. While each query is easy to fix, there are a lot of them and t... |
|
| Debugging Stored Procs... (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| V2hhdCBpcyBuZWNlc3NhcnkgdG8gZGVidWcgU1BzIHdyaXR0ZW4gaW4gU1FMIFNlcnZlcj8gIEkg a2VlcCBnZXR0aW5nIGENCm1lc3NhZ2UgdGhhdCBzYXlzIHRvIGVuc3VyZSB0aGF0IFNRTERCUkVH MiBhbmQgU1FMREJHLmRsbCBhcmUNCnJlZ2lzdGVyZWQuICBEbyB0aGV5IGhhdmUgdG8gYmUgaW5z dGFsbGVkIG9uIHRoZSByZW1vdGUgbWFjaGluZSAoU1FMDQpTZXJ2ZXIpIG9yIG9uIHRoZSBjbGll bnQgbWFjaGluZT8gICBXaGVyZSBjYW4gSSBmaW5kIHRob3NlIHRvb2xzIG9uIHRoZQ0KRFZEPw0K |
|
| ASPNET cannot connect to SQL server accross the network (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Marcie Jones marciejones@yahoo.com Here is the situation: Machine A has SQL Server 2000 and ASP.NET Framework. Everything works like a charm. Machine B is connected to machine A via workgroup and has ASP.NET Framework. ASP.NET web applications on machine B cannot connect to SQL Server on machine A. When tracing the SQL on the server, I can see th... |
|
| Tracking back SqlClient accesses (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi! I'm using the SqlClient to read/modify/... data on my sql server. Intermittently some records are changed even though I wouldn't expect them to. If I were able to find out when and which modifications were sent to the sql server from my page, it could give some indications where to look for the bug. I tried to open/read the transaction protocol (LDF file) but to no avail. Any hints? (I hope th... |
|
| DataReader questions (21 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Marcie Jones marciejones@yahoo.com 1. What method to use when want to specify a fieldname instead of an ordinal? 2. What are e.g. GetSqlInt32, GetSqlChar methods for? Should I use the types fro efficiency's sake when using SQL Server? * code snippets appreciated |
|
| Trouble importing file (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| I have copied a shortened version of the text file I am trying to import into my SQL Server database. I can't figure this file format out, can anybody help me here?, I have no documentation on this file. 2002/05/15 02:29:30 20020514 BD800390000006B 00 FINSTRUCT SECURITIES (PTY) LTD D 00000000 00000000 BD850390000006 BD860390000006 BD770390000006 00000000 0000000 0000000000000000OTH00019990929 BD78... |
|
| SV: RE: SV: sql server connection (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| That's no problem. You may well connect to a SQL Server remotely like this. Regards/Halsningar Andre Colbiornsen Sonnenburg Communications Bergsgatan 3, SE 211 54 Malm F6 Sweden Tel.: 46 (0)40 97 78 80 Fax.: 46 (0)40 97 78 80 Mob.: 46 (0)708 97 78 79 Mail: colbiornsen@sonnenburg.se Web.: www.sonnenburg.se B2B Web Solutions Specializing in .Net Ursprungligt meddelande Fr E5n: Graham Dobson [mailto:... |
|
| SV: sql server connection (4 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| I thought a SQL server connection string should look like this: Dim objConn As New SqlConnection("Server 3Dsqlserver.quotamais.com.br;UID 3Dquotamais;PWD 3D webQ2 602";Database 3Dquotamais) Regards/Halsningar Andre Colbiornsen Sonnenburg Communications Bergsgatan 3, SE 211 54 Malm F6 Sweden Tel.: 46 (0)40 97 78 80 Fax.: 46 (0)40 97 78 80 Mob.: 46 (0)708 97 78 79 Mail: colbiornsen@sonnenburg.se Web... |
|
| Date Q? (4 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Does anyone know of a query trick to get the difference between two dates from two different records from the same field. The date field is sorted ascending, and the date that is needed to find the difference always follows as the next record. There is no other criteria to match up the two records and same field. Thanks! Patrick |
|
| ADO Command (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Tim Musschoot Tim.musschoot@rug.ac.be Hi all, Here is a sample, to summarize my problem: SQL Procedure CREATE PROCEDURE dbo.myProc ( @user id varchar (20) null, @start date datetime null, @cc1b text null ) as return 0 cm.CommandText "myProc" cm.CommandType adCmdStoredProc; cm.Parameters.Append(cm.CreateParameter("returnValue", adInteger, adParamR... |
|
| How can I return the number of rows that where added during each day for the last 7 days (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| How can I return the number of rows that where added during each day for the last 7 days and rename the date to a day name SQLStatement.Text "Select Count(*) Create Date from dwDNS where Create Date ( Convert(datetime,convert(varchar,getdate(), 1)) ) AND Create date (Convert(datetime,convert(varchar,getdate(), 1)) 7) order by Create Date"; For 2002 ASP.NET Solutions & Articles goto: http://aspalli... |
|
| What do I need to select based on date only How do i convert the datetime to date.. (4 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| what do I need to select base on date only How do i convert the datetime to date.. string SQL "Select ID, Problem, Create Date,Version,Poll from dwKnowledgeBase where Lang '" Lang "' and Create Date ( Convert(datetime,convert(varchar,getdate(), 1)) ) AND Create date (Convert(datetime,convert(varchar,getdate(), 1)) 1) order by category"; For 2002 ASP.NET Solutions & Articles goto: http://aspallianc... |
|
| SQLDataReader: Is there a way to return a null string is a null is returned? (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Is there a way to return a null string is a null is returned or the actual value (other than null) when a value is present? myReader[3].ToString(); //returns a empty string when the field returned is null myReader.IsDBNull(3) // returns true when the field returned is a null while (myReader.Read()) { Label1.Text myReader.GetString(0); // throws an exception when a null value is encountered } |
|
| Dynamic WHERE Clause (7 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hello All, I am trying to develop a stored procedure that has a dynamic WHERE clause. Here is what I have currently, but it isn't working. The @Thing1 variable is a WHERE String that I develop on the fly on the website. The error I am getting is that the is a problem near the 'as' by @Thing1 CREATE PROCEDURE sp GetAsianMatches @Thing1 as VarChar(2000) AS Declare @Stuff2 VarChar(2000) Set @Stuff2 3... |
|
| trusted SQL Server connection (5 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hello list, I'm a novice with SQL Server admin. Can anyone tell me what might be causing the error message below and how to fix it? Login failed for user 'sanet'. Reason: Not associated with a trusted SQL Server connection Wes Be sure to visit us on the web at www.dwloukota.com Do You Yahoo!? Yahoo! Health Feel better, live better |
|
| Incorrect syntax near ')'. I cannot find a missing ')' what could cause this (5 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Below is my code and Stored procedure Line 1: Incorrect syntax near ')'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near ')'. Source Error: Line 382: Line 383: myCom... |
|
| SV: Cannot Read Reader (6 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Where do you open (and close) the connection to your database? Regards/Halsningar Andre Colbiornsen Sonnenburg Communications Bergsgatan 3, SE 211 54 Malm F6 Sweden Tel.: 46 (0)40 97 78 80 Fax.: 46 (0)40 97 78 80 Mob.: 46 (0)708 97 78 79 Mail: colbiornsen@sonnenburg.se Web.: www.sonnenburg.se B2B Web Solutions Specializing in .Net Ursprungligt meddelande Fr E5n: Neil Moodley [mailto:Neil.Moodley@u... |
|
| SQLDataAdapter parameter not supplied during insert? (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngstart] to [ngfx sqlclient] by Tony Stark IronMan@aspelite.com I'm trying to insert data from a form into SQL Server database. I dragged the fields from the database onto the form to create a SQLDataAdapter, which creates an automatic insert command. My submit button calls: SqlConnection1.Open() SqlDataAdapter1.InsertCommand.ExecuteNonQuery() SqlConnection1.Close() When I submit, I... |
|
| instanciate a sqlconnection array (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Marcie Jones marciejones@yahoo.com Moved from [aspngfreeforall] to [aspngdata] by Tim Musschoot Tim.musschoot@rug.ac.be Hey, I have got a data access class where I need to have some connections available. Is there a better way to instantiate this array than looping trough each element in my array (vb or c#)? Code Dim mConnectionString As String Private... |
|
| Reuse a connection? (6 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Tim Musschoot Tim.musschoot@rug.ac.be I have two drop down lists, both of which reflect the returns of the same stored procedure. How do I set the droip downs to use the same data? My code %@ Page Language 3D"VB" Debug 3D"true" % %@ import Namespace 3D"System.Data" % %@ import Namespace 3D"System.Data.SqlClient" % %@ outputcache duration 3D"12000... |
|
