I can really tell where you problem lies, I don't normally use a predefined ODBC connection, I prefer to create a connection eg.
set con = Server.CreateOb ject("ADODB.Con nection")
set Main = Server.CreateOb ject("ADODB.Rec ordset")
con.ConnectionS tring="DSN=loca lserver;Trusted _Connection=Yes ;Database=DBNAM E;"
Con.Open
sticking with the above code, to run a query, sp, etc.
...
dthompson
Last Activity: Jul 2 '07, 01:23 PM
Joined: May 18 '07
Location: Johannesburg, South Africa
-
I think I understand what you're trying to achieve, howvever not to my knowledge is it possible to at runtime add new variables to the Settings of your project. Settings variables seem to be designed to serve the purpose of storing user customizable data entered during runtime.
Question, do you need the info entered into the "Test" variable stored for when the app. is re-run, or do you just need a new variable each time the button...Leave a comment:
-
Well to close this up
I have resolved the problem, alas not to sure what the cause/resolution was.
Installed VS2005 SP1. Created a new Test app to open the evil file. Worked fine. Recreated the module in a new module for my existing service. Bob's your Aunty it works. Can only assume that the Service Pack did the trick. Even rebuiling under the new SP didn't work, seems like I had to make a new module to get it to build properly.Leave a comment:
-
Just used a VBScript to test it, code as follows, the same as my orginal code in the VB App.
Sub OpenLog
Dim fso, f,strLine,count
Set fso = CreateObject("S cripting.FileSy stemObject")
Set f = fso.OpenTextFil e("c:\log\bs.lo g", 1, True)
do while not f.atendofline
strLine = f.readline
loop
msgbox strline
f.Close
End Sub
Works fine,...Leave a comment:
-
You looking to do a recursive search
There are many example of such searches on the web, I have written code in the past to do this, if you can wait 24hrs, I may be able to locate it for you.
As for the execution of the file once located and hopefully only 1 instance is located.
Normal Shell command should work in this instance. If not I like using Windows Scripting Objects, below are a couple options.
...Leave a comment:
-
I think a bit more clarity is needed, not quite sure what you want the result to be. Creating new variables is unlikely, a new object however is feasible. Perhaps sketch out what you are trying to achieve.Leave a comment:
-
Thanks for the response,
I have checked this, initially the Service was running using an account that only had access to the SQL database into which the data is piped. I changed it to a Local Admin account, went a step further and gave all users Full access to the folder and files. The application creates a log file and an error log file, these files are created in the same folder with no issue. Just can't read (can create/append/...Leave a comment:
-
Error opening text file 0x80070002 (Works on XP)
I have written a service designed to run on 2003 Servers, in development it works 100% on my Windows XP system. Once deployed to 2003 I keep getting the same error (File Not Found, error 53) EXCEPTION ERROR: 0x80070002
The file is present, I am using FileExists method, if the file is not present no error, if the file is present FileExists = true and the program tries to open the given file. The error results. I have installed the Lastest...
No activity results to display
Leave a comment: