Re: couldnot find installable ISAM - Database Discussion Boards

Jondo24shoots19-May-09 3:16

19-May-09 3:16

please can anyone help with out??

I'm trying to login to a window based application
developed with VB.NET and after entering
my username and password on the login page,
i saw the following error message after waiting
for some time;

A connection was successfully established with the server,
but then an error occured during the pre-login handshake.
(Provider:TCP provider, error 0 - The specified network
name is no longer available) Source: .NET sqlclient Data Provider

someone help me out
Frown | :(

Jondo

Re: login problem

Mycroft Holmes19-May-09 14:37

Mycroft Holmes

19-May-09 14:37

I suspect someone moved your server or changed the IP. Unless you are using express/lite/local version in which case the local DB may not have been deployed with the app.

What version of SQL Server are you using. Is the developer of the VB app available to annoy?

Never underestimate the power of human stupidity
RAH

Re: login problem

Jondo24shoots19-May-09 22:13

Jondo24shoots

19-May-09 22:13

i'm using SQL SERVER 2005 enterprise edition

and no has moved de server

and besides other computers that
are connected to the server are
all working apart from this particular
one.

Re: login problem

Mycroft Holmes19-May-09 23:20

Mycroft Holmes

19-May-09 23:20

so take that computer out and ....

Sorry couldn't resist. I have never run across a "pre login handshake" error before but I guess it may be a network issues, especially as it is isolated. May be some config on that PC.

Never underestimate the power of human stupidity
RAH

How do i insert and retrive images in a sql server database 2000 or 2005???

ma.amer18-May-09 21:33

ma.amer

18-May-09 21:33

hi every one ,,,
How do i insert and retrive images in a sql server database 2000 or 2005???
thanks in advance.

Re: How do i insert and retrive images in a sql server database 2000 or 2005???

Giorgi Dalakishvili18-May-09 23:12

Giorgi Dalakishvili

18-May-09 23:12

Here you are: How To Read and Write BLOB Data by Using ADO.NET with Visual C# .NET[^]

Giorgi Dalakishvili

#region signature
My Articles

Asynchronous Registry Notification Using Strongly-typed WMI Classes in .NET [^]

My blog
#endregion

couldnot find installable ISAM

hrishiS18-May-09 19:45

hrishiS

18-May-09 19:45

Hi ,
I am using VB.NET2005 with Ms Access database(c:\aa\aa.mdb). But i have upgraded the ms office to 2007 now.
Now when I access the database without password works fine.Bit if I give a password...it shows the error, something like
"couldn't find installable ISAM"
My connection string is

"microsoft.ACE.OLEDB.12.0;Data Source=c:\aa\db1.mdb;jet OLEDB;Database Password=abc;"

Could anyone please show me a way to solve the problem.

thanks in advance

-----------------------------
I am a beginner

Re: couldnot find installable ISAM

Vimalsoft(Pty) Ltd18-May-09 22:19

Vimalsoft(Pty) Ltd

18-May-09 22:19

This is because your Connection Sting is not correctly done.

I once had the Problem and i found help and shared it in this Forum, please google before you post there are plenty of solution to this problem.

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

SQLExpress 2008 Issue ?

Mohammad Dayyan18-May-09 8:23

Mohammad Dayyan

18-May-09 8:23

Hi.

I've created this program[^] some days ago. (I've had WinXP and SQLExpress 2008 then)
It works on XP well , but when I wanna run it on Vista SP1 Ultimate this error[^] occurred.
and there is a link in the error window http://oca.microsoft.com/en/dcp20.asp[^]

What's wrong ?
Could you guide me ?
Thanks

PS : I've installed SQLExpress 2008 on Vista

FFDPERL - Flat file database for perl

wickedxter18-May-09 7:52

wickedxter

18-May-09 7:52

I dont know if there are any perl programmers here, but im looking for some testers in my creation of my project. It an flat file style database that uses SQL queries to access data thats stored. If you would like to help drop by. http://ffdperl.sourceforge.net

Column Constraints

jonhbt18-May-09 2:28

jonhbt

18-May-09 2:28

How can I check if a column has a constraint on it through SQL code please?

Thanks for your help

Re: Column Constraints

Manas Bhardwaj18-May-09 5:37

Manas Bhardwaj

18-May-09 5:37

http://forums.devshed.com/ms-sql-development-95/how-to-get-all-the-constraints-on-a-table-372351.html[^]

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Pls...I can't understand what s the problem in this procedure..

PeriyasamyRamachandran18-May-09 1:40

PeriyasamyRamachandran

18-May-09 1:40

Hi Everyone,

