Recent content by snakehips2000

I'm looking to develop a basic website to administer a sports league. I'm an experienced SQL Server database developer but am new to web development. I wish to make full use of my database skills in manipulating data so will be preferring to use the efficiency of pre-compiled stored procedures...

No, that's the same object library I mentioned in the initial post. The point being that it doesn't work for SQL Server 2008 and has been "replaced" in some way by SMO. How to make some alien contact with the elusive SMO is what I seek.

I use Access 2003. For many years I was able to dynamically manipulate the structure of objects in my network SQL Server 2000/2005 databases (i.e. tables, views, stored procedures etc.) by creating a reference to the SQL Server DMO object library (Tools, References). The network SQL Server...

Having experimented a bit on this, I opened two separate instances of IE (not two tabs within the same instance) on the same machine and accessed my site via two different login IDs. Behind the login script there is a piece of code which sets the session("username") value. So, in IE instance 1...

Thanks Chris.

There's probably something basic I'm missing here but, if my ASP page contains the following: <% rsProducts.Close Set rsProducts = Nothing objConnection.Close Set objConnection = Nothing %> If User 1 runs the page and, whilst executing and having set the recordset and connection object...

Thanks for the response. I think I've either understated the problem or you've overlooked something. I'm trying to use the script contained within the actual .sql file itself, i.e. not hard-code the "SELECT ..." statement as per your example. So, I need something which accepts the path to the...

I'm looking to execute a SQL Server script which I've saved as a .sql file, from Excel VBA, and export the results into another Excel workbook via ADO. Could someone please supply a simple example? It's the referencing of the .sql file which I can't get my head around. Presumably, I also need...

Thanks guys for the update and the revised function coding. I guess I started off with the wrong assumption, i.e. that there were 53 weeks in 2010 when in fact there were only 52.

MajP - sorry if there's any confusion on this. In the subject line of the thread I tried to state that I'm looking to return the date of the first day (assuming the week runs from Monday to Sunday) for the stated week. For example, week 1 in 2011 would return 3 Jan. Likewise, week 53 for 2010...

I picked up the following two functions as a means of determining a date from a week number in Excel VBA. Unfortunately, when used together, they return the same date for both week 53 of 2010 and week 1 of 2011 (3 Jan). Does anyone have anything more reliable please? Thanks. Public Function...

Thanks to you both for your suggestions. I'm sure I'll find one which suits my needs.

Thanks for the replies PHV and Gruuuu. I'm aiming to do this manipulation of the Oracle SP from Excel VBA. Essentially my project involves rationalising a large set of manual processes which involve three hierarchical levels: the Oracle back-end, an Access application (where the data is being...

I know there is the SQL-DMO object library which allows all objects on a SQL Server to be manipulated, i.e. databases, tables, views, stored procedures etc., but is there an equivalent reference within VBA for the objects in an Oracle database? I'm particularly interested in changing the...

Im trying to create a formatted Excel spreadsheet with the results of a T-SQL query. However, I'm getting an error when using the following code which seems to be in generic use on several forums. Can anyone tell me where my syntax is wrong? I have the necessary permissions for executing...