I am currently running a third-party software suite, which uses SQL Server as its database. I have a second instance of SQL Server running in a different location, and some apps that I am building in that instance SQL Server needs to access some data in the third-party software. So, I created an ODBC connection between the boxes, and s...
Hi, I'm working on VS2005 and have tried using MySQL's ODBC to connect to a database. The problem is that when I get to the part of choosing which tables to use, there are no tables and the only selectable thing is a View, which has no name and is null (of course something like this doesn't really exist in the DB). I tried adding a Table...
I have a ms-access database and several ODBC linked tables in it. As I have 2 set of ODBC database ,one is for production the other is for development, they have different names Development and Production. How can I get the odbc info of the linked tables by using VBA? ...
Hi, I've a sample table, and it has cols of a few types including datetime. I'm trying to test bulk insert into it using the bcp_* api. I encounter a problem when trying to insert datetime values into the DB (error msgs include 'invalid date time format' when I try to insert as text or 'numeric value out of range' when trying to use ...
I need to query folder structure. In other words I need to be able to access directory structure by SQL. I'm thinking of that there should be some OLE DB provider or some ODBC driver for that purpose. My friend said to google "folder monitoring" but I can't find anything Now I'm doing in command prompt dir>somefile and importing resulte...
I have trouble getting the Sybase ASE ODBC drivers to work on Windows 7 64bit. I have a 64bit version for Sybase ASE 15.0.1. However the installation fails. After selecting a "Custom" installation, and selecting all the options required for the client, the Java-based installer just disappears into thin air when clicking NEXT. I have tr...
I get strings over an ODBC connection from a SQL Server 2005 which contain characters beginning with 'L\' followed by the character code. These characters are not displayable in Ruby/Rails but with other Applications which are using the same ODBC connection. I am using the ruby-odbc gem with utf-8. Umlaut characters are displayed correct...
I've gone back and forth on this problem and can't seem to figure out the best way to do this. Here's the situation: Access database (3rd party product) with data I need in it, from a good number of tables (18 tables) Ideally, need to try to get records into strongly-typed objects somehow so I can query around with LINQ LINQ to SQL cl...
We are in process of upgrading from 32-bit windows 2003 server to 64-bit windows 2003 server. We have hundreds of ODBC DSN's created on the 32-bit, which we now want to work on the 64-bit box. Using the registry export and importing into the 64-bit box results in those entries ending up on the 32-bit part of the odbc windows registry tre...
We commonly use MS Visual Foxpro v9.0 SP1, the language, tables, and reports. However, sometimes we use an ODBC driver to connect to the tables. The ODBC driver was written for Foxpro v6, and doesn't support certain nested selects, autoincrement fields, or embedded casts. We would like to find an alternative to what we have. It could...
Background: Progress based ERP system called QAD 2008.1 (formerly MFGPRO. SQL Server 2005 Enterprise SP2. Reporting Services 2005 SP2. Progress OpenEdge 10.2A Driver. ODBC System DSN created using the Progress OpenEdge 10.2A Driver. Problem: I am creating a report with Reporting Services and will need to use the Progress OpenEdge 10.2A ...
Hi! I'm having a problem "Invalid time format" when I try to use bcp functions(bcp_sendrow/bind etc.) to insert into a table having a datetime column. so as per googled examples, I populated a DBDATETIME structure, for example: if I wanted to populate 3rd august 2009, exactly 8am localtime, I'd populate the structure members like so: d...
I have 2 similar queries select * from openquery(powerschool, 'select * from TEACHERS where teachernumber is not null and schoolid=''1050'' and teacherloginid is not null order by teachernumber') and SELECT * from openqu...
I have the following code: $sql = "update tbl_test set category = N'resumé'; echo $sql; $rs=odbc_exec($conn,$sql); Where $conn is a DSN ODBC connection to an MSSQL Server. The problem seems to be that somewhere between PHP and MySQL (Maybe ODBC?) unicode characters are converted to junk. If I copy paste exactly what the echo says ...
I have an Access 2007 database that uses the "Attachment" datatype (new in Access 2007) for one of its field. This field is a magical "multi-valued" field that can contain several attachments. I would like to be able to easily see the contents of this field, for all the rows in the database, using a single ODBC query. Ideally, each ro...
I have an extended stored procedure (written in Delphi if that makes any difference) that makes its own connection via ODBC and performs some processing - stuff that can't be done using T-SQL alone. If I try to connect using the System DSN that is set up (e.g. named MyDataSource), the xp returns the following error: [Microsoft][ODBC SQ...
I have a client who is incapable of formatting spreadsheets properly. I've asked them 10 times over to follow a sensible guideline (As in FORMAT THE COLUMNS WITH THE CORRECT DATATYPE) but in their lack of intelligence or professionalism or both, they just can't /won't do it. I have an ODBC connection set up for the spreadsheets and pull...
I am having a problem with an a lotus 8 agent running on a server.The agent tries to fetch data form a sybase database (using Sybase 11 ODBC driver).I can run the same agent from a cleint machine with no error, but when the agent runs on the server it ends with the following error. -> LS:DO- ODBC could not complete the requested operatio...
can someone please let me know the steps on creating a linked server using ODBC connection? thanks.... ...
I'm using ODBC, OLE is available if needed to dump approx 3 different types of data to different excel sheets. But to use insert statements in excel, the table has to be created first I believe, especially if the sheet doesn't exist yet. I used to use sql server 2000's import/export wizard that automatically generated the create table s...