The application part of my database is in Access 2003, and I use tables that are linked from SQL server. Now, I have some tables that I have to link from an Oracle database. I link them through and ODBC connection and it works fine. Is it possible to link that Oracle link in SQL and then link that table as it is already linked in Acces...
I have an access 2000 application to manage. The DSN is pointing to the production Postgresql database and I'd like to point it to the one running on my machine for testing. The problem is, I can't figure out how to change it. I tried running odbcad32.exe, and I did see the DSN and was able to change it to what I wanted (and it did pas...
php odbc_connect not connecting with sybase database. I set up a web site using php to talk to a sybase db (already in use for a in-house application) via a odbc connection, so users in the field could access the in-house db. This was on a 2003 NT server, and everything worked fine. Then I set up a similar site on an XP Pro machine (t...
Hi, I am using System.data.odbc to communicate with my MySQL db. When logged, I would need to know whather the user is admin or not, just to know the rights. Is there any way how to retrieve rights of currently logged user? Thank you! ...
Hi, I'm new to windows services and... you guessed it, I’m a bit stuck. Let me paint the picture – I’m running a timed service that use an OdbcDataReader and SqlBulkCopy to (1) archive the data (2) normalize the data on a SQL box. When I run this code in a windows form proj. it works fine. Then, when I change the DNS’s Data Directory P...
Hi, I am currently trying to get to the bottom of a client crash with one of our applications. I have wrapped the app in an exception handler which creates a mini-dump when the crash occurs. The application crashes with the exception c0000139 (of which there isn't a huge amount of documentation). The callstack looks like this ntdll....
I have a .accdb file on my local machine and I am trying to connect to it and read some data from 3 tables within the DB. How do I establish the connection using Perl? So far I have scraped together this much for MS Access, but I am getting errors saying that I am not using the correct driver. Any ideas? my $msaccess_dbh = DBI->connect...
I'm sure this must have been asked before, but I can't find it. Can I set a relative path for the location of a linked table in Access 2003? The other table is also stored in an mdb file. These databases will sometimes be connected to via odbc or oledb, so relying on vba code that fires when Access opens the file will not work. If poss...
Don't shoot me for this, but I've posted this on experts-exchange as well. I just need an answer. Here's the question (and yes, i've searched, googled, and searched again): I'm getting some very strange errors on boiler plate odbc connection code. The code connects to DB2 (which is always a joy to work with) and has never given me issue...
Hi, On the class level, I have created reference: System::Data::Odbc::OdbcConnection Connection; in some method I want to set it to odbcCommand.Connection like this: ::System::Data::Odbc::OdbcCommand Command; Command.Connection=this->Connection; It reports "cannot convert parameter 1 from 'System::Data::Odbc::OdbcConnection' to 'Syst...
Hi, On the classs level, I have declared: System::Data::Odbc::OdbcConnection conn; System::Data::Odbc::OdbcDataReader datareader; //doesnt work System::Data::Odbc::OdbcDataReader^ datareader //works However, the dataReader has to be OdbcDataReader^. I dont understand why. Thanks ...
I am getting this error when I try to load an excel document as a datasource for my webpage Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xd5c Thread 0x7e4 DBC 0x19acf74 Excel'. What is going wrong? ...
I have an ODBC DSN setup to hit a Filemaker database from my ASP.Net application. I'm trying to form a valid query where the column name has spaces in it. In T-SQL, you would enclose it in []. But I fail to get it to work in this case. Here's a valid query: select * from ua_inventory where location like '%a%' But this is not: sele...
I have an old server (Solaris 8) running Informix Dynamic Server 2000 Version 9.21.UC4, and I want to get ODBC enabled so that I can get to the data from elsewhere, but I haven't been able to find documentation online about how to do this on the server. I am able to use dbaccess on the server to get to the data just fine, but when I loo...
So I understand SqlDataReader is quite fast, you dont know how many rows you'll get and it only allocates memory for each row at a time. So if I have a million rows of small rows (say 4 to 32 bytes) each row read means a roundtrip to the server? No buffering takes place right? If I used ODBC via SQL Native Client I could setup a row buf...
I'm looking for a way in C# to determine the quote character for an ODBC connection. I'm trying to get it to work reliably to many different ODBC data sources without having to special case for individual ODBC drivers. I'm familiar with the ODBC API SQLGetInfo from: http://msdn.microsoft.com/en-us/library/ms711681%28VS.85%29.aspx but ...
Hi, I have a system that connect to SQL Server through ODBC. When I try to raiseerror from an IF...ELSE statement, it does not triggered the exception handling. I have done some raise error testing at my side. Below is my finding: RaiseError did not triggered exception: CREATE PROC xxx AS IF 1=1 BEGIN raiserr...
Hi there, i am dealing with some legacy access < 2007 "databases". All the tables are linked tables to a SQL Server 2008. While the odbc-links are established the table structure is copied into the mdb-file together with the DSN-string. Thats what one can see in Msysobjects. A query forces the jet-engine to retrieve the data from SQL...
I have a development project that requires us to be able to support informix data sources via ODBC. I've downloaded the prebuilt Informix Virtual Appliance from the IBM website and am able see the server with the built in tools, but haven't been able to get at it from an ODBC connection on the client! I have the ODBC support package ins...
I currently have multiple queries that query data from a few tables linked through ODBC, and some temporary tables that are edited through the user interface. I have complex criteria in my queries such as: SELECT * from ThingsData WHERE (Thing In(SELECT Thing from ListOfThings) AND getThingFlag() = True); In this case Thing is a field...