About Stephen Jackson Expertise I can help with questions regarding VB.NET syntax and object references, with data interfaces and with the design and creation of robust, data aware object classes. I can also be very helpful with creating distributable applications and provide tricks and tips on .msi creation. I also have extensive experience in designing SQL Server Databases and interfacing them with VB.NET. I try to avoid web specific questions, as that is an area of expertise all its own.
Experience
Experience in the Area: I have been a programmer in Visual Basic since version 1.0 and have worked with VB.NET (which is infinitely more powerful than previous versions) since its initial release and SQL Server, both as a corporate IT professional and professional consultant. I first wrote Basic in 1976 on a TRS 80 and have worked in Visual Basic 1.0 and every subsequent release of Microsoft Visual Basic. I worked for over 7 years as a Senior Level Consultant in the area and currently hold a Project Manager position in IT.
Education and Credentials: MBA in Econometrics, 1983, University of Memphis.
BBA in Financial Management, 1982, Fogelman College of Business and Economics, University of Memphis. Microsoft Certified Professional
Areas of Special Expertise:
My specialty is the design of Object Oriented Solutions with robust, data aware object classes. I generally avoid the classic ‘Three Tier’ model as I find it redundant and cumbersome to maintain. I also specialize in the creation of ‘User Friendly’ User Interfaces which help lessen the need for user training and help prevent user error. I work best with Windows Forms based applications, and while I do work in C# as well, I prefer to limit my questions here to Windows Forms based applications created in Visual Basic.NET and SQL Server. I wil also address questions relating to the distribution and installation of Windows Forms based applications created in VB.NET.
Expert: Stephen Jackson Date: 6/2/2008 Subject: VB.Net and SQL 2000 DB
Question Hello,
I am new to vb.net and just started using the 2008 Express Edition. Could you tell how to use the 'Add new datasource' wizard, to add a sql 2000 Db (located on another machine). When I try to connect it says 'A connection was successfully established with the server, but then an error occurred during the login process (provider: Shared Memory Provider, error 0: No process at end of pipe)" My regular VB interface connects just fine, but not the VB.Net. On advance settings, I saw that the Data source is set to '\.SQLEXPRESS' and cannot be edited, does this have anything to do with...
Some advice would great!
Thanks
Answer Heidi,
First, let me apologize for taking so long to answer. My FIOS modem has been down this week and I finally got a new one 30 minutes ago!
I, like you, had nothing but trouble from the data connection wizard when I tried to use it. The problem lies with the various 'user' permissions which appear to the SQL Server. Now I have little experience in this wizard since I opt always to create my own OLEDB objects and set my own connection properties. This may not be advisable to you since you are probably new to this and likely not that experienced with SQL Server (and all of its little idiosyncrasies!)
I am afraid I can be of little help specifically with SQL Express since I have honestly never used it. I wanted to tell you this here, since I was so naughty for not getting back sooner!
You might try one of the other experts here, I know there are at least two and they are VERY smart.
