• How do I fetch synonym names with the SQLTables function in ODBC API?

    Can somebody please explain how to fetch synonym names with the SQLTables function in ODBC API. I currently use the DSN created with SQL Native Client 10 and SQL Server 2005. My code is as follows:</p><p>ret = SQLTables(stmt, NULL, 0, NULL, 0, NULL, 0,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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

    Chc22515 pointsBadges:
  • How to block AS/400 users from using WinSQL

    How can I block AS/400 users to modify data using WinSQL from the PC? Already I have some users that have insalled into their PCs iSeries Access and WinSQL, they run WinSQL that uses an ODBC to change data using SQL sentences. *** WinSQL is universal database management tool that can be used with...

    Maguito5 pointsBadges:
  • General ODBC Error – Why

    I get an gernal ODBC error when running the below code. It looks like the sqlt is too long, but how can I get it to work as I need the query to be dynamic based on date. sqlt = "SELECT SCHED_TASK_EXEC.TASK_ID, SCHED_TASK_EXEC.TASK_TYPE, SCHED_TASK_EXEC.EXEC_TIME, SCHED_TASK_EXEC.END_TIME,...

    ITKE331,040 pointsBadges:
  • Oracle ODBC Windows Server 2003 scheduling issue

    I have a win 2k3 server running an MS Access odbc application that automatically links to an oracle database using the Oracle Instant client. The problem is that it runs fine when run from the Servers console as a local machine user, but fails when run from the windows at.exe scheduler. It seems...

    Ttstudio45 pointsBadges:
  • odbc error while generating crystal reports

    Crystal reports are not getting generated with odbc error. After the upgradation of rational tools from SQL to DB2 version, refreshing crystal reports template is not fetching data and end with ODBC Error. What could be the reason for this? Is any settings needed for this upgradation?

    Createhandle015 pointsBadges:
  • Migrating C code db acess from sybase to sql server 2005 – newbie

    I have to change the db access from a sybase to a sql server 2005 in a c program (i have to keep the C code) I have read lots of technical articles but i'm a bit confused ... with ODBC and the use of sqlcli.h i write a simple C code that access the sql server db but i think it is not the better...

    0949595 pointsBadges:
  • Crystal 8 & SQL problem

    I created 80+ reports for the company intranet and they worked great. At the time the ODBC's were set up for a general SQL connection of sa/blank password. Now the connection connects via windows login/password. The reports have stopped working. I rebuilt one from scratch and put in on the intranet...

    Virtualfrankdotcom20 pointsBadges:
  • view data from ODBC to Crystal Reports

    i am using Crystal Reports 10 to display data from ODBC. The error "Failed to open rowset. Details:HY000:

    Sryn5 pointsBadges:
  • SQL server as data source for OBI EE

    hi everyone,i have been using OBI EE for the past 2 months.I have been using Oracle 10g database as a data source for OBI EE and it worked just fine and now im trying to use SQL server 2005 as my data source. My ODBC was succesful and i can import from that database but i get following errors when...

    NewIT5 pointsBadges:
  • Accessing AS/400 DB2 physical files with Java

    Hello All, We have one JDE Word Writer program, which export the order master data in the DB2/400 Physical files. We want to access this data from our java program (reside on windows platform). I am wondering how we can do that. I got one hint that can be accessed by ODBC connection. But I am...

    GeethaNatarjan15 pointsBadges:
  • odbc as/400 connect to mysql

    I am trying to figure out how to get data from the as/400 into mysql

    Sunnyday25 pointsBadges:
  • Can’t create ODBC connection to sql 2005 instance

    I have a server 2003 two node cluster with SQL 2005 installed. The orginal instance is working fine and there is no connection problem. I have created a second instance and can connect with the SQL Management Studio. When i try to create a ODBC connection from my client os both XP and VISTA both...

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

    Rmason335 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