Ms SQL7 linking problem

i have tried linking all my aspx scripts with ms access, they all worked,now i have switched on to ms sql7...iam not familier with the codes used for sql...my main problem is the data source syntax...in case of access i had given the file address along with extension...eg: C:\Data\Nortwind.mdb...so what should i do in case of sql... i have also given my code below

sub Page_load(sender as object, E as eventargs)

dim objconnection As sqlconnection
dim objcommand as sqlCommand
dim objadapter as sqlDataAdapter
dim objdata As DataSet
dim strsearch as String
dim sqlquery as String

strsearch = tb1.text

if Len(trim(strSearch))>0 then

objConnection = new sqlconnection("Data Source=(localhost);")

sqlquery= "select * from mayank where (name"&strsearch.ToString()&")"

objcommand = new sqlcommand(sqlquery, objconnection)

objadapter = new sqlDataAdapter(objcommand)

objdata = new DataSet()
objadapter.Fill(objdata)

DataGrid1.DataSource = objdata

DataGrid1.DataBind()

objConnection.close

Else
tb1.text= "enter your search here"
end if
end sub

Checkwww.connectionstrings.com

Regards

MS sql sever connection string

Hi everybody
Can anybody write a code and tell me how can i access a table called
KF_STATUS which is stored in MS SQL server2000. and it thas 3 fields called
KF_ID ,KF_DATE, and KF_STATUS and how can i display contents of those fields
--
Message posted via http://www.sqlmonster.comHi,
Access the table:-
1. Login to QUERY analyzer by providing the user name password
2. From the database pane, select the database where the KF_STATUS table
resides
3. Write the below query
select KF_ID ,KF_DATE, KF_STATUS FROM KF_STATUS
4. Execute the query by pressing Control and E simulteneously. This will
give u result.
THnaks
Hari
SQL Server MVP
"gurvinder gill via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in
message news:f68623ec640847c497a4e72817032580@.SQLMonster.com...
> Hi everybody
> Can anybody write a code and tell me how can i access a table called
> KF_STATUS which is stored in MS SQL server2000. and it thas 3 fields
> called
> KF_ID ,KF_DATE, and KF_STATUS and how can i display contents of those
> fields
> --
> Message posted via http://www.sqlmonster.com

MS sql sever connection string

Hi everybody
Can anybody write a code and tell me how can i access a table called
KF_STATUS which is stored in MS SQL server2000. and it thas 3 fields called
KF_ID ,KF_DATE, and KF_STATUS and how can i display contents of those fields
Message posted via http://www.droptable.comHi,
Access the table:-
1. Login to QUERY analyzer by providing the user name password
2. From the database pane, select the database where the KF_STATUS table
resides
3. Write the below query
select KF_ID ,KF_DATE, KF_STATUS FROM KF_STATUS
4. Execute the query by pressing Control and E simulteneously. This will
give u result.
THnaks
Hari
SQL Server MVP
"gurvinder gill via droptable.com" <forum@.nospam.droptable.com> wrote in
message news:f68623ec640847c497a4e72817032580@.SQ
droptable.com...
> Hi everybody
> Can anybody write a code and tell me how can i access a table called
> KF_STATUS which is stored in MS SQL server2000. and it thas 3 fields
> called
> KF_ID ,KF_DATE, and KF_STATUS and how can i display contents of those
> fields
> --
> Message posted via http://www.droptable.comsql

MS sql sever connection string

Hi everybody
Can anybody write a code and tell me how can i access a table called
KF_STATUS which is stored in MS SQL server2000. and it thas 3 fields called
KF_ID ,KF_DATE, and KF_STATUS and how can i display contents of those fields
Message posted via http://www.droptable.com
Hi,
Access the table:-
1. Login to QUERY analyzer by providing the user name password
2. From the database pane, select the database where the KF_STATUS table
resides
3. Write the below query
select KF_ID ,KF_DATE, KF_STATUS FROM KF_STATUS
4. Execute the query by pressing Control and E simulteneously. This will
give u result.
THnaks
Hari
SQL Server MVP
"gurvinder gill via droptable.com" <forum@.nospam.droptable.com> wrote in
message news:f68623ec640847c497a4e72817032580@.droptable.co m...
> Hi everybody
> Can anybody write a code and tell me how can i access a table called
> KF_STATUS which is stored in MS SQL server2000. and it thas 3 fields
> called
> KF_ID ,KF_DATE, and KF_STATUS and how can i display contents of those
> fields
> --
> Message posted via http://www.droptable.com

ms sql server; linked server; jet; mdw

