• ODBC Connection to iSeries

    Hi, My company has just upgraded to V6RM0 of iSries and I have had problems connecting to the new server through ODBC using Crystal Reports or SQL server DTS. The packages I already had set up are still functioning and I can get a connection OK, but whern I try to create a new package I get an a...

    MBell40 pointsBadges:
  • How to connect Oracle 9i to Visual Basic by ODBC?

    how to connect oracle9i to vb6 by odbc? plese provide me code also?

    Rk90405 pointsBadges:
  • Sybase to SQL Server via linkserver

    I have set up a SQL link server between an SQLserver 2005 on a W2003 R2 and a SYBASE 12.5.0.2 server on a IBM AIX H70 system. I use the Sybase ODBC driver 04.20.00.67 The problem is than most of the times (there is no pattern ) when I select rows from a Sybase table I get ONLY ONE ROW without any...

    Seat15 pointsBadges:
  • Connection failure using dotnet 1.0 and Oracle client 10g with Oracle 10g server

    Hi, I have application developed on dotnet 1.0 ( VS 2003) and Oracle 10g server. Client machine has windows XP ( sp2), Oracle client 10g, Oracle.net, mdac 2.6. ODBC connection is sucessful and using toad also i can connect client machine to server but using ditnet application (...

    Mkb20 pointsBadges:
  • Configuring a SQL Server to optimize for best performance

    We are running SQL Server 2005 on Windows Server 2003 R2 Enterprise Edition x64 SP2. These are Dell 2950 servers with 16 GB of RAM, and they are dedicated to SQL Server. We are mainly performing large database migrations utilizing SSMA and ODBC from Sybase. How can we configure Windows and/or SQL...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Crystal Reports OBDC (Oracle)

    I created an OBDC on the client to link into the Oracle server, and using it in Crystal report, I can only see the system tables, but not the database table. Using the same obdc in Access application, I can see and am able to link all the tables. Do anyone know why is that I can't see the database...

    Askme5 pointsBadges:
  • AS/400 to SQL Server 2008

    Hi, Is there a way to pull an AS/400 File into SQL server 2008? From within SQL 2008 we do not see an ODBC connection that will work for the 400(??) I am not familiar with SQL server and we need to get some data to it. Can anyone shed some light on what I may be missing in regards to the link to...

    Rmason345 pointsBadges:
  • ODBC on Linux

    A user on Twitter, @garyvee, has a question for the community: Whats the best solution for ODBC on Linux ? And is anyone actively working with it? The direct link to his question is here.

    JennyMack4,280 pointsBadges:
  • AS/400 definitions and Password Change Century

    AS400 is new to me and i realy need help... I have 4 questions :) 1. What is the meaning when i see '1' on the column of 'Password Change Century'? 2. How can i see if ODBC is in use in AS400 and if it is in use, how can i see relevant definitions. 3. How can i see if DDM is in use in AS400 and if...

    AS400 - Ask the Expert485 pointsBadges:
  • Setting run priority on prestart jobs

    We have several applications that query the iSeries through ODBC, so they all use the prestart job QZDAINIT. Is there a way to change the run priority on these jobs so that one application's queries can have a higher priority than another application's queries? Since each application's queries...

    GaryF60 pointsBadges:
  • Reporting problem when dates contain zeros in the same field

    Using AcuODBC and creating simple lists involving dates, ie, termination date in an employee file. When I select only records that (in this case) do NOT have a valid date in the TERM-DAT I select no records at all. The data is a signed decimal 8 characters with a valid sign. Crystal seems to not...

    Jelvis5 pointsBadges:
  • SQL Stored Procedure

    I need to create a stored procedure with an input parameter of member name to create an Alias, select all the data in the member then drop the Alias. This procdure wil be called by 3rd party software using an odbc connection.

    Markpg155 pointsBadges:
  • ODBC connectivity to Oracle 10g database from an Oracle 6i client

    Talking through VB Code from a Oracle 6i Client to a 10G database using ODBC.

    Ronneyrajapathirana5 pointsBadges:
  • AS400 ODBC

    Are the permissions for ODBC authority viewable. I am able to view the users that have the ability to perform odbc, but how do I view whether they have read, write, and delete capabilities. Thanks.

    Mramos110 pointsBadges:
  • ODBC in AS/400, OS/400, System i, i5/OS

    Where can I find an ODBC Driver for AS/400? I asked this because I would like to setup an ODBC in AS/400 to connect Lotus Notes (in AS/400) to MySQL (in Windows).

    Yinphin15 pointsBadges:
  • JDBC/ODBC to Excel 2007 getting Exception

    Iam getting the SQLexception by trying to connect using JDBC/ODBC to Excel 2007 through Java. Any Guys can tell abt this problem. java.sql.SQLException: [Microsoft][ODBC Excel Driver] External table is not in the expected format. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at...

    Ansipar288315 pointsBadges:
  • 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...

    Serendipity100 pointsBadges:
  • export the data from excel into a database

    Hi Is there a way to transfer the data in excel sheet into a table in any databse with the use of ODBC connection?

    Jacky160 pointsBadges:
  • Is there a way to make ODBC see SQL Server 2005 Synonyms

    I have created synonyms on tables in SQL Server 2005. Does anyone know of a way to make those synonyms available through ODBC for use in MS Access? I have installed the latest SQL Server Native Client development pack; but the synonyms do not show up in the list of tables when linking via ODBC.

    Randym1,740 pointsBadges:
  • LSXODBC and MS-SQL Stored Procedure Parameters

    Using LSXODBC and ODBCResultSet, how do you pass parameters to a stored procedure using result.Execute or result.ExecProcedure? I am looking for a working example not just syntax.

    Mzrn1x5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following