how to set progress openedge driver name for odbc connection c#
C#
DSN-less Connection String:
DRIVER=<ODBC Driver Name>;HOST=<Hostname>;PORT=<Port>;DB=<Database Name>;UID=<Username>;PWD=<Password>;DIL=<DEFAULT ISOLATION LEVEL>
ODBC Driver Name
The name of the ODBC driver as it appears in Drivers tab of the Microsoft ODBC Data Source Administrator or in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INIusing System;
using System.Data;
using System.Data.Odbc;
public class TestConnect
{
public static void Main(string[] args)
{
//The connection string assumes there is a DSN named sports for a Progress database.
//Alternatively, a DSN-less connection string could be used in its place. See article# 000022406 for more details.
string connectionString = "DSN=sports;" +
"UID=sysprogress;" +
"PWD=x";
IDbConnection dbconn;
dbconn = new OdbcConnection(connectionString);
dbconn.Open();
IDbCommand dbcmd = dbconn.CreateCommand();
string sqlstr = "SELECT country,name FROM pub.customer";
dbcmd.CommandText = sqlstr;
IDataReader reader = dbcmd.ExecuteReader();
while(reader.Read()) {
string country = (string) reader["country"];
string name = (string) reader["name"];
Console.WriteLine("Customer : " + name + " country is: " + country );
}
reader.Close();
reader = null;
dbcmd.Dispose();
dbcmd = null;
dbconn.Close();
dbconn = null;
}
}
Also in C#:
- Title
- format string to date only c#
- Category
- C#
- Title
- c# directories loop
- Category
- C#
- Title
- .net core session
- Category
- C#
- Title
- unity remove gameobject
- Category
- C#
- Title
- sum the digits in c#
- Category
- C#
- Title
- c# move with arrow keys
- Category
- C#
- Title
- usermanager change password without current password
- Category
- C#
- Title
- generate a dropdown list from array data using razor .net mvc
- Category
- C#
- Title
- c# get desktop path
- Category
- C#
- Title
- how to cast list to observablecollection c#
- Category
- C#
- Title
- c# change label forecolor code
- Category
- C#
- Title
- c# ref
- Category
- C#
- Title
- unity making homing missile
- Category
- C#
- Title
- console application in c# ms crm
- Category
- C#
- Title
- add row count devepxress report
- Category
- C#
- Title
- how to add object in dictionary in c#
- Category
- C#
- Title
- ignore fakeiteasy
- Category
- C#
- Title
- while loop in c#
- Category
- C#
- Title
- c# check if string is all numbers
- Category
- C#
- Title
- c# winform remove button border
- Category
- C#
- Title
- how to get array of children transform
- Category
- C#
- Title
- sum of digits in c#
- Category
- C#
- Title
- create dropdown in datatable c# dynamically
- Category
- C#
- Title
- Globalization and localization in ASP.NET Core
- Category
- C#
- Title
- dynamically add rows to datagridview c#
- Category
- C#
- Title
- open udp socket c#
- Category
- C#
- Title
- how to see a tag of what you hit with raycast
- Category
- C#
- Title
- visual studio C# hintergrund bild ändern
- Category
- C#
- Title
- c# set textbox text
- Category
- C#
- Title
- modal dismiss
- Category
- C#
- Title
- see if two string arrays are equal c#
- Category
- C#
- Title
- Request.Form
- Category
- C#
- Title
- c# LCP
- Category
- C#
- Title
- check if multiple variables are null c#
- Category
- C#
- Title
- c# resize image keep aspect ratio
- Category
- C#
- Title
- c# catch two exceptions in one block
- Category
- C#
- Title
- c# object list attribute to string
- Category
- C#
- Title
- How to make a function in C#
- Category
- C#
- Title
- c# index in select
- Category
- C#
- Title
- c# windows application get current path
- Category
- C#
- Title
- inheritance c#
- Category
- C#
- Title
- split on uppercase c#
- Category
- C#
- Title
- how to add a gameobject
- Category
- C#
- Title
- split string
- Category
- C#
- Title
- pop up element from specific index in array
- Category
- C#
- Title
- leantween move ui
- Category
- C#
- Title
- c# two dimensional array
- Category
- C#
- Title
- how to draw a dot in c#
- Category
- C#
- Title
- c# add object to array
- Category
- C#
- Title
- c# check if string is only letters and numbers
- Category
- C#
- Title
- c# push numbers to array
- Category
- C#
- Title
- variables
- Category
- C#
- Title
- unity cycle children
- Category
- C#
- Title
- cursorlockmode cannot be used as a method C#
- Category
- C#
- Title
- add row and columns to grid wpf in code
- Category
- C#
- Title
- cannot convert string to generic type c#
- Category
- C#
- Title
- find gameobject with tag
- Category
- C#
- Title
- C# webclient immitate browser
- Category
- C#
- Title
- c# build string out of list of strings
- Category
- C#
- Title
- unity get child
- Category
- C#
- Title
- if a method doesnt rutern a value, what shouyld i reeturn c#
- Category
- C#
- Title
- how to trim path in C#
- Category
- C#
- Title
- .net core cli
- Category
- C#
- Title
- unity set sprite transparency
- Category
- C#
- Title
- assign datasource to dropdownlist in c#
- Category
- C#
- Title
- change sprite of gameobject unity
- Category
- C#
- Title
- how to remove space between string in c#
- Category
- C#
- Title
- when do i need to end a sentence with ; in c#
- Category
- C#
- Title
- max of array C#
- Category
- C#
- Title
- parsing string to int without format exception c#
- Category
- C#
- Title
- attribute usage c#
- Category
- C#
- Title
- c# use hashtable check if key exists
- Category
- C#
- Title
- c# Sleep
- Category
- C#
- Title
- C# sprint key
- Category
- C#
- Title
- check if string is email c#
- Category
- C#
- Title
- unity how to check object position
- Category
- C#
- Title
- c# get country code
- Category
- C#
- Title
- class selector to property in asp net core dropdown
- Category
- C#
- Title
- c# get all inherited classes of a class
- Category
- C#
- Title
- c# access session in class
- Category
- C#
- Title
- unity rotate around point
- Category
- C#
- Title
- c# print to console
- Category
- C#
- Title
- unity up arrow input
- Category
- C#
- Title
- unity make a int arry with preset values
- Category
- C#
- Title
- c# query string builder
- Category
- C#
- Title
- how to add array to list in c#
- Category
- C#
- Title
- c# Authorization has been denied for this request
- Category
- C#
- Title
- unity how to get transform scale
- Category
- C#
- Title
- compose graphql query string in c#
- Category
- C#
- Title
- c# merge two lists as queryable
- Category
- C#
- Title
- c# discord bot
- Category
- C#
- Title
- check if current time is in the morning c#
- Category
- C#
- Title
- dto and automapper
- Category
- C#
- Title
- asp list box
- Category
- C#
- Title
- c sharp create dictionary
- Category
- C#
- Title
- Instantiate c#
- Category
- C#
- Title
- unity how to change max fps
- Category
- C#
- Title
- exit game unity
- Category
- C#
- Title
- what is type unity
- Category
- C#
- Title
- c# get pc ip address
- Category
- C#