Visual Basic .net 2003 Standard & SQL Server Problems

VB.NET

    Sponsored Links

    Next

  • 1. Display form before main form
    Hi, I would like to display a form (to add registration information) before the main form loads obviously I would like to place this inside an IF statement as I dont need to register every single time the program is started. I do not want the main form to be seen prior to sucessfu completion of the registration form. Can anyone suggest a method to do this? and can anyone tell me what I need to look for on google to find the relevant information? I believe its called a splash screen, but havent been able to find out how to do this with VB.net Yours gratefully David
  • 2. Outlook AdvancedSearch crashing with COMException
    I am posting this here since I don't see an Outlook programming group specific to .net but only VBA. Please let me know if I'll have better luck posting elsewhere. I am writing a VB.NET application that interfaces with Outlook 2003 via Microsoft.Office.Interop.Outlook.dll. I am calling AdvancedSearch which with some folder scopes works fine, but with others crashes with an unhelpful error of: System.Runtime.InteropServices.COMException (0xF9B7064F): The operation failed. Which is thrown at the call of AdvancedSearch. If I specify a scope of Inbox or 'Inbox' it works fine and searches my Inbox. If I search for a folder name that doesn't exist I get the above mentioned error. If I search for any valid sub folder though, I also get the same error. It makes no difference how I quote the folder name or if I use the full path. Sometimes however, and I can't determine what makes a difference, it works as it should. Any ideas what this is? I can verify that my connection to outlook is fine since I can read messages and folder contents, just search is failing. Thank you for any suggestions.. - Matt
  • 3. What is VB express 2005
    What is the future of VB express? We're doing an app in VB2003 and like some of the VB controls in VS2005. Is VB Express a serious product? Let's face it, the price makes me wonder? Free is never forever ;) I don't have an issue with buying VB2005, but I don't see it. What's with the express version? Is it another way of saying betazoid? Will usoft support those of use that use VB express when VB2005 comes out? Thanks,

Visual Basic .net 2003 Standard & SQL Server Problems

Postby Microsoft » Sun, 13 Feb 2005 05:45:32 GMT

his is a multi-part message in MIME format.


Hi,

I have Visual Basic .net 2003 (Standard Edition) & SQL Server 2000 Developer Edition. When trying to create a connection in the server explorer from the .net IDE I get a number of problems;
a.. Under the "Connection" tab, under "1. Select or enter a server name:" when I either select the drop down box or click the refresh button I get an error dialog saying "Error enumerating data servers. Enumerator reports Unspecified error'". The dialog caption is "Microsoft Data Link Error". Strangely "3. Select the database on the server:" does actually list the databases on my default instance and the "Test Connection" button results in "Test connection succeeded".
b.. If I ignore the error above and click on "OK" I get the following error message "Unable to connect to database. It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access databases with this version of Visual Studio". The dialog caption is "Server Explorer". I can't actually find any details of such a restriction in the online documentation and this link 'http://msdn.microsoft.com/vbasic/productinfo/features/default.aspx' says "Unless otherwise noted, all of the features listed below are available in every member of the Visual Studio family product line which enables Visual Basic .NET development including: Visual Basic .NET 2003 Standard..." without any such exclusion noted against "Using ADO.NET, Visual Basic .NET developers can gain high-speed access to Microsoft SQL ServerT, Oracle, DB2, Microsoft Access, and more".
Has anyone else had these problems - I have searched online and can't find anything about either. Any help would be much appreciated.

Barry-Jon
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2604" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have Visual Basic .net 2003 (Standard Edition)
& SQL Server 2000 Developer Edition.  When trying to create a
connection in the server explorer from the .net IDE I get a number of
problems;</FONT></DIV>
<UL>
<LI><FONT face=Arial size=2>Under the "Connection" tab, under "1. Select or
enter a server name:" when I either select the drop down box or click the
refresh button I get an error dialog saying "Error enumerating data
servers.  Enumerator reports Unspecified error'".  The dialog
caption is "Microsoft Data Link Error".  Strangely "3. Select the
database on the server:" does actually list the databases on my default
instance and the "Test Connection" button results in "Test connection
succeeded".</FONT></LI>
<LI><FONT face=Arial size=2>If I ignore the error above and click on "OK" I
get the following error message "Unable to connect to database.  It is
only possible to connect to SQL Server Desktop Engine databases and Microsoft
Access databases with this version of Visual Studio".  The dialog caption
is "Server Explorer".  I can't actually find any details of such a
restriction in the online

