I'm looking for some advice/information from people far more familiar with database connectivity technology than I am. Currently our app allows the user to select any ODBC dsn on their machine, choose a table and optionally specific columns from the table and import them into our app using ODBC. In our new version we are creating a 64 b...
I have a mySQL database that tracks our projects and drives our website's display of their info. For ease of updating the database I have set up an access database that used an ODBC connection (MySQL ODBC 5.1) to edit the data. It has been working just fine for the past few months with no hiccups. However, last night users(2 of 3) exp...
Here's what I've tried: -Find Vista's ODBC Data Source Manager* through search, -Add a new File Data Source*, selecting Driver for Microsoft Access (*.mdb), and selecting my mdb file of interest, -import pyodbc from python shell and try: pyodbc.connect("DSN=<that Data Source I just created>") I get the following error message (Port...
I am trying to connect to a remote MS SQL Server db from PHP on Mac (eventually on an Ubuntu server( with FreeTDS and unixODBC, but even though I seem to have everything set up properly, I'm getting iODBC errors, and I'm not sure how to get around them. I'm using MacPorts, so my config is: /opt/local/etc/freetds.conf:: [bti_db] host =...
I have just been bitten by issue described in SO question Binding int64 (SQL_BIGINT) as query parameter causes error during execution in Oracle 10g ODBC. I'm porting a C/C++ application using ODBC 2 from SQL Server to Oracle. For numeric fields exceeding NUMBER(9) it uses __int64 datatype which is bound to queries as SQL_C_SBIGINT. Appa...
I am firing off a query in PHP to an MS Access database/odbc connection. The query looks like this $commentSQL = "SELECT * FROM tblTicketComments WHERE requestNum = $foo"; $rs1 = odbc_exec($conn,$commentSQL); if(!$rs1){ $this->comments[] = odbc_errormsg(); } while($rs1){ $this->comments[] = "comment"; } $foo is a number, a...
hi i've developed a java descktop application (in Windows 7) that use ms access and cobol db... to use that db i've two odbc sources data that are: *Microsoft Access Driver ODBC (for my .mdb file) **AcuODBC (for cobol db). Now i've canged pc and in my ODBC manager i don't have the driver to create a data sources. (my new OS is Win7 X...
Hi, I have some Selenium test scripts which I'm using to test a Classic ASP web app, but I'm having problems after restoring the database (SQL Server 2005) with a backup file before every test is run. Immediately after the successful RESTORE (from a Python script running sqlcmd ...) when the ASP tries to connect to the db I get the foll...
Azure SQL Services looks pretty cool, and I'd like to use it as a hosted database. I set myself up with a starter web edition database, and after clicking through a million and five EULAs, I got to a console and created a database. It gave me a connection string for ODBC, and for ADO.NET. I'm using a Mac, with 10.6. What are my options?...
We run a nightly process that generates a large number (~8000) of reports each night using Crystal Reports. This is really just about 14 different reports that get run once for each of our clients. The reports' data source is a windows ODBC connection (via the control panel) and connects to an Oracle 10g instance on our network. Our c...
I have an Access DB that is linked to Sage X3 Sales Order table. I get the information form the source but cannot seem to have it refresh when I go back in it. I have hit refresh, I have tried and apend Query etc.. but can not get the table to bring in latest information. What am I doing wrong? I have used Access before and I am rusty....
I am needing to rename an Excel worksheet that comes to us via FTP. The server the sheet resides on does not have Excel running on it so trying to script it via WSH and vbscript using Excel.Application is out of the question. Is it possible to rename an Excel worksheet via OLE DB, ODBC or some other mechanism? ...
I'm developing a simple macosx application and it needs to access a remote sqlite database (must be sqlite). I've been looking for an example on how to do it through ODBC (I don't know if ODBC is the best or easy way). Does anybody have any idea? Thanks! ...
I am writing a small utility to copy a database from a proprietary ODBC database into a SQL Server database. Everything is working great, except when I use SQLBulkCopy to copy over the data. It works in most cases, but not when it's trying to copy a TIME field into a SQL DATETIME. I get this error: The given value of type TimeSpan fr...
Hi, When I am trying to connect to the localhost, there is no problem. But when I am connecting to my server, I am getting this error. [08S01][MySQL][ODBC 5.1 Driver] Lost connection to MySQL server at ‘reading initial communication packet’, system error: 2 Please tell me how to work around this. I have tried with MySQL ODBC Drivers, b...
I have a function I use to send write queries to DB2 through ODBC, and it gets hung up in this function from time to time if I lose my connection to DB2. I am sending 60 as my timeout to the function, but it never times out. It just hangs up my thread indefinitely, and I'm not sure of a good way to force this function to give up. public...
I'm looking for x64 ODBC drivers (specifically Acces and Excel), so that i can test my code on more than just SQL. Do any exist yet, and if so where can i get them? Thanks ...
Access 2007 databases querying linked oracle 10g tables are returning flawed result sets when using the WHERE clause to filter-out unwanted records. Oddly, some filtering is happening, but not reliably. I can reliably demonstrate/produce the problem like this: Create a *new* database with Access 2007. Create a second *new* database w...
I'm running into an issue where I have question mark characters '?' within my SQL scripts inside comments is causing problems. When I run these statements through an ODBC connection using the Visual FoxPro SQLEXEC function these characters are being seen as parameters and VFP prompts for values. What are my options for dealing with ques...
Currently I can connect to a local .mdb with an Oledb connection. I am able to query, add, update and delete the database with correct results. How would connecting to an ODBC database differ in terms of c# usage from an Oledb database? ...