Thanks for the help.

 

I am using Visual Studio pro and create an asp page, I add a gridview and then choose  "new data source"...database...new connection...Its a sql 2000 server and the connection tests fine. I click ok and then next and save the connection string.  This is where I have the problem.  I watch the screen and it looks like its just about to display the "Configure the select statement" screen (actualy does display it for half a second) but goes on the the next step.....it skips the set where I can choose table and fields etc etc.

 I am very new to this

Thanks you very much for your help

 

Joe

Hi rnojoe23,

 

From your description, I understand the Configure the Select Statement dialog switch to Test Query automatically. If there has been any misunderstanding, please let me know.

 

I tried to config DataSource with SQL Server 2000, but I could not reproduce the issue. So I would like to know what the select statement string in Test Query dialog is. It?s blank or by default a fixed string just like: select [???],[???] from [???]

 

Please try to run Visual Studio in safe mode. Visual Studio safe mode loads only the default environment and services, which disables add-ins that might be causing a problem. Run devenv /safemode in Visual Studio 2005 Command Prompt.

 

Or run devenv /setup in Visual Studio 2005 Command Prompt. /setup switch will do a reset on Visual Studio, restoring it to its initial state. Using this switch will erase some of your customizations.

 

 

---

Sincerely,
Benson Yu
Microsoft Online Community Support

Please remember to click ?Mark as Answer? on the post that helps you, and to click ?Unmark as Answer? if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.