|
Can you please write the connection string?? ( one example please..)
|
|
|
|
|
There's a list in the code project
http://www.codeproject.com/database/connectionstrings.asp
|
|
|
|
|
hi
I am making a software that will handle a database of 5 crore records. Please help me how to handle these many records. How should I design the database?
shelly
|
|
|
|
|
hunjan wrote:
a database of 5 crore records.
I'm not sure how you mean - 5 core records of what ? If you gave a little more info, perhaps we could make a suggestion. What's a federated server ? How is that part of the DB design ? What are you storing exactly ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
The only reliable way to tell what level of hardware you need to run on is to load test your application. Proper design and indexing can typically make a performance difference of 10-100x. So a well designed and implemented system can easly run on a tenth of the hardware of a poorly designed one.
BTW I've worked on non-federated SQL servers with billion row tables and thousands of concurrent users and as long as we kept everything well tuned we didn't have any problems.
I can imagine the sinking feeling one would have after ordering my book,
only to find a laughably ridiculous theory with demented logic once the book arrives - Mark McCutcheon
|
|
|
|
|
I tried to install MSDE on windows XP but the installation near the end and its Rollback , i tried to install Server service but its already installed and running i tried to check File and Prenter Sharing but it is installed and running , how could i pass this problem i am using MSDE whtch came inside SQl Standard Edition CD
agmb
|
|
|
|
|
Probably there was a previous installation of SQL Server/MSDE that was uninstalled. When SQL Server is uninstalled, databases are not deleted. Check C:\Program Files\Microsoft SQL Server for existance, and delete everything in it.
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005
|
|
|
|
|
i am using VB 6 as front-end and SQL Server 2000 as back-end, we have one web site that having database to store the daily activities of the marketing executives.
i've to connect my VB6 forms to database which is in the net and generate the reports. im using ADO as database connectivity. How to connect my ADO connetion object to web database. what will be the connection string
|
|
|
|
|
Hi, ajith,
Best practice to put your database on the web is using ASP(Active Server Pages) which runs on the VBScript.
Since , I do not know any way to connect VB forms on the web, I can assure, ASP will do all the job for you.
There is no different connection string..
You need a IIS server, SQL Server. I advice you to install IIS and then type "http://localhost/" in the URL ( Address bar in Internet explorer). You will get ASP help. You need to read manual for ADO also, refer MSDN.
Best way to connect using a ODBC connection,
So set up a ODBC connection for your SQL Server - Database(Ex: DSN=testSQL)
Create Coonection as follows
<%
Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DSN=testSQL",<username>,<password>
Rs = Server.CreateObject("ADODB.Resultset")
Rs.Open SQL,Conn,3,3,1
'''''''''''''''''' Do your work
Rs.Close
Conn.Close
Happy programming
love2code
|
|
|
|
|
With SQL Server 2000, I can execute the following SQL command:
select * from table1 select * from table2
The output contains two record sets, one for each select statement. But if I do this with Oracle or MS Access (via ODBC connections), I got syntax errors. The question is, what is the correct way to execute a SQL command with two or more select statements? Is it supported by Oracle? Is there a way to get around it?
Thanks.
P.S. I know the problem is not with ODBC itself because I can do this with SQL Server 2000 via ODBC connection.
My articles and software tools
|
|
|
|
|
you have to use ';' character to separate SQL statements
TOXCCT >>> GEII power [toxcct][VisualCalc]
|
|
|
|
|
toxcct wrote:
you have to use ';' character to separate SQL statements
Thanks. I tried it, did not work. I also tried "\n" and "\r\n" without success.
My articles and software tools
|
|
|
|
|
if both tables are identical, you can use
'Select * from tab1
UNION
Select * from tab2'
in fact you can use the UNION statement whenever querys return a identical resultset.
dirk
|
|
|
|
|
|
hi everyone,
ım using .net and sql server 2005, ı have a report project and this project have parameters.think that like "primary school" and "high school fields". sometimes, ı want to filter outputs with two parameters, and sometimes ı want to filter with just one parameter. thats the time that ı have problems. when ı pass only a parameter, ı want that this report doesnt care with the second parameter. but, it understands it (param1=something_ı_want, param2=null). then it searches for null values in second parameter and as an output, ı have nothing.
do you know how can ı fix that problem, how can ı say to this report "dont care with second parameter, ı only ask for first one"?
thanks for your help,
Ali Sapancı
|
|
|
|
|
i think u r using crystal report,better you pass recordset to the report at runtime. At run time you can frame your SQL as you want and create the recordset and assign that record set to the report. that will be very flexible than using the parameters in report
|
|
|
|
|
it is not my decision, ım in an internship now and that is what they want
|
|
|
|
|
hi all,
I have a field which name is Information
and it type is Varchar (8000),but some time data access than 8000 character, my client told me,make this field to store Unlimited data.
So how can i achive this task, i m using VS 2003 (ASP.NET with VB.NET) with SQL 2000.
Thanks
Shally
|
|
|
|
|
Look up ntext, text and image in SQL books online. These types will let you store data blobs limited only by the storage space on the server. They do have limits on the types of queries you can run on them so make sure they fit your needs.
I can imagine the sinking feeling one would have after ordering my book,
only to find a laughably ridiculous theory with demented logic once the book arrives - Mark McCutcheon
|
|
|
|
|
|
Thanks.
I can imagine the sinking feeling one would have after ordering my book,
only to find a laughably ridiculous theory with demented logic once the book arrives - Mark McCutcheon
|
|
|
|
|
|
Hi All,
I wanna store " ' " in data base ....for e.g,
"father's" or "isn't",
i m using VS 2003 with SQL Server 2000..
so how can i achive this task
Thanx
Sajjad
|
|
|
|
|
Use an ADO.Net parameter to pass the data in rather then building the SQL dynamically. If you have to build dyanmic sql, '' gets translated to ', so 'father''s' is stored as father's. This is typically done with a call to Replace("'", "''")
|
|
|
|
|
thanx for reply...
but i wanna store in database ' father's ' not ' father"s '
i think u understand my point..
thanx
|
|
|
|