connect ppc to SQL Server 2000 using web services

Similar Threads:

1.using Membership on production server (Copy Web Site tool) - Used to SQL Server 2000 enterprise edition

Hi!

I read a lot about that and I still cannot figure it out.  So.  I'd like to
use membership into an web application that will run on a production
server(s).  On my dev machine, using Web dev Xpress 2008 and SQL Server
Xpress 2008, all is well.  My Aspnetdb.mdf is running fine in my App_data
directory.

When I use the copy website utility to transfer all this on a "test"
production server and try to login or anything, I'm getting the predictable
"Failed to generate a user instance of SQL Server due to a failure in
starting the process for the user instance."

Now, my "test" prod server runs .NET 3.5, IIS 6, SQL server 2000 (Std
Edition) and SQL server Xpress 2008.  I could install SQL 2008 Standard if
necessary but for now we were delaying this.  I could do the same on real
prod servers when ready.

I have many questions :

1) What do I need to have and to configure on my prod server (SQL Server 
2008 XPress or 2000 Standard or anything else) to use Membership with 
Aspnetdb.mdf in a App_data directory ?

2) Is it possible to use many concurrent secure Web app on a production
server, using separate membership structure based on separate Aspnetdb.mdf 
in
each App_data directory of each app?

3) Do I have to use SSL connection to keep secure "Username /Password" use
during login ?

4) Is it a good rule to use the App_data for other application databases
(Inventory, parts catalog, orders and financial data, ...) and how to 
connect
safely their use with the Role/membership structure ?

4) Is it possible/suitable to have a "mixed model", using Windows
Authentification to get in the app zone, login in (to identify more 
precisely
the user) afterward ?  And why is it or is not a good way to go ...

Thanks anyway and have a good day !

-- 
"Who's on first ..." 

2.Problem in Connecting to my desktop SQL Server 2000 from Pocket PC 2000

Hi,

I am trying to connect SQL Server 2000 from Pocket PC emulator using
"Smart Device Applications".

I am keep getting the error "SQL Server does not exist or access denied
"

code snippet as follows

SqlConnection consql2000 = new SqlConnection("User
ID=sa;Password=xxxx;Initial Catalog=DotNetCF;Data Source=taknev;");

SqlCommand cmd = new SqlCommand("SELECT * FROM test", consql2000);
SqlDataReader dr;
try
{
consql2000.Open();
dr = cmd.ExecuteReader();
while (dr.Read())
{
listBox1.Items.Add(dr.GetString(1));
}
dr.Close();
consql2000.Close();
}
catch (SqlException ex)
{
	MessageBox.Show(ex.Message);
}

Any help??? Thanks in advance

-Venki

3.Unable to Connect To Sql Server 2000 using .NET 2005 EXPRESS

Can anyone help me with an issue. I have a .net app that tries to connect to 
my sql server here on my laptop on my company's network. When I have someone 
on the network try the app they get the following message in the errorlog:
*Timeout expired.  The timeout period elapsed prior to completion of the 
operation or the server is not responding*

I tried connecting through IP and machine name but no success. My Sql Server 
agent and Sql Server is running. I can access the data fine locally of 
course. Here is the connection string:

private string connstring = "pwd=<password>;uid=<username>;" +
            "database=projectMgr;server=<machinename>";

Here is what I'm using when the user tries to login:

  cmd.CommandType = CommandType.Text;
                cmd.Connection = sconn;
                cmd.CommandText = "SELECT username, upassword, rights FROM " +
                    "usertable WHERE username = @username AND upassword = 
@upassword";
                cmd.CommandTimeout = 30000;
            
                SqlParameter sparam = new SqlParameter(); 
                sparam = cmd.Parameters.AddWithValue("@username", user);
                sparam.DbType = DbType.String;
                sparam.Direction = ParameterDirection.Input;

                sparam = cmd.Parameters.AddWithValue("@upassword", upassword);
                sparam.DbType = DbType.String;
                sparam.Direction = ParameterDirection.Input;
                sconn.Open();
 
                mAdapter.SelectCommand = cmd;
                mAdapter.Fill(myDataTable);

                if (myDataTable.Rows.Count > 0)
                {
                    mFlag = true;
                    appObject.uClass.urights = 
myDataTable.Rows[0]["rights"].ToString();
                }
                else
                {
                    mFlag = false;
                }

I using the timeout method but it's not helping.
-- 
TC

4.Connect directly to SQL server 2000 using VB 2005

Anyone tell me how can I do in VB 2005 to connect directly my PDA with a SQL
server 2000 (connection string).

I have my aplication in VB2003 an work fine, but whem I have migrate to VB
2005 I have the error:

"SQL Server does not existe or acess denied"

5.fail to connect to sql server 2000 using emulator 4.2

hi:
   i use the VS2003, WinCE Emulator4.2 , IIS, SQL Server 2000
   IIS security used the anonymous login.


   My code is :
   DBPath =  shellui.sqlcewrapper.LocalDatabase;
   lconnstr = "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=" +
DBPath + "; Password = 123;";

   //Create replication object and initialize it
   SqlCeReplication sscerepl = new SqlCeReplication();
   sscerepl.InternetUrl=URL.Text;     //URL of the server agent
   sscerepl.InternetPassword = "liuwenhua";     //credentials for the IIS
directory where the server agent resides
   sscerepl.InternetLogin ="IUSR_CPULICHWEILIU";
   sscerepl.Publisher=SQLServer.Text;    //publisher
   sscerepl.Publication = "contact";   //name of the publication
   sscerepl.PublisherDatabase = "truetel";   //name of the published DB
   sscerepl.PublisherLogin = user.Text;   //credentials for the DB/PAL
(publication access list)on server
   sscerepl.PublisherPassword =password.Text;
   sscerepl.Subscriber = "SQLCE_Client";  //name of the client device
(optional)
   sscerepl.SubscriberConnectionString = lconnstr; //conn string for the
local SQLCE DB
   sscerepl.AddSubscription(AddOption.CreateDatabase);


   the return error code is:
    native error: 28037
    message: a request to send data to the computer running IIS has fialed.
    for more information, see HRESULT.[,,,,,]
    Source:Microsoft SQL Server 2000 Windows CE Edition

6. connect to SQL Server using PPC

7. Web Services on Win 2003 to SQL Server on Win 2000

8. ado.net unable to connect from Windows 2000 after SQL server Resta