|
Can you create a liked server in the MSDE version of SQL Server?
If so, are there any limitations linking to a MS Access database?
Thanks,
Michael
I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious.
Vince Lombardi (1913-1970)
|
|
|
|
|
hi can you tel me how to use the sessions in asp.net. see i have diff users. depending on the user i want to view the data using his code
|
|
|
|
|
|
Hi,
For using session, you can first add some kind of id e.g userid or something to the session and then retrieve the id from the session and depending on user id get the data.
e.g.
to add id to session,
string sUserID=session.add["UserId",userid];
and to retrieve id from the session,
string sUserId = Session["sUserID"].ToString();
all the best,
manasi
|
|
|
|
|
how can i use ping command in ASP.NET??????
|
|
|
|
|
|
To simplify our own situation lets say we have clear seperation of the three layers with the Presentation, Business and Data Access Layers in their own seperate DLLs, but on the same client machine. Our DAL DLL is obfuscated and holds our single service account to access the database.
We are presuming it is at least very difficult even with someone having access to the obfuscated DLL they would have a difficult time determining the userid and password of our one service account that can access our SQL Server database. Still, how do we stop someone from writing their own code and directly accessing the DAL DLL to change our datbase?
We considered sending a hidden key between the layers of the obfuscated DLLs, and even possibly adding an extra layer of encryption using Public and Private keys. Still, every single time a database access is requested would require this key encryption and decryption when 99.9999% of the time it is unnecessary. Is there a quicker and cleaner way of doing this?
Thanks!
|
|
|
|
|
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;
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