I used the below stored procedure to delete a single record in a table in MySql.

Procedure:

DELIMITER $$
DROP PROCEDURE IF EXISTS `healthtour`.`USP_User_DeleteUserRole`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `USP_User_DeleteUserRole`
(
IN UserRoleID INT
)
BEGIN
DELETE FROM HT_UserRole WHERE UserRoleID = UserRoleID;

END$$
DELIMITER ;

Problem:

I run this procedure as below,

CALL USP_User_DeleteUserRole(2);

I have the records in my table for the UserRoleID 10. And i don't have the records for the UserRoleID 2. If I give the input(UserRoleID 2) then the record 10 is deleted. It should not be deleted. Because i gave the input 2 and not 10.

Please can anybody help me?.

Thanks,
-Periyasamy Ramachandiran

Re: Pls...I can't understand what s the problem in this procedure..

scottgp18-May-09 3:04

scottgp

18-May-09 3:04

It looks like you need to read up on what to do when a parameter name is the same as the name of a column in one of the tables (which obviously sounds dangerous). For example, http://stackoverflow.com/questions/715229/mysql-stored-procedures-parameter-with-the-same-name-as-affectings-column-is-i[^]
Scott

Re: Pls...I can't understand what s the problem in this procedure..

PeriyasamyRamachandran18-May-09 3:11

PeriyasamyRamachandran

18-May-09 3:11

Hi,

Yes I found the error that i have used the same name for both table column name and the variable name. Just i changed the variable name. Now it works fine.

Thank u very much.
-Periyasamy Ramachandiran.

how to get database performance

tai-fun18-May-09 0:42

tai-fun

18-May-09 0:42

hi,

i can some speak english. so i hope you understand me.

my question;

how to i measuring to database performance? are there tools for database performance?

best regards.

Traversing Column rows

jonhbt17-May-09 21:26

jonhbt

17-May-09 21:26

Hi,

I am Writing an sql that returns a single record which is row from a table. In the same sql i would like to traverse through the columns of this row. How can I do that? Is it possible to access the columns in SQL through indexing for example like column[1]?

Thanks for your time and help

Re: Traversing Column rows

Mycroft Holmes17-May-09 21:43

Mycroft Holmes

17-May-09 21:43

You cannot refer to a column by it's ordinal (1) in SQL unless you use dynamic SQL in which case you look up the column name from the schema view and build a string to execute.

Never underestimate the power of human stupidity
RAH

Re: Traversing Column rows

jonhbt17-May-09 21:52

jonhbt

17-May-09 21:52

thanks for your reply. I am using Dynamic Sql but the problem is that I don't know the name of the column to fetch for, thats why I was trying to find a way similar to indexing.Is there a way?

Re: Traversing Column rows

Mycroft Holmes17-May-09 22:00

Mycroft Holmes

17-May-09 22:00

Take a look into the information schema views (under system views in Management Studio) INFORMATION_SCHEMA.COLUMNS is the one you want

Never underestimate the power of human stupidity
RAH

Exception handling in mysql stored procedures

Rajeshwary17-May-09 19:15

Rajeshwary

17-May-09 19:15

Hi All,

I am new in MySQL Database. Can anybody give sample stored procedure for Insert Query with "Exception handling".

Please...

Thanks,
Easton.

Re: Exception handling in mysql stored procedures

Henry Minute20-May-09 1:14

Henry Minute

20-May-09 1:14

You do know that there is a MySQL forum, right?

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

nvarchar to datetime conversion plz!!!!!!!!!!!!!!!!!!!!!!!!!!

Learner52017-May-09 4:33

Learner520

17-May-09 4:33

hi everybody
i have two tables

table1 with column name
SubmissionDate nvarchar(11)

table2 with column name
submissiondate2 (datetime)

and i insert data in table1 like 17/05/2009 but still in nvarchar format
cos this is my requirement (i mean nvarchar)

my question is i want to insert same date from table1's column to table2's column but dont know how to convert datatype nvarchar to datetime.

when i try to cast i got this error msg
Arithmetic overflow error converting expression to data type datetime.

any help would be really appricated

Re: nvarchar to datetime conversion plz!!!!!!!!!!!!!!!!!!!!!!!!!!

Manas Bhardwaj17-May-09 7:18

Manas Bhardwaj

17-May-09 7:18

http://msdn.microsoft.com/en-us/library/ms187928.aspx[^]

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: nvarchar to datetime conversion plz!!!!!!!!!!!!!!!!!!!!!!!!!!

Blue_Boy17-May-09 10:49

Blue_Boy

17-May-09 10:49

insert into table2
select cast(submissiondate2 as datetime) from table1

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.