Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server & have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for

How Can I Manage Database On Lan Base[network Base]software

my self avi
currently i am developing one application in vb 6 and back end as
sqlserver 7 which is used on lan.
i have some problem. like in my database i have one table salesvoucher
which has 'voucherno' field. when 2-3 user will work on salesform at a
time [since the softwrae will run on lan] then the same voucherno will
save for all users data which is wrong i need to save different voucherno
for each no. is there any way in sqlserver to apply some condition on
database or to set some its property[tables] so that at a time only one
users data will save depend on firstcome first serve base or is there any
way to make changes in programme.
plz help me regarding this i need it very badly.
since its my first lan based software plz give me some books name
regarding this software for vb6 and sqlserver7

View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Base Database Implementation
I am currently looking to buy or build software that enables my firm to:

Run a set of scripts to create a base database - empty database with minimum amounts of data (i.e. lookup data and seed data). So that when a new development project begins all that is needed to build the database is to run these scripts.

The challenges we face is managing these scripts. It would be easier from a manual perspective to only have 5-6 scripts, so that we do not need to manually open and execute each script (representing an object). The problem with this is when you modify a stored procedure, you modify it in your version control platform (which is single object based) and then you need to find and replace the object in your script.

What we are looking to do is buy or build an application to manage these files for us. I was wondering if anyone has purchased a solution to accomodate this?

We currently have ApexSQL Diff - which works well to compare contents of databases (structurally it does well, seems to have a problem comparing data but that is another discussion). What it does not do well is script out an entire database, and if it were to do this, it would put it all in one file.

View Replies !   View Related
Shrink Database Base On Specific Schedule

I want to know what is command that i add to the Query Analyzer until
i tell to the database that it Shrink my DB every 1 day

I know it can be done from all Tasks > Shrink Database ..

But i want to know the Code commands for that for using in Query Analyzer


View Replies !   View Related
Shrink Database Base On Specific Schedule

I want to know what is command that i add to the Query Analyzer until
i tell to the database that it Shrink my DB every 1 day

I know it can be done from all Tasks > Shrink Database ..

But i want to know the Code commands for that for using in Query Analyzer


View Replies !   View Related
Changing The Visibility Of A Tablerow Base On Database Columns Data
I am creating a product details page that is passing the string from my products database table. I am just wondering what is the best way to filter out a column depending on the information that is in the Product_Category Column For example my database products table has the following...ProductIDProduct_NameProduct_NumberProduct_CategoryProduct_InstructionsProduct_Costetc...I want to make it so if the Product_Category = BooksThen TABLEROW with the ID of "ProductInstructions" will have a visibility of "False" 

View Replies !   View Related
How To Delete A Record In The Data Base Using Linq(sql Server 2005 Express Edition Database)
following is the code which i am trying to use
it throws an error and dosent work. 
error details:
Unable to cast object of type 'System.Data.Linq.DataQuery`1[tbl_temp_bank]' to type 'tbl_temp_bank'.
 source code(aspx.vb file)
 Dim c As New temp_business_bankDataContextDim tag = From t In c.tbl_temp_banks Where t.TIN = Convert.ToInt32(tin.Text) Select t
please can some one help me with this.thanks

View Replies !   View Related
New Data Base
I am using MS visual web developer and i get a lot of things but one
thing i do not get is why is it when i set up the web.config to a data
base i made on my own and run the website and create an account it
creates a new data base and creates that new account in that new
database, i've never opened the web admin tools.   <connectionString>   
<add name="LoginConnection" connectionString="Data
Source=.SQLEXPRESS;AttachDbFilename=&quot;C:Visual Studio
Security=True;Connect Timeout=30;User Instance=True"      providerName="System.Data.SqlClient" />  </connectionStrings>    

View Replies !   View Related
Copy Sql Base
i have base on mssql server (local machine). i want copy/create new base/table on mssql server of my hosting provider. some people tell me, that i must use Enterprise Manager, but as?

