SQL server does not exist or access denied - .net compact

I am developing an application for Pocket PC Mobile 2003. I am trying to
connect to a sql server with the following connection parameters in vb.net
compact framework:

Dim cn As SqlConnection
cn = New SqlConnection
cn.ConnectionString = "Data Source=192.168.1.109;database=TRAKSTAR;User
ID=TRAKSTAR ; password = warehouse"
cn.Open()

I cannot get connection to the sql server DB - I get an error of "SQL server
does not exist or access denied. Source: .net sqlclient data provider
procedure:connectionopen(connect())
I have tried the following for datasource : local , (local) ,localhost ,
adlhplaptop[server name], IP address , IP address with port (1433) and cannot
get a conenction.

I can connect from Networked PCs to the sqlserver Db both via named
instanaces and as well as by IP address alone. I have the same problem trying
to connect either from the Pocket PC device or from the Emulator. I need
some ideas on how to get this connection made.

Thanks in advance.

Badge
Wed Dec 29 19:15:02 CST 2004

I've been experiencing similar problems but no one has been able to solve it.
Check out my post, maybe your problem is not as involved. I'm not sure how to
provide a link to my posting but do a search for "SQL Server not found". Read
through the posts, I was able to get past the error "SQL server does not
exist or access denied" but now I'm stuck at the error "SQL server not
found". I went through all the suggestions the respondents sent me ... I
tried everything .. but I'm still DEAD IN THE WATER !!! Badge.


"FID" wrote:

> I am developing an application for Pocket PC Mobile 2003. I am trying to
> connect to a sql server with the following connection parameters in vb.net
> compact framework:
>
> Dim cn As SqlConnection
> cn = New SqlConnection
> cn.ConnectionString = "Data Source=192.168.1.109;database=TRAKSTAR;User
> ID=TRAKSTAR ; password = warehouse"
> cn.Open()
>
> I cannot get connection to the sql server DB - I get an error of "SQL server
> does not exist or access denied. Source: .net sqlclient data provider
> procedure:connectionopen(connect())
> I have tried the following for datasource : local , (local) ,localhost ,
> adlhplaptop[server name], IP address , IP address with port (1433) and cannot
> get a conenction.
>
> I can connect from Networked PCs to the sqlserver Db both via named
> instanaces and as well as by IP address alone. I have the same problem trying
> to connect either from the Pocket PC device or from the Emulator. I need
> some ideas on how to get this connection made.
>
> Thanks in advance.
>
>

FID
Thu Dec 30 00:35:02 CST 2004

"FID" wrote:
yes ,i know what you mean - i have been searching across the web for a
Solution. i have not seen anyone fully address the question. i amgoing to
try creatin/syncing a sql se database tommorrow instead of waiting for this
solution...i hope that goes more smoothly than direct connection to sql
servers .let me know if you get any answers.

Chris
Thu Dec 30 09:32:38 CST 2004

Sounds like an IP resolution issue. How is the device connected to the
network?

--
<ctacke/>
www.OpenNETCF.org
Your CF searches start and end here


"FID" <FID@discussions.microsoft.com> wrote in message
news:4F21873E-2A4C-45FA-A717-0D2E24F2217E@microsoft.com...
>I am developing an application for Pocket PC Mobile 2003. I am trying to
> connect to a sql server with the following connection parameters in vb.net
> compact framework:
>
> Dim cn As SqlConnection
> cn = New SqlConnection
> cn.ConnectionString = "Data Source=192.168.1.109;database=TRAKSTAR;User
> ID=TRAKSTAR ; password = warehouse"
> cn.Open()
>
> I cannot get connection to the sql server DB - I get an error of "SQL
> server
> does not exist or access denied. Source: .net sqlclient data provider
> procedure:connectionopen(connect())
> I have tried the following for datasource : local , (local) ,localhost ,
> adlhplaptop[server name], IP address , IP address with port (1433) and
> cannot
> get a conenction.
>
> I can connect from Networked PCs to the sqlserver Db both via named
> instanaces and as well as by IP address alone. I have the same problem
> trying
> to connect either from the Pocket PC device or from the Emulator. I need
> some ideas on how to get this connection made.
>
> Thanks in advance.
>
>

FID
Thu Dec 30 10:49:01 CST 2004


I have tested this with the pocket PC connected via 802.11b wireless
connection , pocket pc connected to cradle as well as through emulator (which
of course is on the PC). I can connect to the internet from poc pc when it
is connected wirelessly as well download from the PC to the pocket PC when
connected wirelessly. When using VB.net the pocket pC is connected via
wireless when I execute the vb.net code for testing.

Can anyone confirm all of the processes/installations which need to be
completed on the pocket PC and SQL server Pc for sqlcleint.sqlconnection to
work? I have set up
IIS6 Internet services to allow connecting to the SQL server via IP
address. I can connect to the SQL server DB from other PC's on the network
but not using sqlcleint by IP address.

thanks

David
Thu Dec 30 17:02:49 CST 2004

Why not ask your question in the SQL CE newsgroup?

