all groups > sql server connect > september 2003 > threads for september 29 - 30, 2003
Filter by week: 1 2 3 4 5
DTS Import/Export Wizard Error: GoCreateInstance...
Posted by Jan Nielsen at 9/30/2003 10:30:36 PM
Hi
I have a local computer with a MSDE and a SQL Server PE installed. They both
have SP 3 installed.
I would like to import an Access database to my MSDE (or the PE if MSDE
import is impossible).
I use SQL Server Enterprise Manager
When I rightclick on a database and select All Tasks-->Import ... more >>
Problems with Access SQl pass-through query.
Posted by Al Blake at 9/30/2003 7:46:15 PM
This is really weird. I have a query in sql that runs like this:
SELECT * FROM uvTTExport option (force order)
It runs fine and returns 800+ records.
I need to run this query in Access so I can use some Visual Basic + MAPI
code to process the records... so I created a pass-through query wit... more >>
Want to connect remote server via internet
Posted by Igbal at 9/30/2003 6:14:09 PM
Hi,
Now there is a requirement for me to connect the remote server via internet.
Is it possible?
If yes, what i want to do.
I'm the beginner.
Please explain in detail.
Thanks in Advance.
Regards,
E.S.Mohammed Igbal M.Sc.,
Chella Software Pvt Ltd.,
Madurai.
Phone No: 5391927
... more >>
Server Login Error
Posted by brad at 9/30/2003 1:00:40 PM
Hi,
I am trying to login into my server via query analyzer and
I am receiving the following error. Any ideas how I can
rememdy this issue.
Thanks!
Connection failed:
SQLState: '01000'
SQL Server Error: 1326
[Microsfot][ODBC SQL Server Driver][DBNETLIB]
ConnectionOpen (Connect()).
... more >>
SRV_DONE_ERROR - is it really mandatory ?
Posted by Chetan Raj at 9/30/2003 3:54:01 AM
hi,
we are using sqlclient to connect to DB from app code.
When ever there is an error we set the SRV_DONE_ERROR falg
in srv_senddone & we also send the result-set.
now sqlclient throws an exception whenever there is an
error ( when SRV_DONE_ERROR flag is set ) and does not
allow us t... more >>
Unable to connect to remote sql server thro' query analyser
Posted by Venkatsathish at 9/29/2003 10:34:14 PM
Hai Guys,
See if anybody could help me out.
I am unable to connect to a remote sql server 2000 using
query analyser. It give me the following error
msg 17, level 16, stste 1
SQL Server does not exists or access denied.
Can anyone let me know the solution for this.
Sath... more >>
connecting with SQL server using TDS
Posted by Mocrotronics at 9/29/2003 7:07:58 PM
Hi,
Is there anyone over there with experience of writing C code for a tabular
data stream (TDS) connection with a SQL server? Hope someone could help me
with this.
thnx in advance!
... more >>
Query Optimization tool
Posted by Sahil Malik at 9/29/2003 2:51:38 PM
Hi Everyone,
I'm new to the SQL Server world. I am looking for a tool similar to SQL
navigator in Oracle, that will optimize Sql queries for me.
Any suggestions?
- SM
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Novice SQL Connect Question
Posted by Don at 9/29/2003 11:50:23 AM
Hi All
I have SQL Server Developer Edition Installed on my server. Can you explain
how I comnnect my workstation to the server to be able to use Access 2000 as
a front end database with the SQL Server as the back-end. What if anything
needs to be set up on the WS to connect to Server. I am con... more >>
Connections
Posted by Antonio at 9/29/2003 5:43:20 AM
Hello people, I am experimenting some problems with two
linked server (the first one with SQL 7.0 SP 4 and the
other with SQL 2000 with SP 6), when I try to run some
querys I get the follow message:
"OLE DB provider 'SQLOLEDB' supplied inconsistent
metadata for a column". Somebody can hel... more >>
|