View Replies !   View Related
Default Base
Hi,On first sqlserver install, what's the default base to test connectwith JDBC please ?Is it "system" base with sa/master password ?Thanks,--Jean-Luc M.

View Replies !   View Related
bonjourje cherche a calculer des trimestre sur une année.j'ai essayé :ADD_MONTHS( date, nbmois )ADDDATE(monchamp, INTERVAL 3 MONTH)mais ca ne marche pasopenoffice base utilise quel sql ,oracle ou MySQL ou ....existe t 'il une liste de toute les commande sql valide sous openofficebase ?Merci

View Replies !   View Related
Base Guidelines
hi all
i want to know the basic guidelines for developing and implementing and developing sql server database

Thanks in Advance

Malathi Rao

View Replies !   View Related
Data Base Design-need Help
Hello friends,
i would like to create an e-commerce website,for selling music,video,games and books, i also want    to extend its functionality to electronic products also.
the problem is ,music,books,videos  and electronic goods will have different properties like author,music director,company,ISBN number,..etc,i am very confused about data base design,want to add sub categories also like light music,classical,history books,technical books etc...can anyone give suggestions?  

View Replies !   View Related
Data Base Connectivity
hi Sir,
 I want to know how to connect the Databse to ASP.Net code with c# with MSSQL servers.

View Replies !   View Related
Login And Sql Data Base
I make my login account data base using the Web Site Administration Tool in the solution explorer i then debug it on my computer  and it works fine i can login  then i upload my site and  sql data base to server and it no longer works i just get this message what do i do can i change the Web Site Administration Tool so that it uses a access data base by default for login instead of sql.Server Error in '/KRAZYJON' Application.

to generate a user instance of SQL Server due to afailure in starting
the process for the user instance. The connection will be closed.

Description: An
unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the
error and where it originated in the code.

SQLExpress database file auto-creation error:The
connection string specifies a local Sql Server Express instance using a
database location within the applications App_Data directory. The
provider attempted to automatically create the application services
database because the provider determined that the database does not
exist. The following configuration requirements are necessary to
successfully check for existence of the application services database
and automatically create the application services database:
the applications App_Data directory does not already exist, the web
server account must have read and write access to the applications
directory. This is necessary because the web server account will
automatically create the App_Data directory if it does not already
If the applications App_Data directory already exists, the web
server account only requires read and write access to the applications
App_Data directory. This is necessary because the web server account
will attempt to verify that the Sql Server Express database already
exists within the applications App_Data directory. Revoking read access
on the App_Data directory from the web server account will prevent the
provider from correctly determining if the Sql Server Express database
already exists. This will cause an error when the provider attempts to
create a duplicate of an already existing database. Write access is
required because the web server accounts credentials are used when
creating the new database.
Sql Server Express must be installed on the machine.
The process identity for the web server account must have a local
user profile. See the readme document for details on how to create a
local user profile for both machine and domain accounts.

Source Error:

An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735043 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +68[HttpException (0x80004005): Unable to connect to SQL Server database.] System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +124 System.Web.Management.SqlServices.SetupApplicationServices(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install) +86 System.Web.Management.SqlServices.Install(String database, String dbFileName, String connectionString) +25 System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString) +397

View Replies !   View Related
How To Connect Data Base In Sql

I have a problem with my data base.
when i run my project (ASP.NET)  in Vs 2005 my data base work.
but i run in localhost isn´t work.
my data base as a .mdf(sql server)
Can help-me ???

View Replies !   View Related
Data Base Encodings
Hi,I am looking to check and set the encoding of the database using sqlcommands that work both for SQL-Server and JET.something equivalent to the postgreSQL commands:'SHOW server_encoding'Thanks in advance,Maarten

