| Distribute/deploy latest Jet 4.0 with MDAC 2.8 (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello, Problem: Trying to deploy a .Net application using ADO and MSAccess DB. But, MDAC 2.8 doesn't contain the Jet 4.0 engine. Althou I'm currently using Windows 2000, I'm using a newer version of Jet 4.0. (I checked) than the Windows XP computer that I'm deploying to. I believe this is causing the following error on the XP machine since it does'nt happen on the W2000: Oledberror: System.data.Ol... |
|
| AS400 Rollback does not work ! (5 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I had tried OLEDB (IBMDA400) with .net for Transactions. Transactions are not supported at all with OLEDB and AS400. Now I am trying ODBC.NET for transaction. Rollback does not work with ODBC.NET Can anybody help? If Transactions are not supported also in ODBC.NET , how to lock records and execute statements as a whole work? Any ideas? Please help as I had spent lot of time on this |
|
| Using Visual Basic.Net SQL Server and MSDE (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Help!!!! I have recently purchased a copy of Visual Basic.net with the intent to use it in a databaseing application with SQL Server/MSDE. I also purchased a book on how to do it and It reccomends you download the evaluation version of SQL server (See link) http://microsoft.com/sql/evaluation/trial/2000/download.asp And to use it for database management. SQL server is great, it has managed to over... |
|
| Dispose Method (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi I have this code: OdbcConnection conn new OdbcConnection("DSN myDSN;Uid myUser;pwd myPass"); conn.open(); OdbcCommand cmmd new OdbcCommand("Select * from myTable",conn); OdbcDataReader dr cmmd.ExecuteReader(); while(dr.Read()) { MessageBox.show(dr.getInt32(0)); } dr.Close(); What will the next sentences do? conn.Container.Dispose(); Does It free all the objects? Regards J.C. |
|
| About ADOX with Oracle (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I am trying to use ADOX to get the names of tables on certain Oracle Database. I did install Oracle Client first and its working fine. I made an instance from ADOX.Catalog object and I set the ActiveConnection property to : "Provider msadora;User ID xxx;Password xxx;Data Source local oracle service name " but its not working, it gives the following error: "arguments are of the wrong type, are ... |
|
| Date Formats in ODBC.Net (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Does anyone know what date formats ODBC.Net expects dates to be in? I'm used to converting dates to {d'yyyy mm dd'} in my insert and update statements. This no longer works. DateTimes required {ts'yyyy mm dd hh mm ss'}. Do you know where I look up this ODBC.Net SQL Syntax like this? Lists of ODBC functions that work under ODBC.Net would be useful as well. Thanks very much John |
|
| ODBCDataReader and multiple returns (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello, I'm trying to execute the following SQL statement on a database: SELECT Client Id, Contact Number from U EMAIL ADDRESS WHERE U EMAIL ADDRESS [rcptEmailAddress] [rcptEmailAddress] is the value that I am searching for (recipient's email address). The code below will return all matching records. Begin Code ODBCsession new OdbcConnection(dsn); ODBCsession.Open(); getCmd new OdbcCommand(sqlSelec... |
|
| Problem with Microsoft.Data.ODBC and connection pooling (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I have a data component which takes the logon details from a web app and appends them to a dsn which I use as my connection string. A connection is then opened, a small query executed, then closed. I have disabled connection pooling for the database driver in question. try { //Open odbc connection to database oOdbcConn.ConnectionString m sOdbcConnectionString; oOdbcConn.Open(); //Get back the ... |
|
| ERROR The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. (2 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I'm using ODBC DSN less connection to load an EXCEL file into a dataset. It's raising the error "ERROR [22001] [Microsoft][ODBC Excel Driver] The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data." The problem is one of the column in a excel sheet is having a data of lenght more that 260 chars. How to load an excell sheet whose cells are h... |
|
| Securing method calls on a remote object (4 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I have a remote object (which may be hosted in either IIS or a Windows Service undecided at this time) that is going to be publicly available over the web. I have several method calls on this object that I want to only be available from behind the firewall. What is the best way to do this? Thanks, Ben |
|
| "CREATE TABLE" for files *.dbf with a custom float column (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| How to create dbase file based on SQL 92 which have a FLOAT column like float(14,2): xxxxxxxxxxxxxx,xx Thanks in advance, Patrice |
|
| "Connection is dead" on ODBC insert of decimal into DB2 (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am having problems inserting Decimal values into a DB2 database via a .NET/C# application which is using an OdbcDataAdapter. Other field types such as VarChar, Int, Date, etc work ok, and I can insert literal values into a decimal field, but any attempt to insert a decimal field via an OdbcParameter causes a System.InvalidOperationException ("The connection is dead") to be thrown by the DbDataAd... |
|
| System.Data.OracleClient Problem: Not closing open connection (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, Could any one tell me what is the latest version of System.Data.OracleClient? Currently I'm using version 1.0.1012.0 in my project which is giving problem of not closing connection eventough I'm issuing connection Close() statement.I am trying to connect Oracle 8i from ASP.NET framwork 1.1 in my application. Initially I tried to put Connection Lifetime property to 60 seconds, when the applicat... |
|
| ODBC Connection Pooling with ADO.NET and Oracle RDB (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi! I believe I am not getting ODBC connection pooling in ADO.NET to work correctly. I am connecting to an Oracle RDB database with Oracle RDB ODBC driver 3.1.0.0. With a test project in VB6 I start out with this call to enable pooling on the ODBC level. SQLSetEnvAttr(0&,SQL ATTR CONNECTION POOLING,SQL CP ONE PER DRIVER,SQL IS IN TEGER) This enables connection pooling at driver level (one pool per... |
|
