| Why MySql isn't as good as MSDE (2 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I've been trying to migrate away from SqlServer2000 a bit because even thou I love it, and I own it from a developers point of view, it just isn't light weight enough for me. Solution: I thought, MySql, i'll give that a shot with C# see how it goes. Now MySql is great dont get me wrong, but from a Engineers point of view, it isn't full database. Its a toy database for hacking away at. Stored Proce... |
|
| reading dbf tables (6 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I have an interesting problem reading data from a dbf table I can create a dbf table in excel, save it then use odbc in .net to read it ok. I can read the same table in another (3rd party) app ok. If I change data in the table using the 3rd party app the table structure changes. Excel reads the modified table ok, the 3rd party app reads it ok but .net returns enpty objects. The problem appears to ... |
|
| SCO Vision ODBC (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have a .NET client application which is trying to connect to an Informix database via SQL Retriever 4.17 I am experiencing an error message which was supposed to have been corrected in v4.17 of the ODBC driver: 'ERROR [IM003] Specified driver could not be loaded due to system error 1114 (SCO Vision ODBC).' Does anyone have an idea of how I can overcome this issue. Thanks in advance, Chris |
|
| Reading FoxPro Date field frpm ODBC (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Ok, what is the trick!!! I am using C# to read a FoxPro DBF file. I do the following: Private DataSet getDBFData(string dbfFile) { DataSet ds new DataSet(); string Sql; int dbfNameStart dbfFile.LastIndexOf(@"\"); string dbfTableName dbfFile.Substring(dbfNameStart 1); //Define a connection string with file path as parameter string Connection "Provider MSDASQL/SQLServer ODBC;Driver {Microsoft Visual... |
|
| Use of SqlConnection with an ODBC datasource (3 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi everyone, Is it possible to use an ODBC datasource with a SqlConnection object? If we use SQL Server, we can create a SqlConnection, then drag it onto our form for use. But if we instead use an ODBC datasource, when we drag the connection onto our form, we get the following error: You cannot use an OLE DB provider for ODBC drivers. Thanks a lot, Mike |
|
| ERROR Procedure 'ABC' expects parameter '@abc', which was not supplied. (7 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| Greetings, I am getting this error when I try to populate a DataTable by executing a stored procedure on a SQL Server 2000 database through an ODBC in a VB.NET application: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'ABC' expects parameter @abc, which was not supplied. 'cmd is passed into a helper function that excutes this code conn New System.Data.Odbc.OdbcConnection(... |
|
| ADOX and C# problems (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| The following code: ADOX.Catalog mdb new ADOX.CatalogClass(); try { mdb.Create("Provider Microsoft.Jet.OLEDB.4.0;" "Data Source " mdbPath @"\" mdbName ";" "Jet OLEDB:Engine Type 5"); ADOX.Table mdbTbl new ADOX.TableClass(); mdbTbl.Name "Receivers"; mdbTbl.Columns.Append("AddressBookID", ADOX.DataTypeEnum.adDecimal,9); mdb.Tables.Append(mdbTbl); } catch(Exception ex) { Trace.WriteLine(ex.Source); T... |
|
| Creating a scaled down CRM (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello, I am creating an Outlook 2003 based CRM for my organization and would like to model the approach after Outlook BCM. Unlike BCM, this CRM will be accessible throughout my company (20 users). First, I'll be creating a MSDE SQL Database on my SBS 2003 server and then I'd like to customize an Exchange Public Folder (containing Contacts) to pull extra data from the MSDE. I will create custom for... |
|
| SQL Validation (2 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I am using the Microsoft.Data.Odbc class to submit an SQL to TeraData using the commandText property (SQL is stored in a string locally). Is there a way to perform validation on the SQL syntax prior to submission to the DB? In our environment, we submit dozens of SQL statements sequentially and I am trying to eliminate bad SQL syntax from bombing the execution. Any help is appreciated! |
|
| MySql (5 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I was wondering if Microsoft will have any classes available to connect to MySQL databases instead of just SQL. I know being Microsoft, they wouldn't want to do that, but a lot of the servers out there use MySql because it's more affordable than regular SQL server. Any comments or answers reguarding this? Also if so, when? Thanks a bunch. |
|
| Problem in connecting to FoxPro DB (3 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| (Type your message here) Hi I am trying to connect to a FoxPro db. My application is built as a C# user control in .NET. The DB is a free table directory. I created a DSN (Microsoft Visual Foxpro Driver type) on the server and linked to the folder. It created fine. But when I run my code, it gives me a 'file sample.dbf does not exist'. The file is present under the folder. I also tried a DSNLess c... |
|
| ACT! (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Has anyone successfuly read the ACT! Datafile? We are replacing ACT with an on house program and would like to migrate the data. |
|
| ODBC Driver for Pervasive (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Does anyone know if a ODBC driver for Pervasive SQL is available for .NET? Thanks |
|
| ado.net to Outlook (2 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| (Type your message here) How to connect ADO.NET to outlook ? (VB.Net code) From: yogesh lokhande Posted by a user from .Net Guru (http://www.dot-net-guru.com/) Id au9p8Yue4Umqt6mts/GC1w /Id |
|
| Intermittent Exception from System.Data (2 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I have a number of functions which read 1000 rows from AS400/DB2 tables through ODBC using ODBCDataReaders. Intermittently an error is written to the Windows Application Event Log with the source marked as System.Data and the message Invalid Handle! There is no other information. Immediately before this error is recorded an exception is encountered within one of my functions with the following inf... |
|