Re: Visual Basic .net 2003 Standard & SQL Server Problems

Postby Herfried K. Wagner [MVP] » Sun, 13 Feb 2005 06:01:17 GMT

Barry,

"Microsoft" < XXXX@XXXXX.COM > schrieb:
  b.. If I ignore the error above and click on "OK" I get the following 
error message "Unable to connect to database.  It is only possible to 
connect to SQL Server Desktop Engine databases and Microsoft Access 
databases with this version of Visual Studio".  The dialog caption is 
"Server Explorer".  I can't actually find any details of such a restriction 
in the online documentation and this link 
' http://www.**--****.com/ '

I don't know exactly where this restrictions are documented, but they are 
true.  You can only access MSDE or Microsoft Access databases with the 
Server Explorer in Visual Basic .NET Standard.

-- 
 M S   Herfried K. Wagner
M V P  <URL: http://www.**--****.com/ ;
 V B   <URL: http://www.**--****.com/ ; 


Re: Visual Basic .net 2003 Standard & SQL Server Problems

Postby Peter van der Goes » Sun, 13 Feb 2005 07:24:38 GMT

his is a multi-part message in MIME format.



"Microsoft" < XXXX@XXXXX.COM > wrote in message news: XXXX@XXXXX.COM ...
Hi,

I have Visual Basic .net 2003 (Standard Edition) & SQL Server 2000 Developer Edition. When trying to create a connection in the server explorer from the .net IDE I get a number of problems;
a.. Under the "Connection" tab, under "1. Select or enter a server name:" when I either select the drop down box or click the refresh button I get an error dialog saying "Error enumerating data servers. Enumerator reports Unspecified error'". The dialog caption is "Microsoft Data Link Error". Strangely "3. Select the database on the server:" does actually list the databases on my default instance and the "Test Connection" button results in "Test connection succeeded".
b.. If I ignore the error above and click on "OK" I get the following error message "Unable to connect to database. It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access databases with this version of Visual Studio". The dialog caption is "Server Explorer". I can't actually find any details of such a restriction in the online documentation and this link 'http://msdn.microsoft.com/vbasic/productinfo/features/default.aspx' says "Unless otherwise noted, all of the features listed below are available in every member of the Visual Studio family product line which enables Visual Basic .NET development including: Visual Basic .NET 2003 Standard..." without any such exclusion noted against "Using ADO.NET, Visual Basic .NET developers can gain high-speed access to Microsoft SQL ServerT, Oracle, DB2, Microsoft Access, and more".
Has anyone else had these problems - I have searched online and can't find anything about either. Any help would be much appreciated.

Barry-Jon

And, as you can download MSDE free,

http://www.microsoft.com/downloads/details.aspx?familyid=413744d1-a0bc-479f-bafa-e4b278eb9147&displaylang=en

then use the GUI tools that come with your SQL Server Developer Edition to create and manage databases on your MSDE instance, you should have no difficulties with your VB .NET database projects.

--
Peter [MVP Visual Developer]
Jack of all trades, master of none.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2604" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Microsoft" <<A
href="mailto: XXXX@XXXXX.COM "> XXXX@XXXXX.COM </A>>
wrote in message <A
href="news: XXXX@XXXXX.COM ">news: XXXX@XXXXX.COM </A>...</DIV>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have Visual Basic .net 2003 (Standard Edition)
& SQL Server 2000 Developer Edition.  When trying to create a
connection in the server explorer from the .net IDE I get a number of
problems;</FONT></DIV>
<UL>
<LI><FONT face=Ar

Re: Visual Basic .net 2003 Standard & SQL Server Problems

Postby Barry Jon » Sun, 13 Feb 2005 12:41:04 GMT

his is a multi-part message in MIME format.


Thanks Peter,

