c#连接sybase时一直报错
liuay 2016-04-19 10:42:01 报错
ERROR=Parse failure on line 1 of statement 'use alerts', at or near 'alerts'
代码
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Sybase.Data.AseClient;
using System.Data;
namespace Test_Sybase
{
public partial class Test : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
try
{
//AseConnection con = new AseConnection("Data Source=192.168.0.1;database=alerts;charset=cp850;Port=4100;UID=root;PWD=netcool");
AseConnection con = new AseConnection("Data Source='192.168.0.1';Port='4100';UID='root';PWD='netcool';Database='alerts';");
AseDataAdapter da = new AseDataAdapter("select * from alerts.status", con);
con.Open();
DataTable dt = new DataTable();
da.Fill(dt);
}
catch (Exception ex)
{
}
}
}
}