hello,
is there anybody here who can tell me how to create linked server in
microsoft sql server 2000 to microsoft access database
(microsoft.jet.oledb.4.0);
but access database have own workgroup file; i don't know where to place a
path to this mdw file while creating linked server;
and maybe i should do something else to successfully connect;
access database is divided into two parts (mdb files) - one with business
login and other with data;
in order to get access to data part i should connect to business login part;
i'll be thankful for any sugestions;
regards,
krhThe following article will give you more information on how
to configure the linked server:
HOWTO: Use a SQL Server 7.0 Distributed Query with a Linked
Server to Secured Access Databases
http://support.microsoft.com/?kbid=246255
-Sue
On Thu, 18 Mar 2004 14:20:42 +0100, "Ryszard Halski"
<halley.fm@.poczta.fm> wrote:

>hello,
>is there anybody here who can tell me how to create linked server in
>microsoft sql server 2000 to microsoft access database
>(microsoft.jet.oledb.4.0);
>but access database have own workgroup file; i don't know where to place a
>path to this mdw file while creating linked server;
>and maybe i should do something else to successfully connect;
>access database is divided into two parts (mdb files) - one with business
>login and other with data;
>in order to get access to data part i should connect to business login part
;
>i'll be thankful for any sugestions;
>regards,
>krh
>

MS SQL Server View Linked into MSAccess is not updateable recordset

Hi All,
How can I link a view into MS Access from MS Sql Server, that I can update as a tabble.
Thanks
LaszloInclude the columns from a defined UNIQUE INDEX on the table in your view.

-PatP|||And the table in SQL Server MUST have a primary key defined on it, or Access will not allow you to update it.|||But, the tables have primary keys, the relationships are correct, and the view is updateable on the server, but when I link it into Access then its not work anymore. Even single linked tables (including primary key) are updateable in Access just the views not work.
I found that the one solution is making query form the linked tables in Access.

MS SQL SERVER via C programming

Hi All,

I am new in SQL world, I was wondering if it is possible to access my sql databases via C programming...perhaps through some function calls.
How to proceed with that ? Any reference or sample is welcome...!!
thanks in advance..I think that just a C++ coder would be able to give a good answer, try to post the question on the site's C++ forum too.

ms sql server response is slow

Hi ,
i have ms access client program connecting to sql server 2000 wif sp3a
running on windows 2000 server
the user is complaining that the response from the client program is slow
i have check the current activity and there's no much user connected and
there's no lock/blocking process
where could i check further to determine the cause ?
tks & rdgs
You have only begun to scrape the surface of your issue.
There is a lot more that needs to be known to pinpoint anything.
1. Is MS Access using ADO to connect, or is it using the older DAO libraries
to connect?
2. If you are calling a stored procedure, is that individual sproc slow?
Are the tables indexed correctly?
You have to understand where the issue is with the user, and observe exactly
what they are doing - maybe it is the "way" they are doing the operation?
Trace it from their point of view, backwards through the various layers down
to the database. It may be something in the MS Access VBA code that is
causing the contention.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
> Hi ,
> i have ms access client program connecting to sql server 2000 wif sp3a
> running on windows 2000 server
> the user is complaining that the response from the client program is slow
> i have check the current activity and there's no much user connected and
> there's no lock/blocking process
> where could i check further to determine the cause ?
> tks & rdgs
|||Hi,
i am connected to the SQL server via odbc ver 3.52.
the problem started when the user got the connection failed error while
running the program with SQL State HYP000
i looked into the articles for theis connection failed but it seems not
related in my case
rdgs
"news.microsoft.com" wrote:

> You have only begun to scrape the surface of your issue.
> There is a lot more that needs to be known to pinpoint anything.
> 1. Is MS Access using ADO to connect, or is it using the older DAO libraries
> to connect?
> 2. If you are calling a stored procedure, is that individual sproc slow?
> Are the tables indexed correctly?
> You have to understand where the issue is with the user, and observe exactly
> what they are doing - maybe it is the "way" they are doing the operation?
> Trace it from their point of view, backwards through the various layers down
> to the database. It may be something in the MS Access VBA code that is
> causing the contention.
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
>
>
sql

ms sql server response is slow

Hi ,
i have ms access client program connecting to sql server 2000 wif sp3a
running on Windows 2000 server
the user is complaining that the response from the client program is slow
i have check the current activity and there's no much user connected and
there's no lock/blocking process
where could i check further to determine the cause ?
tks & rdgsYou have only begun to scrape the surface of your issue.
There is a lot more that needs to be known to pinpoint anything.
1. Is MS Access using ADO to connect, or is it using the older DAO libraries
to connect?
2. If you are calling a stored procedure, is that individual sproc slow?
Are the tables indexed correctly?
You have to understand where the issue is with the user, and observe exactly
what they are doing - maybe it is the "way" they are doing the operation?
Trace it from their point of view, backwards through the various layers down
to the database. It may be something in the MS Access VBA code that is
causing the contention.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
> Hi ,
> i have ms access client program connecting to sql server 2000 wif sp3a
> running on Windows 2000 server
> the user is complaining that the response from the client program is slow
> i have check the current activity and there's no much user connected and
> there's no lock/blocking process
> where could i check further to determine the cause ?
> tks & rdgs|||Hi,
i am connected to the SQL server via odbc ver 3.52.
the problem started when the user got the connection failed error while
running the program with SQL State HYP000
i looked into the articles for theis connection failed but it seems not
related in my case
rdgs
"news.microsoft.com" wrote:

