Search results for query: *

Agreed xwb. many thanks.

It wont be the database, but it will be ALL the pages. I'm currently just replacing individual pages - it's quite precise. However, the idea of replacing all the pages, without kicking out the users, fills me with dread!

xwb - a followup question: Is it entirely necessary, in your opinion, to get all the users out of the application, when releasing a new version? If we're simply replacing like-for-like (files), wouldn't the transition be seamless? Throwing out users is the default position normally, but I'm...

Thanks guys.

Hi all, Interested in gauging members thoughts on Access VBA and Functions? Best practice to be stored in Modules or behind Forms? They will work when placed behind the latter, but cant help thinking it's bad practice.

Thanks for all your time on this xwb, but I'm still not convinced that releasing into PROD, a load of files that haven't changed, into all manner of different directories, can be a good thing. Kicking out users during business hours is also a step too far. However, your time and opinions...

Perfect. Exactly what i was after! I can see the attraction in this but also some negatives. For example, with an ASP project I would have to kick everyone out, to do a live release, as all the files would be replaced (albeit with the same thing). Currently, I'm far more surgical, and...

Checking in is per individual file, but does the promotion to the next environment (DEV to UAT) constitute the whole solution, or just the file modified? Hope I'm being clear here.

Your last sentence is interesting. When you say 'checkin everything', does that mean every file that constitutes your solution, regardless if they've been updated or not? If that is the case, I cant help feeling it's unnecessary. Why checkin files you haven't updated? Or have I got the...

Thanks xwb. Much food for thought. Where do you stand on my other point re: synching out of ALL files to PROD, when just one file has been updated? The idea is that this allows you to maintain individual, separate versions. Is this common practice?

I think the post below is probably better suited to this forum: Any of the good members of the Tek-Tips community, have any knowledge or opinions, on the best source control app, to harbour Classic ASP files? Also, discussing deployment strategies, what are peoples thoughts on re-deploying...

Any of the good members of the Tek-Tips community, have any knowledge or opinions, on the best source control app, to harbour Classic ASP files? Also, discussing deployment strategies, what are peoples thoughts on re-deploying the whole app (all files), when an update is made to just one file?

Thanks for your reply Borvik. I'm not using a DSN - I'm using a hard-coded connection string within the app itself. Hope this makes sense.

I appreciate your help Ralph, but I cant run it as an Admin as I have no idea what the password is and getting it, is not an option. It must be the app as they can see SQL Server otherwise. I'm wondering if they're connecting to DEV somehow, as everything seems to be pointing in that direction.

Using Windows only. Using SQL Authentication is not possible. I dont know what UAC is I'm afraid. Sorry to be vague.

Thanks Ralph. Yes I can ping the SQL Server and other apps can connect to the database.

Hi, I have a .Net app, written in VS2008 that connects to a SQL 2005 back end, on Win 7. Everything works fine on XP. However, on Win 7, unless the user is in an Admin AD Group, the connection fails with the error message: The server was not found or was not accessible. Verify that the...

Thanks Imex. I was able to adapt this to read something like: WITH CTE3 AS... SELECT ... FROM ... INNER JOIN ... WHERE ... ORDER BY ...

Thanks imex. I thought it might be useful (understatement I know) to post the code: (SELECT TOP (100) PERCENT dbo.Table3.sdtDateTimeStamp, dbo.Table1.intFXInstructionID, Table1.vchFundCode, dbo.Table1.chCCY, dbo.Table1.monAmount...

Hi, I have a query with 3 tables in it. It contains numerous fields, mainly from Table1, with a sprinkling from Table2 and Table3. The query returns 5 records. The records are all the same apart from the Date field, which contains different values for each of the records. The Date field is...