Search results for query: *

nice one thanks "exec sp_pkeys table_Test"

Is there any way to find which filed is the unique ID field in a table by using some type of SQL... i.e: select * from Test_Db..syscolumns c join Test_Db..sysobjects o on c.id = o.id where o.name = 'table_Test' The above example will find all column names for a given table. I m looking...

I have a page that connects to SQL server 2000 and executes a very large query, that returns a small amount of records. The query takes about 2 minutes to execute in query analyser but the ASP.NET page expires before i get any results on screen. The full message i get is: "Timeout expired. The...

This worked for anyone interested after 8 hours hammering my brain. Private Sub CheckBox1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CheckBox1.CheckedChanged Dim ctr As Integer Dim i As Integer Dim drpbox As New DropDownList...

plhProductFields is a Placeholder object already on the form.

I have a static multiselect list-box tbl1 which contains values. i m selecting several values i.e value1 and value2 and after clicking a button i want based on these selected values to create Dynamically (2) drop down boxes and append to them the values of my previous selection. So for...

Note Unlike the Connection object in the other .NET Framework data providers (SQL Server, OLE DB, and ODBC), OracleConnection does not support a ConnectionTimeout property. Setting a connection timeout using a property or in the connection string has no effect and value returned is always...

this example assumes oracle to oracle relationship. but works one oracle to sql and sql to oracle too

anyway i fixed that: see code below: unless somone has a quicker work arround without using the relationships add thing: Dim Dataset1 As New DataSet Dim Dataset2 As New DataSet Dim Datatable As New DataTable("MyDataTable") Dim DataColumn0 As New...

thats the deal i want to connect to oracle and SQL simultaneously.

Thanks cappmgr, although the article u are giving me suggest using: Imports Oracle.DataAccess.Client while i am using: System.Data.OracleClient. And thus the property Connection Timeout=60; is not supported, im getting: Keyword not supported: 'connection timeout'. So i assume i have to download...

does anybody know how to set the timeout command when connection from ASP.NET to otacle? using Dim oracleConn As OracleConnection = New OracleConnection oracleConn.ConnectionString = "user id=xxx;data source=xxx;password=xxx;" i tired connect timeout=9999 and connection timeout=9999 but both...

I am new to asp.net although i had a good experience working with ASP. I m connecting to 2 different databases, i.e Database A and Database B. Then Selecting fields from Database1.TableA trying to JOIN to Database2.TableB. I then bind to Datagrid. I used the folowing code which works fine but...

The problem is that I am not using any custom query for this. I am talking about the MS Access default Search facility (i.e Ctrl+F). The common office popup window that is used for all office apps for either Find or Replace. Is there any way to make this work fast instead of having to create a...

I m using MS Access 2003 and using the upsizing wizard i have migrated my database to SQL server 2000. Every time I use the MS Access's default search to search the recordsets of my database for a particular value on a large (10.000 recs) table, the search facility becomes very slow. I have...

Hello everybody, I am using Windows XP Pro SP1 with IIS 5.1, is there any way to allow a non-admin user using his accound (non-admin) log on to my machine and administer IIS i.e start/stop IIS server e.t.c lets say im the admin user and he isnt, and that we both exist on the same machine. In...

I finally found some script and simply modifided it to fit the purpose. Thanks stefanwagner for you help. The following code accepts the text file plus two numbers on command line. usage: java SelectLines my.txt 2 4 Output line 2 of file line 3 of file line 4 of file import java.io.*...

Can you help please? I have a text file ".txt" and i want to specify lines to read from it in command line. i.e my.txt contains Line 1 of text Line 2 of text Line 3 of text Line 4 of text Line 5 of text Line 6 of text Input Java LineReader 3,5 or Java LineReader 3 5 Output Line...

I do like answering my own questions is always enjoyable. Well first the reference to my previous post for incompatibilities in "special functions (dates, chars)" is wrong hehehe this never happened... sory for this and seccond i found the following links addressing all my questions...

Hi everyone, could you please give me any possible links to a document/s (or anything) that shows or discusses or lists the basic (or detailed) differences of Access 2000 and Access 2002 (sp2). My attempt to answer this question was simply to go through some existing databases from others, and...