Topics Search

Connecting sybase thru ms-access odbc

Connecting sybase thru ms-access odbc
Views: 39
Was able to connect through ms-access 2007 (Windows XP to Sybase (ASE) to link tables.
However the Sybase server has multiple database - it appears ODBC only allows me to link to one specific d/base.
How may I link to different d/b within the same server and link these tables?
Sponsored Links:

More topics

 

Connecting sybase thru ms-access odbc

Preview
We are using ms-access ODBC to connect sybase. We are able to connect and able to access all the tables. surprisingly we are getting "Admin" failure attempts in sybase audit db whenever we execute queries in MS-Access design view. We verified there is no admin id is present in sybase db and we are using our own logins which are valid. Please help us in resolving this.
 

Connecting to database via ODBC

Preview
I am working with an Access 2003 application, which consists of some linked tables. These are linked via ODBC. My question is: Is there any way to edit the odbc connection for all of these instead of changing for each linked table? If I want to change the database this is very time consuming. I do not want to change the odbc configuration on the computer itself.
 

Connecting to database via ODBC

Preview
I am working with an Access 2003 application, which consists of some linked tables. These are linked via ODBC. My question is: Is there any way to edit the odbc connection for of these instead of changing for each linked table? If I want to change the database this is very time consuming. I do not want to change the odbc configuration on the computer itself.
 

Methods of connecting to MS Access database using ASP.NET

Preview
In this article, I shall discuss different methodologies for connecting to a Microsoft Access database using ASP.NET without any errors. TOC:
Connecting to a Microsoft Access database with ASP.NET; Connecting to a Microsoft Access database directly using ASP.NET; Manipulating a Microsoft Access database directly using ASP.NET; Connecting to a Microsoft Access database through ODBC using ASP.NET; Manipulating a Microsoft Access database through ODBC using ASP.NET; Connecting to a password protected Microsoft Access database directly using ASP.NET.
 

Connecting to mySQL database, or rather not connecting!

Preview
I'm trying to connect to a remote mySQL database.

I created a passthrough query and set the ODBC connection string as follows (using generic names here):

ODBC;Driver={MySQL ODBC 5.1 Driver};Server=mySQLserver.com;Database=mydatabase ;User=myusername;Password=myPassword;Option=3

I get an "ODBC error - call failed" message. If I put in what I know is an incorrect password, I get the mySQL connection screen. I can put in the correct password and hit "Test" and it says "Connected".

There is even a dropdown with all the databases on the server. So I know I'm connecting, but my query still fails. I don't get it!
 

Connection to Oracle through Access failed.

Preview
I am having troubles connecting Access to my Oracle database. I tried to configure my ODBC connection and when I test through ODBC it says connection is successful.

I am basically trying to follow the steps mentioned in the article on Database Journal Article "Connecting with Oracle: Accessing Oracle via Access and Excel".

I am able to perform all the steps mentioned on page 1 but I am having troubles while following the steps defined on Page 2.

When I try to connect it through Machine Data sources I get an ERROR "ODBC-- Call Failed
 

View, refresh, or change the file name and path for linked tables (MDB)

Preview
I can create an Access mdb and add a linked table to an Sql Server database via ODBC. If I change the Sql Server that the ODBC is connecting to with the ODBC control panel applet the mdb still connects to the original Sql Server until Access is restarted. Is there a way to relink these linked server tables without restarting Access?
 

Connecting MS Access to SQL Servers through ODBC

Preview
Once you got a DSN defined in the ODBC manager that connects to your SQL Server, you can connect a normal MS Access document to the Oracle server, and link an Access table to a SQL Server table.
 

distributing Access front ends

Preview
I'm fairly new to Access and trying to understand the big picture.

So, I have an MS SQL Server with all the data. I'm creating an Access file and connecting to that server using ODBC connection. Now I want distribute my access file to users who are not located on my network (i.e. they are at different locations). And I'm having the following problems:

1) Is it true that to distribute my application I need to install ODBC driver on all user computers and create an ODBC connection so that my access is able to connect to the sql server?
2) Is there another way of creating one access file and distributing it without any modifications on the end-user's computer?
 

run-time error '3151' odbc connection failed in Access 2003

Preview
We have an Access FE application connecting to a BE SQL 2005. Recently we changed SQL servers, new name, ip and dsn. I created a new ODBC, then went into Access and changed the Link tables to reflect the new ODBC. I am able to update the tables to the new SQL server but when I try to run a Form that is used to update our Territories I get the "run-time error '3151' odbc connection failed" error. It sends me to VB code and here is where I get lost. I tried to review the code to see if the old db is hardcoded somewhere but couldn't find anything