|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server Express 2005 and VS.Net 2003Dear all
Is Visual Studio.Net 2003 compatiable with SQL Server Express 2005? I have tried to use the Data Form Wizard to link with the SQL Server Express 2005 but "There were errors configuring the data adapter" error shown after selected the desired table. Could anyone help? Thanks Alex Yes, I don't think there is a compatibility problem between those 2
technologies. BTW for the problem can you test with minimum columns and are you using wizard to define the columns? -- Show quote----------------- Satya SKJ Visit http://www.sql-server-performance.com for tips and articles on Performance topic. "Good" wrote: > Dear all > > Is Visual Studio.Net 2003 compatiable with SQL Server Express 2005? I have > tried to use the Data Form Wizard to link with the SQL Server Express 2005 > but "There were errors configuring the data adapter" error shown after > selected the desired table. Could anyone help? > > Thanks > Alex > > > I am using SQL Server Management Studio Express CTP to create a table with
two char(10) column for testing. However, I have I using data wizard form to generate the form, "There were errors configuring the data adapter" occurred. Show quote "Satya SKJ" <satya***@yahoo.co.uk> wrote in message news:67F2D7B7-1798-4861-A8B6-30668DFC1D3C@microsoft.com... > Yes, I don't think there is a compatibility problem between those 2 > technologies. > > BTW for the problem can you test with minimum columns and are you using > wizard to define the columns? > -- > ----------------- > Satya SKJ > Visit http://www.sql-server-performance.com for tips and articles on > Performance topic. > > > "Good" wrote: > >> Dear all >> >> Is Visual Studio.Net 2003 compatiable with SQL Server Express 2005? I >> have >> tried to use the Data Form Wizard to link with the SQL Server Express >> 2005 >> but "There were errors configuring the data adapter" error shown after >> selected the desired table. Could anyone help? >> >> Thanks >> Alex >> >> >> Besides, I have tried to connect with Access 2003 and it worked. Any hints?
Show quote "Good" <g***@man.com> wrote in message news:uo0HUTeHGHA.3728@tk2msftngp13.phx.gbl... >I am using SQL Server Management Studio Express CTP to create a table with >two char(10) column for testing. > > However, I have I using data wizard form to generate the form, "There were > errors configuring the data adapter" occurred. > > "Satya SKJ" <satya***@yahoo.co.uk> wrote in message > news:67F2D7B7-1798-4861-A8B6-30668DFC1D3C@microsoft.com... >> Yes, I don't think there is a compatibility problem between those 2 >> technologies. >> >> BTW for the problem can you test with minimum columns and are you using >> wizard to define the columns? >> -- >> ----------------- >> Satya SKJ >> Visit http://www.sql-server-performance.com for tips and articles on >> Performance topic. >> >> >> "Good" wrote: >> >>> Dear all >>> >>> Is Visual Studio.Net 2003 compatiable with SQL Server Express 2005? I >>> have >>> tried to use the Data Form Wizard to link with the SQL Server Express >>> 2005 >>> but "There were errors configuring the data adapter" error shown after >>> selected the desired table. Could anyone help? >>> >>> Thanks >>> Alex >>> >>> >>> > > Usually, a dev tool doesn't recognize and support versions they weren't tested for. Anyhow, I
suggest you post this to a VS group, as you are more likely to find a definite answer there. -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "Good" <g***@man.com> wrote in message news:uo0HUTeHGHA.3728@tk2msftngp13.phx.gbl... >I am using SQL Server Management Studio Express CTP to create a table with two char(10) column for >testing. > > However, I have I using data wizard form to generate the form, "There were errors configuring the > data adapter" occurred. > > "Satya SKJ" <satya***@yahoo.co.uk> wrote in message > news:67F2D7B7-1798-4861-A8B6-30668DFC1D3C@microsoft.com... >> Yes, I don't think there is a compatibility problem between those 2 >> technologies. >> >> BTW for the problem can you test with minimum columns and are you using >> wizard to define the columns? >> -- >> ----------------- >> Satya SKJ >> Visit http://www.sql-server-performance.com for tips and articles on >> Performance topic. >> >> >> "Good" wrote: >> >>> Dear all >>> >>> Is Visual Studio.Net 2003 compatiable with SQL Server Express 2005? I have >>> tried to use the Data Form Wizard to link with the SQL Server Express 2005 >>> but "There were errors configuring the data adapter" error shown after >>> selected the desired table. Could anyone help? >>> >>> Thanks >>> Alex >>> >>> >>> > > There was a very interesting post to this, which I didn´t know before
writing this with the original poster, perhaps that might clear the issue: http://forums.microsoft.com/MSDN/showpost.aspx?postid=213565 HTH, Jens Suessmeyer. You can connect an application written in VS 2003 to SQL Server 2005 as long
as you don't try to use any of the new datatypes. On the other hand, the meta-data of SQL Server 2005 is very different than SQL Server 2000 so the VS designers that read the meta data to discover the structure of the database will not work. -- Show quoteThis posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm "Good" <g***@man.com> wrote in message news:%23GhoifZHGHA.528@TK2MSFTNGP12.phx.gbl... > Dear all > > Is Visual Studio.Net 2003 compatiable with SQL Server Express 2005? I have > tried to use the Data Form Wizard to link with the SQL Server Express 2005 > but "There were errors configuring the data adapter" error shown after > selected the desired table. Could anyone help? > > Thanks > Alex >  |
|||||||||||||||||||||||
Other interesting topics