all groups > sql server clients > march 2005 > threads for march 15 - 21, 2005
Filter by week: 1 2 3 4 5
SQL Server Enterprise Manager hangs...
Posted by Dirk Dulfer at 3/21/2005 10:36:53 AM
Hi there,
Been using EM for a few years now, most of the time without any
problems. Every now and then however I get stuck with this problem that
seems to persist for some time and then disappears again:
Connected to a remote SQL Server (at hosting provider), when selecting
the databases... more >>
Replications
Posted by John at 3/19/2005 1:51:45 PM
I want the replication b/w Access to MySQL... can any one let me know the
tool .....
... more >>
Replication
Posted by John at 3/19/2005 12:25:30 AM
Can any one let me know the process of Replication b/w access - SQL Server
and Access to MySQL...
Thanks and waiting for your reply
... more >>
URGENT
Posted by John at 3/18/2005 11:22:56 AM
Can any one let me know about the Migration tool from Access to SQL Server.
Thanks and have a nicey Day.
Noor
... more >>
CAL for Web Users
Posted by Bass_trout_Man at 3/17/2005 9:27:02 AM
What is CAL not required for HTTP? Clarification, what is CAL not required
for HTTP, is this a web interface, or if I have canned queries for users via
a web site, CAL is not required? Or, do I need CAL license for the server or
the max. number of users at the same time? Thank you... more >>
SQL code help
Posted by Nate at 3/16/2005 7:31:05 AM
I am trying to create a record number. Don't ask why LOL. Below are the
items I need in my record number. Here is the format I'm looking for. I am
also having problems trying to get it to display zeros before numbers such as
1. Ex. 1 should be 01. This would be stored in a text field.
... more >>
Insert statement for a datetime field from vb.net code
Posted by kd at 3/16/2005 3:11:05 AM
Hi All,
I have a datetime column in a table on the SQL database. I need to insert
values into the datetime column from vb.net code. Here is my code:
dim nameval, str, qry as string
nameval = "abc"
str = "2005/03/16 14:20"
qry = "insert into tab1(name,dateval) values(" & "'" & nameval & "',"... more >>
Error when viewing Taskpad in Enterprise Manager
Posted by Filiep at 3/16/2005 1:40:57 AM
When I want to view the Taskpad for a certain database, I
get an error:
Internet Explorer Script Page:
An error has occurred in the script of this page
Unspecified error... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Update statement gives a "Must declare the scalar variable '@name'" error
Posted by cEciLlE at 3/15/2005 4:49:32 PM
I am trying to update my table. below is the code is used
SqlDataAdapter ioSimpleDA = new SqlDataAdapter("Select * from
myDatabase,dbo.IoSimpleCard",myconnect);
myconnect.Open();
string qrycmd = ("UPDATE myDatabase.dbo.IoSimpleCard SET Name =
@name,Description =
@desc,CardDefinitionName... more >>
LoadFromSQLServer - 'Specified SQL server not found'
Posted by Ollie Riches at 3/15/2005 3:15:59 PM
I am trying to start a remote DTS package from code and I am getting the
following error:
Description='[DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not
found.'
Error=-2147467259'
Source='Microsoft OLE DB Provider for SQL Server'
When I run the code from the local machine it ... more >>
Auto numbering field similar to
Posted by Walker_Michael at 3/15/2005 2:17:06 PM
I've been using MS Access 2000 for a while and have recently switched to MS
SQL 2000. When creating a primary key I am used to MS Access ability to auto
matically enter a number in the ID field when I enter data into my tables.
Does MS SQL have a feature similar to this? I checked all the data... more >>
URGENT: Provider cannot be found. It may not be properly installed
Posted by Ms .NET at 3/15/2005 11:29:36 AM
Hi,
when i select a table from Enterprise manager and select return all rows.
earlier i got the error. "The query cannot be executed because some files
are either missing or not registered"
i found KB article (Article ID - 315868).
but now i am gettong a new error "Provider cannot be foun... more >>
|