473,513 Members | 3,949 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

VB 2008 And SQL Database

Hi,

I have installed VB2008 Express a few months ago, and yesterday I was trying
to create a new program and that program requires the use of a database, so
I tried to create the SQL database, but I get an error message that tells me
that I do not have the appropriate autorisation to create an SQL database,
and I need to create it manually

How do I do that, or better yet how do I correct VB so that I can create the
database from within

--
Thank You in Advance
Merci a l'avance

Martin

Mar 1 '08 #1
6 1674
Hi,

This has nothing to do with VB, the same problem you can have with notepad,
install your SQL server in the way that you are authorisezed as user to use
it.

Cor

Mar 1 '08 #2
You might start by providing the apropriate rights

:-)

Michel

"Martin Racette" <ra*******@hotmail.comschreef in bericht
news:38**********************************@microsof t.com...
Hi,

I have installed VB2008 Express a few months ago, and yesterday I was
trying to create a new program and that program requires the use of a
database, so I tried to create the SQL database, but I get an error
message that tells me that I do not have the appropriate autorisation to
create an SQL database, and I need to create it manually

How do I do that, or better yet how do I correct VB so that I can create
the database from within

--
Thank You in Advance
Merci a l'avance

Martin

Mar 1 '08 #3
Are you running vista?

Before you run vb, try right clicking on it, and click on "run as
administrator"

If that works, that means that you installed it somehow so your regular user
does not have all the rights.

"Martin Racette" <ra*******@hotmail.comwrote in message
news:38**********************************@microsof t.com...
Hi,

I have installed VB2008 Express a few months ago, and yesterday I was
trying to create a new program and that program requires the use of a
database, so I tried to create the SQL database, but I get an error
message that tells me that I do not have the appropriate autorisation to
create an SQL database, and I need to create it manually

How do I do that, or better yet how do I correct VB so that I can create
the database from within

--
Thank You in Advance
Merci a l'avance

Martin
Mar 1 '08 #4
But it was runnig just fine in VB2005 Express, and I did not touch the
installation of SQL

"Cor Ligthert[MVP]" <no************@planet.nlwrote in message
news:50**********************************@microsof t.com...
Hi,

This has nothing to do with VB, the same problem you can have with
notepad, install your SQL server in the way that you are authorisezed as
user to use it.

Cor
--
Thank You in Advance
Merci a l'avance

Martin

Mar 2 '08 #5
And how do I do that, when I was using VB2005 Express, everything was
working fine

"Michel Posseth [MCP]" <MS**@posseth.comwrote in message
news:Os**************@TK2MSFTNGP02.phx.gbl...
You might start by providing the apropriate rights

:-)

Michel

"Martin Racette" <ra*******@hotmail.comschreef in bericht
news:38**********************************@microsof t.com...
>Hi,

I have installed VB2008 Express a few months ago, and yesterday I was
trying to create a new program and that program requires the use of a
database, so I tried to create the SQL database, but I get an error
message that tells me that I do not have the appropriate autorisation to
create an SQL database, and I need to create it manually

How do I do that, or better yet how do I correct VB so that I can create
the database from within

--
Thank You in Advance
Merci a l'avance

Martin

--
Thank You in Advance
Merci a l'avance

Martin

Mar 2 '08 #6
I'm running Vista, and whether I start it in Administrator mode or not I
still can not create a .mdf database

"Miro" <mi**@beero.comwrote in message
news:O4****************@TK2MSFTNGP05.phx.gbl...
Are you running vista?

Before you run vb, try right clicking on it, and click on "run as
administrator"

If that works, that means that you installed it somehow so your regular
user does not have all the rights.

"Martin Racette" <ra*******@hotmail.comwrote in message
news:38**********************************@microsof t.com...
>Hi,

I have installed VB2008 Express a few months ago, and yesterday I was
trying to create a new program and that program requires the use of a
database, so I tried to create the SQL database, but I get an error
message that tells me that I do not have the appropriate autorisation to
create an SQL database, and I need to create it manually

How do I do that, or better yet how do I correct VB so that I can create
the database from within

--
Thank You in Advance
Merci a l'avance

Martin
--
Thank You in Advance
Merci a l'avance

Martin

Mar 2 '08 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1762
by: fiona | last post by:
Reading, Berkshire, UK 05 June 2007 - Crainiate Software make details available of the release of Objecto Framework 2.0, an upgrade to their enterprise business component framework, designed to make it easy for programmers to create agile persisted business objects that are reusable, customisable and scalable, without additional developer...
1
3027
by: Charles Turner | last post by:
Hi guys, Hope some of you SQL database experts out there can help me, 'cos at the moment I'm going mad! I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is my own (Vista) and the other is a company laptop. I can't synchronse using a network connection between the two machines because the work laptop has all manner...
1
2955
by: shapper | last post by:
Hello, I was using LINQ with VS 2008 Beta 2 and suddenly after installed VS2008 final version I get an error. My code is really simple: Dim database As New MyDbDataContext Dim tag = (From t In database.Tags _ Where t.TagID = index).Single
1
1302
by: Steve | last post by:
Hi guys, I'm trying to upgrade TFS 2005 to TFS 2008 on a test server in preparation for upgrading our live box. However, when I run the install of 2008, I get the following error message: TF220059: An error occurred while the Setup program was querying the installation settings for Team Foundation Server. For more information about this...
5
2180
by: Robert Latest | last post by:
Here's what happens on my Windows machine (Win XP / Cygwin) at work. I've googled a bit about this problem but only found references to instances where people referred to dates before the Epoch. Of course at home on my Linux box everything works. I know that everything has its limits somewhere, but I've never heard of March 2008 being a...
2
8186
by: Ian Thompson-Bell | last post by:
I did a fair bit of VB programming many years ago (>10) and have just downloaded the free VB Express 2008. What I need is a good tutorial (preferably in pdf format) or a good book that covers VB Express 2008 in some depth but not aimed at the absolute beginner. Most of the tutorials and books I have been able to find so far are too...
5
5298
by: CAM | last post by:
Hello, I am using SQL Server Express 2008 for my database and Visual Studios 2008 - Visual Basic.Net for my forms. I Gone into VS 2008 and specify the source of data using the Data Sources Windows following the wizard. I have input the Server name using Windows Authentication, select the database name and tested the connection it works...
6
9238
by: AAaron123 | last post by:
I need to move a database from sql server 2008 to sql express 2008. Will backing up the sql server 2008 database to a file and then using that file to restore to sql express 2008 work? I don't have express on my machine so I can't simply try to see if it works. If I do do it, sql server will be on my machine and sql express will be...
2
3137
by: Pieter | last post by:
Hi, We have to make a Windows Forms application, in VS.NET 2005 or preferably 2008, with local reports (*.rdlc, not *.rdl !!), which will be shown in a Reportviewer in this application. So we won't install a Reporting Services on our SQL Server. The problem is: the source database is an SQL 2000. So the question is: will it be possible...
5
10600
by: Onetoomany | last post by:
Hi, I've just upgraded to Small Business Server 2008, 64 bit. My website, which worked perfectly before, is having issues with the connection string: I've tried: 1) sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\Website\databases\database.mdb;" 2) sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;Data
0
7270
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7178
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7397
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7543
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
4757
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3252
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
1612
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
813
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
470
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.