oleDBConnection not recognizing Database

  • Thread starter Thread starter Roger Cantillo
  • Start date Start date
R

Roger Cantillo

Hi,
I'm using oleDBConnection to connect to SQL server. I keep getting "SQL
Server does not exist" on Open event.
The code I'm using is the following
Dim objConn As New OleDbConnection("Provider=SQLOLEDB;Data
Source=sqlserver;Database=db;User Id=user;Password=user;")


Can anyone help?

Roger
 
My Data Source is a machine name. SQL server uses SQL Server and Windows
authentication.
 
Try substituting "Initial Catalog" for "Database" in your Connection String.
Example:

"Provider=sqloledb;Data Source=MachineName;Initial Catalog=Databasename;User
Id=UserName;Password=UserPassword;"

If that doesn't work, one of a couple of things could be wrong:

1. The machine name is not recognized across the network. Try using an IP
address instead. And make sure that the SQL Server is using TCP/IP
2. Your User Name and/or Password are incorrectly typed
3. Your UserName account doesn't have permission to access the database

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
The more I learn, the less I know.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

oledbConnection to SQL Server 1
Use of the connectionstring from my web.config 4
OleDbConnection via MS REMOTE -> "Specified cast is not valid. " 2
SQL Connection/Security problem 9
odbc connection 5
Getting Desparate!!! - Must declare the variable '@CategoryName'. 5
Databinding programmatically 4
DropDownList 8

Back
Top