Hi
Im trying to develop an information system using CRYSTAL REPORT XI.
Im really having a hard time connecting to a SQLSERVER 2000 database server on my network...
I've tried manipulating the datasource but to no avail... If anyone can help me by showing some example please do...
i would really appreciate your help...
Thanks...!!If you just want to connect to MSSQL from CRXI and add database tables for your report, use OLEDB provider for SQL Server. The connection process is self-explanatory.
Showing posts with label connecting. Show all posts
Showing posts with label connecting. Show all posts
Monday, March 26, 2012
how to connect to a local sql server on your laptop?
i have problems connecting to the local server on my laptop. i ahve used the following code but it gives me an error saying login flaied for user "sa" or "sekhar".
i tried using the username and password i use to log onto my computer. but it doesnt work.
can anyone tell me how to do it?
the code is typed is
connection = new sqlconnection("server=localhost;uid=sekhar;pwd=sekhar;database=chandu")
..................
.............................
........................
connection.open()..............i have all the next statements correct.
my username is sekhar and the password is sekhar too but it gives me an error.
somebody help me
Thank you
sekhartry using server=(local)
and whether you need the password or not depends on how the SQL Server is set up. does the users view show a user called 'sekhar'? no? when you right click the server node and go to properties->security, does it show windows auth only, or Windows and SQL Server auth?
Friday, March 23, 2012
How to connect SQL Server using Dreamweaver
HELP HELP HELP !!!!!!!!!!!
I'm having problem in connecting SQL Server using Dreamwerver...
I totally don't have any idea in doing that...
PLease help...
DUE DATE IS AROUND THE CORNER!!!!!!!!!!!!!
thank you1. Setup a DSN on the remote server
2. Then, In Your Application pane, go to Databases (which you probably already knew)
2. Click on the OLE DB Connection
3. For the Connection String box (see box below), type in your dsn, with the syntax of . . .
dsn=yourdsnname
4. Click OK and it should work
I'm having problem in connecting SQL Server using Dreamwerver...
I totally don't have any idea in doing that...
PLease help...
DUE DATE IS AROUND THE CORNER!!!!!!!!!!!!!
thank you1. Setup a DSN on the remote server
2. Then, In Your Application pane, go to Databases (which you probably already knew)
2. Click on the OLE DB Connection
3. For the Connection String box (see box below), type in your dsn, with the syntax of . . .
dsn=yourdsnname
4. Click OK and it should work
Wednesday, March 21, 2012
How to connect instance on local server
hi!
I have a question about connecting instance on local server
I install MS SQL Server 2000 first
and then install MS SQL Server 2005.
2005 has an instance name called "2005"
I use Microsoft SQL Server Management Studio and log into 2000
I want to select data from 2005
so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
but it fail..
I also try following name
[local$2005].TESTDB.dbo.TEST but also fail
How can I connect these two SQL Server?
Can anyone give me a advice?
Thanks a lot!You can create a likned server between the two instances. register either
the 2000 in 2005 or the other way around. Once a linked server is created,
you can execute a query similar to this
SELECT something FROM [server\instance].db.schema.table
You can do a lot of things in here - create a network alias for an instance
name to make it simple if you don't want to use a server\instance name
calls, create a DNS entry that points to the instance name, etc.
"YesGoGoGo" <YesGoGoGo@.gmail.com> wrote in message
news:1185939323.853710.99990@.e16g2000pri.googlegroups.com...
> hi!
> I have a question about connecting instance on local server
> I install MS SQL Server 2000 first
> and then install MS SQL Server 2005.
> 2005 has an instance name called "2005"
> I use Microsoft SQL Server Management Studio and log into 2000
> I want to select data from 2005
> so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
> but it fail..
> I also try following name
> [local$2005].TESTDB.dbo.TEST but also fail
> How can I connect these two SQL Server?
> Can anyone give me a advice?
> Thanks a lot!
>
I have a question about connecting instance on local server
I install MS SQL Server 2000 first
and then install MS SQL Server 2005.
2005 has an instance name called "2005"
I use Microsoft SQL Server Management Studio and log into 2000
I want to select data from 2005
so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
but it fail..
I also try following name
[local$2005].TESTDB.dbo.TEST but also fail
How can I connect these two SQL Server?
Can anyone give me a advice?
Thanks a lot!You can create a likned server between the two instances. register either
the 2000 in 2005 or the other way around. Once a linked server is created,
you can execute a query similar to this
SELECT something FROM [server\instance].db.schema.table
You can do a lot of things in here - create a network alias for an instance
name to make it simple if you don't want to use a server\instance name
calls, create a DNS entry that points to the instance name, etc.
"YesGoGoGo" <YesGoGoGo@.gmail.com> wrote in message
news:1185939323.853710.99990@.e16g2000pri.googlegroups.com...
> hi!
> I have a question about connecting instance on local server
> I install MS SQL Server 2000 first
> and then install MS SQL Server 2005.
> 2005 has an instance name called "2005"
> I use Microsoft SQL Server Management Studio and log into 2000
> I want to select data from 2005
> so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
> but it fail..
> I also try following name
> [local$2005].TESTDB.dbo.TEST but also fail
> How can I connect these two SQL Server?
> Can anyone give me a advice?
> Thanks a lot!
>
How to connect instance on local server
hi!
I have a question about connecting instance on local server
I install MS SQL Server 2000 first
and then install MS SQL Server 2005.
2005 has an instance name called "2005"
I use Microsoft SQL Server Management Studio and log into 2000
I want to select data from 2005
so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
but it fail..
I also try following name
[local$2005].TESTDB.dbo.TEST but also fail
How can I connect these two SQL Server?
Can anyone give me a advice?
Thanks a lot!
You can create a likned server between the two instances. register either
the 2000 in 2005 or the other way around. Once a linked server is created,
you can execute a query similar to this
SELECT something FROM [server\instance].db.schema.table
You can do a lot of things in here - create a network alias for an instance
name to make it simple if you don't want to use a server\instance name
calls, create a DNS entry that points to the instance name, etc.
"YesGoGoGo" <YesGoGoGo@.gmail.com> wrote in message
news:1185939323.853710.99990@.e16g2000pri.googlegro ups.com...
> hi!
> I have a question about connecting instance on local server
> I install MS SQL Server 2000 first
> and then install MS SQL Server 2005.
> 2005 has an instance name called "2005"
> I use Microsoft SQL Server Management Studio and log into 2000
> I want to select data from 2005
> so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
> but it fail..
> I also try following name
> [local$2005].TESTDB.dbo.TEST but also fail
> How can I connect these two SQL Server?
> Can anyone give me a advice?
> Thanks a lot!
>
I have a question about connecting instance on local server
I install MS SQL Server 2000 first
and then install MS SQL Server 2005.
2005 has an instance name called "2005"
I use Microsoft SQL Server Management Studio and log into 2000
I want to select data from 2005
so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
but it fail..
I also try following name
[local$2005].TESTDB.dbo.TEST but also fail
How can I connect these two SQL Server?
Can anyone give me a advice?
Thanks a lot!
You can create a likned server between the two instances. register either
the 2000 in 2005 or the other way around. Once a linked server is created,
you can execute a query similar to this
SELECT something FROM [server\instance].db.schema.table
You can do a lot of things in here - create a network alias for an instance
name to make it simple if you don't want to use a server\instance name
calls, create a DNS entry that points to the instance name, etc.
"YesGoGoGo" <YesGoGoGo@.gmail.com> wrote in message
news:1185939323.853710.99990@.e16g2000pri.googlegro ups.com...
> hi!
> I have a question about connecting instance on local server
> I install MS SQL Server 2000 first
> and then install MS SQL Server 2005.
> 2005 has an instance name called "2005"
> I use Microsoft SQL Server Management Studio and log into 2000
> I want to select data from 2005
> so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
> but it fail..
> I also try following name
> [local$2005].TESTDB.dbo.TEST but also fail
> How can I connect these two SQL Server?
> Can anyone give me a advice?
> Thanks a lot!
>
How to connect instance on local server
hi!
I have a question about connecting instance on local server
I install MS SQL Server 2000 first
and then install MS SQL Server 2005.
2005 has an instance name called "2005"
I use Microsoft SQL Server Management Studio and log into 2000
I want to select data from 2005
so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
but it fail..
I also try following name
[local$2005].TESTDB.dbo.TEST but also fail
How can I connect these two SQL Server?
Can anyone give me a advice?
Thanks a lot!You can create a likned server between the two instances. register either
the 2000 in 2005 or the other way around. Once a linked server is created,
you can execute a query similar to this
SELECT something FROM [server\instance].db.schema.table
You can do a lot of things in here - create a network alias for an instance
name to make it simple if you don't want to use a server\instance name
calls, create a DNS entry that points to the instance name, etc.
"YesGoGoGo" <YesGoGoGo@.gmail.com> wrote in message
news:1185939323.853710.99990@.e16g2000pri.googlegroups.com...
> hi!
> I have a question about connecting instance on local server
> I install MS SQL Server 2000 first
> and then install MS SQL Server 2005.
> 2005 has an instance name called "2005"
> I use Microsoft SQL Server Management Studio and log into 2000
> I want to select data from 2005
> so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
> but it fail..
> I also try following name
> [local$2005].TESTDB.dbo.TEST but also fail
> How can I connect these two SQL Server?
> Can anyone give me a advice?
> Thanks a lot!
>sql
I have a question about connecting instance on local server
I install MS SQL Server 2000 first
and then install MS SQL Server 2005.
2005 has an instance name called "2005"
I use Microsoft SQL Server Management Studio and log into 2000
I want to select data from 2005
so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
but it fail..
I also try following name
[local$2005].TESTDB.dbo.TEST but also fail
How can I connect these two SQL Server?
Can anyone give me a advice?
Thanks a lot!You can create a likned server between the two instances. register either
the 2000 in 2005 or the other way around. Once a linked server is created,
you can execute a query similar to this
SELECT something FROM [server\instance].db.schema.table
You can do a lot of things in here - create a network alias for an instance
name to make it simple if you don't want to use a server\instance name
calls, create a DNS entry that points to the instance name, etc.
"YesGoGoGo" <YesGoGoGo@.gmail.com> wrote in message
news:1185939323.853710.99990@.e16g2000pri.googlegroups.com...
> hi!
> I have a question about connecting instance on local server
> I install MS SQL Server 2000 first
> and then install MS SQL Server 2005.
> 2005 has an instance name called "2005"
> I use Microsoft SQL Server Management Studio and log into 2000
> I want to select data from 2005
> so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
> but it fail..
> I also try following name
> [local$2005].TESTDB.dbo.TEST but also fail
> How can I connect these two SQL Server?
> Can anyone give me a advice?
> Thanks a lot!
>sql
How to connect Anasysis server in different domain
Please let me know the steps to connect Analysis server 2000 from different domain.
fyi for connecting sql server I am using SQL server authentication and I am able to connect.
try this, it works for me in as 2005:
create a local user on the AS server as yourself. Use the same user name/password that you have on the other domain.
example:
domain dom1:
you are logged on as dom1\bob with password xxxxx
On the AS server, create a local user bob with password xxxx. give bob access to the cubes.
Test your connection.
|||this also works:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1365877&SiteID=1
|||Thanks for you information,
It is working now.
How to configuring SQL 2K & connect to it.
I am new to SQL Server 2000 and need step-by-step help
setting it up and connecting to it. I am in desperate
need of help. If anyone can I'll greatly appreciate it.Hi,
After the installtion of SQL server, You can use the user friendly utility
Enterprise manager to administer the
SQL Server and databases. The tasks are:-
1. Create a new database
2. Create new login
3. Assign the required role the login created.
Once you create the Login and database you can use the other utility named
"Query Analyzer" to connect to the
SQL Server. Using Query Analyzer you can execute all TSQL commands
For tracing you can use the utility "Profiler"
To enable and Disable the protocols you can use 'Server Netwotk utility".
For more information on Administration, TSQL commands download the latest
boks online from below link:-
http://www.microsoft.com/sql/techin.../2000/books.asp
Thanks
Hari
MCDBA
"Rafyel" <rafyelb@.tmail.com> wrote in message
news:2a38901c467a4$0b4909d0$a601280a@.phx
.gbl...
> I am new to SQL Server 2000 and need step-by-step help
> setting it up and connecting to it. I am in desperate
> need of help. If anyone can I'll greatly appreciate it.|||Thanks for your help. I've tried this and cannot connect still. I
continue to recieve a error message "[Microsoft][ODBC SQL Server
Driver][TCP/IP Sockets]SQL Server does not exist or access denied." What
am I doing wrong?
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!|||Hi,
This error can come in below situations:-
1. SQL Server is down
2. Your client network issues. Try a ping to server and check the network
connection
3. Providing wrong SQL server name.
If all the above is OK, then create a ALIAS server name using the CLient
network utility specifying protocol as TCIP , IP address , port number.
After that try to connect using that ALIAS name.
Thanks
Hari
MCDBA
"Rafyel Brooks" <rafyelb@.tmail.com> wrote in message
news:OIgy7n7ZEHA.3132@.TK2MSFTNGP10.phx.gbl...
> Thanks for your help. I've tried this and cannot connect still. I
> continue to recieve a error message "[Microsoft][ODBC SQL Server
> Driver][TCP/IP Sockets]SQL Server does not exist or access denied." Wh
at
> am I doing wrong?
>
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Okay, I've started a new installation and started all over. I've
selected to use Windows NT authentication. Now I have to setup correctly
the database and create the login. whats the proper procedure?
Rafyel
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
setting it up and connecting to it. I am in desperate
need of help. If anyone can I'll greatly appreciate it.Hi,
After the installtion of SQL server, You can use the user friendly utility
Enterprise manager to administer the
SQL Server and databases. The tasks are:-
1. Create a new database
2. Create new login
3. Assign the required role the login created.
Once you create the Login and database you can use the other utility named
"Query Analyzer" to connect to the
SQL Server. Using Query Analyzer you can execute all TSQL commands
For tracing you can use the utility "Profiler"
To enable and Disable the protocols you can use 'Server Netwotk utility".
For more information on Administration, TSQL commands download the latest
boks online from below link:-
http://www.microsoft.com/sql/techin.../2000/books.asp
Thanks
Hari
MCDBA
"Rafyel" <rafyelb@.tmail.com> wrote in message
news:2a38901c467a4$0b4909d0$a601280a@.phx
.gbl...
> I am new to SQL Server 2000 and need step-by-step help
> setting it up and connecting to it. I am in desperate
> need of help. If anyone can I'll greatly appreciate it.|||Thanks for your help. I've tried this and cannot connect still. I
continue to recieve a error message "[Microsoft][ODBC SQL Server
Driver][TCP/IP Sockets]SQL Server does not exist or access denied." What
am I doing wrong?
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!|||Hi,
This error can come in below situations:-
1. SQL Server is down
2. Your client network issues. Try a ping to server and check the network
connection
3. Providing wrong SQL server name.
If all the above is OK, then create a ALIAS server name using the CLient
network utility specifying protocol as TCIP , IP address , port number.
After that try to connect using that ALIAS name.
Thanks
Hari
MCDBA
"Rafyel Brooks" <rafyelb@.tmail.com> wrote in message
news:OIgy7n7ZEHA.3132@.TK2MSFTNGP10.phx.gbl...
> Thanks for your help. I've tried this and cannot connect still. I
> continue to recieve a error message "[Microsoft][ODBC SQL Server
> Driver][TCP/IP Sockets]SQL Server does not exist or access denied." Wh
at
> am I doing wrong?
>
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Okay, I've started a new installation and started all over. I've
selected to use Windows NT authentication. Now I have to setup correctly
the database and create the login. whats the proper procedure?
Rafyel
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
How to configuring SQL 2K & connect to it.
I am new to SQL Server 2000 and need step-by-step help
setting it up and connecting to it. I am in desperate
need of help. If anyone can I'll greatly appreciate it.
Hi,
After the installtion of SQL server, You can use the user friendly utility
Enterprise manager to administer the
SQL Server and databases. The tasks are:-
1. Create a new database
2. Create new login
3. Assign the required role the login created.
Once you create the Login and database you can use the other utility named
"Query Analyzer" to connect to the
SQL Server. Using Query Analyzer you can execute all TSQL commands
For tracing you can use the utility "Profiler"
To enable and Disable the protocols you can use 'Server Netwotk utility".
For more information on Administration, TSQL commands download the latest
boks online from below link:-
http://www.microsoft.com/sql/techinf...2000/books.asp
Thanks
Hari
MCDBA
"Rafyel" <rafyelb@.tmail.com> wrote in message
news:2a38901c467a4$0b4909d0$a601280a@.phx.gbl...
> I am new to SQL Server 2000 and need step-by-step help
> setting it up and connecting to it. I am in desperate
> need of help. If anyone can I'll greatly appreciate it.
|||Thanks for your help. I've tried this and cannot connect still. I
continue to recieve a error message "[Microsoft][ODBC SQL Server
Driver][TCP/IP Sockets]SQL Server does not exist or access denied." What
am I doing wrong?
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
|||Hi,
This error can come in below situations:-
1. SQL Server is down
2. Your client network issues. Try a ping to server and check the network
connection
3. Providing wrong SQL server name.
If all the above is OK, then create a ALIAS server name using the CLient
network utility specifying protocol as TCIP , IP address , port number.
After that try to connect using that ALIAS name.
Thanks
Hari
MCDBA
"Rafyel Brooks" <rafyelb@.tmail.com> wrote in message
news:OIgy7n7ZEHA.3132@.TK2MSFTNGP10.phx.gbl...
> Thanks for your help. I've tried this and cannot connect still. I
> continue to recieve a error message "[Microsoft][ODBC SQL Server
> Driver][TCP/IP Sockets]SQL Server does not exist or access denied." What
> am I doing wrong?
>
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!
|||Okay, I've started a new installation and started all over. I've
selected to use Windows NT authentication. Now I have to setup correctly
the database and create the login. whats the proper procedure?
Rafyel
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
setting it up and connecting to it. I am in desperate
need of help. If anyone can I'll greatly appreciate it.
Hi,
After the installtion of SQL server, You can use the user friendly utility
Enterprise manager to administer the
SQL Server and databases. The tasks are:-
1. Create a new database
2. Create new login
3. Assign the required role the login created.
Once you create the Login and database you can use the other utility named
"Query Analyzer" to connect to the
SQL Server. Using Query Analyzer you can execute all TSQL commands
For tracing you can use the utility "Profiler"
To enable and Disable the protocols you can use 'Server Netwotk utility".
For more information on Administration, TSQL commands download the latest
boks online from below link:-
http://www.microsoft.com/sql/techinf...2000/books.asp
Thanks
Hari
MCDBA
"Rafyel" <rafyelb@.tmail.com> wrote in message
news:2a38901c467a4$0b4909d0$a601280a@.phx.gbl...
> I am new to SQL Server 2000 and need step-by-step help
> setting it up and connecting to it. I am in desperate
> need of help. If anyone can I'll greatly appreciate it.
|||Thanks for your help. I've tried this and cannot connect still. I
continue to recieve a error message "[Microsoft][ODBC SQL Server
Driver][TCP/IP Sockets]SQL Server does not exist or access denied." What
am I doing wrong?
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
|||Hi,
This error can come in below situations:-
1. SQL Server is down
2. Your client network issues. Try a ping to server and check the network
connection
3. Providing wrong SQL server name.
If all the above is OK, then create a ALIAS server name using the CLient
network utility specifying protocol as TCIP , IP address , port number.
After that try to connect using that ALIAS name.
Thanks
Hari
MCDBA
"Rafyel Brooks" <rafyelb@.tmail.com> wrote in message
news:OIgy7n7ZEHA.3132@.TK2MSFTNGP10.phx.gbl...
> Thanks for your help. I've tried this and cannot connect still. I
> continue to recieve a error message "[Microsoft][ODBC SQL Server
> Driver][TCP/IP Sockets]SQL Server does not exist or access denied." What
> am I doing wrong?
>
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!
|||Okay, I've started a new installation and started all over. I've
selected to use Windows NT authentication. Now I have to setup correctly
the database and create the login. whats the proper procedure?
Rafyel
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Subscribe to:
Posts (Atom)