odbc

Do I Still Need To Install Oracle Client if Using Microsoft ODBC for Oracle to connect to an Oracle Database?

Using ActiveX Data Objects 2.8 Library as a Reference from Excel VBA, and the connection string is: "Driver={Microsoft ODBC for Oracle}......." And I also have the "Microsoft ODBC for Oracle" (MSORCL32.dll) entry in the Drivers tab of Windows XP's ODBC Manager. Now, will I be able to connect to an oracle databse, without any oracle cl...

Sharepoint Designer 2007 ODBC database connection to MySQL impossible?

I'm trying to create a Database Connection to ODBC data sources in SPD 2007 and am having absolutely no luck. I've had some success using an SqlDataSource control, however. I don't know if SPD's database connection support is just broken or what. Googling has turned up others having issues but no definitive answers. So, my two data s...

ODBC Benefits ?

I beleive that ODBC has gotten to a certain point that makes it more reliable and queit portable. Needless to mention that there arent too many oppurtunities for Speed optimization if one should consider using a direct RDBMS API. In Addition, ODBC abstraction, to some sense, does make codes writing portable, having said that, Migrating...

Excel: Use a cell value as a parameter for a SQL query

I'm using MS Excel to get data from a MySQL database through ODBC. I successfully get data using an SQL query. But now I want that query to be parameterized. So I wonder If it is possible to use a cell value (a spreadsheet cell) as a parameter for such a query. For example, for this query: select name from user where id=1 I'd like to ...

Is there a database access library for C and/or C++ with a similar interface to Perl's DBI?

I'm willing to write a subset of Perl's DBI interface for libodbc (or unixODBC) in C++. I believe doing so will allow me concentrate better on my goal. BTW, I prefer avoiding to reinvent the wheel, if of course something similar is already out there. ...

ODBC Issue to Oracle from Windows

I'm currently using some ODBC drivers from DataDirect to link an access db to an Oracle db. When pulling back information it seems to subtract 1 hour from date/time fields, but not in all cases. If the date is say, 19/08/2009 00:00 then the value returned is 1808/2009 23:00 but if the date is 19/08/2009 15:00 the value returned is 19/0...

Old school schema.ini question

Hey guys 'n gals, Anyone know how to specify a custom record delimiter in a schema.ini file? I need to import some data for an old system, and the source file uses pipes (|) as field delimieters and tilda's (~) as row delimiters. I've managed to get the field delimiters configured. Row delimiters anyone? The current schema.ini file... ...

Java not giving Error!

Here is my code - i am simply checking my MySQL database connection. But first i have compiled and run the program successfully. but then i have commented the line Class.forName . Still when i compile it runs successfully, without any error.Why? import java.sql.Connection; import java.sql.DriverManager; public class FirstJbdc { pu...

OleDbConnection.Open() throws a "No error message available" error before even contacting the SQL Server

Hi all Using a connection string of "Provider=SQLOLEDB;Data Source=localhost;User ID=foo;password=bar;Database=CodeLists;Pooling=true;Min Pool Size=20;Max Pool Size=30;" I get the following stack trace System.Data.OleDb.OleDbException: No error message available, result code: -2147024770(0x8007007E). at System.Data.OleDb.O...

Microsoft's Microsoft Text Driver sees text as float operation.

Using .NET I have a text file with comma separated data. One of the columns consists of text like the following : 1997/020269/07 Now when I do a select with an OdbcCommand the string is seen as a float and it returns the 'answer' instead of the actual text! How can I get the actual text? Am I going to be forced to parsing the file ma...

SAS to Oracle ODBC - passing a SAS table INTO the database

Can anyone please advise the syntax for passing a table FROM a SAS library INTO an oracle database? example code below (although obviously the connection to the WORK library cannot be referenced in this way) PROC SQL noprint; connect to ODBC as X (dsn='ALIAS' uid='USER1' pwd='passwd' quote_char=''); exec (CREATE TABLE Test AS SELEC...

Connection to Oracle via VBScript

I have two databases on the same server with the same name and different port number. The tnxnames.ora entry looks like (actually one database is a clone of the other one.) AAAA.FSA.GOV.UK = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = SERVERNAME)(Port = 1530))) (CONNECT_DATA = (SID = AAAA))) AAAA.FSA.GOV.UK = (DE...

Importing a text file into SQL Server in Python

I am writing a python script that will be doing some processing on text files. As part of that process, i need to import each line of the tab-separated file into a local MS SQL Server (2008) table. I am using pyodbc and I know how to do this. However, I have a question about the best way to execute it. I will be looping through the f...

link with DB2 ODBC drivers on Linux

Hi All, I need to link our C/C++ code that is using the DB2 ODBC driver on linux, and although ive pulled in sqlcli.h I dont know where to find the objects so i can link. Ive installed DB2 v9.1 ESE so i wouldve thought i could get everything. Anybody got any ideas? ...

Error while connecting to Oracle DSN using Java

Hi, I need to develop an application that connects to various DSN's using the Microsoft ODBC drivers. I have developed the application in Eclipse and it seems to work properly. The connection succeeds and I am able to view table data. However when I export the project to a runnable jar file (using Eclipse) the functionality fails for O...

Cleaning up ODBC DSN in C# .NET

I am using C# and an OBDC DSN to connect to a Paradox database. I seem to be leaking memory if I open and close each connection. My code is basically: csb.Dsn = "DNSName"; OdbcConnection con = new OdbcConnection(csb.ConnectionString); con.Open(); OdbcCommand comm= new OdbcCommand("SELECT...

Set Excel ODBC paramater based on user input

I have an Excel 2007 ODBC connection defined and I need to allow users to specify two of the paramaters each time the query is run. Something along the lines of SELECT * FROM table WHERE tdate between ? AND ? With the user specifying the date range each time the query is run. Any ideas? Thanks, David ...

Connecting to MySQL database with ASP on a virtualized Windows 2003 x64 server

Hi, I'm trying to connect to a MySQL 5 database using the MySQL ODBC 5.1 driver. In the control panel's ODBC settings I created and tested the ODBC connection and it's working fine. When I try to use the connection from VBScript code I get an error though: ADODB.Connection error '800a0ea9' Provider is not specified and there is no desig...

DSN tests ok, but login failure trying to use the DSN to SQL Server 2005

I'm writing a small ASP.NET application in a hosted environment (meaning I don't own the server). Using the hosting provider's webtools, I created a DSN that specifies the Driver, the Server, the UID, the PWD, and the Database. When I test the connection, it tests out fine. However, when I load my web page with the code: OdbcConnecti...

ODBC problems in SQL 2000 --> 2005 Upgrade

This wiki post outlines both a problem and a solution. I wanted to post this for others that may be having similar problems, as I couldn't find anything specifically to solve this problem elsewhere. We recently upgraded our SQL Server 2000 database to SQL Server 2005. One of the databases on the server is a back-end to a MS Access datab...