View Replies !   View Related
Data Base Design
I got an assignment usig perl and xml.And I was told to design the database.I'd like to know that how one would structure the data storageand retrieval process on a site which stores a range of dataon a particular entity, keeping in mind that we may wish to add or deletefields in the future, and how the data for any one field would be returnedassuming you know the particular entity you wish to return.I do not want the code but how would u design it?I think the database storage and retrieval logic will be sameirrespective of any language .Any ideas ,do share with meByechintu

View Replies !   View Related
Base Functionality Script
Hello, everyone:

In the BOL about Designing a Backup and Restore Strategy, it is mentioned there is a Base Functionality Script that should be run after SQL Server restored. What is Base Functionality Script? Just DBCC CHECKDB? Anything else?



View Replies !   View Related
Data Base Size
So which is the biggest database you have worked with ?

View Replies !   View Related
Importing Data Base

I want to transfer (Export or Import) my Database TEST1 to TEST2.
To do so I execute the following steps :
- Create an empty Database TEST2
- Create A login TEST2USR which will be the owner of the objests in TEST2

But the owner of the User Objects in TEST1 is TEST1USR
How can i transfer my objects using (Import/Export Utility) from TEST1 to TEST2 changing the owner (From TEST1USR to TEST2USR).

View Replies !   View Related
Data Base Design
i am going to design a database for an online this data base i must write mathematics multiple question and answers.for this purpose
i must enter the values of superscript and subscript and matrices values

but i know in the table values it accepts a normal text but i need the following how i can proceed please help in this regard as early as possible

for this purpose how i can give the values to database

thnking u

gurava reddy

View Replies !   View Related
Data Base Administrator
any one could tell me about database administrator.
i want to connect oracle management server for import database of sql server 2000, i new the its
user : sysman
and also its password.
it is connected first time and i change its password
now i am trying to connect it but a msg is prompt

"VTK-1000 : Unable to connect to the management server (server name). please verify that you have entered the correct host name and the status of the oracle management server"

plz tell me as soon as possible......
i will be thanks for all....

View Replies !   View Related
Data Base Deployment
We have a client with our data base, but this database is undergoing constant changes since the development has not been finished, for that reason whenever we made an update we must synchronize the data base. I wondering if exists a tool in which setup can be created and updates the data base in SQL.

View Replies !   View Related
Restore Of D/Base From Another Server
Anybody know how to restore a backup of a database (done via a maintenance plan) from one server, to overwrite a database sited on another server. I can't manage to point it to a directory on the Server where the backup resides (I've shared the directory at NT level).

View Replies !   View Related
Copy Data Base ...
i want copy Data base fron 2 sql server2000 in the same network. so i want copy all object(table,users,diagrams,....)

View Replies !   View Related
Detach Data Base
hi i want to save evrey mounth the data base files. so i will use DTS to detch base ?
then if i detch it i can cotinu using it ?

View Replies !   View Related
Week Base Grouping

SQL Server 2000
Table_A, Col_1 datetime

I want a query to group the date on weeks.
Please advise how ?


View Replies !   View Related
Triggers For Different Data Base
Vipin writes "Hello

Can it be possible that triggers can be fired to affect tables lying in different database.

Database may be on same Machine or may be on different machine.

Explain with Example"

View Replies !   View Related
Maintain A Sql Data Base
Sebastian Garibaldi writes "Hi I'm Sebastian from Argentina, and i have a problem with a SQL data base. I receive error from data base of broken index and consistency errors. I set the fill factor with the information from the books online, i put 70 in tables that have a lot of INSERT/UPDATE/DELETE but it works for two o tree days.

I now that i must make some maintain in the database but which tools i shuld use?

here i paste an error from dbcc checktable:

Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 981108969. The text, ntext, or image node at page (1:949979), slot 52, text ID 57535781339136 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 981108969. The text, ntext, or image node at page (1:949979), slot 53, text ID 57535782191104 is not referenced.
DBCC results for 'FCRMVI'.
There are 108460 rows in 17430 pages for object 'FCRMVI'.
CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'FCRMVI' (object ID 981108969).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (ArleiProd.dbo.FCRMVI ).

thanks, and sorry my english."

