By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 1,367 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

connecting MSAccess to Sybase

P: 1
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
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
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

Post your reply

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