microsoft.public.sqlserver.ce

David
------
This posting is provided "AS IS" with no warranties, and confers no rights.

"FID" <FID@discussions.microsoft.com> wrote in message
news:8FAD2B69-A83C-4DCC-AEFB-1379DB6B1183@microsoft.com...
>
> I have tested this with the pocket PC connected via 802.11b wireless
> connection , pocket pc connected to cradle as well as through emulator
(which
> of course is on the PC). I can connect to the internet from poc pc when
it
> is connected wirelessly as well download from the PC to the pocket PC when
> connected wirelessly. When using VB.net the pocket pC is connected via
> wireless when I execute the vb.net code for testing.
>
> Can anyone confirm all of the processes/installations which need to be
> completed on the pocket PC and SQL server Pc for sqlcleint.sqlconnection
to
> work? I have set up
> IIS6 Internet services to allow connecting to the SQL server via IP
> address. I can connect to the SQL server DB from other PC's on the
network
> but not using sqlcleint by IP address.

FID
Thu Dec 30 17:47:03 CST 2004


OK - I will post there as well - if anyone else has any suggestions on where
else to post it would be appreciated. I also have this question posted on
Experts exchange as well.

Rodolfo
Thu Feb 24 11:09:00 CST 2005

Hi...

I'm creating a PocketPC interface for my already built application with
SQL Server 2000 as backend... The PocketPC application connects to the
server, but then I get a SqlException when executing a reader:

string CONN = "Integrated Security=SSPI;User ID=user;Initial
catalog=test2;password=userpassword;Data Source=192.168.1.173";
SqlConnection conn = new SqlConnection(CONN);
SqlCommand comm = conn.CreateCommand();
comm.CommandType = CommandType.Text;
comm.CommandText = "select * from MyTable";
conn.Open();
// The following line throws an SqlException
SqlDataReader r = comm.ExecuteReader();
conn.Close();

This code works ok from proper .NET Framework... I've checked the server
collation (somewhere in MSDN I read that there was only 1 supported
collation for english devices...)

Have been there any advances on this?

Please, help.

Att,

RODOLFO

FID wrote:
> OK - I will post there as well - if anyone else has any suggestions on where
> else to post it would be appreciated. I also have this question posted on
> Experts exchange as well.

FID
Fri Feb 25 21:29:01 CST 2005

I still had had no answers for executing sql statmetns directly to sql server
through .net compact.

anyone who can helpout - please do.

"Rodolfo" wrote:

> Hi...
>
> I'm creating a PocketPC interface for my already built application with
> SQL Server 2000 as backend... The PocketPC application connects to the
> server, but then I get a SqlException when executing a reader:
>
> string CONN = "Integrated Security=SSPI;User ID=user;Initial
> catalog=test2;password=userpassword;Data Source=192.168.1.173";
> SqlConnection conn = new SqlConnection(CONN);
> SqlCommand comm = conn.CreateCommand();
> comm.CommandType = CommandType.Text;
> comm.CommandText = "select * from MyTable";
> conn.Open();
> // The following line throws an SqlException
> SqlDataReader r = comm.ExecuteReader();
> conn.Close();
>
> This code works ok from proper .NET Framework... I've checked the server
> collation (somewhere in MSDN I read that there was only 1 supported
> collation for english devices...)
>
> Have been there any advances on this?
>
> Please, help.
>
> Att,
>
> RODOLFO
>
> FID wrote:
> > OK - I will post there as well - if anyone else has any suggestions on where
> > else to post it would be appreciated. I also have this question posted on
> > Experts exchange as well.
>

ctacke/>
Sat Feb 26 05:31:30 CST 2005

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnroad/html/road08272002.asp

-Chris

"FID" <FID@discussions.microsoft.com> wrote in message
news:8D3BE98D-ABA0-43A8-88EC-10E5915160C9@microsoft.com...
>I still had had no answers for executing sql statmetns directly to sql
>server
> through .net compact.
>
> anyone who can helpout - please do.
>
> "Rodolfo" wrote:
>
>> Hi...
>>
>> I'm creating a PocketPC interface for my already built application with
>> SQL Server 2000 as backend... The PocketPC application connects to the
>> server, but then I get a SqlException when executing a reader:
>>
>> string CONN = "Integrated Security=SSPI;User ID=user;Initial
>> catalog=test2;password=userpassword;Data Source=192.168.1.173";
>> SqlConnection conn = new SqlConnection(CONN);
>> SqlCommand comm = conn.CreateCommand();
>> comm.CommandType = CommandType.Text;
>> comm.CommandText = "select * from MyTable";
>> conn.Open();
>> // The following line throws an SqlException
>> SqlDataReader r = comm.ExecuteReader();
>> conn.Close();
>>
>> This code works ok from proper .NET Framework... I've checked the server
>> collation (somewhere in MSDN I read that there was only 1 supported
>> collation for english devices...)
>>
>> Have been there any advances on this?
>>
>> Please, help.
>>
>> Att,
>>
>> RODOLFO
>>
>> FID wrote:
>> > OK - I will post there as well - if anyone else has any suggestions on
>> > where
>> > else to post it would be appreciated. I also have this question posted
>> > on
>> > Experts exchange as well.
>>

