Connection to SQL server?

[Tomer]

I'm trying to connect to a sql server using this code:
Conn = new SqlConnection("Data Source=192.168.223.52; user id=sa;
password=sa; initial catalog=DBTest;Connect Timeout=30");
Conn.Open();

Also tried:
Conn = new SqlConnection("Server=P1000; user id=sa; password=sa; initial
catalog=DBTest");

but I always get the same exception:
'PlatformNotSupportedException'

I use symbol 8100/2846/mc9050 and the emulator. same result.

what to do?


Tomer

 

[Guest]

Add a reference to System.Data.SQLClient then try the followin

Dim oConn as new SQLClient.SQLConnectio

oConn.ConnectionString = "packet size=4096;user id=sa;password=sa;data source=192.168.223.52;persist security info=False;initial catalog=DBTest;Connect Timeout=30;

oConn.Open(

I use this to connect to to SQL2000 works just fine