connection string - ConnectionString issues - SQL Server 2008 on Windows 2008 -


we have third party program used run on windows 2003 against sql server 2000 database (app , db on same machine). trying migrate/install on windows 2008/ sql server 2008.

the connection string specified not seem allow connect sql server (see below)

    <configuration name="prog">     <adoconnection>         provider=sqloledb.1;persist security info=false;user id=sa;pwd=p@ssw0rd;initial catalog=db_new;data source=servername     </adoconnection> </configuration>

i tried alternate 1 , not work

<configuration name="prog">      <adoconnection>     provider=sqlncli10.1;persist security info=false;initial catalog=db_new;data source=servername;uid=sa; pwd=p@ssw0rd;

i able use 1 below connect application sql server 2008 database on windows 2003

<configuration name="prog">     <adoconnection>         provider=sqloledb.1;persist security info=false;user id=sa;pwd=p@ssw0rd;initial catalog=db_new;data source=servername     </adoconnection>

what right syntax application connect sql server 2008 on windows 2008 server?

you can check provider version(s) installed looking in registry: hkey_classes_root\sqlncli10\clsid

hkey_classes_root\sqlncli10.1\clsid (for version 10.1 etc)

the sqlncli10 (sql server native client) name alias latest version installed on computer. on 2003 box find entries sqloledb in registry won't have installed on 2008 box.

i expect following should work: provider=sqlncli10;persist security info=false;user id=sa;pwd=p@ssw0rd;initial catalog=db_new;data source=servername

for more info on formatting of connection string , various provider see: this connectionstring site


Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more