sql - Exception "Data source name not found" while connecting to an existing DSN -


i have created odbc connections (both 32/64 bit) configuration given below:

microsoft sql server odbc driver version 10.00.14393  data source name: odbcmssql data source description:  server: .\sqlexpress database: medicalmarketting language: (default) translate character data: yes log long running queries: no log driver statistics: no use regional settings: no prepared statements option: drop temporary procedures on disconnect use failover server: no use ansi quoted identifiers: yes use ansi null, paddings , warnings: yes data encryption: no

i want connect local mssql server given in below code snippet:

        string connectionstring = "data source=odbcmssql;initial catalog=medicalmarketting;integrated security=true";         con = new odbcconnection(connectionstring);         cmd = new odbccommand();         cmd.connection = con;         cmd.commandtype = commandtype.text;         try         {             this.con.open();             this.tr = con.begintransaction();             this.cmd.transaction = tr;         }         catch (exception ex)         {                 this.rollback();         }

this throws exception has error message below:

error [im002] [microsoft][odbc driver manager] data source name not found , no default driver specified

sorry if basic, had post clue because same configuration different odbc connections works perfectly.

i found quick fix problem changing connection string to,

string connectionstring = "dsn=odbcmssql";// best practice store in seperate config file.

in fact, other attributes specified (initial catalog, integrated security) not odbc connection string attributes, hence ignored. full list of odbc connection attributes can found below.

https://msdn.microsoft.com/en-us/library/ee275047(v=bts.10).aspx


Comments

Post a Comment

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

i running os ububtu 16.04. ultimate goal able run php script cron job every minute. here php script located @ /var/www/html/tests/test/index.php : <?php $directorypath = $_server['document_root']."/tests/test/data/"; echo "directorypath: $directorypath<br><br>";//check $imagefilepathsarray = glob($directorypath . "*.{png,gif}", glob_brace); echo "<br><br>imagefilepathsarray: "; print_r($imagefilepathsarray);//check ?> when open php script in browser visiting url my-ip-address/tests/test/index.php , get: directorypath: /var/www/html/tests/test/data/ imagefilepathsarray:array( [0] => /var/www/html/tests/test/data/pic.png [1] => /var/www/html/tests/test/data/pic.gif ) before writing cron job in crontab file, need check if can run anywhere using terminal . opened ubuntu terminal @ /home/ location, , executed in terminal: sudo php /var/www/html/tests/test/index.php i got following out...
Read more

php - How can i create a user dashboard -

today have questions you, want create user dashboard site, include (obviously), users data, example -email -username -and others stuff how can information, , print them in html page? if can, how can these information via php sessions? shuld use session? example, if user login, , start new session ( session_start() ), how can data print in dashboard? should use php "project"? in advice, have day , thank time!
Read more

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -

i have jquery mobile page fixed full-screen toolbar, data-tap-toggle enabled. straight under toolbar have positioned banner should slide upwards when toolbar hiding , slide downward when toolbar showing. jquery mobile toggles toolbar applying , removing ui-fixed-hidden class - sadly, can't find in documentation of toolbar widget toggle , hide or show event that. how can detect when toolbar toggled, reposition banner? .banner { position: fixed; background-color: darkseagreen; top: 46px; min-height: 48px; width: 100%; text-align: center; line-height: 48px; } <!doctype html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no"> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"> <script src="https://code.jquery.com/jquery-1....
Read more