Forum Replies Created

Viewing 15 posts - 12,706 through 12,720 (of 13,460 total)

  • RE: HELP with error ''''80020009''''

    you didn't post any changes, so I'm assuming you are still not checking for nulls.

    add this function to the page:

    Private Function tnull(s) As String

        If IsNull(s) Or IsEmpty(s)...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 14, 2007 at 9:00 am

    #689727

  • RE: SQL image data type to jpeg

    in that case, here's an example from vb6: create a form, slap a button on it, and have the button call this function.change the SQL statement to your table, and...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 14, 2007 at 5:55 am

    #689675

  • RE: Error handling Problem- What am I doing wrong ?

    Also you've got to watch for the problem where if an error is level 16 or above, execution stops PERIOD... so it would never go to the log stuff.

    so if...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 13, 2007 at 2:17 pm

    #689577

  • RE: Secure FTP Batch File Problem

    Man you've already covered the basics, I see;

    Ok, i'd look at file attributes , file locking, and finally folder security... gotta cover the basics.

    any chance that the folder or the...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 13, 2007 at 12:46 pm

    #689545

  • RE: Secure FTP Batch File Problem

    i'm guessing that the username that is used to run SQLJobs doesn't have rights to the F:\ScriptedFiles\Oracle\DownloadedFiles folder;

    is this a mapped drive? try changing it to a uncpath: ie

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 13, 2007 at 5:09 am

    #689411

  • RE: How to find User Connections

    i know for SQL 2000, there's an applet in the control panel: Start>>Control Panel>> SQL Server Licensing Setup;

    mine says Processor License for 2 Processors, and doesn't have the ability to...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 12, 2007 at 5:48 pm

    #689336

  • RE: SQL image data type to jpeg

    not natively in SQL server; there's no implicit conversion funcitons in SQL for images.

    you have to farm it out to a .NET object for example, convert it, and then put...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 12, 2007 at 2:53 pm

    #689310

  • RE: Function to cast an integer to a varchar where 1 = A, 26 = Z, ...

    there are a lot of script contributions that do decimal to hex and hex to decimal for example, but non of them have the exact format you are looking for;

    take...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 12, 2007 at 8:59 am

    #689227

  • RE: No. of connections to the SQL Server

    I agree with Colin; Server does not exist or Access Denied.  is typically the application cannot connect, and has nothing to do witht he number of allowed connections.  A different...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 12, 2007 at 8:28 am

    #689216

  • RE: How to find User Connections

    because spids that are below 50 are system processes, i usually use this for the rough guestimate:

     

    select count(*) from master.dbo.sysprocesses where spid >=50

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 12, 2007 at 7:43 am

    #689159

  • RE: Help

    did you create a program called HTTP.exe?

    that is the error you are getting.

    maybe it does exist, but it's not in the path of the server when it's run?

    maybe something like...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 9, 2007 at 2:38 pm

    #688973

  • RE: schedule a trace

    I hope this helps:

    open profiler( Start>>Run>>Profiler)

    File>>New>>Trace Template

    Add all the Events, Data Columns and Filters you want to capture.

    Save the Trace Template.

    Test the template by doing Start>>Run>>Profiler.exe C:\PathToTemplate\YourTrace.tdf

    if it seems...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 9, 2007 at 2:32 pm

    #688969

  • RE: Consolidating Multiple Stored Procedure Results

    i think something like this, which does it all in one fell swoop, is what you are after:

    there are three virtual tables, x1,x2,x3, which are really the big select statements...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 9, 2007 at 11:00 am

    #688922

  • RE: xp_cmdshell can''''t execute VBS

    ok, I see the issue is that you need an inet control to read a web page....no problem...so i built a dll in vb6 with just one public method.

    a .vbs...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 9, 2007 at 9:58 am

    #688899

  • RE: xp_cmdshell can''''t execute VBS

    you are right...i get the same results...it runs to completion and returns null.

    what are you expecting to get back, though? you don't expect it to return the html as results...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 9, 2007 at 7:56 am

    #688839

Viewing 15 posts - 12,706 through 12,720 (of 13,460 total)