Advanced Search

Results 1 to 4 of 4

Thread: mssql_connect question

  1. #1
    Join Date
    Feb 2009
    Posts
    6
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Question mssql_connect question

    I have mysql ver 3.23 with PHP 4.2.3 and want to connect to a MS SQL 2008 database. Can this be done without downloading 2008 client tools from MS? Having a hard time here. Thanks, anyone!

  2. #2
    Join Date
    Feb 2009
    Posts
    156
    Thanks
    0
    Thanked 4 Times in 3 Posts

    Default

    give more detail

  3. #3
    Join Date
    Feb 2009
    Posts
    6
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default

    When I do this:

    $server="q:/directory/data,3306";
    $con=mssql_connect($server,$username,$password) or die (NOPE);

    I get this error:

    Fatal error: Call to undefined function: mssql_connect() in c:\phpdev\www\worker.php on line 9

    When I do this:

    $server="q:/directory/data,3306";
    $con=odbc_connect($server,$username,$password) or die (NOPE);

    I get this error:

    Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in c:\phpdev\www\worker.php on line 9
    NOPE

    Any ideas??

  4. #4
    Join Date
    Mar 2006
    Location
    Illinois, USA
    Posts
    12,154
    Thanks
    260
    Thanked 690 Times in 678 Posts

    Default

    Are you using MySQL or MSSQL? You wrote both in your first post, and that is important.
    Daniel - Freelance Web Design | <?php?> | <html>| espa˝ol | Deutsch | italiano | portuguŕs | catalÓ | un peu de franšais | some knowledge of several other languages: I can sometimes help translate here on DD | Linguistics Forum

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •