• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 381
  • Last Modified:

VB Error connecting to MS SQL Server 2005 Express

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
Oppital
Asked:
Oppital
  • 7
  • 6
1 Solution
 
grayeCommented:
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
 
OppitalAuthor Commented:
the problem is software
I am not able to do it communicate with the database
but using other programs can
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
grayeCommented:
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
 
OppitalAuthor Commented:
I tried the forms on this site, the ideal would be to try to find something in the code

thanks
0
 
grayeCommented:
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
 
OppitalAuthor Commented:
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
 
grayeCommented:
What kind of errors are you getting?
0
 
OppitalAuthor Commented:
Run-time error '3706'

i'm use win 7 x64
0
 
grayeCommented:
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
 
OppitalAuthor Commented:
the problem is in software that is not working on x64, no with the database
0
 
grayeCommented:
Error 3706 is all about the database provider... did you try it?
0
 
OppitalAuthor Commented:
good
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now