User Profile

Collapse

Profile Sidebar

Collapse
jwebster
jwebster
Last Activity: Sep 19 '09, 05:38 AM
Joined: Jan 15 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • jwebster
    replied to Why can't i connect to my database over the internet
    in PHP
    I have tried both. I have also tried it with no port. Nothing works so far.
    See more | Go to post

      Leave a comment:

    • jwebster
      started a topic Why can't i connect to my database over the internet
      in PHP

      Why can't i connect to my database over the internet

      i am trying to connect to SQL Server 2000 over the internet with the following code:

      Code:
      <?php
$myServer = "miawmsonline.no-ip.org,1433";
$myUser = "user";
$myPass = "pass";
$myDB = "database";

//connection to the database
$dbhandle = mssql_connect($myServer, $myUser, $myPass)
  or die("Couldn't connect to SQL Server on $myServer");
      ...
      See more | Go to post
      • jwebster
        replied to Win CE SDF Help
        in Visual Basic .NET
        Thanks

        That's a good idea, i'll try it out and see if i can come up with some way to distinguish between which table to use.
        See more | Go to post

          Leave a comment:

        • jwebster
          replied to Win CE SDF Help
          in Visual Basic .NET
          Sql

          .sdf is the database. It is a SQL Server Compact Edition database.
          See more | Go to post

            Leave a comment:

          • jwebster
            started a topic Win CE SDF Help
            in Visual Basic .NET

            Win CE SDF Help

            I have a PDA application created with VB 2008. I used SDF files for my database. Within the database i have a table that has the following fields : Lot, Part, Expiration Date, Status. The user completes information on a form ( Lot, Part) and then i have to look up that combination in the table. However, the table has between 75,000 and 100,000 records and takes approx. 6 to 12 seconds to find the correct record, and display the expiration date. This...
            See more | Go to post
            No activity results to display
            Show More
            Working...