Recent content by cmhunt

Just thought I'd let you know that I've found a more permanent and robust solution. I found an article on using the Microsoft Text Driver and schema.ini file at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetschema_ini_file.asp Using this, I can turn off the...

Hi I've used VS2003 to create an application that consumes a web service which works fine on my test web server. When I build that app and deloy on our production web server, I get the error: "The underlying connection was closed: Unable to connect to the remote server" There doesn't seem to...

Hi I have a dataveiw which I am setting the sort to a column in ascending order. Is there a simple way of sorting to NULL values to the bottom instead of the top? Any help is gratefully appreciated. Chris

Hi Unfortunately the URL we have to check is not on our server so I don't think sessions are an option. One of our clients wants to integrate one of our web products into their website. Our product usually uses a username, password and IP address as security but the client wants a seemless link...

Hi Simple question relating to security on our site. We need the client to access one page before accessing another so please can someone tell me if the referring url (Request.UrlReferrer) easily "hackable"? Thanks Chris

Hi After some fiddling I found that simply adding a blank line at the top of the input files means everything works file. Not the perfect solution as messing with input files is just asking for something to go wrong, but I can't think of another way of doing it. Has anyone got any ideas whether...

Ok, the values in the first row of the CSV file which the DataAdaptor is using to fill the DataTable are being used as the column headers for the DataTable so when iterating through the DataTable in later processing, the DataTable has one less row than the CSV file (the first row). Apologies if...

The first row is going in as DataTable headings. Thanks Chris

Do you have access to your web.config file? If so, change the customErrors mode to off as it suggests. If you don't, you can always use Try....Catch to catch your error and then display it somewhere useful. Chris

Hi I'm trying to import a csv file into a data table without using the first row as a header row. My code is below: Dim Conn As OdbcConnection Dim dt As New DataTable Dim da As OdbcDataAdapter Dim strConnstr, strImportFolder, strFilename As String...

Cheers, I'll give that a go!

Hi Chiph - apologies for cross post. File genuinely has no line breaks in it. The file is being created using PHP. The file creation works fine and we have had no problems with this. My PHP knowledge isn't that brilliant so I'd prefer not to amend something that's working. I was thinking that...

Hi I'm currently delivering a series of XML files to clients. Files are all well formed and abide by schema. Clients, however, would like the file formatted for readability. I've told them that they can open the file in IE which'll make it readable but that want line feeds and tabs actually...

Hi I'm currently delivering a series of XML files to clients. Files are all well formed and abide by schema. Clients, however, would like the file formatted for readability. I've told them that they can open the file in IE which'll make it readable but that want line feeds and tabs actually...

Great, thanks - I'll give it a go. Apologies for the misleading subject by the way. I know that's originally how I thought I'd have to do it! Don't know why I put it in there though! Chris