Jak
Mon May 30 10:51:04 CDT 2005

Hello FID, I had same problem

I tried to connect to SQL Server 2000 PC database from Pocket PC Emulator
2002 by using sqlClient connection property (in c# & VS.net 2003)

private void button1_Click(object sender, System.EventArgs e)
{
System.Data.SqlClient.SqlConnection conn;
//System.Data.SqlClient.SqlCommand coman;
try
{
inputPanel1.Enabled=false;
dataGrid1.Visible=true;
conn=new System.Data.SqlClient.SqlConnection("Data
Source="+textBox1.Text+";user
id="+textBox2.Text+";password="+textBox3.Text+";Initial
Catalog="+textBox4+";persist security info=True;packet size=4096");
System.Data.SqlClient.SqlCommand coman = new
System.Data.SqlClient.SqlCommand("Select * from Customers",conn);
System.Data.SqlClient.SqlDataAdapter da=new
System.Data.SqlClient.SqlDataAdapter(coman);
DataSet ds=new DataSet();
da.Fill(ds,"Customers");
dataGrid1.DataSource=ds;
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}

but I had the following exception "sqlexception ".
Are U found the solution!! And if yes, howâ?¦.

Are I need another prerequisites ???

PLS I want a solution as soon as possible.

Sorry for my bad English typewrite (because my language is Spanish and I
live in Dubai)


"FID" wrote:

> I am developing an application for Pocket PC Mobile 2003. I am trying to
> connect to a sql server with the following connection parameters in vb.net
> compact framework:
>
> Dim cn As SqlConnection
> cn = New SqlConnection
> cn.ConnectionString = "Data Source=192.168.1.109;database=TRAKSTAR;User
> ID=TRAKSTAR ; password = warehouse"
> cn.Open()
>
> I cannot get connection to the sql server DB - I get an error of "SQL server
> does not exist or access denied. Source: .net sqlclient data provider
> procedure:connectionopen(connect())
> I have tried the following for datasource : local , (local) ,localhost ,
> adlhplaptop[server name], IP address , IP address with port (1433) and cannot
> get a conenction.
>
> I can connect from Networked PCs to the sqlserver Db both via named
> instanaces and as well as by IP address alone. I have the same problem trying
> to connect either from the Pocket PC device or from the Emulator. I need
> some ideas on how to get this connection made.
>
> Thanks in advance.
>
>

Jak
Tue May 31 18:12:00 CDT 2005

Where R U man!!

FID
Wed Jun 01 08:20:16 CDT 2005

I think the problem I was having is I was trying to connect to sql server
MSDE desktop engine version. I recently installed SQL server standard
edition and have had no trouble connecting. Check your sql server version
and make sure you are not using MSDE. I don't think MSDE has the network
support for .net compact sql cleint connection.


"Jak" wrote:

> Where R U man!!

Jak
Sun Jun 05 10:07:13 CDT 2005

Hello FID,
Thanks a lot, thus what I wrote in my program was rightâ?¦
Are U can tell me more about MSDE??

And how I can check my SQL Server version? and are MSDE is engine?
I wait U ;)
Finally thank U very mach 4 U'r Kindness.

I want to become friends (if U want) my E-mail is jalalkharsa@care2.com


"FID" wrote:

> I think the problem I was having is I was trying to connect to sql server
> MSDE desktop engine version. I recently installed SQL server standard
> edition and have had no trouble connecting. Check your sql server version
> and make sure you are not using MSDE. I don't think MSDE has the network
> support for .net compact sql cleint connection.
>
>
> "Jak" wrote:
>
> > Where R U man!!

jalalkharsa
Mon Jun 06 10:44:06 CDT 2005

Dear FID:
Are I can install SQL server standard edition in windows XP?

"Jak" wrote:

> Hello FID,
> Thanks a lot, thus what I wrote in my program was rightâ?¦
> Are U can tell me more about MSDE??
>
> And how I can check my SQL Server version? and are MSDE is engine?
> I wait U ;)
> Finally thank U very mach 4 U'r Kindness.
>
> I want to become friends (if U want) my E-mail is jalalkharsa@care2.com
>
>
> "FID" wrote:
>
> > I think the problem I was having is I was trying to connect to sql server
> > MSDE desktop engine version. I recently installed SQL server standard
> > edition and have had no trouble connecting. Check your sql server version
> > and make sure you are not using MSDE. I don't think MSDE has the network
> > support for .net compact sql cleint connection.
> >
> >
> > "Jak" wrote:
> >
> > > Where R U man!!

FID
Fri Jun 10 10:20:05 CDT 2005


you cannot install SQL server standard edition on XP , only Windows Server
2000 or 2003. If you are currently running XP then you are using MSDE version
of SQL Server. To run on server 2000/2003 you need to purchase the standard
edition of sql server as well have a 2000/2000 server operating system
installed.