Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

VB Error connecting to MS SQL Server 2005 Express

Posted on 2010-08-22
13
Medium Priority
?
354 Views
Last Modified: 2013-11-25
I'm Having Trouble
I installed MS SQL 2005 Express
and created the program in vb, the code is attached
When I click "connect" or connect
appears two errors
I Do Not Know Where I'm wrong
Other programs successfully connect in sql
But my mistakes Have
someone help me?
thanks
Form1.frm.txt
Testar.vbp.txt
Testar.vbw.txt
0
Comment
Question by:Oppital
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
13 Comments
 
LVL 41

Expert Comment

by:graye
ID: 33501560
I'd check to make sure that the SQL Server 2005 Express Edition has been configured for network connectivity.   The default install does NOT enable network connection.
Take a look at the following (about 1/2 way down)
http://msdn.microsoft.com/en-US/library/ms345154(v=SQL.90).aspx 
0
 

Author Comment

by:Oppital
ID: 33501954
the problem is software
I am not able to do it communicate with the database
but using other programs can
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 41

Expert Comment

by:graye
ID: 33502272
Take a look at these example connection strings...  The express edition typically has an "instance name" of SQLEXPRESS
http://www.connectionstrings.com/sql-server-2005 
0
 

Author Comment

by:Oppital
ID: 33502491
I tried the forms on this site, the ideal would be to try to find something in the code

thanks
0
 
LVL 41

Expert Comment

by:graye
ID: 33503340
Well, we don't really have much to go on, since we can't see what values are being used to build the connection string.
Here is what I'd guess would be the correct connection string:
    SQL = "Provider=SQLNCLI;Data Source=" & Servidor.Text & "\SQLEXPRESS; Initial Catalog=" & BancoDados.Text & ";Password=" & Senha.Text & ";User ID=" & Login.Text & ";"
0
 

Author Comment

by:Oppital
ID: 33507421
I found the solution
ip: xxxx \ SQLEXPRESS
and found new problem
how to make a vb6 program that connects to a database
ms sql server 2005 express
that runs on x84
run on computers with x64 windows 7?
0
 
LVL 41

Expert Comment

by:graye
ID: 33509834
What kind of errors are you getting?
0
 

Author Comment

by:Oppital
ID: 33511835
Run-time error '3706'

i'm use win 7 x64
0
 
LVL 41

Accepted Solution

by:
graye earned 1500 total points
ID: 33512410
OK, it looks like you need to install the 64-bit version of SQL Server 2005 "Native Client" on that PC
http://msdn.microsoft.com/en-us/library/ms131321(SQL.90).aspx 
0
 

Author Comment

by:Oppital
ID: 33514230
the problem is in software that is not working on x64, no with the database
0
 
LVL 41

Expert Comment

by:graye
ID: 33515132
Error 3706 is all about the database provider... did you try it?
0
 

Author Closing Comment

by:Oppital
ID: 34174814
good
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question