使用系统数据源而不是用户数据源作为 ODBC 连接字符串

发布于 2024-10-24 21:54:14 字数 798 浏览 4 评论 0原文

OdbcConnection DbConnection = null;
        try
        {
            DbConnection = new OdbcConnection(
                "Driver=SQL Anywhere 10;" +
                "Uid=user;" +
                "pwd=pass;" +
                "Dsn=<name>");
            DbConnection.Open();
        }
        catch (Exception e)
        {
            Console.WriteLine(e.Message);
            Console.ReadKey();
            System.Environment.Exit(0);
        }

现在我的问题是，如果是用户数据源名称，一切都很好。另一方面，如果我使用 System-Datasourcename 作为，它会抛出一个错误，指出它找不到 Datasourcename。有什么提示可以让我使用系统 DSN 吗？

提前致谢。

两个示例图像： https://i.sstatic.net/3h7vh.png http://imgur.com/5Govx

原文

OdbcConnection DbConnection = null;
        try
        {
            DbConnection = new OdbcConnection(
                "Driver=SQL Anywhere 10;" +
                "Uid=user;" +
                "pwd=pass;" +
                "Dsn=<name>");
            DbConnection.Open();
        }
        catch (Exception e)
        {
            Console.WriteLine(e.Message);
            Console.ReadKey();
            System.Environment.Exit(0);
        }

Now my problem is that if <name> is a User-Datasourcename everything is fine.
On the other hand if i use a System-Datasourcename as <name> it throws me an error that it can't find the Datasourcename. Any hints how i could use a System DSN?

Thanks in advance.

Two example Images:
https://i.sstatic.net/3h7vh.png
http://imgur.com/5Govx

分享到QQ

分享到微博