> You have only begun to scrape the surface of your issue.
> There is a lot more that needs to be known to pinpoint anything.
> 1. Is MS Access using ADO to connect, or is it using the older DAO librari
es
> to connect?
> 2. If you are calling a stored procedure, is that individual sproc slow?
> Are the tables indexed correctly?
> You have to understand where the issue is with the user, and observe exact
ly
> what they are doing - maybe it is the "way" they are doing the operation?
> Trace it from their point of view, backwards through the various layers do
wn
> to the database. It may be something in the MS Access VBA code that is
> causing the contention.
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
>
>

ms sql server response is slow

Hi ,
i have ms access client program connecting to sql server 2000 wif sp3a
running on windows 2000 server
the user is complaining that the response from the client program is slow
i have check the current activity and there's no much user connected and
there's no lock/blocking process
where could i check further to determine the cause ?
tks & rdgsYou have only begun to scrape the surface of your issue.
There is a lot more that needs to be known to pinpoint anything.
1. Is MS Access using ADO to connect, or is it using the older DAO libraries
to connect?
2. If you are calling a stored procedure, is that individual sproc slow?
Are the tables indexed correctly?
You have to understand where the issue is with the user, and observe exactly
what they are doing - maybe it is the "way" they are doing the operation?
Trace it from their point of view, backwards through the various layers down
to the database. It may be something in the MS Access VBA code that is
causing the contention.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
> Hi ,
> i have ms access client program connecting to sql server 2000 wif sp3a
> running on windows 2000 server
> the user is complaining that the response from the client program is slow
> i have check the current activity and there's no much user connected and
> there's no lock/blocking process
> where could i check further to determine the cause ?
> tks & rdgs|||Hi,
i am connected to the SQL server via odbc ver 3.52.
the problem started when the user got the connection failed error while
running the program with SQL State HYP000
i looked into the articles for theis connection failed but it seems not
related in my case
rdgs
"news.microsoft.com" wrote:
> You have only begun to scrape the surface of your issue.
> There is a lot more that needs to be known to pinpoint anything.
> 1. Is MS Access using ADO to connect, or is it using the older DAO libraries
> to connect?
> 2. If you are calling a stored procedure, is that individual sproc slow?
> Are the tables indexed correctly?
> You have to understand where the issue is with the user, and observe exactly
> what they are doing - maybe it is the "way" they are doing the operation?
> Trace it from their point of view, backwards through the various layers down
> to the database. It may be something in the MS Access VBA code that is
> causing the contention.
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
> > Hi ,
> >
> > i have ms access client program connecting to sql server 2000 wif sp3a
> > running on windows 2000 server
> >
> > the user is complaining that the response from the client program is slow
> >
> > i have check the current activity and there's no much user connected and
> > there's no lock/blocking process
> >
> > where could i check further to determine the cause ?
> >
> > tks & rdgs
>
>

MS sql server on workgroup not domain.

Hi have a small network setup and have MS sql server on workstation.
Can access it locally but cannot access it from other work stations.
I am assuming it is some sort of logon error, being it is not a
domain. Any ideas on getting by this ?Two possible issues.

One it's installed on Win XP with service pack 2. SP2 has an automatic
firewall that you will need to punch a hole through.

Two the SQL Server is configured for Windows only authentication. Since you
can access it locally you are probably a member of the local administrators
group and as such are granted sa rights by default. Windows only
authentication will not work for remote connections in a work group. You
will need to use SQL Server standard security in mixed mode.

Hope this helps,
Danny

"Father Jack Hackett" <Jachack@.rcc.org> wrote in message
news:j8r4q0djmla88go6hdbraesv6nl4n4d3cd@.4ax.com...
> Hi have a small network setup and have MS sql server on workstation.
> Can access it locally but cannot access it from other work stations.
> I am assuming it is some sort of logon error, being it is not a
> domain. Any ideas on getting by this ?|||I have been trying to set it up on a local workgroup with all XP home
edition computers, I am running into the same problem.

Lionel

On Tue, 23 Nov 2004 12:45:16 GMT, "Danny" <istdrs@.flash.net> wrote:

>Two possible issues.
>One it's installed on Win XP with service pack 2. SP2 has an automatic
>firewall that you will need to punch a hole through.
>Two the SQL Server is configured for Windows only authentication. Since you
>can access it locally you are probably a member of the local administrators
>group and as such are granted sa rights by default. Windows only
>authentication will not work for remote connections in a work group. You
>will need to use SQL Server standard security in mixed mode.
>Hope this helps,
>Danny
>
>"Father Jack Hackett" <Jachack@.rcc.org> wrote in message
>news:j8r4q0djmla88go6hdbraesv6nl4n4d3cd@.4ax.com...
>> Hi have a small network setup and have MS sql server on workstation.
>> Can access it locally but cannot access it from other work stations.
>> I am assuming it is some sort of logon error, being it is not a
>> domain. Any ideas on getting by this ?

