ODBC

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 becauseI can link to it via Access or if I try to create the same one again, ittells me it is already there and if I want to overwrite it.In trying to...

View Answer   |  May 2 2008   2:33 PM GMT   |  asked by Bigblew
Windows XP, SQL, ODBC

Alternatives to ODBC

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

View Answer   |  Apr 15 2008   7:52 PM GMT   |  asked by Chany
ODBC, SQL, Database connectivity

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...

View Answer   |  Apr 7 2008   1:47 PM GMT   |  asked by Bradob
Great Plains, Database, ODBC

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

View Answer   |  Apr 6 2008   3:37 AM GMT   |  asked by Chc225
ODBC, AS/400 security

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

View Answer   |  Apr 1 2008   3:03 PM GMT   |  asked by HABDOU
Data transfer, AS/400, DB2

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...

View Answer   |  Feb 8 2008   3:33 PM GMT   |  asked by M1
ODBC, Oracle, Access

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...

Answer Question   |  Jan 31 2008   8:05 PM GMT   |  asked by State chick
ODBC, Windows XP, Windows Server 2003

AS400 System Information Through Data Access

Hi,We do a lot of AS400 system checks on a number of servers. Is there a way of using ODBC/OLE DB to access information from an AS400 concerning such commands like WRKDSKSTS (After using the F11 key to determine which ones are active), WRKSBS, QSYSOPR Messages, etc.I am trying to download this...

View Answer   |  Nov 30 2007   7:02 AM GMT   |  asked by Rjkrawch
AS/400, WRKDSKSTS, VB

opening crystal report using ISeries sql error Temp table already exists

I built an sql stored procedure on the ISeries using ISeries Navigator. The procdure returns a good result set using a couple of global temporary tables from other stored procedures I call. When I try to access the stored procedure using Crystal X1, I get an obdc error telling me the temp table...

View Answer   |  Oct 29 2007   8:20 PM GMT   |  asked by Jlav
ODBC, Crystal Reports, iSeries