View Replies !   View Related
Set Base Alternative Of Cursors?
Hey all,
I am spinning my wheels to get this thing resolved unable to do that. How can i convert this code into set based or without cursors code.

declare cursor2 cursor for
select File_Name, File_Title_Txt, Upd_Mtch_tx, UpdateInd, AddInd, DeleteInd, AnyUpdateInd from File_Object_Table
where TableName = ''' + @Table + '''
and Criteria = ''' + @Criteria + '''
and File_Title_Txt = ''' + @Title + '''

declare @File_Name varchar(50)
declare @File_Var1 varchar(50)
declare @File_Var2 varchar(500)
declare @File_Var3 bit
declare @File_Var4 bit
declare @File_Var5e bit
declare @File_Var6 bit

open cursor2
fetch next from cursor2 into @File_Name, @File_Var1, @ExtraUpdateMatch, @PullUpdate, @File_Var4, @File_Var5e, @File_Var6

WHILE (@@fetch_status = 0)

if @File_Var6 = 1
exec (''INSERT ConfirmTable SELECT ''''' + @fileId + ''''', A.UnitNbr, ''''' + @Title + ''''', '' + @File_Var1 + '', A.'' + @File_Name + '', B.'' + @File_Name + '', ''''U''''
from #tempTable A left join #tempTable B on B.UnitNbr = A.UnitNbr and B.ActivityStatusCd = ''''U'''' '' + @File_Var2+ ''
where A.ActivityStatusCd = ''''O'''' and B.ActivityStatusCd = ''''U'''''')

fetch next from mtcursor2 into @File_Name, @File_Var1, @File_Var2, @File_Var3, @File_Var4, @File_Var5e, @File_Var6

close cursor2
deallocate cursor2

View Replies !   View Related
Aggregation On Monthly Base
I need to create a report containing the headcounts of the employees for each month. The data I can retrieve from the database looks like this:





In order to get the right information for the report the information should be represented in the following way:

January 2005
February 2005
March 2005
"April" 2005




(there should be more data in the 2nd table but it's a sliced representation of the data. Sliced by 2 report parameters: startdate (=1 January 2005) and enddate (=30 April 2005)   )

I need some help about building up the query to aggregate the info from table1 to the format of table2.


View Replies !   View Related
Get A Max Value From One Table Base On Date From Another.
I have a problem where I need to join multiple tables.  Part of the query needs me to make the following relationship in a join.

Say I have a table with items, prices, and dates.



A               1.00        5/5/2000

B               3.00        1/1/2000

A               2.50         6/5/2004


This table represents an items price from the date on.  So Item 'A' costed 1.00 from 5/5/2000 through 6/5/2004, then it costed 2.50 from that day on.

Now say I have a table of transactions with items, amount bought, and dates.



A                  5             6/6/2003

A                  1             8/5/2003

A                   2            8/5/2004

The total for A should come out to be 11.00.  There are multiple Items and multiple price changes.

If someone could point out how a inner join of this nature would work it will help me in my query.  I guess the reason i say inner join is because I am joining multiple other tables to do my query.


My current Price Table has a start date and an end date and my query looks something like this.  "Select SUM(PriceTable.Price * TransactionTable.Amount) From PriceTable Inner Join TransactionTable ON TransactionTable.Date Between PriceTable.StartDate and PriceTable.EndDate AND PriceTable.Item = TransactionTable.Item".


I want something like this because the tables need to be in the format above "Select SUM(PriceTable.Price * TransactionTable.Amount) From PriceTable INNER JOIN TransactionTable ON Max(PriceTable.Date) WHERE PriceTable.Date <= TransactionTable.Date AND PriceTable.Item = TransactionTable.Item".

Hope that made sense, thanks.

View Replies !   View Related
Data Base Diagrams ...

I am relatively new to SQL 2005.
How do I create the Data Base diagrams of my existing data base in SQL 2005 ?

Abhijit Sinha

View Replies !   View Related
Need Help In Data Base Design

Hello friends,I have to design a database for banking application,but it is my first db design so i need some expert advice.

Data base has some performance constraint i.e high output ,minimum query time,need to process 2 to 5 million transaction per day.

Further specification can be revealed if appropriate help is provided.

your advice will be of great help for me.


View Replies !   View Related
Connecting To Data Base

Once we create reports on one machine, can we move those reports to another machine and work or modify from there?
Right Now I created bunch of reports based on the data base which is in my local machine.
But now How can I connect those reports to data base in prodcution server? It is not accesible right now because of the security purpose. Is there any  other alternatve way to do that? And other option is moving ReportserverDB and TemperoryDB to production server environment. How can we do that? My supervisors dont like juct backing up and resotring option.

View Replies !   View Related
Third Party Software To Manage MSDE?
Hi, it's my first time to use MSDE. So would you guys please recommend me a third party software or application which has interface to manage it? thank you!

View Replies !   View Related
Getting A Sql Data Base To Work From Expression Web
Sql date base help 1 do not  now where to start I am trying simple to run the sql database I have in expression web which I built within visual web developer 2005. I thought. I would upload it in with expression web in the website using ftp and it would run on the server. No can anybody help   the web site uses all ASP.NET pages , I have everything tested and working right on my computer, I have three simple data bases I up date through master details forms  pages I run on my computer and not on the server.The data is of names addresses, ex and I display them with a grid view control on the web site pages. I used visual web developer 2005 to do this.And I do not use ASP.NET 2.0 Membership, Role and Profile features. I tested it on a server got a server error connecting to sql server 2005. I think I need sql server 2005 installed on the server and is the sql server 2005 just a program for and to run sql data basesAt this point I’m lost.I do not know how it works Do not know anything about sql data bases other than the above.I need a simple explanation no how to get the sql data base to work on the web site and a quick explanation on how all this works. In the   Recipe: Deploying a SQL Database to a Remote Hosting Environment (Part 1) It said unfortunately there hasn't historically been a super-easy way to accomplish this. Copying the .aspx files and compiled assemblies to the remote system is pretty easy (just FTP or copy them up).  I coped the data base files by ftp but what are compiled assemblies?  The release candidate of a new SQL Server Hosting Toolkit is this, what I need and how do I use it.The toolkit allows you to work with SQL Express, SQL Server 2000, and SQL Server 2005 databases locally and then easily transfer your schema and data and install themWhat is a schema? And how do I use it to setup and recreate the database contents - both schema and data - on the remote hosted site.  Bill
Deploying a SQL data base to a server  have looked at the sql server videos from Microsoft and now can create a fantastic data base but cannot get a simple signal table data base published and running on a sql server 2005. Why is it so difficult to get help or a video or publication from Microsoft on the most important things?  What good is the most fantastic data base if you cannot get it up and running it was the same for a simple piece of script to get an asp web form to post the results of a form as an e-mail took me 3 months to scrap together the script to make it work? How this with the data base. As I have explained do not know the process never down it, first time too build and try to put a data base on a website.
If you publish to sql express all you need to do is ftp it up to the server and it will work I think.
But it’s not so simple with SQL server 2005 it’s much more complicated. So I have installed the new publishing wizard in Microsoft for visual web developer 2005 to help get it running on the server.  This was the simplest way I think. Have three data bases the data bases are so simple as they only have one table each.
Does anybody now of a video or article that explains from the start how to get a simple data base up and running no SQL server 2005 for a beginner that explains in detail the possess.

View Replies !   View Related
Error In Adding New SQL Data Base
When I try to add new item "SQL Data Base" the following error generate:
Failed to generate a user instance of SQL server due to a failure in starting the process for the user instance. The connection will be closed.
what is mean? what is its reason? how I can solved?
Please help me as soon as possible..

View Replies !   View Related
Connecting To SQL Data Base With ADODB
Hi I need help regarding ADODB Connection that i have used in connecting database in my web application, do tell me is this connection type is ok? or I need to switch to ADO.NET Connection.

View Replies !   View Related
SharePoint Data Base Access
I am not sure whether this is the place for this post.
I am developing a search functionality which is accessing data from the SQL SERVER  sharepoint portal database.
I have troubles in connecting to the particular server and retrieving each table from the database.I have succes in importing tables into Access.
I want to query the portal sql database itself and need to provide a connection string which will made the access easier.
Any suggestion or help to do would be much apprecited.
thanks in Advance.

View Replies !   View Related
Restoring Data Base From .bak File
I got a .bak file from my friendI want to restore the data base in my system(presently I don’t have any database in my system).But while I try to restore itI am getting an error“System.Data.SqlClient.SqlError: Directory lookup for the file "D:Microsoft SQL Server 2005mydatabase.mdf" failed with the operating system error 2(The system cannot find the file specified.). (Microsoft.SqlServer.Smo)â€?I have installed Microsoft sql server in a different directory not in D: where he is installedI can successfully restore the back up files of data base on my own systemBut not the backup files created from others systems

View Replies !   View Related 2.0 Data Base Connection Problem.....
we have Sql Server 2000 and Sql Server 2005 IN A SINGLE MACHINE.
when connecting with data base  Sql Server 2000 with 2.0 application ,an error occur
"Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding."
can anyone suggest any idea to solve this problem...
thanking u.

View Replies !   View Related
Can I Add A Row To A Data Base Table With VWD Express
I have a data table I have adabted for my own use and want to add a row to the table. Can I do that with Visual Web developer Express?
I can add update modify the colums and data in the exciting table but I cannot figure out how to add a row.
This is just a simple datalist of names. firstname lastname. there are 18 of them and i want to add more names

View Replies !   View Related
WTD: Data Base/Application Needed
I need some help building a data base/application for storing information. Iam using my sql as a sever application.. Email me if you can help me out onthis project and I will explain further..I do appreciate all that reply.

View Replies !   View Related
Compairing Updated Data Base.
I do not know SQL but learning fast and furious.I am programming an agent and working with a group of existing databases.I would like to able to compare the database before and after an update.The testing databases are relatively small.I have no problem programming some compare but how do I go about it.Should I do this in SQL duplicating the database.I would be happy to write some SQL and dump the databases and do the compareexternally.I would appreciate any suggestion.Andre

View Replies !   View Related
Read Only User On Data Base
I'm sure this is a really easy one but I want to create a user with read only access on a sql 2000 database using SQL authentication.

I'm building a little pilot DB system and I have a trainee developer who I want to built me some queries for crystal reports. But I dont want them to be able to amend/delete data or tables etc.

I've created the user but how to I set it to read only. Also will the user still have read only rights if the user has access to the database via enterprize manager/Query analysier.


View Replies !   View Related
Search Record Base On Date

The following is a VB code which I use it to check the existence of the record before I insert a new record
into my SQL 7.0 database. When I run the vb code, I got an error which is
"-2147217913 [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value." I couldn't figure out what's wrong with my code especially the WHERE clause.
Please help me look into this problem. TQ.

Private Sub AddDate()
Dim rstDate As ADODB.Recordset
Dim myDate As Date
Dim Criteria As String

myFileDate=#27-10-2000 16:00#
myDate = Format(myFileDate, "mm-dd-yyyy")

Criteria = "SELECT Date " _
& "FROM DateGen " _
& "WHERE Date = '" & myDate & "'"

Set rstDate = New ADODB.Recordset

With rstDate
.ActiveConnection = cn
.CursorType = adOpenDynamic
.LockType = adLockOptimistic
.Open Criteria
End With

If rstDate.RecordCount > 0 Then
RecordExist = True
RecordExist = False
rstDate("Date") = Format(myFileDate, "dd-mm-yyyy")
End If
End Sub


View Replies !   View Related

Copyright © 2005-08, All rights reserved