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.
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.
3265 pts.
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...
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...
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...
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...
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.
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.
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 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...
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.
Talking through VB Code from a Oracle 6i Client to a 10G database using ODBC.
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.
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.
Connecting Visual Basic and SQL Server
After creating ODBC, what code will connect the front-end Visual Basic and the back-end SQL Server?
After creating ODBC, what code will connect the front-end Visual Basic and the back-end SQL Server?
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).
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).
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...
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...
Linked Server Query Returns Incomplete Results
I have set up a linked server using Microsoft OLE DB Provider for ODBC Driver to an Oracle DB ODBC DSN. The Oracle table I'm querying has 865 rows but when I try to fetch all the rows I only get back 766 rows. Why am I not getting the complete results? Here is the query I'm using: select *...
I have set up a linked server using Microsoft OLE DB Provider for ODBC Driver to an Oracle DB ODBC DSN. The Oracle table I'm querying has 865 rows but when I try to fetch all the rows I only get back 766 rows. Why am I not getting the complete results? Here is the query I'm using: select *...
job QZDASOINIT
My web application is using ODBC connection to access DB2.Connections are closed properly on each page.But job QZDASOINIT is not ending and remain in TIMW status.This is creating large number of jobs on server.How can i close this job when connection is closed?
My web application is using ODBC connection to access DB2.Connections are closed properly on each page.But job QZDASOINIT is not ending and remain in TIMW status.This is creating large number of jobs on server.How can i close this job when connection is closed?
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?
Hi Is there a way to transfer the data in excel sheet into a table in any databse with the use of ODBC connection?
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.
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.
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.
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.
Accessing an SQL 2005 Synonym with ODBC
Is there a way to link to a synonym in SQL 2005 using ODBC and MS Access?
Is there a way to link to a synonym in SQL 2005 using ODBC and MS Access?
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?
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?
ODBC and AS/400 trigggers
Will a AS/400 physical file trigger work when the file is updated by ODBC?
Will a AS/400 physical file trigger work when the file is updated by ODBC?
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
Does any one know how to create an CL or a script to run Microsoft Word Merge feature with Iseries ODBC Connection
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...
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...
