Problem connecting to SQL Server

[bob]

Can anyone help me connect to SQL Server???

I am new to all this... it is been a titanic struggle consuming hours &

days & ....

I am trying to create an SQL database programatically . But my code
stalls before it gets started, and can't establish a connection to SQL
Server.
Here is my code:

=============== =============== =============== ===========

Sub MakeDatabase()
Dim cn As New SqlConnection, cmd As New SqlCommand
Dim connect$, sql$

connect$ = "Data Source=(local); Integrated Security=SSPI;
Initial Catalog=;"
cn.ConnectionSt ring = Connect$

Try
cn.Open()
Catch ae As SqlException
MsgBox(ae.Messa ge.ToString, MsgBoxStyle.Cri tical, "SQL
Connection")
Exit Sub
End Try

sql$ = "CREATE DATABASE Cf"

cmd.Connection = cn
cmd.CommandText = sql$
cmd.ExecuteNonQ uery()

cn.Close()
End Sub

This thing stalls and can't connect, giving me an error #5. The error
message suggest that my installed SQL might not allow "remote access".
But I checked and it does. I am using VB 2005 Express and SQL 2005
Express.

[pvdg42]

<bo*@datasync.c om> wrote in message
news:11******** **************@ g10g2000cwb.goo glegroups.com.. .

Can anyone help me connect to SQL Server???

I am new to all this... it is been a titanic struggle consuming hours &

days & ....

I am trying to create an SQL database programatically . But my code
stalls before it gets started, and can't establish a connection to SQL
Server.
Here is my code:

=============== =============== =============== ===========

Sub MakeDatabase()
Dim cn As New SqlConnection, cmd As New SqlCommand
Dim connect$, sql$

connect$ = "Data Source=(local); Integrated Security=SSPI;
Initial Catalog=;"
cn.ConnectionSt ring = Connect$

Try
cn.Open()
Catch ae As SqlException
MsgBox(ae.Messa ge.ToString, MsgBoxStyle.Cri tical, "SQL
Connection")
Exit Sub
End Try

sql$ = "CREATE DATABASE Cf"

cmd.Connection = cn
cmd.CommandText = sql$
cmd.ExecuteNonQ uery()

cn.Close()
End Sub

This thing stalls and can't connect, giving me an error #5. The error
message suggest that my installed SQL might not allow "remote access".
But I checked and it does. I am using VB 2005 Express and SQL 2005
Express.

Try replacing the "(local)" in your connection string with either
"<machinename>\ SqlExpress", or ".\SqlExpre ss".

Here, SQL 2005 Express installs a named instance, using the name SqlExpress.
If your SQL Server instance is anonymous, don't add the \SqlExpress.
Also had issues here with (local). Replacing (local) with either of the
above fixed the connection.

[Kerry Moorman]

Bob,

When you installed SQL Server 2005 Express did you take the default of
installing a named instance? (The install wants to create a named instance
named SQLExpress).

If so, then try changing the data source in the connect string to:

Data Source=(local)\ SQLExpress;

Kerry Moorman

"bo*@datasync.c om" wrote:

Can anyone help me connect to SQL Server???

I am new to all this... it is been a titanic struggle consuming hours &

days & ....

I am trying to create an SQL database programatically . But my code
stalls before it gets started, and can't establish a connection to SQL
Server.
Here is my code:

=============== =============== =============== ===========

Sub MakeDatabase()
Dim cn As New SqlConnection, cmd As New SqlCommand
Dim connect$, sql$

connect$ = "Data Source=(local); Integrated Security=SSPI;
Initial Catalog=;"
cn.ConnectionSt ring = Connect$

Try
cn.Open()
Catch ae As SqlException
MsgBox(ae.Messa ge.ToString, MsgBoxStyle.Cri tical, "SQL
Connection")
Exit Sub
End Try

sql$ = "CREATE DATABASE Cf"

cmd.Connection = cn
cmd.CommandText = sql$
cmd.ExecuteNonQ uery()

cn.Close()
End Sub

This thing stalls and can't connect, giving me an error #5. The error
message suggest that my installed SQL might not allow "remote access".
But I checked and it does. I am using VB 2005 Express and SQL 2005
Express.

[Cor Ligthert [MVP]]

Bob,

Have a look at this sample on our website.

http://www.vb-tips.com/default.aspx?...1-d6dda3c888c8

I think there is more in than you need, but the information you can use.

You are the first one who uses still sql$ by the way in these newsgroups and
I have seen much.

There is nothing wrong with that, however as written tomorrow by GhostAD,
you don't write a program for the computers, write it to let others know
what you are doing.

I hope this helps,

Cor

<bo*@datasync.c om> schreef in bericht
news:11******** **************@ g10g2000cwb.goo glegroups.com.. .

Can anyone help me connect to SQL Server???

I am new to all this... it is been a titanic struggle consuming hours &

days & ....

I am trying to create an SQL database programatically . But my code
stalls before it gets started, and can't establish a connection to SQL
Server.
Here is my code:

=============== =============== =============== ===========

Sub MakeDatabase()
Dim cn As New SqlConnection, cmd As New SqlCommand
Dim connect$, sql$

connect$ = "Data Source=(local); Integrated Security=SSPI;
Initial Catalog=;"
cn.ConnectionSt ring = Connect$

Try
cn.Open()
Catch ae As SqlException
MsgBox(ae.Messa ge.ToString, MsgBoxStyle.Cri tical, "SQL
Connection")
Exit Sub
End Try

sql$ = "CREATE DATABASE Cf"

cmd.Connection = cn
cmd.CommandText = sql$
cmd.ExecuteNonQ uery()

cn.Close()
End Sub

This thing stalls and can't connect, giving me an error #5. The error
message suggest that my installed SQL might not allow "remote access".
But I checked and it does. I am using VB 2005 Express and SQL 2005
Express.

[Cor Ligthert [MVP]]

Doh,

How I did think it was access is almost unbelievable reading the text again.

http://www.vb-tips.com/default.aspx?...a-6680e677e994

Sorry

Cor

<bo*@datasync.c om> schreef in bericht
news:11******** **************@ g10g2000cwb.goo glegroups.com.. .

Can anyone help me connect to SQL Server???

I am new to all this... it is been a titanic struggle consuming hours &

days & ....

I am trying to create an SQL database programatically . But my code
stalls before it gets started, and can't establish a connection to SQL
Server.
Here is my code:

=============== =============== =============== ===========

Sub MakeDatabase()
Dim cn As New SqlConnection, cmd As New SqlCommand
Dim connect$, sql$

connect$ = "Data Source=(local); Integrated Security=SSPI;
Initial Catalog=;"
cn.ConnectionSt ring = Connect$

Try
cn.Open()
Catch ae As SqlException
MsgBox(ae.Messa ge.ToString, MsgBoxStyle.Cri tical, "SQL
Connection")
Exit Sub
End Try

sql$ = "CREATE DATABASE Cf"

cmd.Connection = cn
cmd.CommandText = sql$
cmd.ExecuteNonQ uery()

cn.Close()
End Sub

This thing stalls and can't connect, giving me an error #5. The error
message suggest that my installed SQL might not allow "remote access".
But I checked and it does. I am using VB 2005 Express and SQL 2005
Express.

[bob]

Thanks! That was the problem all along.
pvdg42 wrote:

<bo*@datasync.c om> wrote in message
news:11******** **************@ g10g2000cwb.goo glegroups.com.. .

Can anyone help me connect to SQL Server???

I am new to all this... it is been a titanic struggle consuming hours &

days & ....

I am trying to create an SQL database programatically . But my code
stalls before it gets started, and can't establish a connection to SQL
Server.
Here is my code:

=============== =============== =============== ===========

Sub MakeDatabase()
Dim cn As New SqlConnection, cmd As New SqlCommand
Dim connect$, sql$

connect$ = "Data Source=(local); Integrated Security=SSPI;
Initial Catalog=;"
cn.ConnectionSt ring = Connect$

Try
cn.Open()
Catch ae As SqlException
MsgBox(ae.Messa ge.ToString, MsgBoxStyle.Cri tical, "SQL
Connection")
Exit Sub
End Try

sql$ = "CREATE DATABASE Cf"

cmd.Connection = cn
cmd.CommandText = sql$
cmd.ExecuteNonQ uery()

cn.Close()
End Sub

This thing stalls and can't connect, giving me an error #5. The error
message suggest that my installed SQL might not allow "remote access".
But I checked and it does. I am using VB 2005 Express and SQL 2005
Express.

Try replacing the "(local)" in your connection string with either
"<machinename>\ SqlExpress", or ".\SqlExpre ss".

Here, SQL 2005 Express installs a named instance, using the name SqlExpress.
If your SQL Server instance is anonymous, don't add the \SqlExpress.
Also had issues here with (local). Replacing (local) with either of the
above fixed the connection.

[bob]

That must have been it -- using the default during the SQL Server
Express install. Frankly, when I installed it I didn't really know
exactly what was going on... This is my first engagement/battle with
Sql Server.

Thanks so much.
Bob
Kerry Moorman wrote:

Bob,

When you installed SQL Server 2005 Express did you take the default of
installing a named instance? (The install wants to create a named instance
named SQLExpress).

If so, then try changing the data source in the connect string to:

Data Source=(local)\ SQLExpress;

Kerry Moorman

"bo*@datasync.c om" wrote:

Can anyone help me connect to SQL Server???

I am new to all this... it is been a titanic struggle consuming hours &

days & ....

I am trying to create an SQL database programatically . But my code
stalls before it gets started, and can't establish a connection to SQL
Server.
Here is my code:

=============== =============== =============== ===========

Sub MakeDatabase()
Dim cn As New SqlConnection, cmd As New SqlCommand
Dim connect$, sql$

connect$ = "Data Source=(local); Integrated Security=SSPI;
Initial Catalog=;"
cn.ConnectionSt ring = Connect$

Try
cn.Open()
Catch ae As SqlException
MsgBox(ae.Messa ge.ToString, MsgBoxStyle.Cri tical, "SQL
Connection")
Exit Sub
End Try

sql$ = "CREATE DATABASE Cf"

cmd.Connection = cn
cmd.CommandText = sql$
cmd.ExecuteNonQ uery()

cn.Close()
End Sub

This thing stalls and can't connect, giving me an error #5. The error
message suggest that my installed SQL might not allow "remote access".
But I checked and it does. I am using VB 2005 Express and SQL 2005
Express.

[bob]

Cor, I'm not sure I understand you about still using "sql$". Anyway, I
got the problem fixed, and thanks for the help.

Bob
Cor Ligthert [MVP] wrote:

Bob,

Have a look at this sample on our website.

http://www.vb-tips.com/default.aspx?...1-d6dda3c888c8

I think there is more in than you need, but the information you can use.

You are the first one who uses still sql$ by the way in these newsgroups and
I have seen much.

There is nothing wrong with that, however as written tomorrow by GhostAD,
you don't write a program for the computers, write it to let others know
what you are doing.

I hope this helps,

Cor

<bo*@datasync.c om> schreef in bericht
news:11******** **************@ g10g2000cwb.goo glegroups.com.. .

Can anyone help me connect to SQL Server???

I am new to all this... it is been a titanic struggle consuming hours &

days & ....

I am trying to create an SQL database programatically . But my code
stalls before it gets started, and can't establish a connection to SQL
Server.
Here is my code:

=============== =============== =============== ===========

Sub MakeDatabase()
Dim cn As New SqlConnection, cmd As New SqlCommand
Dim connect$, sql$

connect$ = "Data Source=(local); Integrated Security=SSPI;
Initial Catalog=;"
cn.ConnectionSt ring = Connect$

Try
cn.Open()
Catch ae As SqlException
MsgBox(ae.Messa ge.ToString, MsgBoxStyle.Cri tical, "SQL
Connection")
Exit Sub
End Try

sql$ = "CREATE DATABASE Cf"

cmd.Connection = cn
cmd.CommandText = sql$
cmd.ExecuteNonQ uery()

cn.Close()
End Sub

This thing stalls and can't connect, giving me an error #5. The error
message suggest that my installed SQL might not allow "remote access".
But I checked and it does. I am using VB 2005 Express and SQL 2005
Express.

[Cor Ligthert [MVP]]

Bob,

When I had sent my both messages and had read the answers from Peter and
Kerry I saw as well the answer to your problem.

For that there was no need for me to sent another message. Your code is
however in a very personal style: good readable probably by VB diehards, but
not as we see code today. That was what I did mean with my text about the
mystring$. To say it in other words the old literals are not so common
anymore.

In my opinion( but not mine alone) is one of the first commands to create a
program using a program language as VBNet, is to make it maintainable by
others.

Cor

<bo*@datasync.c om> schreef in bericht
news:11******** *************@y 43g2000cwc.goog legroups.com...

Cor, I'm not sure I understand you about still using "sql$". Anyway, I
got the problem fixed, and thanks for the help.

Bob
Cor Ligthert [MVP] wrote:

Bob,

Have a look at this sample on our website.

http://www.vb-tips.com/default.aspx?...1-d6dda3c888c8

I think there is more in than you need, but the information you can use.

You are the first one who uses still sql$ by the way in these newsgroups
and
I have seen much.

There is nothing wrong with that, however as written tomorrow by GhostAD,
you don't write a program for the computers, write it to let others know
what you are doing.

I hope this helps,

Cor

<bo*@datasync.c om> schreef in bericht
news:11******** **************@ g10g2000cwb.goo glegroups.com.. .

> Can anyone help me connect to SQL Server???
>
> I am new to all this... it is been a titanic struggle consuming hours &
>
> days & ....
>
> I am trying to create an SQL database programatically . But my code
> stalls before it gets started, and can't establish a connection to SQL
> Server.
> Here is my code:
>
> =============== =============== =============== ===========
>
> Sub MakeDatabase()
> Dim cn As New SqlConnection, cmd As New SqlCommand
> Dim connect$, sql$
>
> connect$ = "Data Source=(local); Integrated Security=SSPI;
> Initial Catalog=;"
> cn.ConnectionSt ring = Connect$
>
> Try
> cn.Open()
> Catch ae As SqlException
> MsgBox(ae.Messa ge.ToString, MsgBoxStyle.Cri tical, "SQL
> Connection")
> Exit Sub
> End Try
>
> sql$ = "CREATE DATABASE Cf"
>
> cmd.Connection = cn
> cmd.CommandText = sql$
> cmd.ExecuteNonQ uery()
>
> cn.Close()
> End Sub
>
> This thing stalls and can't connect, giving me an error #5. The error
> message suggest that my installed SQL might not allow "remote access".
> But I checked and it does. I am using VB 2005 Express and SQL 2005
> Express.
>

[bob]

Cor,

I'm glad you brought that up -- I am just in love with those "old
literals". I guess you mean by that that

Dim sql as String

is preferred to

Dim sql$

I think the last form is so much better. Especially when you see people
doing this:

Dim strSql

See what I mean?

(A lot of people must like the "sql$" approach, because I notice that
MS (after threatening to drop this capability) kept it in VB.NET all
the way through VB.NET 2005.
Cor Ligthert [MVP] wrote:

Bob,

When I had sent my both messages and had read the answers from Peter and
Kerry I saw as well the answer to your problem.

For that there was no need for me to sent another message. Your code is
however in a very personal style: good readable probably by VB diehards, but
not as we see code today. That was what I did mean with my text about the
mystring$. To say it in other words the old literals are not so common
anymore.

In my opinion( but not mine alone) is one of the first commands to create a
program using a program language as VBNet, is to make it maintainable by
others.

Cor

<bo*@datasync.c om> schreef in bericht
news:11******** *************@y 43g2000cwc.goog legroups.com...

Cor, I'm not sure I understand you about still using "sql$". Anyway, I
got the problem fixed, and thanks for the help.

Bob
Cor Ligthert [MVP] wrote:

Bob,

Have a look at this sample on our website.

http://www.vb-tips.com/default.aspx?...1-d6dda3c888c8

I think there is more in than you need, but the information you can use.

You are the first one who uses still sql$ by the way in these newsgroups
and
I have seen much.

There is nothing wrong with that, however as written tomorrow by GhostAD,
you don't write a program for the computers, write it to let others know
what you are doing.

I hope this helps,

Cor

<bo*@datasync.c om> schreef in bericht
news:11******** **************@ g10g2000cwb.goo glegroups.com.. .
> Can anyone help me connect to SQL Server???
>
> I am new to all this... it is been a titanic struggle consuming hours &
>
> days & ....
>
> I am trying to create an SQL database programatically . But my code
> stalls before it gets started, and can't establish a connection to SQL
> Server.
> Here is my code:
>
> =============== =============== =============== ===========
>
> Sub MakeDatabase()
> Dim cn As New SqlConnection, cmd As New SqlCommand
> Dim connect$, sql$
>
> connect$ = "Data Source=(local); Integrated Security=SSPI;
> Initial Catalog=;"
> cn.ConnectionSt ring = Connect$
>
> Try
> cn.Open()
> Catch ae As SqlException
> MsgBox(ae.Messa ge.ToString, MsgBoxStyle.Cri tical, "SQL
> Connection")
> Exit Sub
> End Try
>
> sql$ = "CREATE DATABASE Cf"
>
> cmd.Connection = cn
> cmd.CommandText = sql$
> cmd.ExecuteNonQ uery()
>
> cn.Close()
> End Sub
>
> This thing stalls and can't connect, giving me an error #5. The error
> message suggest that my installed SQL might not allow "remote access".
> But I checked and it does. I am using VB 2005 Express and SQL 2005
> Express.
>