Hi All, Can anyone please help me with the following code: using System; using System.Data; using System.Data.Odbc; public class test { public static void Main(string[] Args) { OdbcConnection myConnection = null; try { myConnection = new OdbcConnection(); myConnection.Connection...
I have been charged with maintaining a legacy classic ASP application. The application uses an ODBC system DSN to connect to a MySQL database. We had to recently update the servers to satisfy some licencing requirements. We were on Windows, with MySQL 4.x and the 3.51 ODBC driver. We moved to a Linux machine running MySQL 5.1.43 and ...
Hi, This is the second time it happens to me and before modifying a 3rd party Database structure I wanted to know if anyone knew a better solution: I'm accessing a MS SQL Server 2008 from a Lotus Notes Agent (Notes 7) to retrieve some data. I use LSXODBC and my "Select" statement works perfect... Except that my agent cannot "understand...
Hello, I'm trying to store Django data on MS SQL Server 2005 using: http://code.google.com/p/django-pyodbc/ (pyodbc + FreeTDS) As long as I'm storing string consist of ASCII characters everything is ok. When I'm using unicode (ex. '\xc5\x82'), django throws ProgrammingError on: ProgrammingError at /admin/cli/punktrejestracji/add/ ('4...
Using an ODBC connection to a mysql database, the connection times-out after a period of 8 hours (the default). In order for my application to be resilient, it must recreate this connection to issue a prepared statement query. Is it possible to issue a new database connection for a prepared statement? Does it make sense to do so? It ...
I'm working on an installer that, among other things, installs a web server. As part of the setup, I'm setting up an ODBC driver and data source. I'm trying to put a bunch of utility files, including the third party ODBC driver DLL, into a certain folder, but when I run the installer, it insists on changing that directory to the SystemFo...
Hi there. I'm trying to set a connection through ODBC to an SQl Server Express 2005 instance the following connection string is working fine when I use it on the same machine Conn string: "DSN=_Vendas;TrustedSecurity = yes;"; I have an ASP.NET application that needs to use the same connection remotel, and this fails Exception: ERROR ...
Hello all, I have been successful in querying a Microsoft Access 2003 database (.mdb file) and now I am trying to do the same for a Microsft Access 2007. I have tried the following: if($type[1]=='accdb'){ echo 'accdb'; //2007 Microsoft Access $connection = odbc_connect("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=$mdbFil...
I get an "Index was outside the bounds of the array." error when I do the following. 1) I launch the Import and Export Data Wizard (32 bit). 2) Data source: .Net Framework Data Provider for Odbc. 3) I provide a connection string and DSN for a 32 bit Progress OpenEdge 10.2A ODBC driver that I've set up. 4) I set up a flat file destina...
I am designing a database in PostgreSQL on a dedicated server. I want certain complex queries to be run often, and the results to be accessible with ODBC/JDBC clients such as MS-Access or reporting software. As I see it, I have the option to either define a VIEW within PostgreSQL and import it using ODBC, or to define the query within t...
In an Access app, I've linked to MySQL tables. I have also linked to a View. A couple of the View columns have been mapped by Access as Memo, and one as OLE Object. They should be Text(255). Is there anyway that I can fix this? MTIA ...
I have the following parameter being bound for calling a SQL procedure: TCHAR str[41]; SQLINTEGER cb; SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT_OUTPUT, SQL_C_TCHAR, SQL_C_TCHAR, 40, 0, str, 0, &cb); When I loop through str after calling the query I can see the result is there, but it's not quite right: std::stringstream ss; ss<<"{";...
We are creating an x64 build of our Win32 app and I have to make our ODBC imports work. I have been searching the web but i can't seem to find any good information on what has changed and what is the best way to handle ODBC in a 64 bit app. Our current code uses classes that no longer exist like CDaoDatabase and CDaoTableDef. Can anyon...
Here's an odd situation, if I open a command prompt and start the mongrel server then everything works swimmingly. ActiveRecord talks nicely to the MSSQL server using ODBC if I have a User-DSN defined. But if remove the User-DSN and set just an identical System-DSN then odbc bombs: [Microsoft][ODBC Driver Manager] Data source name ...
Is there any way to set the default database of an ODBC DSN, using the ODBC connection string in an OdbcConnection? Edit: If I already have a DSN setup and a normal connection works. OdbcConnection connection = new OdbcConnection("DSN=TestDSN;UID=ADMIN;PWD=****;"); Is there a way I can change the default connection that is set ...
Hi there Is there anyway to get information out of an Odbc data source when you know the DSN name? example, get a user id, etc I need to open a connection to some dataSource and execute some command. The only thing I know is the data source name (DEfined in the ODBC Data Source Administrator) and the command text. Now, if I need som...
Hello all, I have mananed to use the odbc_connect like the following for access 2007 and 2003 and I can get data. But when I try to get the column names the following function will not work for access 2007 but will for acccess 2003 - why? if($type[1]=='mdb'){ $connection = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq...
I have used many SQL abstraction libraries, such as ODBC, JDBC, and ActiveRecord. What are the abstraction options in the NoSQL / key-value store world? I am mostly asking this so that if I choose a key-value store then I can use an abstraction library and not be locked in, which I think is important given the number of key value store...
I'm getting the following Error: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified The code is written as : protected void btnconnect_Click(object sender, EventArgs e) { OdbcConnection oConn = new OdbcConnection(); oConn.ConnectionString = "Provider=MSDASQL.1...
I'm using ODBC and C++ against SQL Server 2005 (native client). I have the following simple test stored procedure that returns two rows of constant values: CREATE PROCEDURE usp_testme AS BEGIN declare @details table( one int, two int, three int, four int ) insert @details SELECT 1 one, 2 two, 3 three, 4 four UNION SELECT 5, ...