|
I have just put together a Windows 2003 x64 Server for a client. Our intent is to move an application that is currently on a Windows 2000 server. It uses an Access 2003 front end and connects via ODBC to a mysql database. When we go to the 64 bit server everything is screwed up.
mysql finally released mysql 5.0 binaries for Windows x64. However, after creating an ODBC datasource we get "Access encountered an unexpected error and shutdown...." this happens if both Access and mysql are on the 64 bit machine or if only mysql is on 64 bit and Access and ODBC datasource is on 32 bit Win 2000.
I also tried using Maxdb. I got that installed and it works from the command line. However none of the GUI tools work on 64 bit Windows. Furthermore, I can put a few records into a table to test. Opening the table via Access and ODBC is ok but if you try to delete a record Access just hangs. When you force a shutdown of Access and reopen the desired record has been deleted. Again this happens if everything is on 64 bit machine or 64 bit for backend and 32 bit for front end.
Help! and Thanks!
Scott
|
|
|
|
|
Hi, I am using ADO 2.81 with C++ 6.
In my program I have a datagrid which is filled with data from adodatacontrol. Whenever i select a different row, my app needs to display information about it. The problem is, I can't find in which row the user clicked...
Is there any code that can help me?
i am trying to put it in the function:
void CMyDlg::RowColChangeDatagrid(VARIANT* LastRow, short LastCol)
here lastRow shows the last row clicked not the present.
I tried with dataGrid.get_Row();
this works fine if I dont scrool the data grid. But if I do so, it gives me the same informations (like I am not scrolling)
PLS help
|
|
|
|
|
hi ,
i want ot update multiple rows in the sqlserver2005 database by calling a single procedure from the frontend (ASP.NET). I m passing an xml string to stored procedure for that.
Table name is UnicomUser, UnicomUserId is rowID for which updation is to be done, status is the column to be updated
The procedure written is:
CREATE PROC UnicomUI_DistrubutionGroupAdmin_ApproveUser
@UnicomUserId varchar(500)-- string containing xml tags passed as parameters
AS
DECLARE @hDoc int
exec sp_xml_preparedocument @hDoc OUTPUT,@UnicomUserId
UPDATE UnicomUser
SET
UnicomUser.status = 4
FROM OPENXML(@hDoc,'/items/item')
WITH UnicomUser XMLUser
WHERE UnicomUser.UnicomUserId = XMLUser.UnicomUserId
EXEC sp_xml_removedocument @hDoc
It is executing but not updating.
Another thing, it it runs ok, then will it update all the rows at one hit or cursors is required to navigate thru the rows.
Is there anyother way to achieve the target
thanx
sandeep
|
|
|
|
|
hai guys,
in my webform contains two textboxs(TexBox1,TexBox2)and a button also.
when i click a button that input will add to my dabase's table.
i am using c# coding in asp.net.my backend is sqlserver?
i am using ado.net to connect the databse to open.it's fine.
but how can i add/insert the input data to the table by c# progrmming?
i need the code
solv my probs...
vm.kumaar
|
|
|
|
|
SqlCommand InsertCommand = new SqlCommand();
InsertCommand.Connection = cnn;//ur SqlConnection;
string sql;
sql = "INSERT INTO TABLE VALUES ('"+textbox1.text + "','" +"+textbox2.text +"')";
InsertCommand.CommandText = sql;
try
{
cnn.Open();
InsertCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
finally
{
cnn.Close();
}
_____________________
Proud to be Albanian
_____________________
|
|
|
|
|
Hi, I'm using Visio, used "Reverse Engineering" to generate an ERD diagram from database. I edited the diagram and wanted to generate C# code. For instance, I want table "User" maps to "User.cs", how can I do this? Thanks.
|
|
|
|
|
I use CodeSmith[^] to do that type of thing in one step. If you use the .Netiers template, it will generate all of your code and NUnit tests for it all too.
Steve Maier, MCSD MCAD
|
|
|
|
|
Thanks, but I just want to generate setters/getters from ERD or database schema, no DAL needed:
class User {<br />
<br />
protected int _UIN;<br />
...<br />
<br />
public void SetUIN(int value) {<br />
_UIN = value;<br />
);<br />
<br />
public int GetUIN() {<br />
return _UIN;<br />
}<br />
<br />
... more getters/setters ...<br />
<br />
}
Is there such tools?
Norman Fung
|
|
|
|
|
You're just writing your own DAL... I find having it generated for me easier.
Steve Maier, MCSD MCAD
|
|
|
|
|
Thanks Steve. I asked this only because my client demands Enterprise Framework be used for DAL.
Norman Fung
|
|
|
|
|
Hi friends
I have two tables and i want to link them by veiw i am not sure that i can do that in my case so here is example;
table1
CREATE TABLE [book] (
[id_book] [int] IDENTITY (1, 1) NOT NULL ,
[title] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[author] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[publishing] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[discription] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[category_id] [int] NOT NULL ,
[rating] [int] NOT NULL CONSTRAINT [DF__book__rating__2F10007B] DEFAULT (5),
PRIMARY KEY CLUSTERED
(
[id_book]
) ON [PRIMARY] ,
CONSTRAINT [FK_book_category] FOREIGN KEY
(
[category_id]
) REFERENCES [category] (
[id_category]
),
CONSTRAINT [CK__book__rating__300424B4] CHECK ([rating] >= 0 and [rating] <= 10)
) ON [PRIMARY]
GO
table 2
CREATE TABLE [borrow] (
[id_borrow] [int] IDENTITY (1, 1) NOT NULL ,
[book_id] [int] NOT NULL ,
[user_inf_id] [int] NOT NULL ,
[borrow_date] [datetime] NOT NULL ,
[return_date] [datetime] NULL CONSTRAINT [DF__borrow__return_d__36B12243] DEFAULT (null),
[note] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[status] [tinyint] NOT NULL ,
PRIMARY KEY CLUSTERED
(
[id_borrow]
) ON [PRIMARY] ,
CONSTRAINT [FK_borrow_book] FOREIGN KEY
(
[book_id]
) REFERENCES [book] (
[id_book]
),
CONSTRAINT [FK_borrow_user_inf] FOREIGN KEY
(
[user_inf_id]
) REFERENCES [user_inf] (
[id_user]
),
CHECK ([status] >= 0 and [status] <= 1)
) ON [PRIMARY]
GO
example
SELECT TOP 100 PERCENT dbo.book.title, dbo.book.author, dbo.book.publishing, dbo.book.discription, dbo.book.rating, dbo.borrow.status
FROM dbo.book LEFT OUTER JOIN
dbo.borrow ON dbo.book.id_book = dbo.borrow.book_id
The problem is because i want to show only current status of book not all statuses so how to do that.If i use view i get all status of book for example
if i borrow book befour one week and now i take both??
How i can get only the current status ???
Thank u have a nice day
best regards
|
|
|
|
|
Hi,
I am struggling to create a new user in SQL Server 2005. I created a database MyDatabase, and made sa the owner. Was this the correctr decision?
Now I need to create a different login name and password to access the same database. Where do I do this? Do I navigate down the database treeview:
MyDatabase --> Security --> Users
..and then create the user here? When I upload the database and web application to the hosting company I want the web application to use this login information, and not the login for sa.
Please let me know.
Regards,
ma se
|
|
|
|
|
hi, I have to do a project using daab transaction using Microsoft visual studio(vb) using the enterprise libray too.
is there any website or book anyone can recommend whereby they give step by step or detailed way on how bout doing it???
I am having troubles wif my code, the bolded part has an error and i have no idea y...:
Imports Microsoft.VisualBasic
Imports Microsoft.Practices.EnterpriseLibrary.Data
Imports System.Data.SqlClient
Imports System.Data.Common
Imports System.Data
Imports System.Transactions
Public Function ConfirmTransactions(ByVal tempCID As String)
Dim db As Database = DatabaseFactory.CreateDatabase()
Dim connection As IDbConnection
Using (connection = [B]db.GetConnection[/B]())
connection.Open()
IDbTransaction(Transaction = connection.BeginTransaction())
Try
db.ExecuteNonQuery(Transaction, "CreditAccount", srcAccount, amount)
db.ExecuteNonQuery(Transaction, "DebitAccount", dstAccount, amount)
Transaction.Commit()
Catch e As Exception
Transaction.Rollback()
End Try
connection.Close()
End Using
End Function
can anyone help me???
or does anyone have a complete set of code for daab transaction??
syl
-- modified at 20:24 Tuesday 28th March, 2006
|
|
|
|
|
Hello Friedns,
I am tring to restore backup file which is on Machine1. And SQL server might be on anyother machine in local network.
I am using this Code:
==============================================================
//create an instance of a server class
SQLDMO._SQLServer srv = new SQLDMO.SQLServerClass();
//connect to the server
if(rbLocal.Checked==true)
srv.Connect(this.txtServName.Text,this.txtUserName.Text,this.txtPass.Text);
else
srv.Connect(this.cmbServList.Text,this.txtUserName.Text,this.txtPass.Text);
//create a restore class instance
SQLDMO.Restore res = new SQLDMO.RestoreClass();
//set the backup device = files property ( easy way )
res.Devices = res.Files;
//set the files property to the File Name text box
res.Files = "[" + System.IO.Path.GetTempPath()+"AlcoMateBlank.BAK" + "]";
//set the database to the chosen database
res.Database = this.txtDBName.Text;
// Restore the database
res.ReplaceDatabase = true;
res.SQLRestore(srv);
==============================================================
This code working properly if Backup file is on Local Machine but not if backup file is on another machine in a network. I am getting this error
BackupDiskFile::OpenMedia: Backup device 'C:\DOCUME~1\sachin\LOCALS~1\Temp\AlcoMateBlank.BAK' failed to open. Operating system error = 3(The system cannot find the path specified.).
Can you please suggest me eassy way of restoring database from remote PC to remote sql server which is in LAN?
Sachin Gedam
(Software Engg.)
Pune India
|
|
|
|
|
Hi.
I am trying to get a bit clearer understanding on what goes on between .net 1.1 and databases, in particular ms sql 2k and ms access.
Initially I could not quite figure out how @name in Execute1(string name) was handled by ms sql and .net because it looked to me like a undeclared variable in sql.
If I use SqlParameters against ms sql 2k, it seems that what actually happens is that .net executes the stored procedure sp_executesql on ms sql 2k.
Example (using NorthWind db on ms sql 2k in C#):
<br />
public void Execute1(string name){<br />
...<br />
command.CommandText="Select CategoryID from Categories where CategoryName like @name"; <br />
SqlParameter param=new SqlParameter ("@name",System.Data.SqlDbType.NVarChar,15);<br />
param.Value=name;<br />
command.Parameters.Add(param);<br />
...}<br />
is equal to (in regards to what ms sql recieves) :
<br />
public void Execute2(string name){<br />
...<br />
command.CommandText="exec sp_executesql N'Select CategoryID from Categories where CategoryName like @name', N'@name nvarchar(15)', @name = N'" + name +"'";<br />
...}<br />
My question is then..
Since sp_executesql do not exsist in ms access, what does the tsql look like, when using SqlParameters in a query against a ms access database ?
Is there a tool that lets me peek into what goes on between .net and ms access?
Something like ms profiler for access databases ?
Thanks
Michael Weber.
|
|
|
|
|
Hello all
using Query analyzer, i want find the logged username. Here I know in case of Query Analyzer is using Integrated windows authentication.
but how to get using Sql Server Authentication?
plz help me urgent
will be appriciated.
Ramana
-- modified at 15:10 Monday 27th March, 2006
|
|
|
|
|
Use the following in the query analyzer to get the current login and current user.
print 'This session''s current login is: '+ SUSER_SNAME()
print 'This session''s current user is: '+ SESSION_USER
To create a login that uses Sql Server Authentication, look in SQL Server Books Online online for "sp_addlogin":
--SQL Server Books Online--
sp_addlogin
Creates a new Microsoft® SQL Server™ login that allows a user to connect to an instance of SQL Server using SQL Server Authentication.
Syntax
sp_addlogin [ @loginame = ] 'login'
[ , [ @passwd = ] 'password' ]
[ , [ @defdb = ] 'database' ]
[ , [ @deflanguage = ] 'language' ]
[ , [ @sid = ] sid ]
[ , [ @encryptopt = ] 'encryption_option' ]
If this doesn't answer your question, maybe look up "Authentication Modes" in the SQL Server Books Online.
----------
There go my people. I must find out where they are going so I can lead them.
- Alexander Ledru-Rollin
|
|
|
|
|
Hi Everyone,
I am running my program where i am using pubs database, authors table of Sql. But while updating (dataadapter.update (dataset,"authors") ,it gave me this error:
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error.
I used try catch to catch the exception, it gave me this error:
line1 : Incorrect syntax near ','.
(I have passed parameters, passed update statement)
I have downloaded the code from this site
http://www.programmersheaven.com/2/Les_VBNET_13_p4[^]
I am putting code for your kind reference
Private Sub InitializeCommands()<br />
' Preparing Insert SQL Command<br />
dataAdapter.InsertCommand = conn.CreateCommand()<br />
dataAdapter.InsertCommand.CommandText = "INSERT INTO authors au_id, au_fname, au_lname, address VALUES @au_id, @au_fname, @au_lname, @address"<br />
<br />
AddParams (dataAdapter.InsertCommand, "au_id", "au_fname", "au_lname", "address")<br />
dataAdapter.UpdateCommand = conn.CreateCommand()<br />
dataAdapter.UpdateCommand.CommandText = _<br />
"UPDATE authors au_id = @au_id, au_fname = @au_fname, au_lname = @au_lname,address = @address WHERE au_Id = @au_Id"<br />
AddParams(dataAdapter.updateCommand, "au_id", "au_fname", "au_lname", "address")<br />
<br />
dataAdapter.DeleteCommand = conn.CreateCommand()<br />
dataAdapter.DeleteCommand.CommandText = "DELETE FROM article WHERE au_id = @au_Id"<br />
AddParams(dataAdapter.DeleteCommand, "au_Id")<br />
End Sub<br />
<br />
Private Sub AddParams(ByVal cmd As SqlCommand, ByVal ParamArray cols() As String)<br />
' Adding Hectice parameters in SQL Commands<br />
Dim col As String<br />
For Each col In cols<br />
cmd.Parameters.Add("@" + col, SqlDbType.Char, 0, col)<br />
Next<br />
End Sub<br />
<br />
Private Sub btnSave_Click(ByVal sender As System.Object, _<br />
ByVal e As System.EventArgs) Handles btnSave.Click<br />
lblLabel.Text = "Saving Changes..." <br />
Me.Cursor = Cursors.WaitCursor<br />
Dim row As DataRow = dataTable.Rows(currRec)<br />
row.BeginEdit()<br />
row("au_id") = txt1.Text <br />
row("au_fname") = txt2.Text<br />
row("au_lname") = txt3.Text<br />
row("address") = txt4.Text<br />
row.EndEdit()<br />
dataAdapter.Update(ds, "authors")<br />
ds.AcceptChanges()<br />
ToggleControls(True)<br />
insertSelected = False<br />
Me.Cursor = Cursors.Default<br />
lblLabel.Text = "Changes Saved"<br />
End Sub<br />
Thanking you and waiting for some kind replies.
Amit
|
|
|
|
|
I think the problem is you are missing the SET keyword on your update statement.
UPDATE tablename SET <column> = <value>, <column> = <value> ......
|
|
|
|
|
Looks like my reply may not be clear. Maybe I was typing too fast or my using a less than, greater than sign around the words "column" and "value" created a problem.
Anyhow - let me try again.
UPDATE tablename SET column_name = value, column_name = value, .... etc.
I believe you need to specify the SET keyword as part of the UPDATE command.
|
|
|
|
|
Thanks for your reply but i'm using set keyword near update statement. I have given the update statement and fieldnames.
Please refer my question.
Thanks again.
Amit
|
|
|
|
|
As the previous poster pointed out, your update query -"UPDATE authors au_id = @au_id, au_fname = @au_fname, au_lname = @au_lname,address = @address WHERE au_Id = @au_Id"
is missing the keyword 'Set'
it should be "UPDATE authors Set au_id = @au_id, au_fname = @au_fname, au_lname = @au_lname,address = @address WHERE au_Id = @au_Id"
Since it is missing, the sql parser detects an error at the first comma
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke
|
|
|
|
|
Hey Thanks everyone. My Problem got solved i missed one quotes.
|
|
|
|
|
Hi
i have 2 tables T1( ID int, content ntext) and T2(ID int, content ntext)
i want to fill T2 with T1 rows.
4 some reasons i should reade T1.ID and write theme to T2 and then
read T1.Content and write theme to T2.Content. What should i do plz???
|
|
|
|
|
INSERT INTO T2
(
id,
content
)
SELECT
id,
content
FROM
T1
|
|
|
|
|