MS SQL Server 2000 / MS Access - ODBC connection question

Hello all!

I have such question to all of you.
I have some tables linked from MS SQL Server 2000. Is time of processing
query
based on these linked tables from MS SQL Server 2000, faster or slower than
the time of processing the same query based on tables, which are not linked
but
imported to MS Access?

Can you answer this question?

Thank you in advance for posts
Marcin from Poland.No idea - it depends how big the tables are, what your queries look
like, how you execute your queries etc. If you're using stored
procedures, for example, then I would expect MSSQL to be faster, as all
the processing happens on the server, and it can use indexes, caching
etc. The best way to get an answer is simply to test it yourself.

Simon

MS SQL Migration From MS Access

Hi,

I am looking to move up from MS Access to MS SQL.

What is the maximum amount of fields allowed in a MS SQL Record?

In my Access database I have had to create a number of tables to hold the data. I would like to keep everything in one table for the MS SQL DB.

Is there any problems I should watch for regarding data types etc when I change over.

Many Thanks

Darrell...One record on SQL Server cannot keep more than 8060 bytes - of course you can use text fields, but they are not so convenient.
Question is - what kind of database do you have? OLTP, warehouse or something else? Do you need to normalize your data or denormalize?|||Hi,

I believe I am looking at a normalised access database, that I want to migrate from.

The data is currently split across 5 tables, using refrential integrity with primary key the unique id for each record.

With the 8060 bytes of data, is that just adding up the data type sizes for the maximum amount data fields or is there some kind of overhead to bear in mind?

Thanks

Darrell...|||Originally posted by Darrell
Hi,

I believe I am looking at a normalised access database, that I want to migrate from.

The data is currently split across 5 tables, using refrential integrity with primary key the unique id for each record.

With the 8060 bytes of data, is that just adding up the data type sizes for the maximum amount data fields or is there some kind of overhead to bear in mind?

Thanks

Darrell...

You can create table like this with warning that it is impossible to add record if total amount data is more than 8060 bytes:

create table mytable( id int
,code1 varchar(8000)
,code2 varchar(8000)
,code3 varchar(8000)
,code4 varchar(8000)
,code5 varchar(8000)
)

See BOL about data types.

ms sql mdf database file attached vs created on sql server

Hi all

I have a question concerning sql database mdf files. In the old days I would user a ms access database. This file would be stored with the actual web files and would utilise a dsn connection.

I have noted when designing with vwd 2005 express it allows you to use 2 methods of creating a mdf database. You can either create it as an attachment mdf or you can create it directly using sql manager.

My question is, if you create the mdf database as an attachement file can you store it in the same manner as if you where using a ms access database, meaning can you store it with the web site's files so it uses the file storage allocated size and then create a connection similar to a dsn (but for sql) to the isp's sql engine or does it have to be uploaded to the isp' s sql server.

The reason for this question is some of my customers do not want to pay the extra cost to have an sql allocation, however I do not want to go back to using old asp methods to create advanced sites as I prefer using stored procedures.

Any help will be appreciated

Hi,

