| Using the Desktop Engine (4 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I'm attempting to use MS Access with .NET but am not having much luck, so I've decided maybe I should just use the SQL Server Desktop Engine. Is there any way to import my tables from Access into the Desktop Engine? |
|
| Oracle using ASP.NET (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi All Can anyone help me with the following problem: I am trying to log onto an Oracle 8.0.5 database using ASP.NET running Oracle 8.1.7 Client. The application don't seem to find the created System DNS. Can anyone please HELP. I can connect to the DB using the Client with no problems. Thanks |
|
| Updating Access table through OleDb works but Odbc give Concurrency Violation error?! (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I developed a web site using the OleDb namespace, but I need to use an DSN on the production web server and thus must convert the app to use Odbc namespace. I have done this and all works find except for updating one table. The following code example demonstrates the situation exactly. In the code below example setting iTestCase to 0 results in "Success" being outputted. Setting it to non zero res... |
|
| ODBC Text Driver question (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I found a doc saying that the ODBC text driver doesn't support insert/update/delete, etc. Is this accurate for the latest version of the ..NET framework? The text driver is basically a read only implementation then? http://support.microsoft.com/default.aspx?scid http://support.microsoft.com:80/support/kb/articles/Q178/7/17.ASP&NoWebContent 1 Thanks in advance! Derrick |
|
| data types not supported (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I'm trying to get data from an NCR Teradata Database but OdbcDataReader won't accept columns that are of INTERVAL data type. I get an "Unknown SQL Type 101" error when trying to read INTERVAL values. Does anyone know of a way to read non CLR data types using the OdbcDataReader? Can the DataReader be forced to read a value as a string for example? |
|
| UniData & ODBC & VB (.net or VB6) (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Has anyone had any experience with the UniData ODBC Client? I'm just getting started and having trouble calling a UniData Basic program from VB. I'm getting the following error: "ERROR [42000] [Ardent][UniData ODBC Driver][Informix][SQL Client][UNIDATA] MY.PROGRAM.NAME; Syntax error" Any ideas??? TIA! Bryan Dickerson |
|
| Too Few Parameters Error calling query stored in Access Database (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am calling a query stored in Access that requires a parameter. But the parameter that I am passing in as part of the command does not seem to be being recognized. I have two queries in an Access database. They are: SELECT [tblEventParticipants].[EventID], [tblEventParticipants].[MemberID], [tblEventParticipants].[InterestLevelID] FROM tblEventParticipants WHERE ((([tblEventParticipants].[MemberI... |
|
| ODBC DataReader - dBase IV (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hey, I've been working for the last few days on changing over a system from SQL Server to dBase IV (don't ask :0) ). Everything seems to be going well, except whenever I use the ODBCDataReader, specifically use the ODBCDataReader.Item( fieldName ) overload, I get an OutOfRangeException. I tried using the .Item(int) overload, and I get the fields, but of course, they are in the order they exist in ... |
|
| Using Access with C#.NET (4 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I'm tyring to use MS Access with .NET, but I'm having some problems. Here's the code: string sSQL "SELECT Statement Id,Statement In Brief FROM Statements"; OleDbDataAdapter thisAdapter new OleDbDataAdapter(sSQL,oleDbConnection1); DataSet thisDataset new DataSet(); thisAdapter.Fill(thisDataset,"Statements"); It bombs on the 4th line. I get the error message, " The Microsoft Jet database engine cann... |
|
| Driver's SQLSetConnectAttr failed ERROR (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi all, I try to migrate an application ASP to ASP.NET(C#). This application get data from a SAGE database located on a server. I test my ODBC connection everything work fine, and in ASP no problem. But in ASP.NET I've got the following error : ERROR [S1000] [Simba][Simba ODBC Driver][CBase]Erreur inconnue ! ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [01... |
|
| How to get tables and index information from an Odbc provider (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I need to retrieve schema information from an Odbc provider basically I need to know which tables are available and what the indexes are on those tables. I need a method that works across SQL Server, Oracle, Text, etc. I'm converting C code that uses the native Odbc libraries but I can't figure out how to do the same thing via .NET's Odbc driver. The only thing I can think of to do at this point i... |
|
| CurrentUser function from access doesn't work in VB (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am trying to access an Access query that uses the CurrentUser function from VB. The query runs fine in Access but gives me a Undefined Function error in VB. Anybody struck this before? Steve |
|
| Jet Won't Open (5 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I get the following error when I write any code against a connection that is hooked to an Access database: The Microsoft Jet database engine cannot open the file 'C:\Inetpub\wwwroot\TimeTracker\Data\TimeTracker.mdb'. It is already opened exclusively by another user, or you need permission to view its data. Does anyone have any idea what to do about this? |
|