I uninstalled MSDE 2000 prior to installing SQL Server 2000 Developer
Edition. I then found I could not use Developer Edition with Visual Basic
..net Standard Edition and tried to reinstall MSDE. The MSDE installation seems
to go fine but when the Service Manager loads is tells me "Not Connected -
\\" no servers are in the Server drop-down and no services are listed in
the Services drop-down. I am very new to all of this and would very much
appreciate any help/advice you could offer. I then uninstalled
Developer Edition to no avail and tried again and have now reinstalled developer edition and still no joy. I am running Windows XP Pro. What am I doing wrong?

Barry Jon
"Peter van der Goes" < XXXX@XXXXX.COM > wrote in message news:eStK$ XXXX@XXXXX.COM ...

"Microsoft" < XXXX@XXXXX.COM > wrote in message news: XXXX@XXXXX.COM ...
Hi,

I have Visual Basic .net 2003 (Standard Edition) & SQL Server 2000 Developer Edition. When trying to create a connection in the server explorer from the .net IDE I get a number of problems;
a.. Under the "Connection" tab, under "1. Select or enter a server name:" when I either select the drop down box or click the refresh button I get an error dialog saying "Error enumerating data servers. Enumerator reports Unspecified error'". The dialog caption is "Microsoft Data Link Error". Strangely "3. Select the database on the server:" does actually list the databases on my default instance and the "Test Connection" button results in "Test connection succeeded".
b.. If I ignore the error above and click on "OK" I get the following error message "Unable to connect to database. It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access databases with this version of Visual Studio". The dialog caption is "Server Explorer". I can't actually find any details of such a restriction in the online documentation and this link 'http://msdn.microsoft.com/vbasic/productinfo/features/default.aspx' says "Unless otherwise noted, all of the features listed below are available in every member of the Visual Studio family product line which enables Visual Basic .NET development including: Visual Basic .NET 2003 Standard..." without any such exclusion noted against "Using ADO.NET, Visual Basic .NET developers can gain high-speed access to Microsoft SQL ServerT, Oracle, DB2, Microsoft Access, and more".
Has anyone else had these problems - I have searched online and can't find anything about either. Any help would be much appreciated.

Barry-Jon

And, as you can download MSDE free,

http://www.microsoft.com/downloads/details.aspx?familyid=413744d1-a0bc-479f-bafa-e4b278eb9147&displaylang=en

then use the GUI tools that come with your SQL Server Developer Edition to create and manage databases on your MSDE instance, you should have no difficulties with your VB .NET database projects.

--
Peter [MVP Visual Developer]
Jack of all trades, master of none.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2604" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Thanks Peter,</FONT>&

Re: Visual Basic .net 2003 Standard & SQL Server Problems

Postby Peter van der Goes » Sun, 13 Feb 2005 22:33:46 GMT

his is a multi-part message in MIME format.



"Barry Jon" < XXXX@XXXXX.COM > wrote in message news: XXXX@XXXXX.COM ...
Thanks Peter,

I uninstalled MSDE 2000 prior to installing SQL Server 2000 Developer
Edition. I then found I could not use Developer Edition with Visual Basic
.net Standard Edition and tried to reinstall MSDE. The MSDE installation seems
to go fine but when the Service Manager loads is tells me "Not Connected -
\\" no servers are in the Server drop-down and no services are listed in
the Services drop-down. I am very new to all of this and would very much
appreciate any help/advice you could offer. I then uninstalled
Developer Edition to no avail and tried again and have now reinstalled developer edition and still no joy. I am running Windows XP Pro. What am I doing wrong?

Barry Jon
I'm not sure you're doing anything wrong, but perhaps the instructions we use for classroom/lab installs of MSDE to work with Visual Studio .NET 2003 will be helpful:
<quote>
1. Before you begin, check the PC to ensure there are no remnants of prior MSDE installation attempts{*filter*} around. The place to check is: C:\Program Files\Microsoft SQL Server. If you locate a folder named Microsoft SQL Server, delete it and its contents!



2. Execute the file: SQL2KDeskSP3.exe(or whatever the file name for your MSDE download is). This step will extract the contents of the file to a designated folder. Make a note of the destination folder. You'll need it later. This step does not install MSDE (although the dialogs seem to hint that it does)!



