PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEVWEBDEV e WINDEV Mobile

Inicio → WINDEV 2024 → Connecting to a SQL Server (Native access) database using a Connection String
Connecting to a SQL Server (Native access) database using a Connection String
Iniciado por Mark, jan., 03 2019 10:37 PM - 3 respostas
Publicado em janeiro, 03 2019 - 10:37 PM
I have a MS SQL Server database that I need to open using a valid C# connection string. Is there a way to open the connection using the provided connection string? I want to be able to use the provided connection string directly without having to parse it to get the Server, Database and other information needed to describe a "connection" to be used in the "HConnect" functions.

Thanks,
Mark
Publicado em janeiro, 24 2019 - 3:37 AM
Show us the connection string?
Publicado em janeiro, 24 2019 - 3:39 AM
Show us the connection string you have and we can tell you the answer?
Publicado em abril, 17 2019 - 8:45 PM
Using the .NET Framework Data Provider for SQL Server


Standard Security:
Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;

Trusted Connection:
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

Conenction to a SQL Server instance:
Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword;