SQL Server

[Bernard Bourée]

When I try to run SQL Server I get an error message which says that it is
not installed but it is!

How can I solve the problem ?

 

[CT]

Bernard,

How are you trying to run SQL Server, what edition it is, what is the exact
error message, and how did you install it?

 

[Bernard Bourée]

Carsten
I have the Enterprise Architect edition.
Was installed WITH the SQL Server.

I was trying to use the example supplied by MS in order to test a Data
When runing the example I got an error message " SQL Server is not installed
or the access is denied"

Thanks for your help

 

[Cor Ligthert]

Bernard,

Have a look to the connection string in that sample.
I think that most probably is that the reason.


Cor

 

[Bernard Bourée]

Cor

The connection string is
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\Northwind.mdb"

and Northwind.mdb is the same directory as the solution.

Something wrong ?

 

[Herfried K. Wagner [MVP]]

When I try to run SQL Server I get an error message which says that it is
not installed but it is!

This is a VB.NET language group. For questions on SQL Server consider
posting to one of the microsoft.public.sqlserver.* groups.

 

[Bernard Bourée]

Cor
The error occurs at the opening of the database

scnnNorthwind.Open()

 

[Leythos]

Cor

The connection string is
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\Northwind.mdb"

and Northwind.mdb is the same directory as the solution.

Something wrong ?

Yea, a MDB file has nothing to do with SQL server. The Northwind.MDB
file is a Microsoft ACCESS file.

 

[Bernard Bourée]

Herfried
Sorry!
It is fine , will do it

 

[Bernard Bourée]

Well that's the example provided by MS !!
I haven't changed anything in the code !

 

[Leythos]

Well that's the example provided by MS !!
I haven't changed anything in the code !

And if you look at the example it's clearly a MS Access example - JET,
MDB, etc....

Please fix your Usenet client (Outlook Express) - it should put your
signature at the BOTTOM of the post. As a normal Usenet reader client
does, your sig is in the wrong place and causes all items in the reply
to be clipped - it's also the NORM to bottom post in a reply.

 

[Cor Ligthert]

Bernard,

This has nothing to do with SQL server, why you say sorry, don't let you
kick of this newsgroup.

Cor

Herfried
Sorry!
It is fine , will do it

 

[Leythos]

This is a VB.NET language group. For questions on SQL Server consider
posting to one of the microsoft.public.sqlserver.* groups.

To be quite honest, since he's using VB, the question is very pertinent
to this group. Next time, look at his post, read it, and help him - it
was a mistake on his part to think it was a SQL connection, it's a MS
Access question and he needs to understand how to connect using VB
connect string.

 

[Cor Ligthert]

Bernard,

As Leythos told this is a MS-Access sample, it is as well OLEDB what not is
the nicest for SQLServer.

In this resourcekit are a lot of samples about DATA and walkthroughs.

VB.net Resource kit
http://msdn.microsoft.com/vbasic/vbrkit/default.aspx

And if you have problems installing the resource kit
http://msdn.microsoft.com/vbasic/vbrkit/faq/#installvdir

I hope this helps a little bit?

Cor

Well that's the example provided by MS !!
I haven't changed anything in the code !

 

[Bernard Bourée]

Cor

Thanks very much for your help.
I'm gpong to follow your links,
but I'm wondering why an example proved by MS is not working as it is ?

found here:
http://msdn.microsoft.com/vbasic/downloads/samples/default.aspx



--
Bernard Bourée
(e-mail address removed)

Bernard,

As Leythos told this is a MS-Access sample, it is as well OLEDB what not is
the nicest for SQLServer.

In this resourcekit are a lot of samples about DATA and walkthroughs.

VB.net Resource kit
http://msdn.microsoft.com/vbasic/vbrkit/default.aspx

And if you have problems installing the resource kit
http://msdn.microsoft.com/vbasic/vbrkit/faq/#installvdir

I hope this helps a little bit?

Cor

 

[Herfried K. Wagner [MVP]]

This is a VB.NET language group. For questions on SQL Server consider
posting to one of the microsoft.public.sqlserver.* groups.

To be quite honest, since he's using VB, the question is
very pertinent to this group. Next time, look at his post,
read it

Look at his inital post. It's 0% related to VB.NET and thus "off-topic".

 

[Herfried K. Wagner [MVP]]

This has nothing to do with SQL server, why you say sorry,
don't let you kick of this newsgroup.

The question as stated in the OP's original post was not related to VB.NET.
Period.

 

[Cor Ligthert]

Herfried,

I deleted my answer, probably you know what it was looking like.

Cor

"Herfried K. Wagner [MVP]"
...

 

[Leythos]

but I'm wondering why an example proved by MS is not working as it is ?

because there are different versions of JET, Access, and applications.
If you're going to learn programming you've got to learn enough to
modify examples, from any source, to work with your setup and system.

 

[Leythos]

Look at his inital post. It's 0% related to VB.NET and thus "off-topic".

And the post stating that this was a .Net group and not a SQL group was
at least 20 minutes after his second post where he cleared it up in a
reply to another poster. Sometimes it pays to read the rest of the
thread before replying. But, if not reading any further in the thread
before making the reply, then yes, I was wrong and his post would have
looked out of place.