sql - ASP.NET ERROR : Keyword not supported: 'provider' -

-

my app fails @ line of code:

dim objconnection new sqlconnection(application("connstring"))

my connection string is:

"server=testaitsql;database=sscommerce;uid=planowebapp;pwd=xxxxxxxx;"

i googled problem , solution having malformed connection string "provider" being specified when shouldn't have. example conn string:

provider=sqloledb.1;integrated security=sspi;database=apinquiry;server=sqlserver

i'm not specifying provider think have different problem...???

does test server have exact same configuration file development machine? suspect configuration file on test machine may have different set of values connstring expecting.


Comments

Post a Comment

Popular posts from this blog

c++ - Convert big endian to little endian when reading from a binary file -

-
this question has answer here: how convert between big-endian , little-endian values in c++? 28 answers i've been looking around how convert big-endian little-endians. didn't find solve problem. seem there's many way can conversion. anyway following code works ok in big-endian system. how should write conversion function work on little-endian system well? this homework, since systems @ school running big-endian system. it's got curious , wanted make work on home computer also #include <iostream> #include <fstream> using namespace std; int main() { ifstream file; file.open("file.bin", ios::in | ios::binary); if(!file) cerr << "not able read" << endl; else { cout << "opened" << endl; int i_var; double d_var; while(!file.eof()) {...
Read more

linq to sql - Linq2EF: Return DateTime with a TimeZone Offset -

-
our database has times stored utc, , know user's current timezone, want return relative that. want incorporate offset in linq projection so: var users = u in this.context.users select new userwithcorrecteddate { id = u.id, firstname = u.firstname, lastname = u.lastname, registrationdate = u.registrationdate.value.addhours(-5) }; of course, linq2ef cannot convert " addhours " canonical function. there way this? update: another thought, if timezone offset stored in database column, there way have db perform calculation (date + offset)? linq entities supports sqlfunctions. if know offset number of hours this: var users = u in this.context.users select new userwithcorrecteddate { id = u.id, firstname = u.firstname, lastname = u.lastname, registrationdate = sqlfunctions.dat...
Read more

gdi+ - WxWidgets draw a bitmap with opacity -

-
how can draw wximage, or wxbitmap dc opacity? looks not possible standard dc or wxgraphicscontext. beginlayer/endlayer not yet implemented in wxgraphicscontext have been 1 solution. gdi+ doesn't seem support layers, non-trivial add this. the solution seems to programmatically alter alpha channel pixel-by-pixel? void yourcustomwindow::onpaint( wxpaintevent& event ) { wxpaintdc dc(this); wximage image( width, height ); image.initalpha(); unsigned char* imgdata = img.getdata(); unsigned char* imgalpha = img.getalpha(); // manipulate raw memory buffers populate // them whatever image like. // putting zeros everywhere create // transparent image. // done, not quite... // wxdc can draw wxbitmaps, not wximage, // 1 last step required // wxbitmap bmp( image ); dc.drawbitmap( bmp, 0, 0 ); }
Read more