Converting MS Access to SQL Server 2K

Hi,
I am fairly new to SQL Server and would appreciate if anyone could solve my
problem.
I have SQL server 2k installed on the server, say server1. My website is
also hosted on the same server. I have another instance installed on my
client machine.
Now I am connecting to the remote SQL server instance and
migrating/importing data from MS Access DB. The database migrated
successfully. I changed the ADO connection properties in my ASP code to
access data from SQL server.
Now the problem...
1) I am connecting to the DB but have to prefix all my table names with the
DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
2) Also the recordset does not return any record
please help
regards
Using the 2-part name is optional... When you select * from mytable. SQL
first looks to see if YOU own a table with that name. ( ie wayne.mytable).
If such a table does NOT exist, then it searches for and returns a table
like this owned by the dbo... ( ie dbo.mytable)...
So you shouldn't have to use the 2-part name...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Fuzail" <Fuzail@.discussions.microsoft.com> wrote in message
news:AB8DC0C4-29A8-48A1-99AC-B89F9668DBDA@.microsoft.com...
> Hi,
> I am fairly new to SQL Server and would appreciate if anyone could solve
my
> problem.
> I have SQL server 2k installed on the server, say server1. My website is
> also hosted on the same server. I have another instance installed on my
> client machine.
> Now I am connecting to the remote SQL server instance and
> migrating/importing data from MS Access DB. The database migrated
> successfully. I changed the ADO connection properties in my ASP code to
> access data from SQL server.
> Now the problem...
> 1) I am connecting to the DB but have to prefix all my table names with
the
> DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
> 2) Also the recordset does not return any record
> please help
> regards
|||
>2) Also the recordset does not return any record
what is your query, and what is the dB structure?

Converting MS Access to SQL Server 2K

Hi,
I am fairly new to SQL Server and would appreciate if anyone could solve my
problem.
I have SQL server 2k installed on the server, say server1. My website is
also hosted on the same server. I have another instance installed on my
client machine.
Now I am connecting to the remote SQL server instance and
migrating/importing data from MS Access DB. The database migrated
successfully. I changed the ADO connection properties in my ASP code to
access data from SQL server.
Now the problem...
1) I am connecting to the DB but have to prefix all my table names with the
DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
2) Also the recordset does not return any record
please help
regardsUsing the 2-part name is optional... When you select * from mytable. SQL
first looks to see if YOU own a table with that name. ( ie wayne.mytable).
If such a table does NOT exist, then it searches for and returns a table
like this owned by the dbo... ( ie dbo.mytable)...
So you shouldn't have to use the 2-part name...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Fuzail" <Fuzail@.discussions.microsoft.com> wrote in message
news:AB8DC0C4-29A8-48A1-99AC-B89F9668DBDA@.microsoft.com...
> Hi,
> I am fairly new to SQL Server and would appreciate if anyone could solve
my
> problem.
> I have SQL server 2k installed on the server, say server1. My website is
> also hosted on the same server. I have another instance installed on my
> client machine.
> Now I am connecting to the remote SQL server instance and
> migrating/importing data from MS Access DB. The database migrated
> successfully. I changed the ADO connection properties in my ASP code to
> access data from SQL server.
> Now the problem...
> 1) I am connecting to the DB but have to prefix all my table names with
the
> DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
> 2) Also the recordset does not return any record
> please help
> regards|||>2) Also the recordset does not return any record
what is your query, and what is the dB structure?

Converting MS Access to SQL Server 2K

Hi,
I am fairly new to SQL Server and would appreciate if anyone could solve my
problem.
I have SQL server 2k installed on the server, say server1. My website is
also hosted on the same server. I have another instance installed on my
client machine.
Now I am connecting to the remote SQL server instance and
migrating/importing data from MS Access DB. The database migrated
successfully. I changed the ADO connection properties in my ASP code to
access data from SQL server.
Now the problem...
1) I am connecting to the DB but have to prefix all my table names with the
DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
2) Also the recordset does not return any record
please help
regardsUsing the 2-part name is optional... When you select * from mytable. SQL
first looks to see if YOU own a table with that name. ( ie wayne.mytable).
If such a table does NOT exist, then it searches for and returns a table
like this owned by the dbo... ( ie dbo.mytable)...
So you shouldn't have to use the 2-part name...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Fuzail" <Fuzail@.discussions.microsoft.com> wrote in message
news:AB8DC0C4-29A8-48A1-99AC-B89F9668DBDA@.microsoft.com...
> Hi,
> I am fairly new to SQL Server and would appreciate if anyone could solve
my
> problem.
> I have SQL server 2k installed on the server, say server1. My website is
> also hosted on the same server. I have another instance installed on my
> client machine.
> Now I am connecting to the remote SQL server instance and
> migrating/importing data from MS Access DB. The database migrated
> successfully. I changed the ADO connection properties in my ASP code to
> access data from SQL server.
> Now the problem...
> 1) I am connecting to the DB but have to prefix all my table names with
the
> DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
> 2) Also the recordset does not return any record
> please help
> regards|||
>2) Also the recordset does not return any record
what is your query, and what is the dB structure?