|
I'm having some trouble creating an index with ADOX (against MSJet as the provider).
For the life of me, I can't figure out how to make the index *unique*. Sure, there is a pIndex->PutUnique() function on the Index object, but it doesn't seem to work, since the resulting database still lists the field as "duplicates OK" when I open it in Access.
I've also tried 'pIndex->Properties("Unique")->PutValue(true)', but that only results in an exception being thrown (with some unhelpful error message). But PutValue(false) doesn't result in an error. Am I missing some prerequisites for a unique index?
If I change the index in Access to "no duplicates" and reopen the database, both the pIndex->GetUnique() and Properties("Unique")->GetValue() return true.
Any help is much appreciated.
|
|
|
|
|
Whats wrong with this:
use master
GO
CREATE DATABASE mydb3 ON FILEGROUP myfilegroup
( NAME=mydb3Data,
FILENAME='f:\mydb3Data.mdf',
SIZE=2MB,
MAXSIZE=10MB,
FILEGROWTH=1MB)
LOG ON
(NAME=mydb3Log,
FILENAME='f:\mydb3Log.mlf',
SIZE=1MB,
MAXSIZE=4MB,
FILEGROWTH=1MB)
GO
Error:
Line 1: Incorrect syntax near 'FILEGROUP'
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
Hi,
Try the following query.........
use master
GO
CREATE DATABASE mydb3 ON PRIMARY
( NAME=mydb3Data,
FILENAME='f:\mydb3Data.mdf',
SIZE=2MB,
MAXSIZE=10MB,
FILEGROWTH=1MB)
LOG ON
(NAME=mydb3Log,
FILENAME='f:\mydb3Log.mlf',
SIZE=1MB,
MAXSIZE=4MB,
FILEGROWTH=1MB)
GO
Ravi Shankar S
Programmer Analyst
iSOFT R&D Pvt Ltd
Chennai, INDIA
Ph: 91-44-4414980 Extn 1103
|
|
|
|
|
When I get the properties of my new databse in Enterprise manager in the collation names it is said:
SQL_Latin_General_CP1_CI_AS
The question is what is CP1?
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
CP1 obviously means: Codeproject is the number 1 - simply the best. 
But I think, more realistic would be Code Page 1.
|
|
|
|
|
Martin Ziacek wrote:
Code Page 1.
What does it mean? 
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
You do not believe, that's code project, do you?
Have look here: MSDN
|
|
|
|
|
In SQLServer 2000 I have a table with 25000 rows 7 columns. One of the columns is a nvarchar of 60. I need to do a substring search on that column and the performance is very poor, 3-10 seconds. The search is done by a stored procedure, for example a search for "John Doe" is implemented in SQL by a simple "LIKE %John% AND LIKE %Doe%". I need the functionality of this kind of query, but it's just too inefficient and slow.
Any suggestions or references on improving text searching using SQL would be most appreciated.
David
|
|
|
|
|
You might want to try setting up Full Text Search.
Other than that, if you're searching for "John Doe", wouldn't you want the like to look like this: LIKE '%John Doe%'
Andy Gaskell, MCSD MCDBA
|
|
|
|
|
I'd looked at Full Text Search before, but maybe I missed something... Thanks.
The LIKE statement is weird because Searching for "John Doe" is suppose to return matches like "John Jackson" and "Jane Doe". That's the only way I've found to get result.
|
|
|
|
|
Is there an index on the column? Also, what about just using LIKE %JOHN DOE% instead of LIKE %John% AND LIKE %Doe%?
|
|
|
|
|
Is there an easy way to make VS or some SQLServer tool create a script for
me that will install my application's database schema in a new, empty
database (for a new installation of the app)? Or is there a better way?
Backup/restore?
Thanks!
Steve
|
|
|
|
|
hi,
SQL Server has an inbuilt schema generation tool to create scripts
Just right click any database and choose 'Generate Scripts'. Check the options required for your deployment.
Ravi Shankar S
Programmer Analyst
iSOFT R&D Pvt Ltd
Chennai, INDIA
Ph: 91-44-4414980 Extn 1103
|
|
|
|
|
Ravi,
Thank you. I hadn't noticed it before.
However, in my Visual Studio Server Explorer, the "Generate Create Scripts" item appears in the context menu but it is disabled (grayed out). It looks like maybe I need to install the "Client Tools"? But I don't know how to find them since my SQL Server came with Visual Studio.
Any help?
Thanks again,
Steve
|
|
|
|
|
Hi
scrozier wrote:
It looks like maybe I need to install the "Client Tools"?
Visual Studio .NET Server Explorer uses the SQL Server Generate script dialog (When you click the menu, the same dialog appears as in SQL Server Enterprise Manager). So, You must have SQL Server Enterprise Manager installed in the machine that has the Visual Studio installed.
Ravi Shankar S
Programmer Analyst
iSOFT R&D Pvt Ltd
Chennai, INDIA
Ph: 91-44-4414980 Extn 1103
|
|
|
|
|
I'm using VS.NET and need to distribute MSDE (Microsoft SQL Server 2000
Desktop Engine) with an application I'm building for a client. I've read a
stack of articles and white papers about MSDE that talk all around the
issue, but nothing that deals directly with what must be a relatively simple
task. I am admittedly new to the Microsoft deployment/setup world.
Can someone point me to a source for a step-by-step for MSDE distribution?
Thanks,
Steve
|
|
|
|
|
Yes, MSDE is located on the SQL Server Developer edition or on an Office CD. All you need to do is run the Setup.exe. However, I recommend creating a Batch file to run the Setup because by default when it installs on WindowsNT it will be setup with "Windows Authentication Only" which will mess up any SQL Server Logins you have created. I have yet to find an easy way to run the Scripts after it's installed though.
|
|
|
|
|
Anonymous is correct; but he missed one location to find the setup files.
Microsoft Visual Studio .NET\Setup\MSDE.
After it is installed you should be able to run the osql command to execute scripts.
James
"Java is free - and worth every penny." - Christian Graus
|
|
|
|
|
I think the subject line just about says it all...
- DanielD
|
|
|
|
|
Greetings,
I am trying to connect to a ms access db remotely, and I keep getting a file not found error.
Does anyone know what I am doing wrong?
Here is my connection string like what I am using:
------------------------------------------------------------
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source = http://Myserverblah/somedir/mydatabase.mdb";
The file exists on the server, and I can actually download it via a browser, so
it appears that there is no apparent security problem. I have tried putting the mdb file in the root web directory, and I have tried creating a virtual directory to put the database in.
I keep getting the error below:
-------------------------------
"Source = Microsoft JET Database Engine"
"Description = Not a valid file name. "
I am new to remote database, so any ideas as to what I am doing wrong would be great.
I think it has something to do with my connection string, but I am not sure.
Thanks in advance!
|
|
|
|
|
What's the size of your project? If you are going to have more than a handful of people access this then do not use Access over the web. It's slow! The DB can't grow past 2GB and Access can't handle more than 64K rows in a table.
Bart-Man wrote:
The file exists on the server, and I can actually download it via a browser, so
it appears that there is no apparent security problem.
Never, ever, allow anyone to download your database. Move it out of a public folder pronto. But, do make sure you have write permissions for the folder the MDB is in so it can create a lock file.
Try this for your connection string...
"Provider=MS Remote; Remote Server=http://somewhere.com; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\somewhere\my.mdb;"
If you require a login to the database you can also specify User Id and Password in the connection string.
Jeremy Falcon
Imputek
<nobr>"..." - Paul Watson 07-17
|
|
|
|
|
Thanks for your reply, and your suggestions about access db and it's limitations!!!
For now I am stuck using it since only a few people use the db, and they are sticking
to access. 
Here's what I did.
------------------
1.) I moved the database from the public folder like you suggested.
2.) Checked the folder to make sure it had write permissions.
2.) Tried the connection string you provided and it worked great!!!
I can now connect to the database!! 
*3.) ++My Problem now++: I can't seem to get the recordset to do anything.
I just did a simple query of "Select * from Table1".
and I get the error "Internet Client Error: Invalid Server Response".
I checked, and "Table1" is a valid table within the database
Is this a security setting that I didn't set right?
At any rate thanks for helping me with the connection string.
|
|
|
|
|
Bart-Man wrote:
and I get the error "Internet Client Error: Invalid Server Response".
How exactly are you accessing this DB? Is it from a program or within an ASP page or what?
Bart-Man wrote:
At any rate thanks for helping me with the connection string.
No problem.
Jeremy Falcon
Imputek
<nobr>"..." - Paul Watson 07-17
|
|
|
|
|
A program...is that the problem should I use an asp page instead?
|
|
|
|
|
Bart-Man wrote:
A program...is that the problem should I use an asp page instead?
No, not at all.
Could you tell me what language you are using? RDS (what you are using) over ADO is idenpendent of language, but I'm gonna try and past a code sample for ya.
Jeremy Falcon
Imputek
<nobr>"..." - Paul Watson 07-17
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
