Everything on the sybase 9.0 side is working just fine I am able to add data create tables....etc
When I open up asp.net and start a new project, they try linking to my databsae I do not see the option for sybase as the documentation shows. It has optoins for MST SQL server, MSFT SQL Server compact 4.0, MSFT SQL Server Database File & other.
DMK1
Member
7 Points
22 Posts
Connection to Sybase
Apr 12, 2012 05:07 AM|LINK
Is there a way to connect to a sybase database and create a page where you can choose a specific date in a calendar and view specific sales data.
Database specific table..... dba auth - u:username p:password
select * from dbname.system_sales
order by date;
nijhawan.sau...
All-Star
16398 Points
3172 Posts
Re: Connection to Sybase
Apr 12, 2012 05:15 AM|LINK
In order to connect, refer these articles:
http://www.sybase.com/files/White_Papers/ias_wp_SA_aspnet_tutorial.pdf
http://www.velocityreviews.com/forums/t103926-how-to-connect-to-sybase.html (This does works!)
DMK1
Member
7 Points
22 Posts
Re: Connection to Sybase
Apr 13, 2012 02:31 PM|LINK
Good information although I am using Interactive SQl version 9.0
When it comes to looking to change the data source in Visual Studio I am unable to see the SQL Anywhere.
I did follow steps below with no luck.
__________________________________________________
If SQL Anywhere does not appear in the
Data source list, please ensure that the SQL
Anywhere integration components for Visual Studio are properly installed. To install the
integration components:
1. Close Visual Studio 2010.
2. Open a Command Prompt and change to this directory:
C:\Program Files\SQL Anywhere 11\Assembly\v2
3. Then execute the following command:
SetupVSPackage.exe -i
___________________________________________________
nijhawan.sau...
All-Star
16398 Points
3172 Posts
Re: Connection to Sybase
Apr 16, 2012 06:23 AM|LINK
Are you getting any erros while installing?
Or installation is working ?, did you import iAnywhere.Data.SQLAnywhere in your project.
DMK1
Member
7 Points
22 Posts
Re: Connection to Sybase
Apr 20, 2012 12:13 AM|LINK
Everything on the sybase 9.0 side is working just fine I am able to add data create tables....etc
When I open up asp.net and start a new project, they try linking to my databsae I do not see the option for sybase as the documentation shows. It has optoins for MST SQL server, MSFT SQL Server compact 4.0, MSFT SQL Server Database File & other.
Hope this helps identify the issue I am having.