Hello, I have an MS-Access database, which I am connecting to in Java using the JDBC (I think the JDBC-ODBC bridge). My access database has some values which are in hebrew. When I try to read these values using String str = rs.getString(1) (rs is a RowSet), the string I get is just a string of question marks. I have other strings in h...
Hi, I am thinking about adding ODBC database connectivity to an application. The user will at runtime configure and select their database odbc connection. Are there any components that will give me the required series of dialogs ? Allowing the user to select the data source type, select drivers, browse already defined ODBC connect...
I've tried the following: >>> import pyodbc >>> cnxn = pyodbc.connect(Driver="MDB", database="SohabeD51.mdb") pyodbc.Error: ('08001', '[08001] [unixODBC]Could not find DSN in connect string (1) (SQLDriverConnectW)') Connecting to a database using a DSN entry works fine, but I'd like to supply a database in the code. ...
Hi, I have an application where I am doing connection with .mdb file. Here are the steps we are following : Creating object for database utils inteface Calling the connect() function, to get connected to the database whose extension is .mdb file Above flow is working correct on all windows platform but not on windows server 2008 CO...
I have a data source on a Windows machine that supports an ODBC connection. I want to programmatically copy that entire data source to a MySql database every hour. Is there something faster than doing a select * from and then doing an insert for each row? ...
After finding a pretty nasty bug in the packaged 3.51.15 driver that came with ubuntu I downloaded and compiled the latest version from mysql's site. Now im wondering how I can find out what version isql is actually using. ...
I need to select some values from an Informix database via Oracle ODBC. One of the columns is a timestamp, and when I just select it all I see in SQL*Plus is the date value. How do I get the time as well? ...
Hi all, I am working on a project where I need to extract data from a MSSQL database table, and then insert the data into a table of the same structure on an AS400. The SqlBulkCopy would be the ideal candidate for this operation, but fails (understandably) because the AS400 uses an ODBC connection. Any help or suggestions on this woul...
I am looking for advice. I know stackoverflow likes "answerable" questions, I hope this is. I have a large legacy (Windows) application, using a proprietary (ISAM) database. I wish to investigate moving it over to using a SQL database: primarily MS SQL Server, I wouldn't mind Oracle flexibility but that is only a "would be nice", and ...
Please help me, I don't know what can be wrong with the following code: OdbcConnection conn = new OdbcConnection(connString); String query = "INSERT INTO customer (custId, custName, custPass, "+ "custEmail, custAddress, custAge) VALUES (" + "@ID, @Name, @Pass, @Email, @Addres...
I found: http://stackoverflow.com/questions/307636/how-do-you-setup-a-linked-server-to-an-oracle-database-on-sql-2000-2005 The DSN tested successfully but after using the stored procedures outlined in the article to create the linked server the 'open query' returned the following message: OLE DB provider "MSDASQL" for linked server "...
I have been trying to get ruby 1.8.6 to connect to a MS SQL Server 2005 on Mac OS X snow leopard following the guide here http://wiki.rubyonrails.org/database-support/ms-sql. I have installed the Ruby ODBC Bindings and the dbi and dbd-odbc gems and ruby was compiled from source. If I run this in irb, DBI.connect('dbi:ODBC:A_DSN', '...
Hello All, a bit newb question: in my DB I've got a table with a binary field. I'd like to fetch not that whole field in a request, but rather part of it, preferably using ODBC. Is it at all possible? I'm using PostgreSQL 8.3 - in case a solution exists for that specific DBMS. Thanks. Getting data part-by-part seems to be possible with ...
I have PHP talking to SQLServer through ODBC using FreeTDS and unixODBC. I followed tutorials to get this setup. It's working fine now although special characters in the database are not showing up correctly. Specifically, the ™ symbol. It's showing up in the browser as �. I've tried setting client charset = UTF-8 in the [global] se...
I have a set of stored procedures that I am using to populate an ASP.Net CheckBoxList. When running this procedure from code as { CALL ProcedureName(params); } with the type set as stored procedure, I only seem to be getting a partial result back (i.e. many columns from the actual result are missing.) If I copy the CommandText from the ...
I'm connected to an OpenEdge DataServer via ODBC (not our product, we are just accessing their database, I hardly have any information and certainly no help from the other side). Anyhow, I just need to execute a simple Select, add a couple of rows and I need the equivalent of an IsNull statement. Basically I'd like to execute SELECT I...
I'm working on populating a combobox in visual studio 2005 using vb and I'm stuck on the connection string part. I should mention i'm connecting to a SQL Server 2005 instance. Here is what i have: Dim gDBA As ADODB.Connection Dim records As ADODB.Recordset gDBA = New ADODB.Connection gDBA.Open("Server=e-13;Database=subscribers;User...
I've set up system DSNs, which I can use from other ODBC apps (e.g. iQueryODBC), but in mono, I get "Data source name not found and n" (sic). I am using "DSN=myodbc" for the connection string, via the connection string builder. OSX 10.4 Latest Mono packages - 2.4.2.3. Anyone ever got ODBC working on Mono/ OSX? (Oh - for what it is ...
I have no experience with access. How to do update/insert/delete/select statement with and without $rs = new com("ADODB.RecordSet"); ? ...
Hello Everybody... I am developing a client server application for a cross-database system. I am using Eclipse IDE with Python 2.5 and PyODBC2.5; need to read content from a Lotus Notes database, so run some basic query like - SELECT peronname FROM tablename. 'import pyodbc' is ok - python see it! But when I try to run conn = pyodbc...