| You cannot use an OLE DB provider for ODBC drivers. (5 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I can create a data connection in the Server Explorer to MySQL databases, using the "Microsoft OLE DB Provider for ODBC Drivers" and have installed ODBC.NET. Test Connection verifies the ability to connect. I cannot see my databases using any other providers. Things get weird here, and all I want to do is use VB.NET with MySQL. 1) If I drag a database or table from the Server Explorer to a web for... |
|
| Connections and Commands (4 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I am creating a model for generic connections and commands, and at this level there doesnt seem any difference between a command wether its oracle, odbc, oledb or sql, can I just use the idb interfaces directly to access varying clients rather than accomadate all the client types. for example i just want the user to type a connection string and an sql statement and not worry wether it is oracle, o... |
|
| fail to connect informix by odbc.net, but i can do it through ado (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| a strange question, i can connect the informix database in visual basic 6.0, the driver is informix cli 2.5, ado 2.6. but i can't connect by odbc.net, the same db server, the same odbc driver, so much as i can't connect by ado, not ado.net in vs.net, but i can see the data in server explorer. if i update the informix client to 2.8X. the problem disappear. unfortunately i can't update the client fo... |
|
| Sybase 10 & .net & ODBC (3 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi all folks I have the next problem: I made an application in .net, it is C#, which the main objective is to execute several stored procedures at the same time, and it works. But i had proof this application with a stored procedure which inserted about 40000 registers, and it worked. So i decided run the application with the real application which it has to work, and it fails, it raises an error;... |
|
| Connections (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi I'm testing the connection's states to check if my application has to reconnect again and I'm in doubt because when I restart the server or stop DB's service my connection keeps open. What does it happen?? I suppose that my connection would be broken or closed. Regards |
|
| ODBC access to Oracle error (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello I'm using MS ODBC for Oracle DSN to access Oracle database. I have Oracle Client 9i Administrator installed. Connection works from desktop vb.NET application. The problem appears when I try to connect from .NET webService I obtain the following error: "ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL HANDLE ENV failed" and messagebox: "The Oracle(tm) client and n... |
|
| SQL Server Desktop Installation (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I recently bought a copy of Visual C#.NET Deluxe Learning addition. I was under the impression that this comes with SQL Server Desktop Engine. I installed everything I should have (I think), but when I type the commands to grant access to SQL at the DOS prompt, it tells me that SQL Server doesn't exist. The actual error message reads as follows: [DBMSLCPN]SQL Server does not exist or access denied... |
|
| FoxPro OleDb (and ODBC) Problem on Windows 2003 (2 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I cannot use neither UPDATE nor INSERT commands in ASP.NET (on Windows 2003 !!!!) application which use FoxPro database. When I try update table, then I get error: "Cannot update the cursor. Table table since it is read only" But it isn't true. Win32 application successfuly wrote into Fox DB. I tried MS example which is described in title: "Using ASP.NET in Visual Studio .NET with Visual FoxPro 7.... |
|
| get list of System DSN:s? (3 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I'd like to show my users a list of available system/user DSN:s, how do I do that? ( VS 2003, C# ) Best regards. Lazze |
|
| Interbase and ODBC.NET (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello, I installed the ODBC.NET here http://www.microsoft.com/downloads/details.aspx?FamilyId 6CCD8427 1017 4F33 A062 D165078E32B1&displaylang en When I want to create the ODBC connection (Administrative Tools ODBC) I don't see it int the driver list. This provider works with interbase ? Is there another provider to use Interbase 7.1 with C# (Visual Studio 2003) Thanks, |
|
| NotesSQL Connection Problems (6 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| My VB.Net code ... Dim strConnString As String "Driver {Lotus NotesSQL Driver (*.nsf)}; Server IRIS;Database mail\tdodds.nsf;Uid tdodds;Pwd NTTCcon1" Dim connNotes As New OdbcConnection(strConnString) When I run the connNotes.Open() I get the following error: ERROR [IM005] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL HANDLE DBC failed ERROR [01000] [Microsoft][ODBC Driver Manage... |
|
| ODBC Drivers for ObjectStore (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I'm looking for ODBC drivers for ObjectStore OO database Someone knows where I can find it? In the site of www.objectstore.net there is reference to MSDN, however I can not find it here Please assist |
|
| ODBC Security Problem (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| SECURITY PROBLEM I DON'T UNDERSTAND HOW TO FIX. dbaseToXml.exe ... .net application Reads a dbase IV table, and then converts it to XML, using the .net odbc stuff. Works fine if both the dbase tables and the dbaseToXml.exe are on the local computer. But doesn't work if the dbase tables and the dbaseToXml.exe are on a Mapped K: drive on another computer i.e. This works: Computer1 calls.... C:\myapp... |
|
| Disposing of connections (6 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| Our RDB database is running out of connections so I have inserted a finalizer and implement IDisposable in a data layer class to dispose of all ODBC data connections. These seems to fix the problem the connections correctly drop. HOWEVER, on testing, every 2nd time the dispose code executes, I get an exception from the ODBCConnection.Dispose method: The handle is not initialized. Anyone got any id... |
|
| Web Forms and MS Access (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi: Does anyone know if the VS .NET 2003 DataGrid Web Form control can be used with MS Access? The following code works (the DataGrid is filled with data) when the DataGrid control is a Windows form: Private Sub Form1 Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim con As New OdbcConnection("dsn SetiSpy Database;uid sa;pwd ;") Dim sql As String "SELECT [Date], Res... |
|
| dBASE webservice (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I'm trying to access a dBASE database from my webservice. When debugging the webservice in my browser (on the server) everything works perfectly. However when I try to use the webservice from my console application, I don't seem to have sufficient rights to create a lock file, hence this error: Unhandled Exception: System.Web.Services.Protocols.SoapException: System.Web.Ser vices.Protocols.Soa... |
|
| parameter output (3 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I have an stored procedure which has an OUTPUT parameter, how can i get it, it has to be through a DataReader or something like that???? or when i call it??? can you give me an example??? Any help will be welcome, thanX!!!! Regards... |
|
| Could not find installable ISAM (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am trying to open a Excel spreadsheet with the following code: Dim strConn As String "Provider Microsoft.Jet.OleDb.4.0;" & "datasource C:\Inetpub\wwwroot\Metrolina\Data\Metrolinatest.xls;" & "Extended Properties Excel 8.0;" Dim objConn As New OleDbConnection(strConn) objConn.Open() but recieve "Could not find installable ISAM" I am testing on XP Professional using Excel 2003 spreadsheet. Any hel... |
|
| Generic Connection String (5 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I need to present the user with a list of Tables from a database. After they have selected the table I need to present them with a list of Fields. After they select the Fields they require, I need to use an ODBCDataReader to retrieve the Data. It NEEDS to be an ODBCDataReader. I cannot find a way of retrieving the list of Tables using the ODBC.NET data provider. (Is there a way ?) I can get a ... |
|
| Visual Basic .NET Standard & SQL Server (5 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I am trying to develop a web application with connectivity to a SQL server but when I proceed thru the SqlDataAdapter wizard, even thought I am able to sucessfully configure the ODBC connector, I receive an error suggesting this version of Visual Studio is only compatible with MSDE or Access database files. Does anyone know if this is true? Is it the VB .NET Professional version I would need for S... |
|
| OdbcDataReader works on winXP, not on 2000 (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I've got a program which works on a Windows XP Pro machine, but fails on a Windows 2000 Server machine. This matters for me, since I'd like to be able to develop on a different computer than the production machine. As far as I can tell, the .Net and ODBC stuff is identical (or as identical as I can make it) on both systems. Using Microsoft.Data.Odbc, the OdbcDataReader seems to cough and die when ... |
|
| output parameter problem (7 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| When I try to execute a command using ODBC.net provider, it gives the following error: {"ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '('." } Code: OdbcConnection conn new OdbcConnection("DSN ..."); conn.Open(); OdbcCommand cmd new OdbcCommand("insert into tblUser (username,password) values(?,?) set ? SCOPE IDENTITY()",conn); OdbcParameter [] arParms n... |
|
| Trusted SQL Server connection (9 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I am able to preview this data in the development environment, but when I run the application the error below shows up. How do I set up a Trusted Connection? Ray Server Error in '/WebApplication2' Application. Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Description: An unhandled exception occurred during the execution of the current web request. Ple... |
|
| Error using MS-Access/Webservice/ODBC and Insert/Update/Delete statement (2 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| Folks. We are trying to connect to an Access DB using Webservice on ODBC. When used without the Webservice, everything seems fine and all insert statements work. But when we use webservice, the error is like "Use an updatable statement instead of insert....." We are on .NET Framework 1.0.x, VB.NET and ODBC drivers for Access 3.52. We are trying to support database independent application s/w. The ... |
|
| List of Tables in Database? (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Is there any way to access the list of tables that are available via a particular ODBC connection? Bruce |
|
