[Mono-list] SQL# connection string

[Daniel Morgan]

From SQL#'s manpage via man sqlsharp (mono cvs) or man sqlsharpcli (mono
release 0.17)

Connection String examples:


Microsoft SQL Server via System.Data.SqlClient
or Mono.Data.TdsClient provider:

	Server=DANPC;Database=pubs;User ID=saPassword=


PostgreSQL via Mono.Data.PostgreSqlClient provider:

	host=localhost;dbname=test;user=postgres;pass=fun2db

		          or

	Server=localhost;Database=test;User ID=postgres;Password=fun2db


MySQL via Mono.Data.MySql provider:

	Server=localhost;Database=test;User ID=mysql;Password=

ODBC via System.Data.Odbc provider using
a DSN named "MSSQLDSN"	I set up
in the Windows control panel's ODBC Data Sources
which connects to Microsoft SQL Server 2000:

	DSN=MSSQLDSN;UID=myuserid;PWD=mypass


SQL Lite via Mono.Data.SqliteClient
provider which connects to the
database file SqliteTest.db; if not found,
the file is created:

	URI=file:SqliteTest.db


OLE DB via System.Data.OleDb provider
which connects to a PostgreSQL database:

	Provider=PostgreSQL;Addr=127.0.0.1;Database=rodrigo

Oracle is not mentioned in the man page since it does not work in SQL# yet
since it only has simple DML capabilities right now. Here it is anyways. The
Data Source is the Oracle TNS Name.

	Data Source=dansdb;User ID=scott;Password=tiger

-----Original Message-----
From: mono-list-admin@ximian.com [mailto:mono-list-admin@ximian.com]On
Behalf Of Markus Palme
Sent: Sunday, December 29, 2002 3:23 PM
To: mono-list@ximian.com
Subject: [Mono-list] SQL# connection string


Hi !
I want to test the SQL# tool (gtk# version).
What's the format of the connectionstring ?
Is it ADO like or something special ?

Markus



_______________________________________________
Mono-list maillist  -  Mono-list@ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list