| Thread | Last Post | Replies |
|
| Version of Excel in Connection String | 02 May 2005 16:58 GMT | 1 |
I am using the following connection string in my program Code: XLFileConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filename & _
|
| stored proc /w Oracle and Ado.Net | 02 May 2005 12:27 GMT | 5 |
Can someone help me with a very simple task I am trying to execute a stored procedure in an Oracle database using Ado.Net. The following is a code snippet conn = New OracleConnection(mOracleConnectionString)
|
| Advice on "converting" one DataTable to a different structure? | 02 May 2005 04:26 GMT | 3 |
Hi everyone-- I have a one-row DataTable that I need to manipulate. It consists of a series of three columns of related information. All the columns are strings. For example--
|
| Two nested relations, but one is to itself | 01 May 2005 23:41 GMT | 1 |
I have an XSD which describes a set of objects which one is both contained in a parent, as well as referencing itself again (recursively). XSD.exe doesn't like it very much and complains about: "The same table cannot be the child table in two nested relations."
|
| Date Format Problem - SQL Server Insert From Web Application | 01 May 2005 15:38 GMT | 8 |
I've written a short aspx file so that end users can insert lines into our SQL server database. The following string is sent by Internet Explorer to the database where it updates the relevant table - INSERT INTO Tbl_Manual([Data Date],[Staff ID], Flag1, Flag2, Flag3, Ref1,
|
| Opening from Excel into a dataset, issue with mixed datatypes | 01 May 2005 02:13 GMT | 1 |
I have an excel sheet with a column of mixed data types, i.e., numeric & text. ADO.NET is scanning the first few rows and deciding on numeric so when we come across text, the data becomes blank. That being the case I set the extended properties setting to include IMEX=1 but ...
|
| Re: Using ms access how do I set column that can be of zero length TIA | 01 May 2005 02:10 GMT | 1 |
Sorry , I should have made it clear, how do I do it in code. Thanks.
|
| Importing existing data | 01 May 2005 02:06 GMT | 1 |
vs2005 beta2. I have created a sql server data file from within vs. Is there any way to import existing access tables & data into the sql server datafile? I have tried installed sql server 2004 developer from msdn but did not see any enterprise manager type tools that come with ...
|