Cant connect to db......

Lasse Edsvik · Jan 20, 2004

Hello

I made a .udl file and tested its connectionstring and it worked, when i put
the connectionstring in the code it says that it is invalid? what have i
done wrong?

<%@ Page Language="vb" debug="true" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">

Sub Page_Load(sender As Object, e As EventArgs)
BindData()
End Sub

Sub BindData()
Dim conn as new
SqlConnection(ConfigurationSettings.AppSettings("Provider=SQLOLEDB.1;Persist
Security Info=False;User ID=myuser;Password=mypass;Initial Catalog=lab;Data
Source=192.168.8.5"))
const strsql as String = "myTestProc"

Dim mycomm as New SqlCommand(strsql,conn)
conn.open()

test.Datasource =
mycomm.ExecuteReader(CommandBehavior.CloseConnection)
test.Databind()

End Sub

</script>
<html>
<head>
</head>
<body>
<asp:datagrid id="test" runat="server"></asp:datagrid>
</body>
</html>

Michael · Jan 20, 2004

The ConfigurationSettings.AppSettings() call is to retrieve a value set in
the Web.Config file, like this. If this is what you are trying to do, try
this (in your Web.config file)
<configuration>

<appSettings>

<add key="ConnectionString" value="Provider=SQLOLEDB.1;Persist Security
Info=False;UserID=myuser;Password=mypass;Initial Catalog=lab;Data
Source=192.168.8.5" />

</appSettings>

....

</configuration>

Then in your code, just change it to this.

Dim conn as new
SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))

This should work,
--Michael

Lasse Edsvik · Jan 20, 2004

hmm, some progress but still error

Keyword not supported: 'provider'

i tried to remove Provider= but it whined about next one

/Lasse

Michael · Jan 20, 2004

http://www.able-consulting.com/dotnet/adonet/Data_Providers.htm

This should help you construct a valid connection string.

hmm, some progress but still error

Keyword not supported: 'provider'

i tried to remove Provider= but it whined about next one

/Lasse

Eran Amitai · Jan 20, 2004

You are using an OLEDB connection string with the SQL Server native .NET provider. Either use the OLEDB provider (the OleDbConnection class and the OleDb related classes) or use a string compatible with the SQL Server provider. You can look up the proper parameters for each provider. In particular, you will have to remove the provider and persist security info parameters.

Eran

hmm, some progress but still error

Keyword not supported: 'provider'

i tried to remove Provider= but it whined about next one

/Lasse

Dan Forster · Jan 21, 2004

Lasse,

Connection String that should work for you:

User ID=myuser;Password=mypassword;Initial Catalog=MyCat;Data
Source=Myserver

Dan

You are using an OLEDB connection string with the SQL Server native .NET
provider. Either use the OLEDB provider (the OleDbConnection class and the
OleDb related classes) or use a string compatible with the SQL Server
provider. You can look up the proper parameters for each provider. In
particular, you will have to remove the provider and persist security info
parameters.

Eran

hmm, some progress but still error

Keyword not supported: 'provider'

i tried to remove Provider= but it whined about next one

/Lasse

lucky_hemya · Jan 21, 2004

Yes, I Agree with Eran and Lasse,

Lucky_Hemya :arrow:

Guest · Jan 21, 2004

Hello,
I'm having the same problem as Lasse, and I've tried to the suggestions from Michael with no luck. When I put the

<appSettings>
<Add key="connString" Value="Server=servername;initial catalog=databasename;Uid=user;Pwd=password" /></appSettings>

right underneath the <configuration> section in web.config file I get this error message:
Parser Error Message: Unrecognized configuration section 'appSettings'

If I put the <appSetting> section in the <system.web> section of the web.config file my call
Dim cn As New SqlConnection(ConfigurationSettings.AppSettings("connString"))
returns nothing from AppSettings.

The machine.config has the appSetting section defined in the <system.web> section so that is where I thought the web.config file should have it also. At this point, I'm out of ideas, it seems like it should just work but it's not.

Jamie

Loop through record in datareader in aspx for textbox other item	1	Sep 26, 2023
Completely unable to update an access db from a datagrid	4	May 17, 2005
Connect Form to Database Insert Code	7	Mar 17, 2005
Runtime error when trying to connect to an Access DB	2	Jan 30, 2007
Display DB Records in DataList?	1	Aug 3, 2006
Image upload to Access DB in ASP.NET/VB = VOODOO WICHCRAFT REQUIRED????	13	Jun 14, 2005
Populate TextBox With DB Records	2	Oct 6, 2006
Unhandled exception error on Command object	0	Jun 19, 2006

Cant connect to db......

Lasse Edsvik

Michael

Lasse Edsvik

Michael

Eran Amitai

Dan Forster

lucky_hemya

Guest

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads