Connecting to SQL Server
-
Hi, i'm developing a Pocket PC Application. I am working on security issues, so i was wondering if there is any way to modify the connection string: adding the ip of the server instead of the server name. The application is working with this string:
String RDAOleBDConnectionString = "Provider=SQLOLEDB;Data Source=" + NombreServidor + "," + Puerto + ";Integrated Security=SSPI;Initial Catalog =" + NombreBD + ";";
to something like this:
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
i tried to use the last one but i got errors about the provider. thanks for any help
-
Hi, i'm developing a Pocket PC Application. I am working on security issues, so i was wondering if there is any way to modify the connection string: adding the ip of the server instead of the server name. The application is working with this string:
String RDAOleBDConnectionString = "Provider=SQLOLEDB;Data Source=" + NombreServidor + "," + Puerto + ";Integrated Security=SSPI;Initial Catalog =" + NombreBD + ";";
to something like this:
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
i tried to use the last one but i got errors about the provider. thanks for any help