|
yes, The server instance is running.
I found FAQ from hosting company:
Question:"Can I connect to my database remotely?"
Answer: "No, we do not allow external connections to our database servers."
So I think, it means I have to upload code to the server, then test and debug...
But before the domain name is available, I have no idea how to test it on the server. That's why I want to test and debug on my local machine.
Any suggestions? I would really appreciate it!
Thanks!
|
|
|
|
|
I am using Sql Server 2000 and Visual Studio 2005 and c#. I am have stored procedure which takes some input parameters and it has couple of output parameters
it also returns a Recordset. I am trying to get the value from the Output parameter and also the read the SqlDataReader (which says that it has some rows)
but when I try to access the value in the output parameter it says that 'new' is required to access the data.
varSqlDataReader = SqlCommandObj.ExecuteReader();
How can I get both the Output parameter value back and also the records within the same procedure is this possible
Any sample code would be helpful.
Thanks
netsurf1970
|
|
|
|
|
I have icluded an SQL database file in my application and it now uses sqlexpress to attach that and use that file. It workes good but now I have to deploy sqlexpress 2005 with my application and it requires SP2 for Windows XP. Is there any other way I can use this SQL file without forcing all the customers to install SP2?
Any help is good because I'm desperate.
--Nikola--
modified 7-Dec-20 21:01pm.
|
|
|
|
|
Get them all to install full SQL server
|
|
|
|
|
I'd love to but for some reason (I don't know why ) they don't want to.
--Nikola--
modified 7-Dec-20 21:01pm.
|
|
|
|
|
Apologies for not having a more useful answer. It's very warm in here and i may have been a bit heavy on the coffee today...
|
|
|
|
|
No problem.
--Nikola--
modified 7-Dec-20 21:01pm.
|
|
|
|
|
My O.S is windows 2000.I want to execute a function which is defined in dll.
Let ne know how to execute a function in oracle which is rsiding in a dll.
Looking forward to a reply
Manish
|
|
|
|
|
You reference the DLL in your project, then you can use the classes and other types exposed in the DLL like any other class in .NET framework.
--------------------------------------------------------
My development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
Hi all,
I want to create db in sql server 2005. Just i have gone to object explorer and in the database folder. i just right click and said new database, then i got below this error. This is the way to create new database or anyother way. please help me anyone
TITLE: Microsoft SQL Server Management Studio
----------------------------------------
Cannot show requested dialog.
----------------------------------------
ADDITIONAL INFORMATION:
Full-text is not supported on this edition of SQL Server. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft SQL Server&ProdVer=9.00.1116.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.UnsupportedFeatureException&LinkId=20476
----------------------------------------
BUTTONS:
OK
----------------------------------------
Regards,
siva
|
|
|
|
|
try and create the db using a script
create database......
create table ......
its harder but more fun and more satifiying.
Look where you want to go not where you don't want to crash.
Bikers Bible
|
|
|
|
|
-- =============================================<br />
-- Create database template<br />
-- =============================================<br />
USE master<br />
GO<br />
<br />
-- Drop the database if it already exists<br />
IF EXISTS (<br />
SELECT name <br />
FROM sys.databases <br />
WHERE name = N'<Database_Name, sysname, Database_Name>'<br />
)<br />
DROP DATABASE <Database_Name, sysname, Database_Name><br />
GO<br />
<br />
CREATE DATABASE <Database_Name, sysname, Database_Name><br />
GO
The above is from the template of the SSMS. Open a new quesry then copy the above into your query wondow. Change Database_name to the name you want for your db.
Pictures of the menu available at the drive-thru
|
|
|
|
|
how do i read data from log file when i failed to create a database in sql server.
|
|
|
|
|
Krishnatv wrote: how do i read data from log file when i failed to create a database in sql server.
What log file?
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
I have a 5 gigabyte database .
I need to backup it everynight .How can i do it for new added data only?
|
|
|
|
|
Create an incremental backup.
NOTE: You should do one complete backup each week because it will be a hassle to restore the complete plus all those incrementals if you don't and your database gets broken.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
You extract all new data to a second db with DTS and backup that database. But you need a date to view which data has been changed. If data is changing on old data then you might have issues restoring the db from these incremential changes.
Look where you want to go not where you don't want to crash.
Bikers Bible
|
|
|
|
|
hi,
if i failed to create a table in sql server in my data base then it generate
any log file for me ?
or how do i know what is the error which is cause to fail my table creation.
krishna
|
|
|
|
|
Krishnatv wrote: how do i know what is the error which is cause to fail my table creation.
SQL Server will give you an error message. That will tell you the reason it failed.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
SqlException from your front end will give those details.
|
|
|
|
|
That assumes he is using a .NET application to access the database - He didn't mention anything about .NET
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
Ya, I dint read that properly.
|
|
|
|
|
Hello,
I have a vb.net project that allows me to locally store data into a database that I have created within visual studio 2005. I would like to have a button on my form that will export the data to SQL Server 7.0? How could I accomplish this?
Will I need to setup a DTS package on SQL Server 7.0 and then run scripts from VB.net to execute it or take the data in my local tables, and dump it into a text or xml file, then export it to SQL Server?
Any suggestions is greatly appreciated.
Rashar
|
|
|
|
|
Is your local db SQL Server Express 2005 ?????
I'd use VB to update a temp table on SQL Server 7 with a time event and use a SQL V7 to sync the data.
Look where you want to go not where you don't want to crash.
Bikers Bible
|
|
|
|
|
Correct. My local db is SQL Express 2005. Not sure what you mean by "update a temp table on SQL Server 7 with a time event " ... Do you mean that when I pass the data to my local data base, time stamp the data?
Thanks,
Rashar
|
|
|
|