473,320 Members | 1,945 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

connecting MSAccess to Sybase

I need to connect to sybase using MS Access..
The following methods can be used for the purpose

1. Start up MS Access.
2.1 On first use:
Specify "Create a New Database Using", "Blank Database".
Specify it's name and where to store the mdb file.
2.2 on subsequent uses:
Specify Open an Existing Database." and select the appropriate
one.
3. Link tables from Sybase.
3.1 Choose "File".
"Get External Data."
"Link Tables ..."
3.2 "Link" window appears.
Under "Files of Type:" select "ODBC Databases."
3.3 Under "Select Data Source" Window, choose "Machine Data Source".
Select "CIS Sybase Server" and "OK".
3.4 Under "Logon to Sybase" window, choose "Server Name" 'sybase' from
pull-down menu.
Enter your Unix Login name.
Enter your Sybase password.
Specify your class database ("cis670a").
"OK".
3.5 Select whichever tables you want to use.

can somebody please tell me from where to find the DLL for sybase so that i will be able to get "CIS Sybase Server" in step 3.

please help..its urgent!!!!!

thanks n regards
anu
Dec 21 '06 #1
1 5557
PEB
1,418 Expert 1GB
Have u searched the net with keyword Sybase Connection?

Once i've done it and there was drivers for ODBC!

And also search for the needed dll in direct search! Sure that will appear somewhere!

Best regards!

I need to connect to sybase using MS Access..
The following methods can be used for the purpose

1. Start up MS Access.
2.1 On first use:
Specify "Create a New Database Using", "Blank Database".
Specify it's name and where to store the mdb file.
2.2 on subsequent uses:
Specify Open an Existing Database." and select the appropriate
one.
3. Link tables from Sybase.
3.1 Choose "File".
"Get External Data."
"Link Tables ..."
3.2 "Link" window appears.
Under "Files of Type:" select "ODBC Databases."
3.3 Under "Select Data Source" Window, choose "Machine Data Source".
Select "CIS Sybase Server" and "OK".
3.4 Under "Logon to Sybase" window, choose "Server Name" 'sybase' from
pull-down menu.
Enter your Unix Login name.
Enter your Sybase password.
Specify your class database ("cis670a").
"OK".
3.5 Select whichever tables you want to use.

can somebody please tell me from where to find the DLL for sybase so that i will be able to get "CIS Sybase Server" in step 3.

please help..its urgent!!!!!

thanks n regards
anu
Dec 26 '06 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: John Fabiani | last post by:
Hi, I'm hoping someone on the list has connected to sybase/MsSQL with something that works with DBAPI 2.0 from a linux box (SUSE 9.2) because I can't seem to get it done. I found Object Craft's...
1
by: Martin_Hurst | last post by:
Is it possible to establish a connection from within a postgres database to another external database on the network, i.e., not a java or scripting connection, BUT by some type of table definition...
6
by: bala | last post by:
hi access guru's there is a requirement wherein i have to connect ms access frontend with sybase (backend). the data from the frontend should be saved in the table in sybase databae thro...
115
by: TheAd | last post by:
At this moment I use MsAccess and i can build about every databound application i want. Who knows about a serious open source alternative? Because Windows will be a client platform for some time, i...
1
by: Coney Coxwell | last post by:
Hopefully, someone will take the time to answer this. I have MYSQL back-end data source that I would like to link MSAccess to. My goal is to use Access to query specific pieces of information from...
0
by: http://www.visual-basic-data-mining.net/forum | last post by:
I am trying to connect to MsAccess 2000 database using ASP.NET. The code snippet is attached below. In the select statement, when I use a *, I get the values and they are populated in the drop down...
6
by: Nishanth | last post by:
Hi all Can someone direct me on how to connect to a database Sybase/Oracle from C++. and execute a Store Procedure. Help will be much appreciated. Thanks, Nishanth
0
by: umamaheshg | last post by:
Hi All, I m unable to transfer a table from .mdb database file to a table in sybase environment. I need the code to be in Visual Basic/VBScript (Preffered in VBScript). Please help me on this. ...
2
by: bhusandi | last post by:
Dear All, I am new to this forum and perl ..;) I am trying to connect to Sybase (windows env) but am getting the error: "install_driver(Sybase) failed: Can't locate loadable object for module...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.