you can attach your .mdf file (SQL Server Express) to a database (Attaching a .mdf file when you don't have the .ldf file available). However I think the hosting company will charge your customers for attaching it. To my knowledge you don't have a replacement available like DSN.

Grz, Kris.

|||

Hi there,

My first website I did using Visual Studio I used an sql express database. Most hosting companys only use SQL server so you'll have to do some changes to your express database to get it hosted. So it doesnt really matter which way you design your database.

The hosting company will usually place your database on a separate secure server where you'll be able to access through SQL Server Manager once you have a static IP address. I'm not sure which hosting company you use but I live in Ireland and the best company here for windows hosting iswww.blacknight.ie

I use the standard windows hosting which allows you have up to 16 websites and 16 SQL server databases. An excellent company.

I recommend if you are going to use this a lot, upgrade your package to Visual Studio pro and this includes SQL Server Developer edition which allows you to create a SQL Server 2005 database which makes it easier when you go to publish your application.

Hope this is some use to you.

Anthony

|||

Hi Kris

So what you are saying is you can attach a database to an sql server without having to import it directly. Which means the database can run externally from the sql server. My hosting company I think offers it for free if you are attaching and they have a control panel which makes it user friendly to do this by yourself. I will contact them again to verify. www.sahost.co.za

|||

Hi,

about 1,5 years ago I tried out a free hosting for ASP.NET 2.0 where you could upload a .mdf file to and in their admin pages they provided such an attach procedure. Unfortunately I don't remember their name.

Grz, Kris.

MS SQL hiding behind Access

Hi guys

We have a helpdesk application which is based on an MS SQL database, and which runs with a rather large and complicated C# based interface. We don't have the code for this, so we can't customise it. Long story short, what we want is to create an interface in Access (or similar) which accesses the same database as the helpdesk suite, and allows reading AND writing, and some rather complex operations (which SHOULD be fairly simple to do in SQL).

Unfortunately, I have been given this project, and I know about as much about Access and SQL as I do about Ghengis Khan's fashion sense.

I will follow with more information as required, but I'm going to need a lot of help with this one. First things first, is Access the way to do this? Is it going to be easier to create a new Access DB and synchronise it with the SQL, instead of both applications using the same database?

The only way I can get Access to interrogate the SQL database is to create a Data Access Page - is this the correct starting point? The only problem is that this seems to only offer HTML, and is far from being a friendly interface, at least not to me.

I know that I currently have no grounding in physics and I'm trying to build a space station, but any advice that you could give me would be much appreciated.

Thanks guys!Access is the tool if you want it done fast and you do not have a firm grounding in another programming language.

Read about Access Data Projects (.adp files).|||Hi

Agree with Thrasy thingy me bob.
You don't need to use adp but it is rather well suited for use against a SQL Server BE.
You don't need to use DAP unless you specifically want an html based interface. If you do use this you will find the forum resources at your disposal drastically reduced because they don't get used that much.

You do not want to create an Access db and synchronise with SQL Server. Either link to the server (simple) or use ADO code to create a disconnected interface (a bit complex if you are new to this but a more ideal set up).

Is this a third party product? If so then check your agreement with the supplier. You might be invalidating your agreement and they may, for example, be able to withdraw support. Also be aware that there may be some (a lot??) of business knowledge embedded in the C# FE which you will have to infer. Similarly, there are probably sprocs that enforce some validations etc for inserts and updates - you could probably do with looking at these and using them where you can.

I must say - I would be nervous about writing my own FE to an application I haven't built\ don't have access to the source code. Can you not use the C# app for inputting and limit yourself to procuding a bespoke reporting front end instead?

There is an Access forum for questions of a more access orientated nature. I think you need to prepare yourself for a very steep learning curve if you aren't familiar with Mr Kahn's clothing predelictions.|||Steep learning curves are generally the way things are done around here. My biggest problem is having to forget everything I know about Lotus Notes in order to start learning about REAL databases!!

The data access project seemed to be what I wanted - I now have an SQL database which is apparently pretending to be an Access database, so assumedly I can just forget all about SQL and work with Access forms and VB code as though this was an Access DB, is that correct?

Also, just to stop me destroying the world, is it easy to create a copy of the MS SQL DB and work with that instead, just until I know what I'm doing. If I break this database there are several peole that will be after my blood!!

In case you're wondering, the reason for this project is that the C# interface provided is fine for support staff, and works well, but unfortunately has all the customizability of a brick, and doesn't support the sales/invoicing staff very well. So we want to keep the C# interface for the support staff, but make a different one for the sales staff. Is there going to be any problem with both parties accessing the data at the same time? It is VERY unlikely that we will ever overlap on editing entities, due to the (quite) seperate nature of the two sides to the system.|||The data access project seemed to be what I wanted - I now have an SQL database which is apparently pretending to be an Access database, so assumedly I can just forget all about SQL and work with Access forms and VB code as though this was an Access DB, is that correct?Nope. I'm not too familiar with adpsbut they are really more the other way around as I understand them - they bring much of the SQL Server functionality into Access - Access becomes a sort of rudimentary SQL Server tool (as well as a UI designer).

Also, just to stop me destroying the world, is it easy to create a copy of the MS SQL DB and work with that instead, just until I know what I'm doing. If I break this database there are several peole that will be after my blood!! Oh dear lord yes do that. At the minimum have a test database where you fine tune any of your work before using it on the production database. I would suggest that using this test database indicates that you have some idea of what you are doing rather than something to dump once you can write a few lines of code. I'm not sure if it is possible to destroy the world with SQL Server though that might be one of the new features in 2005.
Gist is - you want to backup your database and then restore it (ideally on a different, dedicated server). I am afraid I use enterprise manager to create and restore backups - a bad habit I will probably be chastised for. Check out BACKUP in BoL and Google to avoid learning bad habits.

MS SQL Express 2005 Client?

hi to all,

newbie to ms sql here. i just installed the free sql express edition and i do not know what i need to access the database...

shouldn't there be a gui somewhere that shows how to create, edit, connect, to a database?

thanks in advance

Download the SQL Server Express Managment Studio: http://msdn.microsoft.com/vstudio/express/sql/download/

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||You can also use the Visual Studio Express Editions to access SQL Server Express if you already have these. Or use sqlcmd |||

hi to all,

thanks for the reply.

just finished downloading the 240 mb download!

yep, there is the client gui there.

thanks again!

phil

MS Sql Database

Hi
I have access to a MS Sql database from my webhost.
I have used MS Acces in the past and created the tables locally then uploaded the MS Access DB.
How & what do I use to connect to the MS SQL DB on my web host and how do I create tables within the DB?
I'm very new to using and trying to connect to MS Sql DB.
Thanks for any help in advance.
Cheers
kefi2927

Hi,

You would either require a SQL Client installation to connect to the Server where SQL Server exists to create Database/Tables etc.,

Else, you would require Remote Desktop Access to logon to the Server and work directly over there.

Thanks.

|||Hi
Thanks for the reply.
What utility would I use for a Remote Desktop Access.
Cheers|||Hi,
Remote Desktop Access is built-in functionality from Windows XP Professional (not sure about the Home Edition).
From START- RUN - Type "mstsc" and give ENTER. You will get the dialog for entering the IP address of the machine.
If Remote Desktop Access is enabled to the server and you are connected to the Internet, you can logon to that machine from your machine.
If you are running older versions or require Remote Desktop Client software, you can check and download fromhttp://www.microsoft.com/windowsxp/downloads/tools/rdclientdl.mspx
Thanks.

MS SQL 2005 Express covertion

How could I convert a MS SQL 2005 Express database to MS SQL 2005 or MS Access 2003? And after I convert the database should I make any changes in the source code of the site?

You need a tool (SQL Server Management Studio comes with SQL Server 2005 installation) to get this done easily with many options

If you have MS SQL Server 2005, you can connect to your Express server instance to attach your database created in MS SQL Server 2005 Express and detach it. From the SQL SERVER 2005, attach the database file you detach in Express version.

For Access 2003, you can use the Management Studio to Export to Access.

You can use the trial version to get this tool. I know there is a free version SQL Server Management Studio Express, but I cannot put on my machine to play. Besides it has limited function I need. You can try it if you don't have full sql server 2005 versionon your machine.

Hope this helps.

MS SQL 2000 on Webserver

Hi All,
I've completed my first website, and now I want to add database
functionality. I am familar with Access and VB. I have been using MS
Visual Web Dev Express to create the website.
I've bought some space with a hosting company who provide MS SQL 2000
Database functionality, and I've got MS SQL 2005 installed on my
machine.
I've managed to connect to the Web DB okay through the SQL 2005
management program, and I am able to create tables etc.
My questions are as follows:
To create tables, input data and generally administer the DB over the
internet is a slow and frustrating process. I am used to copying and
pasting with MS Access, which makes data inputting really quick because
I can use Excel to generate the data first.
1. Is there any way of creating the database on my local machine, and
then copy/sync with the web server copy? (- I am not able to remotely
create a database or use replication with the web server host, since to
create DBs I must be logged in to thier website.)
2. I ultimately intend to create a full e-commerce website, which won't
ever have as many users as say Amazon, but even so, am I right in
saying that it makes sense to create the DB in SQL 2000, since it will
be easily able to cope with heavy workloads in the future, as opposed
to me putting an Access DB on the web?
I've got some good books to help me, but none of them tackle the issues
of using a web based database system.... or am I simply using the
wrong software here'
Thanks in advance.Hi
As you are using SQL Express, then you can only be a replication subscriber
and would need standard or enterprise edition on the local system to do this
see http://www.microsoft.com/sql/prodin...e-features.mspx for
features each edition supports. An alternative may be to either
backup/restore or detach/attach the database and copy those onto the web
server. SQL express can attach databases as part of the connection see
http://www.connectionstrings.com/?carrier=sqlserver2005 so you may not need
to explicitly attach the database (just stop/start the web site). If you
don't want to stop the web site during an upgrade you may want to
restore/attach the database as a separate database and then have a process
that updates the live database from that.
HTH
John
"ginozzzz@.btclick.com" wrote:

> Hi All,
> I've completed my first website, and now I want to add database
> functionality. I am familar with Access and VB. I have been using MS
> Visual Web Dev Express to create the website.
> I've bought some space with a hosting company who provide MS SQL 2000
> Database functionality, and I've got MS SQL 2005 installed on my
> machine.
> I've managed to connect to the Web DB okay through the SQL 2005
> management program, and I am able to create tables etc.
> My questions are as follows:
> To create tables, input data and generally administer the DB over the
> internet is a slow and frustrating process. I am used to copying and
> pasting with MS Access, which makes data inputting really quick because
> I can use Excel to generate the data first.
> 1. Is there any way of creating the database on my local machine, and
> then copy/sync with the web server copy? (- I am not able to remotely
> create a database or use replication with the web server host, since to
> create DBs I must be logged in to thier website.)
> 2. I ultimately intend to create a full e-commerce website, which won't
> ever have as many users as say Amazon, but even so, am I right in
> saying that it makes sense to create the DB in SQL 2000, since it will
> be easily able to cope with heavy workloads in the future, as opposed
> to me putting an Access DB on the web?
> I've got some good books to help me, but none of them tackle the issues
> of using a web based database system.... or am I simply using the
> wrong software here'
> Thanks in advance.
>|||Thanks John, but as I mentioned in my posting, I do actually have a
full copy of MS SQL 2005 running on my machine, and I'm using it to
handle an SQL 2000 DB on my hosts website... so where does this leave
me?
Thanks|||Sorry John... I forgot to add that I don't seem to be able to copy a DB
onto the web server. I have had to create the DB online using their
management interface, and then I'm given the login details to use with
my front-end software/GUI.
Also, any ideas on why there's such a lack of information on this
subject? Are there any websites that go into depth with this kind of
databasing'|||Is there any way of creating the database on my local machine, and
then copy/sync with the web server copy?
You should be able tol use Excel to create the data as well as copy
from your 2005 to the hosted 2K server as long as as you have a DTS
package create the tables.
I am not sure if that answers your question.
Regards,
H

> Hi All,
> I've completed my first website, and now I want to add database
> functionality. I am familar with Access and VB. I have been using MS
> Visual Web Dev Express to create the website.
> I've bought some space with a hosting company who provide MS SQL 2000
> Database functionality, and I've got MS SQL 2005 installed on my
> machine.
> I've managed to connect to the Web DB okay through the SQL 2005
> management program, and I am able to create tables etc.
> My questions are as follows:
> To create tables, input data and generally administer the DB over the
> internet is a slow and frustrating process. I am used to copying and
> pasting with MS Access, which makes data inputting really quick because
> I can use Excel to generate the data first.
> 1. Is there any way of creating the database on my local machine, and
> then copy/sync with the web server copy? (- I am not able to remotely
> create a database or use replication with the web server host, since to
> create DBs I must be logged in to thier website.)
> 2. I ultimately intend to create a full e-commerce website, which won't
> ever have as many users as say Amazon, but even so, am I right in
> saying that it makes sense to create the DB in SQL 2000, since it will
> be easily able to cope with heavy workloads in the future, as opposed
> to me putting an Access DB on the web?
> I've got some good books to help me, but none of them tackle the issues
> of using a web based database system.... or am I simply using the
> wrong software here'
> Thanks in advance.|||Hi
Unless you provider gives you FTP access or possibly a VPN, then your
options are limited, for instance if FTP was possible then snapshot
replication via FTP or a manual distribution of backup/data files will be an
option.
You can read up on replication on MSDN or Books Online for example one
reference is http://msdn2.microsoft.com/en-us/library/ms151844.aspx
John
"Gee" wrote:

> Sorry John... I forgot to add that I don't seem to be able to copy a DB
> onto the web server. I have had to create the DB online using their
> management interface, and then I'm given the login details to use with
> my front-end software/GUI.
> Also, any ideas on why there's such a lack of information on this
> subject? Are there any websites that go into depth with this kind of
> databasing'
>|||Thanks to all. For the benefit of the thread... I have managed to ask
the ISP about this, and they have told me that I only have DBA rights
when I create the database online, and that I'll need to FTP the DB to
my webspace, and ask them to attach it for me.
They will not give me full rights to access the server 'for obvious
reasons'.
Ho hum......|||Hi
You are not likely to get full rights if this is a shared server, but the
cost for housing your own kit or having a dedicated server will be
significantly higher.
John
"Gee" wrote:

> Thanks to all. For the benefit of the thread... I have managed to ask
> the ISP about this, and they have told me that I only have DBA rights
> when I create the database online, and that I'll need to FTP the DB to
> my webspace, and ask them to attach it for me.
> They will not give me full rights to access the server 'for obvious
> reasons'.
> Ho hum......
>

MS SQL 2000 on Webserver

Hi All,
I've completed my first website, and now I want to add database
functionality. I am familar with Access and VB. I have been using MS
Visual Web Dev Express to create the website.
I've bought some space with a hosting company who provide MS SQL 2000
Database functionality, and I've got MS SQL 2005 installed on my
machine.
I've managed to connect to the Web DB okay through the SQL 2005
management program, and I am able to create tables etc.
My questions are as follows:
To create tables, input data and generally administer the DB over the
internet is a slow and frustrating process. I am used to copying and
pasting with MS Access, which makes data inputting really quick because
I can use Excel to generate the data first.
1. Is there any way of creating the database on my local machine, and
then copy/sync with the web server copy? (- I am not able to remotely
create a database or use replication with the web server host, since to
create DBs I must be logged in to thier website.)
2. I ultimately intend to create a full e-commerce website, which won't
ever have as many users as say Amazon, but even so, am I right in
saying that it makes sense to create the DB in SQL 2000, since it will
be easily able to cope with heavy workloads in the future, as opposed
to me putting an Access DB on the web?
I've got some good books to help me, but none of them tackle the issues
of using a web based database system.... or am I simply using the
wrong software here'
Thanks in advance.Hi
As you are using SQL Express, then you can only be a replication subscriber
and would need standard or enterprise edition on the local system to do this
see http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx for
features each edition supports. An alternative may be to either
backup/restore or detach/attach the database and copy those onto the web
server. SQL express can attach databases as part of the connection see
http://www.connectionstrings.com/?carrier=sqlserver2005 so you may not need
to explicitly attach the database (just stop/start the web site). If you
don't want to stop the web site during an upgrade you may want to
restore/attach the database as a separate database and then have a process
that updates the live database from that.
HTH
John
"ginozzzz@.btclick.com" wrote:
> Hi All,
> I've completed my first website, and now I want to add database
> functionality. I am familar with Access and VB. I have been using MS
> Visual Web Dev Express to create the website.
> I've bought some space with a hosting company who provide MS SQL 2000
> Database functionality, and I've got MS SQL 2005 installed on my
> machine.
> I've managed to connect to the Web DB okay through the SQL 2005
> management program, and I am able to create tables etc.
> My questions are as follows:
> To create tables, input data and generally administer the DB over the
> internet is a slow and frustrating process. I am used to copying and
> pasting with MS Access, which makes data inputting really quick because
> I can use Excel to generate the data first.
> 1. Is there any way of creating the database on my local machine, and
> then copy/sync with the web server copy? (- I am not able to remotely
> create a database or use replication with the web server host, since to
> create DBs I must be logged in to thier website.)
> 2. I ultimately intend to create a full e-commerce website, which won't
> ever have as many users as say Amazon, but even so, am I right in
> saying that it makes sense to create the DB in SQL 2000, since it will
> be easily able to cope with heavy workloads in the future, as opposed
> to me putting an Access DB on the web?
> I've got some good books to help me, but none of them tackle the issues
> of using a web based database system.... or am I simply using the
> wrong software here'
> Thanks in advance.
>|||Thanks John, but as I mentioned in my posting, I do actually have a
full copy of MS SQL 2005 running on my machine, and I'm using it to
handle an SQL 2000 DB on my hosts website... so where does this leave
me?
Thanks|||Sorry John... I forgot to add that I don't seem to be able to copy a DB
onto the web server. I have had to create the DB online using their
management interface, and then I'm given the login details to use with
my front-end software/GUI.
Also, any ideas on why there's such a lack of information on this
subject? Are there any websites that go into depth with this kind of
databasing'|||Is there any way of creating the database on my local machine, and
then copy/sync with the web server copy?
You should be able tol use Excel to create the data as well as copy
from your 2005 to the hosted 2K server as long as as you have a DTS
package create the tables.
I am not sure if that answers your question.
Regards,
H
> Hi All,
> I've completed my first website, and now I want to add database
> functionality. I am familar with Access and VB. I have been using MS
> Visual Web Dev Express to create the website.
> I've bought some space with a hosting company who provide MS SQL 2000
> Database functionality, and I've got MS SQL 2005 installed on my
> machine.
> I've managed to connect to the Web DB okay through the SQL 2005
> management program, and I am able to create tables etc.
> My questions are as follows:
> To create tables, input data and generally administer the DB over the
> internet is a slow and frustrating process. I am used to copying and
> pasting with MS Access, which makes data inputting really quick because
> I can use Excel to generate the data first.
> 1. Is there any way of creating the database on my local machine, and
> then copy/sync with the web server copy? (- I am not able to remotely
> create a database or use replication with the web server host, since to
> create DBs I must be logged in to thier website.)
> 2. I ultimately intend to create a full e-commerce website, which won't
> ever have as many users as say Amazon, but even so, am I right in
> saying that it makes sense to create the DB in SQL 2000, since it will
> be easily able to cope with heavy workloads in the future, as opposed
> to me putting an Access DB on the web?
> I've got some good books to help me, but none of them tackle the issues
> of using a web based database system.... or am I simply using the
> wrong software here'
> Thanks in advance.|||Hi
Unless you provider gives you FTP access or possibly a VPN, then your
options are limited, for instance if FTP was possible then snapshot
replication via FTP or a manual distribution of backup/data files will be an
option.
You can read up on replication on MSDN or Books Online for example one
reference is http://msdn2.microsoft.com/en-us/library/ms151844.aspx
John
"Gee" wrote:
> Sorry John... I forgot to add that I don't seem to be able to copy a DB
> onto the web server. I have had to create the DB online using their
> management interface, and then I'm given the login details to use with
> my front-end software/GUI.
> Also, any ideas on why there's such a lack of information on this
> subject? Are there any websites that go into depth with this kind of
> databasing'
>|||Thanks to all. For the benefit of the thread... I have managed to ask
the ISP about this, and they have told me that I only have DBA rights
when I create the database online, and that I'll need to FTP the DB to
my webspace, and ask them to attach it for me.
They will not give me full rights to access the server 'for obvious
reasons'.
Ho hum......