I have developed several applications using MS Visual Basic 6.0 SP5 using MDAC 2.7. Each of these applications use MSDE 2000 or SQL Server 2000. My applications work great on the development machines, but when I install the applications on client computers (packaged using either Visual Studio's PDW or InstallShield 6), the application fails on the connection to SQL Server. The only solution I can find for this is to install the Client Tools that are shipped with SQL Server 2000. After putting these tools on the client machines that did not work, the app runs great.
Obviously, that solution really won't work, as it is both illegal and too much hassle. I am wondering if there is a package from Microsoft or some DLLs that I need to be shipping.
Thank you,
Jay
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I am accessing the db via OLEDB, using a connection string similar to:
Provider=sqloledb;Data Source=SomeServer;Initial Catalog=SomeDB;User Id=sa;Password=;
I have MDAC 2.7 installed onto each client machine. I did come across something called the MDAC 2.7 Refresh library. It might solve my problem, but I don't have a machine with the issue right now, and haven't taken the time to set up a clean test machine.
The problem is caused because you're using Windows authentication instead of mixed authentication.
Empty passwords are bad, so I'll also explain how to change that.
When you install SQL server, you should do it with the following command line options:
setup.exe SECURITYMODE=SQL SAPWD=mypassword (use mixed authentication and set the password to "mypassword").
To change the authentication method change the following registry key:
HKEY_LOCAL_MACHINE\SOFTWAR
Changing it to 1 will use mixed authentication. Restart the server after changing this.
To change the local password, login as a local administrator, and run:
osql -E -Q "sp_password NULL,mynewpassword,sa"
Try the following function, see it works:
Sub TestADO()
Dim conn As New ADODB.Connection
Dim sConnString As String
sConnString = "Provider=SQLOLEDB; Data Source=SERVEUR2000; User ID=sa;password=mypass; Initial Catalog=master;"
Dim sQuery As String
sQuery = "SELECT name FROM master..sysdatabases"
conn.Open sConnString
Dim Rs As New ADODB.Recordset
Set Rs = conn.Execute(sQuery)
Dim sText As String
Do While Not Rs.EOF
sText = sText & Rs(0) & Chr(13)
Rs.MoveNext
Loop
Rs.Close
MsgBox sText
End Sub
taplin:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
Business Accounts
Answer for Membership
by: DustPuppy75Posted on 2003-04-16 at 14:38:37ID: 8344412
How do you access the SQL Server? If you use ODBC you should configure it as a datasource first.
Are the MDAC-libs installed on the client?