ODBC Questions


odbc question
what odbc driver you use to go from system-i to sql2005 i sue IBMDA400 but does not handle pack fields very well any suggestions?

Answer Question   |  August 6, 2010  9:27 PM
ODBC, ODBC on i5
asked by:
5 pts.

ODBC and AS/400 trigggers
Will a AS/400 physical file trigger work when the file is updated by ODBC?

Answer Question   |  July 31, 2010  12:08 PM
AS/400, AS/400 triggers, ODBC
asked by:
40 pts.

ISeries ODBC Connection to Microsoft Word
Does any one know how to create an CL or a script to run Microsoft Word Merge feature with Iseries ODBC Connection

Answer Question   |  September 9, 2008  3:31 PM
CL, Microsoft Word, Microsoft Word merge, ODBC, ODBC on i5
asked by:
10 pts.

Access mailbox through the file system?
We are running Exchange 2003 Server Enterprise with SP2, on Windows 2003 SP1. We have a user who wants to make a connection to an Exchange mailbox folder from an MS Access database. I know that Exchange 2000 used to have the M: drive for file system access, but that no longer exists in Exchange [...]

Answer Question   |  November 1, 2008  5:44 PM
Exchange 2003, Exchange mailbox management, Microsoft Access, ODBC, Outlook 2003, Windows Server 2003
asked by:
100 pts.

Rretrieving data from AS400 tables with PHP?
I think I will die! Does anyone know how to get data from a table on AS400 displayed with PHP through ODBC? I’m starting to go mad. I tried ODBC drivers (iSeries Access client, Client Access). Nothing helps. I have Apache server as localhost on my machine and php installed and that works fine. The [...]

Answer Question   |  June 15, 2009  2:40 PM
AS/400 database, ODBC, PHP
asked by:
80 pts.

Setting the ODBC in SQL Server 2005
I use SQL Server 2000, and I am in the process of upgrading to SQL Server 2005. However, when setting the ODBC, the database option for SQL Server 2005 does not appear. Is there something I have to set first before the ODBC?

Answer Question   |  August 4, 2008  2:23 PM
ODBC, SQL Database, SQL Server 2005
2,585 pts.

Developer 10g
I want to connect my forms and reports of developer 10g to other data sources. e.g. Sql Server. How can i connect to it through odbc?

Answer Question   |  August 4, 2008  6:24 AM
Developer 2000, ODBC, Oracle 10g, SQL Server
asked by:
115 pts.

Does Siebel 7.7 work on Windows Vista (64-bit)?
My name is Ayman and I’m new on this technology Siebel 7.7. My questions is: * Does Siebel 7.7 work on Windows Vista (64-bit)? * Where can I find Siebel 8.0 software? * Why does Siebel needs ODBC? Thank you so much for your time.

Answer Question   |  July 23, 2008  5:15 PM
CRM software, ODBC, Siebel, Siebel 7.x, Siebel 8.x, Vista
asked by:
250 pts.

odbc in i5/OS
I need to know how i can create an data source name or a odbc connection for a database in i5/OS. Kindly guide me.

Answer Question   |  April 16, 2010  4:31 AM
i5/OS, ODBC, ODBC on i5, OS/400
asked by:
160 pts.

AS400 ODCB table link
When i link tables with a ODBC driver then some table won’t give me any records (I link into microsoft access. But I do see the column headings. I the record fields I get: #Name? Is this an AS400 problem, ODCB or Access ?

Answer Question   |  May 3, 2010  4:14 PM
AS/400 errors, Microsoft Access, ODBC
15 pts.

AS400 ODBC
Hi Our company uses AS400 for our financial processing application. The users access the AS400 through an emulator. They also access the application database through ODBC. They extract the data to excel sheets to create certain reports for their own purpose. Recently, one the data base files in AS400 were replaced by such a user [...]

Answer Question   |  May 7, 2010  10:00 AM
AS/400, Database permissions, DB2 administration, DB2/400, ODBC
asked by:
20 pts.

DSN and DSN-Less Connection
What is difference between DSN and DSN less Connection? Which is better to use and Why?

Answer Question   |  July 2, 2008  4:29 AM
Data Source Name, DSN, ODBC
asked by:
15 pts.

Copy Attachments to Folder
Anyone have a lotusscript to copy attachments to a folder? Also need to extract to excel a view but right now i think i can handle that with NotesSQL ODBC. The attachments part is buging me the most. This is not a mail system…. We have a database setup for document approvals. Lotus Domino 6.5

Answer Question   |  June 13, 2008  1:29 PM
Domino, Lotus Domino, Lotus Notes 6.x, LotusScript, ODBC, SQL
asked by:
140 pts.

SQL linking to database in XP
First of all, I tried to create an ODBC connection to a local SQL database. It successfully created but it does not show up. I know it is there because I can link to it via Access or if I try to create the same one again, it tells me it is already there and [...]

Answer Question   |  May 6, 2008  2:33 PM
Database, ODBC, SQL, Windows XP
asked by:
15 pts.

Alternatives to ODBC
Our db group wants to remove ODBC access. My application relies on ODBC to get data. What are the alternatives?

Answer Question   |  April 17, 2008  7:52 PM
Database connectivity, ODBC, SQL
asked by:
25 pts.

Great Plains 8 ODBC Error (45)
This just started today, Great Plains has been working for a good time now. I get first error message when logging on ” A get/change first operation on table ‘tablename’ (45).” And then when you click on More Info… it says “[Microsoft][ODBC SQL Server Driver][SQL Server]Database’Databasename’ is already open and can only have one user [...]

Answer Question   |  April 7, 2008  1:47 PM
Database, Great Plains, ODBC, SQL Server errors
asked by:
155 pts.

how to prevent users from pc to use odbc
Hello, how can we stop a user say from a windows to use odbc to connect to the as400 server. I am looking more for setting up a block on the as400 machine rather than on the pc itself. thanks

Answer Question   |  November 4, 2009  3:37 AM
AS/400 security, ODBC
asked by:
15 pts.

Data transfer from DB2 (AS400) TO SQL SERVER 2005
I want to transfer a data from a DB2 file to a SQL Server file. I do not want to buy a software that do it. I want to do it by my self (perhaps using ODBC) Thinks all for help. Abdou

Answer Question   |  November 28, 2011  3:03 PM
AS/400, AS/400 DB2, Data transfer, DB2, ODBC, SQL Server 2005
asked by:
5 pts.

Exporting MS Access data to Oracle
Hi, I am exporting MS Access tables to Oracle using ODBC. I face MS Access ‘Overflow’ error for the tables which has date/time fields and has values in the format MM/DD/YYY. The error happens for only some of the data, for example 10/15/101. Please provide suggestions for how to solve this error. Thanks.

Answer Question   |  February 8, 2008  3:33 PM
Access, ODBC, Oracle
asked by:
M1
5 pts.

Setup routines for ODBC driver failing
I have loaded an ODBC Driver ‘PB INTERSOLV OEM 3.11 32-BIT INFORMIX 9 ODBC’ driver and receive two errors: “The setup routines for the ‘PB INTERSOLV OEM 3.11 32-BIT INFORMIX 9 ODBC’ driver could not be loaded due to system error code 126.” and “Could not load the setup translator library” After googling this error [...]

Answer Question   |  January 31, 2008  8:05 PM
ODBC, Windows Server 2003, Windows XP
asked by:
5 pts.