Hello - We would like to force encryption of the data going to and from our customers' SQL databases. Currently, we access the customer databases via ODBC DSNs, using both SQL Management Studio (Query Analyzer) and our custom applications. Yeah, I know this is not "best practices", but I have to deal with it for now. Anyway, I have b...
Is there a way to get the detailed error-messages PostgreSQL shows when running a query from command-line or a client like PG-Admin when using the ODBC-Interface-Driver? The Err-object in Access just tells you that something went wrong but is not very helpful - I have to run the same query again in PG-Admin to see where the problem is. ...
Hello, I would like to know how to explicitly set a timeout for the Ruby DBI ODBC driver, when connecting to SQL Server. I would like long running queries to simply timeout and cancel themselves, saving further server resources and Rails processes. This was happening while we were using the ADO based Ruby driver, but now that we've sw...
I have a filemaker script that inserts a new entry on several imported mySQL tables. I need to get the unique id of these entries as they are created (before or after, either way) so I can refer to them later in the script. This is easy to do in SQL with LAST_INSERT_ID(), but I can't seem to find how in filemaker. What I have tried that...
I want my application to be able to work with multiple db vendors. In other words, depending on the DB infrastructure of the client, the db schema will be deployed on one of Oracle, MySQL, SQL Server. I am between using ODBC and OleDB, and the following key requirements that must be taken into account for the selection: the DB schema m...
The problem I am looking to solve is communicating from a 64-bit app through ODBC with a datasource for which there only exists a 32-bit ODBC-driver. One solution that would suffice for the moment is using an ODBC-to-ODBC bridge. I found an ODBC-to-ODBC bridging-software created by Easysoft. Are there any alternatives? ...
I ran into an issue with some third party software that we use to track software license usage in our computer labs. We recently migrated the app to 64-bit Server 2008 after receiving assurances from the company that it was compatible and running some preliminary tests that showed that the app worked in the 64-bit environment. Unfortun...
I want to allow the user to define a query which will be used to fetch some information. The database the user connects to is also user definable. Basically the steps that the user needs to perform are: 1/ Select the data provider (this is one of the providers returned by DbProviderFactories.GetFactoryClasses ()) 2/ Configure the sel...
How do I get a database from ODBC data source to SQL Server 2005? Can I use SQL Managment Studio Express for this? ...
I was just wondering how prepared queries work. I am using PHP and MySQL. I know that prepared queries compile the query and then repeated uses only have to change the parameters, so it saves time. But how long does that compiled query have an effect? At which point does it have to be reevaluated? Is it just as long as the PHP script is...
Ok, this one is driving me completely crazy. I have a table in a PostgreSQL database and I'm trying to get the value a boolean column for a specific record with OdbcDataReader.GetBoolean(int col). The problem is that GetBoolean() keeps throwing a cast is not valid exception even though the same code worked just several days ago. What's...
Towards the bottom of the SQLNativeSql() function documentation it seems to be indicated that ODBC drivers perform translation. It says: The following are examples of what SQLNativeSql might return for the following input SQL string containing the scalar function CONVERT. Assume that the column empid is of type INTEGER in the data so...
I have a large number of INSERT statments to run. As I run them, I understandably get "maximum open cursors exceeded". OK Oracle, so I will close the cursors immediately after running the INSERT statements. SQLCloseCursor( hStmt ) But Oracle says to this "Invalid cursor state." Why is Oracle not happy with me closing the cursor? ...
I'm using pyodbc to query an AS400 (unfortunately), and some column names have hashes in them! Here is a small example: self.cursor.execute('select LPPLNM, LPPDR# from BSYDTAD.LADWJLFU') for row in self.cursor: p = Patient() p.last = row.LPPLNM p.pcp = row.LPPDR# I get errors like this obviously: AttributeError: 'pyodbc.R...
I am using SQL Server 2000. I have a database with n number of tables in it. I have configured a maintenance plan. If I enable integrity check and run the plan, I am not able to enter any data through VC++/ODBC. Is there anything I have to check? ...
We are developing a standalone application that stores its data in a Database. We use Dataset and TableAdapters for the communication with the Database. One of the basic requirements is the application to be able to use SQL Server, Oracle and MySQL. For this purpose we made the queries in the TAs vendor independent. We use ODBC provider....
Hi! I've to write a c++ application that receives a huge data stream( many thousands of messages per second) and insert it into a MS sql server2008 db (into one or more tables) as fast as possible. I'm new to windows, and amongst so many ways described in msdn, I'm not able to judge the best way to do this, for example: 1. should I use ...
I understand that some databases have native support in R (e.g. MySQL) but you can connect to other DBs like MS SQL Server using RODBC. How much speed improvement does one gain for reading/writing with the native drivers vs. RODBC? What other DBs have native drivers in R? Is reading faster or slower than writing generally? ...
Our MS Access application with linked tables to SQL Server 2005 is slow when using Windows Authentication from Windows XP clients. We've been running it successfully using SQL Server authentication, but now we want to move to Windows Authentication for better security control. Setup: Database server: Windows 2003 Server, SQL Server...
I found this question here: http://stackoverflow.com/questions/271504/oledb-v-s-odbc Which gave me more information, but did not really answer the question I'm asking, so I shall proceed from there. I am working in C#. I'll spare you the long story about how I arrived at this conundrum, but basically I'm trying to decide between ODBC ...