Hello Bob, You are trying to use trusted connections. None of the data providers in Mono support trusted connections (Windows Authentication). When connecting, let the database server authenticate the user. A default installation of Microsoft SQL Server 2000 only does Windows authentication. You have to change this to Mixed mode or SQL Server authentication mode.
Here is a connection string for an ODBC DSN that uses SQL Server authentication to connect to a Microsoft SQL Server 7/2000: "DSN=SqlServerDsn;UID=someuser;PWD=somepass" Here is a connection string for the SqlClient data provider: "Server=MYCOMPUTERNAME;Database=pubs;User ID=someuser;Password=somepass" Make sure the SQL Server database is set to authenticate the user via SQL Server. If you want to learn more about how to get the SqlClient and ODBC data providers to use Windows or Windows Domain Authentication, try contacting the FreeTDS developers. I believe these people have found a way to connect to SQL Server with Windows Domain authentication from a non-windows machine. See http://www.freetds.org/ and subscribe to their mailing list. Daniel -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of B Johnson Sent: Saturday, December 21, 2002 9:33 AM To: [EMAIL PROTECTED] Subject: [Mono-list] Re: Mono-list digest, Vol 1 #660 - 22 msgs Hello, I was just looking at the features that are available for the ODBC Data Provider on the web site and I decided to write up some test code for "Insert", "Delete", Update". I just compiled my Insert test (Which is using an Access 200 database) and the code compiles ok with mono but the insert is not happening. I also compile this same code with CSC and the code does insert the recode ok. The OS I am using to test this is windows XP Professional. I have attached the code I used at the end of my posting. I also have a question. Is it ok to do more of this kind of ODBC testing? IS there some sort of test plan to use for these types of test? Bob J My test Code: // created on 12/21/2002 at 8:33 AM // // OdbcTest.cs - Test for the ODBC ADO.NET Provider in System.Data.Odbc // // // // // Author: // Bob Johnson <[EMAIL PROTECTED]> // using System; using System.Data; using System.Data.Odbc; namespace Test.OdbcInsertTest { class OdbcInsertTest { [STAThread] static void Main(string[] args) { OdbcConnection dbcon = new OdbcConnection(); // connection string to a Microsoft SQL Server 2000 database // that does not use a DSN //dbcon.ConnectionString = // "DRIVER={SQL Server};" + // "SERVER=(local);" + // "Trusted_connection=true;" + // "DATABASE=pubs;"; // connection string that uses a DSN. dbcon.ConnectionString = "DSN=testdb;UID=sa;PWD="; int rowsAffected; dbcon.Open(); OdbcCommand dbcmd = new OdbcCommand(); dbcmd.Connection = dbcon; dbcmd.CommandType = CommandType.Text; //dbcmd.CommandText = "SELECT LastName FROM address"; dbcmd.CommandText = "Insert into Address" + "(FirstName, LastName, Phone)" + "values ('Robert', 'Johnson', '212-111-1111')"; rowsAffected= dbcmd.ExecuteNonQuery(); Console.WriteLine ("Rows Affected: " + rowsAffected); dbcon.Close(); } } } _______________________________________________ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list