4. Navigate to the folder you created in Step 2. In that folder, you will find a subfolder named MSDE. In MSDE, you will find SETUP.EXE. Executing SETUP.EXE will install MSDE.



5. To execute SETUP.EXE correctly, you must supply an instance name and a system administrator password as part of the command: i.e. the command must be:



SETUP.EXE INSTANCENAME="NetSDK" SAPWD="yourSAPassword"



where yourSAPassword is your actual system administrator password. This password is needed only to install MDSE, not to use it. Access to MSDE is controlled by normal "NT Security" which should allow users access based on network logon and password. It is very important the the INSTANCENAME parameter be NetSDK, as this name will enable you to generate the sample databases automatically instead of having to run SQL scripts from the command line.



6. Once installation is complete, you must reboot the PC before you will see MSDE. After the reboot, you should see the MSDE icon in SysTray.



7. You now must execute the file: ConfigSamples.exe to configure sample applications and MSDE system databases. This step will also create user databases in the following location: C:\Program Files\Microsoft SQL Server\MSSQL\Data.

</quote>



If you have trouble locating the ConfigSamples.exe, it's a small file (56k) and I can send it to your email if needed.



Hope this helps.


--
Peter [MVP Visual Developer]
Jack of all trades, master of none.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2604" name=GENERATOR>
<STYLE></STYLE>
</HEAD&

Re: Visual Basic .net 2003 Standard & SQL Server Problems

Postby Peter van der Goes » Sun, 13 Feb 2005 22:53:18 GMT

his is a multi-part message in MIME format.



"Peter van der Goes" < XXXX@XXXXX.COM > wrote in message news: XXXX@XXXXX.COM ...

"Barry Jon" < XXXX@XXXXX.COM > wrote in message news: XXXX@XXXXX.COM ...
Thanks Peter,

I uninstalled MSDE 2000 prior to installing SQL Server 2000 Developer
Edition. I then found I could not use Developer Edition with Visual Basic
.net Standard Edition and tried to reinstall MSDE. The MSDE installation seems
to go fine but when the Service Manager loads is tells me "Not Connected -
\\" no servers are in the Server drop-down and no services are listed in
the Services drop-down. I am very new to all of this and would very much
appreciate any help/advice you could offer. I then uninstalled
Developer Edition to no avail and tried again and have now reinstalled developer edition and still no joy. I am running Windows XP Pro. What am I doing wrong?

Barry Jon
I'm not sure you're doing anything wrong, but perhaps the instructions we use for classroom/lab installs of MSDE to work with Visual Studio .NET 2003 will be helpful:
<quote>
1. Before you begin, check the PC to ensure there are no remnants of prior MSDE installation attempts{*filter*} around. The place to check is: C:\Program Files\Microsoft SQL Server. If you locate a folder named Microsoft SQL Server, delete it and its contents!



2. Execute the file: SQL2KDeskSP3.exe(or whatever the file name for your MSDE download is). This step will extract the contents of the file to a designated folder. Make a note of the destination folder. You'll need it later. This step does not install MSDE (although the dialogs seem to hint that it does)!



4. Navigate to the folder you created in Step 2. In that folder, you will find a subfolder named MSDE. In MSDE, you will find SETUP.EXE. Executing SETUP.EXE will install MSDE.



5. To execute SETUP.EXE correctly, you must supply an instance name and a system administrator password as part of the command: i.e. the command must be:



SETUP.EXE INSTANCENAME="NetSDK" SAPWD="yourSAPassword"



where yourSAPassword is your actual system administrator password. This password is needed only to install MDSE, not to use it. Access to MSDE is controlled by normal "NT Security" which should allow users access based on network logon and password. It is very important the the INSTANCENAME parameter be NetSDK, as this name will enable you to generate the sample databases automatically instead of having to run SQL scripts from the command line.



6. Once installation is complete, you must reboot the PC before you will see MSDE. After the reboot, you should see the MSDE icon in SysTray.



7. You now must execute the file: ConfigSamples.exe to configure sample applications and MSDE system databases. This step will also create user databases in the following location: C:\Program Files\Microsoft SQL Server\MSSQL\Data.

</quote>



If you have trouble locating the ConfigSamples.exe, it's a small file (56k) and I can send it to your email if needed.



