how to create sql database in visual basic

First i am newbie in vb and Sql server...

Is possible to create and attaching, via vb classic or VBA, a sql
database in this instance:\\DVD377-14D9E48C\SQLEXPRESS...
I have Sql Express.

Database name: mydatabase
Database Table: mytable

fileds:
fiedl1 text format
fiedl2 text format
fiedl3 text format
fiedl4 date format
fiedl5 number format
fiedl6 text formatFirst i am newbie in vb and Sql server...

Is possible to create and attaching, via vb classic or VBA, a sql
database in this instance:\\DVD377-14D9E48C\SQLEXPRESS...
I have Sql Express.

Database name: mydatabase
Database Table: mytable

fileds:
fiedl1 text format
fiedl2 text format
fiedl3 text format
fiedl4 date format
fiedl5 number format
fiedl6 text format

You can execute sql statement from your code...its better to read a book on vb - database programming.|||Also it's best not to be creating tables from app code.

If your app logs in as a user that has rights to create tables, then it's logging in as a user with far too many rights - usually only an admin would be allowed to create tables. So this would ONLY be acceptable to me if your app was an administrative app, such as SSMS. :)

How to create cube in sql2005?

Hi experts,

I want to create a cube using sql2005. I have read some articles which told me to create it through Visual Studio and still i cannot find where i should do that. I cannot find an "Analysis Manager" UI in sql2005 or Visual Studio. If any body could help i will really appreciate. Thanks

Hi paul_sh,

Which version of visual studio are you using now?

The "analysis manager" UI only exists in sql2000 and has migrated to Visual Studio since sql2005. Now if you want to create cubes , first open visual studio (the version should be 2003 and above), and click NewProjects. Choose project type as Bussiness Intelligence Projects and select the template of " Analysis Service Project" then click ok. After that you can edit your cube freely(note there are lots of pre-defined templates which you are make use of)

Hope my suggestion helps

How to create charts and graphs on reports?

Hi to all,

I am newbie to Reporting Services technology

I am trying to develop some reports in Reporting Services using Visual Studio Management Express.

Is there a way to create some charts and graphs inside a report?

Have I to use Report Builder?

Thanks a lot

Bye

Sure, it's quite simple actually. The trick is to get the right SQL query.

Personally, I wouldn't use report builder.

Here are the steps:

1. Create a Report Server Project from Business Intelligence Studio

2. Add a new report to the project. This can be done by opening solution explorer (View -> solution explorer). Next, right click the name of your project then Add -> New Item. Click on Report then click OK.

3. On the Data tab, you want to create a new dataset and form your SQL statement there. This can be a stored procedure or textual.

4. From the toolbox (view -> toolbox), drag and drop a chart to the grid area of the layout tab.

5. Now, you can select the type of chart and play with whatever kind of formatting you want the chart or graph to have.

6. The important thing to do next is click view -> datasets. You want to drag and drop the field(s) to the Y or X-axis as appropriate.

If you have any more questions, let us know but that should get you started.

|||

Thanks for the reply.

I will try and I will post here news about develop

thanks a lot

bye

How to create a new SQL2005 DB?

Hi folks,

i have VSTS installed and TFS beta refresh 3. all is working fine.

How can i use Visual Studio 2005 to create a new database on the remote server? i can connecto to it fine using the 'server explorer' tab .. but of course it only lists databases that currently exist. How can i create a new one?

lastly, i have no installed sql2005 express edition or whatever it is called LOCALLY on my machine. the reason i didn't do this is becuase i was hoping to use the enterprise sql 2005 server.

If your are using the SQLExpress version best thing to do is download and install the SQLExpress Management Studio CTP from microsoft. It basically gives you the same functionality that is in the full SQL2005 versions.

After running the studio and connecting to the database engine you can navigate to the databases node, right click, new, Database then begin configuring all your tables, constraints and security.

The management studio CTP can be had herehttp://www.microsoft.com/downloads/details.aspx?familyid=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en

|||

Ahh! so this Management Studio is the equivalent to the SQL CLIENT TOOLS for our sql server 2000's?

is there a Management Studio for sql2005? is it found on the sql2005 cd or do we download it?

