|
Hello,
I have been trying to figure out how to get some additional information into a
report on an ASP page but I am stuck. The report asks the user for a date
range. There is also a field to input the UserID to narrow down the search.
So if I would like a report on information for the previous month I would just
input the dates. If I just wanted the report for the particular UserID then I
would add info to that field.
What I am trying to do is modify the record set so that the report will display
another column in a different tables within the database. I have not been
successful yet. I am not sure how to go about this since the recordset is using
a string, not a SELECT statement.
Here is the select statement:
'Prepare and open recordset
GetConn dbconn
Set rs = server.createobject("adodb.recordset")
rs.activeconnection=dbconn
rs.source = strSP
rs.open
If I change the source from strSP(the string) to a normal join statement for
the two tables then the information on the page is not correct. Is there any
way to combine the string and a select statement?
I've searched all over the internet and books for examples but I have not found
any. If anybody has any ideas let me know.
Thank You!
|
|
|
|
|
I figured it out. The string was calling a stored procedure. once I figured out what stored procedure was the source I was able to add the data.
|
|
|
|
|
Hi
I am using ADO on Win98, When i am trying to use insert/select sql statements I am getting CryptApI,CryptoAcqire failed eroor, can any one help me
Gourigari Ramesh Reddy
Hyderabad
|
|
|
|
|
Hi,
I connect to an oracle database using OleDbConnection and run quite a number of queries. In the connection string I use everything default, that means the min pool size is 0, max pool size is 100 etc. I don't keep any connection open, as soon as I finish one query I will close the connection and do something else. Also, this is not a multi-thread program.
The problem I have now is that I found my program will create more than one sessions in Oracle, the highest number of sessions I found so far is 24, the lowest is 2. I don't know why. Can anyone explain it a little bit and tell me what is the relationship with connection, connection pooling and the actual session in database?
Thanks in advance.
|
|
|
|
|
I am trying to update an ISequentialStream object in a RowSet. But am getting the following errors:
- Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
- String data, length mismatch
The "String data, length mismatch" one is troubling me. And I think it has something to do with the way I am creating the stream. This is the methodology I am trying to implement:
IStream *pIStream;
CreateStreamOnHGlobal(NULL, true, &pIStream);
pIStream->SetSize(x);
pIStream->Write(databuf, databuf_len, &byteswritten);
ISequentialStream *pISeqStream;
pIStream->QueryInterface(IID_ISequentialStream, (void **)&pISeqStream);
I am struggling with the length. As to what it should be set to. I have done a simple test to try and write a 6 character string. The size of the stream created is 6 bytes and I have set the size of the length in the bindings for the rowset to be 6. Yet I am getting a string length error on Update ...does a null terminator for the string have to be allowed for somewhere.
Any help on what I may be doing wrong here would be appreciated. Thanks.
|
|
|
|
|
If I do an GlobalAlloc and copy the data into this block of memory and pass that to the CreateStreamOnHGlobal function instead of using the IStream->Write function it works without an error.
But as far as I can tell, the size of the streams created using both methods are the same, and the memory allocated to each is the same.
|
|
|
|
|
I'm working on a project where i have a parent child relation between two tables. just straight forward. I use the Win form DataGrid in .NET c# to view the data. The relation is made and a + appears before the key in my datagrid. When i click that + i can click on a label which brings me to the child records. The parent row is then showed as a header.
What i would want is when i click the + that child records appear under the parent record in the current datagrid. Simular the way access shows related records.
Can this be done with the datagrid in a window application ??
|
|
|
|
|
|
I'm using Visual Studio.NET 2003 Professional and I seem to be unable to right click the stored proceedure (in the server explorer) and get 'New Stored Procedure' in the drop down menu. Is this only available in the the Enterprise Edition of VS.NET2003?
Jerry
Most people are willing to pay more to be amused than to be educated--Robert C. Savage, Life Lessons
Toasty0.com
Ladder League (beta)
|
|
|
|
|
At the file menu you will see a database option, there you will be able to create a new stored procedure.
Hope it helps!
Illegal Operation
WannaBe and GonnaBe Systems Developer
|
|
|
|
|
Maybe I'm not explaining myself well.
As this image shows there is no selection in the drop dowm menu.
Jerry
Most people are willing to pay more to be amused than to be educated--Robert C. Savage, Life Lessons
Toasty0.com
Ladder League (beta)
|
|
|
|
|
This is cross posted in the Visual Basic / VB.NET and SQL / ADO / ADO.NET since I am not sure exactly where it goes. So... lets give this a shot. Background: I am using Access 2000 with extensive Visual Basic coding to handle much of the legwork and raw data manipulation. In the project I have a table with several columns (Say [Info1], [Info2], [Amount1], and [Amount2]). When I open the form it selects all the entries from the table where [Amount1] is less than [Amount2] (I call this a sub set of the table but I am sure there is some big word or funny acronym that is normally used). In the VB code for the form I use Form_FormName.RecordSet.Movefirst / Movenext / Movelast to move around the subset of data and modify it as needed based on what is in [Info1] and [Info2]. This all works fine, but I would like to take all of this data from the subset and put it into a new table in the same database. The new table already exist and has data in it, what I can’t figure out is how to open two different tables in a single form and place data from one table into the other table. It sounds simple, and probably is, but I just can’t seem to figure it out. If anyone could give me a hand or at least get me pointed in the right direction I would greatly appreciate it.
Thanks,
Mark
|
|
|
|
|
We have four systems, which I will designate as follows:
MySvr1 - Windows Server 2003 - MSDE 2000 SP3
MySvr2 - Windows Server 2003 - MSDE 2000 SP3
DbSvr1 - Windows Server 2000 - SQL Server 2000 SP3
DbSvr2 - Windows Server 2003 - SQL Server 2000 SP3
All of these systems are members of a domain that I'll call DOMAIN.
MySvr2 has a service running under the local system account. This service
wants to access a database using its domain computer account. We've created
a security group (call it SecGroup) that includes DOMAIN\MySvr2$ among its
members. We've created a database login for SecGroup on all four servers.
The service running on MySvr2 attempts to connect to the database using the
connect string:
Provider=sqloledb;Integrated Security=sspi;Initial Catalog=MyDatabase;Data
Source=servername
If the service attempts to connect to the database on MySvr2 or MySvr1 it
succeeds. Furthermore, if I remove the SecGroup login on MySvr1 and try to
connect, I get a login error message that indicates login failure for
"DOMAIN\MySvr2$". This is exactly what I would expect and hope for.
If we attempt to connect to the database on DbSvr1 we get a login failure:
IDispatch error #3149
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
If we attempt to connect to the database on DbSvr2 we get a login failure:
Unspecified error
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
As one more test, we created a share on DbSvr1 with a file in it. We put an
ACL on the share, the underlying folder, and the file, that granted access
only to members of SecGroup. When I tried to access the file from MySvr2,
while logged in as myself, I got access denied (as expected). When the
service tried to access the file it was able to do so, and we could verify
that it had authenticated to DbSvr1 as DOMAIN\MySvr2$.
The TCP/IP transport is enabled on all four servers.
Anyone have any ideas as to what could be causing this? Any remedies?
--------
There are 10 types of people in this world. Those who know binary and those who don't.
|
|
|
|
|
If TCP is enable, why don't you use this connection string:
<add key="ConnectionString" value="server=192.168.1.1;user id=sa;password=yourpassword;database=databasename"/>
|
|
|
|
|
I want to zero-fill and right justify the display of an int field in a select statement using SQL Server 2000.
Anyone know an easy way?
|
|
|
|
|
I usually handle this on the front end but, as and exercise, here is something that works:
SELECT
REPLACE(ISNULL(SPACE(10 - LEN(CAST([MyIntField] AS VARCHAR(10)))),''),' ',0) +
CAST([MyIntField] AS VARCHAR(10)) AS ZeroPaddedNumber
FROM
[MyTable]
Just replace [MyIntField] & [MyTable] as appropriate and it should work. The number 10 represents the length of the resultant string (padded with zeros).
|
|
|
|
|
I want to list the tables of the selected access database and to view the data stored in this table I am using windows applicaiton (using c# language)
|
|
|
|
|
to get a list of tables from Acces DB try SELECT NAME FROM MSYSOBJECTS WHERE TYPE =6;
|
|
|
|
|
Use an OracleCommandBuilder.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
The method OracleCommandBuilder.DeriveParameters does'nt exist in ODP.Net 9.2 ,
I found it in ODT (Oracle® Data Provider for .NET Developer's Guide
10g Release 1 (10.1.0.3) ,but i use ODP.Net 9.2 .
I think that i hav to use odp 10.1.
thnx
ENSI TUNISIA
|
|
|
|
|
Creating a mysql-based application the user that use my application needs mysql server installed on its pc?
|
|
|
|
|
no need . but your user should install the driver or client browser.
So you can connect to a mysql server in the network.
Your code is cool as your are
Your work is cool as Your code
So be a cool code worker
|
|
|
|
|
i tried to install SQL Server 2000 on my Windows 2000 Advanced Server and i got error when the setup was configuring the server... it told to check the sqlstp.log file which has the following lines at the end...
i could not get the error...
can anyone help me ???
thnkx
*************************************************************
00:20:03 End Action: Locked Connectivity Files Check
00:20:03 Setup is installing Microsoft Data Access Components (MDAC) ...
00:20:03 G:\x86\Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
00:20:35 ExitCode: 0
00:20:35 Setup is installing Microsoft Distributed Transaction Coordinator (MSDTC) ...
00:20:35 D:\WINNT\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir "D:\WINNT\TEMP\SqlSetup\Bin" -DTCPkg "G:\x86\Other\dtcsetup.exe" -LogFile "D:\WINNT\sqlstp.log"
00:20:35 Process Exit Code: (0)
00:20:35 InstallMSSearch instance: MSSQLSERVER
00:20:35 Software\Microsoft\Search\Install:Version not present
00:20:35 MSSearch 2.0 or greater version check returned -1
00:20:35 Setup is installing the Microsoft Full-Text Search Engine ...
00:20:35 "G:\x86\FullText\MSSearch\Search\SearchStp.exe" /s /a:SQLServer
00:20:44 Process Exit Code: (0)
00:20:44 /Q:A /T :\WINNT\TEMP\ixp001.tmp
00:20:44 Setup is installing HTML Help ...
00:20:45 HTML Help installer exit code: 0
00:21:07 End Action InstallPkgs
00:21:07 Begin Action MoveFileData:
00:21:07 Enabled SELFREGISTERBATCH
00:21:07 Enabled CORECOMPONENTHANDLING
00:22:07 Begin Action: MoveFileDataSpecial
00:22:07 End Action: MoveFileDataSpecial
00:22:07 End Action MoveFileData
00:22:07 Begin Action ProcessAfterDataMove:
00:22:07 G:\x86\Binn\hhcol.exe D:\Program Files\Microsoft SQL Server\80\Tools\Books
00:22:08 End Action ProcessAfterDataMove
00:22:08 Begin Action BuildServer:
00:22:08 D:\WINNT\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 5 -ExePath "D:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlservr.exe" -Service "MSSQLSERVER"
00:22:08 Process Exit Code: (0)
00:22:08 Begin Action: CreateRegistrySetSQL
00:22:08 End Action: CreateRegistrySetSQL
00:22:08 Begin Action: RegWriteSetupEntry
00:22:08 End Action: RegWriteSetupEntry
00:22:09 Begin Action: CreateSer
00:22:09 End Action: CreateSer
00:22:09 Begin Action: SkuIt
00:22:09 End Action: SkuIt
00:22:09 SetFileSecuritySQLAndAdmin for D:\Program Files\Microsoft SQL Server\MSSQL returned: 1350, 1350
00:22:09 SetRegSecuritySQLAndAdmin for Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
00:22:09 Begin Action: UpdateSystemPath
00:22:09 Path successfully updated.
00:22:09 %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;D:\Program Files\Microsoft SQL Server\80\Tools\BINN
00:22:09 End Action: UpdateSystemPath
00:22:09 Grant Right for V2RS\Administrator returned : 1, 0
00:22:09 Grant Right for V2RS\Administrator returned : 1, 0
00:22:09 Grant Right for V2RS\Administrator returned : 1, 0
00:22:09 Grant Right for V2RS\Administrator returned : 1, 0
00:22:10 D:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F "D:\WINNT\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 524698 -U sa -P
###############################################################################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=VISHUCOOL;UID=saWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (GetOverLappedResult()).
driver={sql server};server=VISHUCOOL;UID=saWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (ReadFile()).
driver={sql server};server=VISHUCOOL;UID=saWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (ReadFile()).
SQL Server configuration failed.
***********************************************************
|
|
|
|
|
This user[^] had the same problem.
A question that occurs to me is why it's using the Named Pipes driver. I can't recall whether Named Pipes is enabled by default on a new installation - I didn't think it was. I would have expected it to select Shared Memory. You could try checking to see whether there are any aliases configured in the Client Configuration tool (cliconfg.exe).
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
if any one know the code to view the tables in access database and display the data from any table plz send it quickly
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