Hope this helps.


--
Peter [MVP Visual Developer]
Jack of all trades, master of none.



Arrrgh!

Pay no attention to the skip in step numbers. The missing step was specific to our lab

Similar Threads:

1.visual basic.net standard 2003 (ado.net)

2.How to connect VB .NET 2003 STANDARD to SQL Server Desktop engine

I purchased Visual Basic .NET version 2003 Standard

I first try to connect Visual Basic .NET 2003 Standard to SQL Server
2000 Personal edition. When I go into Visual Basic .NET under Server
Explorer and try to add the connection, I received the following
message "Unable to connect to database.  It is only possible to
connect to SQL Server Desktop Engine databases and Microsoft Access
Databases with this version of Visual Studio."

Then I download the SQL Server Desktop Engine and install it. I think
the installation is ok because osql commend works under DOS. Now, I
can not find it in the Server Explorer. How can I connect Visual Basic
.NET 2003 Standard to SQL Server Desktop Engiee?

Very very confusion. Please help.

3.Connecting VB.net 2003 standard and SQL Server

I received a copy of VB.NET 2003 standard from Microsoft as part of a 
promotion by viewing ASP.NET webcasts. Included was an ASP training CD and 
"ASP.NET Programming with Visual Basic.NET" by G. Andrew Duthie. 

From all I can tell it is a full *standard* version.... not something 
gimped. Yet when I try creating a data connection and point it to SQL Server 
a message comes back telling me that it is ".....unable to connect and that 
this version of Visual Studio can only use the SQL Server Desktop Edition and 
MS Access as data sources....".

What?!?!?!!?

They sent me this copy with training materials that are using full SQL 
Server databases, not desktop editions. So I cant use the software they 
provide to actually *do* the exercises? 

Perhaps this is a bug? Perhaps I am doing something wrong? Can anyone help 
me out?

As a side note, I reveiwed the VB.Net 2003 product page and looked at their 
comparison between the standard and professional versions and nowhere can I 
find it saying that you can only connect to SQL Server DE and MS Access with 
the standard edition. In fact it is even misleading because it says you can 
upgrade old vb apps with the standard edition.... what they should have said 
is that you can upgrade old database apps as long as they use SQL Server DE 
or MS Access as a datasource!

Any help, advice, clarification and direction would be greatly appreciated!!

Dec

4.VB.Net 2003 standard connecting to SQL Server

I received a copy of VB.NET 2003 standard from Microsoft as part of a 
promotion by viewing ASP.NET webcasts. Included was an ASP training CD and 
"ASP.NET Programming with Visual Basic.NET" by G. Andrew Duthie. 

From all I can tell it is a full *standard* version.... not something 
gimped. Yet when I try creating a data connection and point it to SQL Server 
a message comes back telling me that it is ".....unable to connect and that 
this version of Visual Studio can only use the SQL Server Desktop Edition and 
MS Access as data sources....".

What?!?!?!!?

They sent me this copy with training materials that are using full SQL 
Server databases, not desktop editions. So I cant use the software they 
provide to actually *do* the exercises? 

Perhaps this is a bug? Perhaps I am doing something wrong? Can anyone help 
me out?

As a side note, I reveiwed the VB.Net 2003 product page and looked at their 
comparison between the standard and professional versions and nowhere can I 
find it saying that you can only connect to SQL Server DE and MS Access with 
the standard edition. In fact it is even misleading because it says you can 
upgrade old vb apps with the standard edition.... what they should have said 
is that you can upgrade old database apps as long as they use SQL Server DE 
or MS Access as a datasource!

Any help, advice, clarification and direction would be greatly appreciated!!

Dec

5.VB .Net 2003 Standard,SQL Server 2002 Connection

I cannot connect to an instance of SQL server 2000 with my current version on Visual Studio.  Error message sounds like I didn't spend enough money.  Anyone know what I need to do to be able to establish a connection?

6. Visual basic.net Standard 2003 update failure

7. Visual Basic .net standard 2003

8. Free Copy of Visual Basic .NET 2003 Standard Edition



Return to VB.NET

 

Who is online

Users browsing this forum: No registered users and 96 guest