User Profile

Collapse

Profile Sidebar

Collapse
guswebb
guswebb
Last Activity: Jul 29 '07, 11:02 PM
Joined: Jul 28 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • guswebb
    replied to BCP to XML
    in XML
    i have now fixed the problem of inserting the root tags.

    my next problem is that in the process of doing this, i am creating a temporary file called myfiletemp.xml. once the bcp process has completed, i no longer need this file, so i am appending the command to delete it to my bcp command, as follows...

    del /Q myfiletemp.xml

    for some reason, this still prompts me with a Y/N option, asking if i'm sure that...
    See more | Go to post

    Leave a comment:


  • guswebb
    started a topic BCP to XML
    in XML

    BCP to XML

    i'm running bcp to output some MSSQL table content to XML. i can get the xml output file fine but am having problems with the insertion of the <root> open and close tags.

    the code that I'm using is as per various threads that i've found on the net, but i get an 'unknown argument on command line' error as follows...

    unknown argument 'rootopen.txt+m yfile.xml+rootc ls.txt' on command line.

    the code i...
    See more | Go to post

  • guswebb
    replied to Mssql Iis6
    in PHP
    i did, but having gone back through them, and following the installation of MDAC 2.8, my connection now works!

    i have had to use the notation of ,1433 to stipulate the port on the MSSQL server.

    thanks for all your help....
    See more | Go to post

    Leave a comment:


  • guswebb
    replied to Mssql Iis6
    in PHP
    i did, but foolishly, and in my haste, i added this as an extra line of code near the top of the page, leaving the original line of code lower down. this meant that my custom value was being overwritten by the default.

    so...i have corrected that problem and now have a more meaningful error relating to the MSSQL connection, as follows:

    Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: MSSQLINSTANCE...
    See more | Go to post

    Leave a comment:


  • guswebb
    replied to Mssql Iis6
    in PHP
    ok. now i'm getting somewhere. i can see the phpinfo output. this shows my php.ini file to be in the C:\Windows directory and not the system32 sub-directory. i have overwritten both versions with one that contains the extension=php_m ssql.dll as loaded.

    i am still getting the error in line 7 as above.
    See more | Go to post

    Leave a comment:


  • guswebb
    replied to Mssql Iis6
    in PHP
    i have resaved the phpinfo.php file containing code exactly as you have typed it and still i get a blank page....
    See more | Go to post

    Leave a comment:


  • guswebb
    replied to Mssql Iis6
    in PHP
    and i still have the problem whereby my phpinfo.php file does not load anything other than a blank page, with no errors.

    is there something more fundamental wrong with my installation/configuration that i need to get sorted before attempting to troubleshoot the MSSQL connection issue?

    my phpinfo.php file reads...

    [PHP]<? phpinfo() ?> [/PHP]

    this renders a blank page, but from what...
    See more | Go to post

    Leave a comment:


  • guswebb
    replied to Mssql Iis6
    in PHP
    i have removed the line 8 code and also checked the extension=php_m ssql.dll entry in the php.ini file as per your PM. i changed this ini file before rebooting, but now it appeared again with a semicolon in front of the line where I had previously removed it. not sure how, maybe i didn't save it when i thought i had.

    is the php.ini file only meant to be stored in the windows/system32 folder and not in the C:\PHP install folder?...
    See more | Go to post

    Leave a comment:


  • guswebb
    replied to Mssql Iis6
    in PHP
    ok. so now i'm making a little progress. i have turned on error reporting and now have the following error:

    Parse error: syntax error, unexpected T_STRING in C:\filepath on line 10

    my entire code is as follows:

    <?php
    echo "<p>line 1</p>";

    error_reporting (E_ALL);
    ini_set('displa y_errors', True);

    $con = mssql_connect(" MSSQLINSTANCE", "administrator" ,"password")
    ...
    See more | Go to post

    Leave a comment:


  • guswebb
    started a topic Mssql Iis6
    in PHP

    Mssql Iis6

    Hi. I'm a newbie to PHP and am having a few problems as follows...

    I have installed PHP successfully on server 1 which is running IIS 6 (W2k3) and hosting multiple sites, some of which connect to MSSQL 2k (SP4) on server 2 (using ASP).

    I can load a basic 'Hellow world' PHP page hosted on server1 but when I add the code to create a simple connection to MSSQL on server 2, my PHP doesn't seem to connect nor output any of...
    See more | Go to post
No activity results to display
Show More
Working...