|||The SQL Management Studio is installed by default in all versions of SQL2005, Eval, Std, Dev and Enterprise. it can be found in Start--All Programs--Microsoft SQL Server 2005--SQL Server Management Studio. The CTP version can be used to connect to any SQL2005 instance on the network. Just choose the Server/Instance from the drop down list in the Connect to Database engine dialogue or manually type the server/instance name.|||

ahh, interesting.

i installed Team Foundation Server beta refresh 3. Part of that is the SQL2005 install. I installed my SQL2005 version using the MS provided UNATTENDED INSTALL file. This file must have excluded the management studio! damn :(

that said, what about clients trying to manage a sql server, where the sqlserver is remote. Are there client tools on the SQL2005 CD?

How to covert data from visual foxpro database to SQL server

Hi,
I have my data all store in visual foxpro
database, if i want to change my database to SQL server,
how do i copy all the data in visual foxpro and save in
SQL Server Database? Thank you.We are currently taking a lot of our data from Foxpro to SQL Server. We are
only taking Data and Structure. We simply used the Foxpro drivers and
created a link to the Foxpro DB. Using DTS we sucked the Data in. The
usual things are worth looking out for like Dates but besides that we have
no real problems with it.
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"florence" <florencelee@.visualsolutions.com.my> wrote in message
news:696501c3437c$d5f33f40$a401280a@.phx.gbl...
> Hi,
> I have my data all store in visual foxpro
> database, if i want to change my database to SQL server,
> how do i copy all the data in visual foxpro and save in
> SQL Server Database? Thank you.|||The converse of this method is to create an SQL Server table to receive the
data and then create a remote view to that table on the FoxPro side. After
that you only need to APPEND FoxPro data to the view and issue a
TABLEUPDATE().
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@.mvps.org, www.cindywinegarden.com
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:e2klnp4QDHA.1564@.TK2MSFTNGP12.phx.gbl...
> We are currently taking a lot of our data from Foxpro to SQL Server. We
are
> only taking Data and Structure. We simply used the Foxpro drivers and
> created a link to the Foxpro DB. Using DTS we sucked the Data in. The
> usual things are worth looking out for like Dates but besides that we have
> no real problems with it.
> --
>
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
> "florence" <florencelee@.visualsolutions.com.my> wrote in message
> news:696501c3437c$d5f33f40$a401280a@.phx.gbl...
> > Hi,
> >
> > I have my data all store in visual foxpro
> > database, if i want to change my database to SQL server,
> > how do i copy all the data in visual foxpro and save in
> > SQL Server Database? Thank you.
>

How to copy sql express tables & stored procedures into remote full sql server 2005

Hi all,

I am using Visual web developper 2005 with sql server express 2005 and i have also sql server management studio express. it's all free now .

my web site is ready

I didn't have problem to upload my site to my hoster.

Now I want to upload all my tables and my stored procedure create locally with VWD express

How can i do it ?

NB: I know i can't design DB (create/modify tables and stored proc) with express edition

thank's for your help

Hi all,

I have my all tables and stored procedures on the remote server and my site is working well but it was very hard to.

let me resume SSMSE steps for tables:

1. Connect to local server

2. Connect to remote server

3. Create Sql file by using "Script out Create " command on the local table

4. Change connection from local to remote

5. execute your sq file to create table on the remote DB

6. Open table on remote DB

7. Open table on local DB

8. use copy/paste to copy rows from local to remote

you must do it for all table including aspnet tables when you use features like menbership, roles profiles and personalization

for stored procedures no steps 6 7 8 and you must change the name of the databases on thesql file

How to copy local sql express DB to remote full sql server 2005

Hi guys,

I am using Visual wev developper 2005 with sql server express 2005 and i have also sql server management studio express. it's all free now .

my web site is ready

I didn't have problem to upload my site to my hoster.

Now I want to upload all my tables and my stored procedure create locally with VWD express

How can i do it ?

thank's for your help

Hi all,

I have my all table on the remote server but it was very hard to.

let me resume SSMSE steps:

1. Connect to local server

2. Connect to remote server

3. Create Sql file by using "Script out Create " command on the local table

4. Change connection from local to remote

5. execute your sq file to create table on the remote DB

6. Open table on remote DB

7. Open table on local DB

8. use copy/paste to copy rows from local to remote

you must do it for all table including aspnet tables when you use features like menbership, roles profiles and personalization