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...

...on the server and i also use all the followings but non of them seems to do the trick. Me.sqlcn.ConnectionString = "packet size=4096;user id=*****;password=*****;data source=*****;persist security info=False;initial catalog=*****;connection timeout=3600;"...

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

...oracleConn.ConnectionString = "user id=xxx;data source=xxx;password=xxx" oracleConn.Open() CommandTextB = "SELECT * " CommandTextB = CommandTextB & "FROM DIRECTORY D, datAdapter = New OracleDataAdapter(CommandTextB, oracleConn)...

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...

...Security=SSPI;Connect Timeout=3600") datAdapter = New SqlDataAdapter("select * from tableA", sqlconn) sqlconn.Open() datAdapter.Fill(Dataset1, "TableA") sqlconn.Close() sqlconn = New...

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...

...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.*; // Illustrate the LineNumberReader class. class SelectLines { public static void main(String[] args){ int n = 0; int Line1...

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...